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…
Read Full RecipeTag: oracle
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…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
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…
Read Full Recipe
CPU (Critical Patch Update) and N-apply
OVERVIEW Oracle has been regularly releasing security fixes for all it's products to take care of any security vulnerability. Since 2005 Oracle formulated a policy that it will release CPU…
Read Full Recipe