AWE -What is It and How to use it?
32-bit Operating systems provide 4Gb of addressable space to applications. This includes memory for the user application and also for the system. When running Oracle on 32-Bit Windows, we can…
CRSCTL CheatSheet
You can find below various commands which can be used to administer Oracle Clusterware using crsctl. This is for purpose of easy reference. Start Oracle Clusterware #crsctl start crs Stop…
Allocation Unit and Extents In ASM
ASM was introduced with Oracle 10g and is used as a Volume Manager and a file system. It provides both mirroring and striping of the database files. To use ASM…
ORA-15063 – ASM Discovered Insufficient amount of Disks
Looking at the response generated by my earlier post on ASM, I thought of writing one more article. Many of us (Working on ASM) would have encountered following errors during…
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…
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…