Tag: Oracle

When (and How) Europe Met Pythian

Thanks to Paul for announcing the founding of Pythian Europe. Paul finished his blog by inviting me to tell you the story about “how we met Pythian”. Here it is.

Read More >

What’s New in 11i TXK AutoConfig and Templates Rollup Patch S

The 11i TXK AutoConfig and Templates Rollup Patch S (6372396) was released on May 5th. This patch differs from traditional TXK autoconfig template patch releases in that the ATG team decided to include some other important TXK patches also with this release. One of these is TXK Advanced Utilities Rollup Patch C (5011249). As a side effect of this generous inclusion of import updates, the patch size has increased from 16mb (RUP R) to 65mb (RUP S).

Read More >

Undocumented parameter _fix_control: How to break your database

Beware this parameter can prevent your database from starting. Indeed it can prevent your instance from starting! There are two dynamic views v$system_fix_control and v$session_fix_control which were introduced in 10.2 and control whether fixes for bugs in the optimizer can be turned on or off. This can also be controlled using the _fix_control initialization parameter. Also beware if setting this parameter in a running database. You can prevent further logins if you get it wrong or indeed try to unset it. Do not do. The moral of the story is be very careful with undocumented parameters when upgrading!

Read More >

Log Buffer #96: A Carnival of the Vanities for DBAs

This is the 96th edition of the weekly review of database blogs, Log Buffer.

Read More >

Introducing Pythian Europe

It is with great pride that I am able to announce that Pythian is making a large investment in Europe. As of this month, Pythian Europe s.r.o. is fully operational and we have headquartered the company in beautiful Prague. Additional offices are planned in Paris and Malta by the end of the summer.

Read More >

Oracle Application Server: How to Bounce AS from One Location

n this post and some upcoming posts, I’m going to write more about Oracle application servers, a subject we have addressed too little on the Pythian blog. In this post, I am addressing how to bounce a whole application server, including all tiers and databases from one location. The reason being, I have a request from a client to have the application server be bounced automatically during the weekend to release swaps and to address memory leaks.

Read More >

Oracle RAC, v$, and gv$

I have experienced some pain at the hands of the Oracle RAC. My first encounter was about five months ago when I first became an “official” DBA. Being eager to jump into solving problems in my new job (as that’s what most DBAs do, solve problems), I relished the chance to get my hands dirty and work on a “real” DBA task — a database lock. Checking with a few knowledgeable co-workers, I was directed to a set of common database diagnostic scripts affectionately known as the “Pythian Kit”. his wasn’t the confidence-boosting exercise that I had anticipated.

Read More >

Log Buffer #95: A Carnival of the Vanities for DBAs

he 95th edition of Log Buffer, the weekly review of database blogs, has been published by Mark Schoonover on his Mark’s IT Blog.

Read More >

Log Buffer #94: A Carnival of the Vanities for DBAs

Log Buffer, the weekly review of database blogs, welcomes back for his record-tying (Sheeri, are you reading?) third edition Ronald Bradford of Opinions, Expertise, Passion.

Read More >

A Question from OTN Forum

Here is the question that was posted on OTN Forum Grid Control Extensibility. My first reaction was — how stupid one should be to post such absolutely irrelevant question in that forum? I was even more surprised that someone actually tried to provide a sensible response…

Read More >
Page 107 of 143« First Page...10...105106107108109...120...Last Page »