Author Archive
10.2.0.4 on AIX5L (64-Bit) is Out
As usual Laurent has been first to locate that 10.2.0.4 on AIX5L (64-Bit) is Out. Patchset size is whopping 1.9G which I believe is the maximum size for Oracle Patchset till date. Looks like 10.2.0.3 on AIX had lot of bugs or it could be that DATABASE REPLAY feature needed [Read More]
Tracing Sessions with Event 10046
10046 Event is used to trace SQL statements (similar to sql_trace=true) with additional details depending on the tracing level which is specified. 10046 EVENT levels: 1 – Enable standard SQL_TRACE functionality (Default) 4 – As Level 1 PLUS trace bind values 8 [Read More]
11G: OCR Manual Backups
OCR is a file that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. The OCR contains information about the cluster node list, instance-to-node mapping information, and information about Oracle Clusterware resource [Read More]
ORA-07445 [opidsa()+480] – Metalink Alert for 10.2.0.3
Oracle has reported a new Alert for user’s who have upgraded their databases to 10.2.0.3 patchset on windows. User processes dumps core dumps with following errors ORA-07445: exception encountered: core dump or ORA-07445: exception encountered: core dump [Read More]
Significance of LD_LIBRARY_PATH
Few days back, I wanted to remove a instance semaphore as they were not cleared automatically due to abnormal shutdown. As there were few other databases running on the server , so I thought of capturing the semaphore id to remove them manually using “ipcrm” . [Read More]
ASM Disk Discovery
While creating ASM diskgroup or adding new disk to a existing diskgroup, Disk should be visible in V$ASM_DISK. ASM discovers and examines the contents of all of the disks that are in the paths that you designated with values in the ASM_DISKSTRING initialization parameter. [Read More]
Application Design and ORA – 4031
Much has been written on designing good application (which uses bind variables) so as to have better performance and avoid shared pool memory issues. Tom Kyte explains this on one of his post consequences of not using bind variables If you do not use bind variables and you [Read More]
Deciding “PROCESSES” parameter value
Many times we observe following error which corresponds to low setting of processes parameter. $ oerr ora 20 00020, 00000, “maximum number of processes (%s) exceeded” // *Cause: All process state objects are in use. // *Action: Increase the value of the [Read More]
ERRORSTACK- Oracle Debugging Event
One more post arising out of my frequent visits to Oracle forum Basically there was a question on “How to set events for ORA – 1652 errors” I had replied to the post but Aman asked me if I could provide any notes regarding Errorstack.I didn’t had one [Read More]
Changing Database Characterset With Export/Import Utilities
Recently there was a thread on Oracle Forums regarding change of Database characterset from WE8ISO8859P1 to AL32UTF8. User wanted to upgrade his database from 9i to 10g and also change the database characterset. He was looking forward to use either Export/Import utilities [Read More]
Tweaking _Shared_pool_reserved_min_alloc and ORA – 4031
Here comes one more article dedicated towards diagnosing ORA- 4031 and related parameters. While googling on ORA-4031 error or working on TAR with Oracle Support you will most likely hit this parameter “_Shared_pool_reserved_min_alloc “ and find a advice for [Read More]
Undo Tablespace Sizing
In this post I will be discussing various types of Undo extents which can be helpful in determining cause of ORA-30036 i.e unable to extend segment by %s in undo tablespace ‘%s’ and ORA-1555 – Snapshot too old Error While using Automatic Undo management (Set [Read More]
Sign on Letter to Larry Ellison on AWR and ASH Licensing
While surfing across the blog’s, I found this particular link, a compaign which is aimed at getting free access to the ASH and AWR reports. I believe most of us know that we need to pay extra fees for the Diagnostic Tuning Pack which also includes ASH and AWR report. [Read More]
HW enqueue contention with LOB
DefinitionEnqueues are local locks that serialize access to various resources. Enqueue wait event indicates a wait for a lock that is held by another session (or sessions) in an incompatible mode to the requested mode. HW Enqueue – High Watermark enqueue is acquired [Read More]
Shared Sub Pools
Today I will discuss about Shared pool subpools which have been introduced in release 9iR2 and higher (To be precise >9.2.0.5) and can be controlled by a hidden parameter “_kghdsidx_count “ Most of you would not have come across this term/parameter unless you [Read More]
