Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.


ASM Disk Info
ASM Diskgroup Info
How can I tell if a procedure/package is running
Show current locks in the database
DDL Locks on Objects
Library Cache Locks
Object Cache Locks
Locked Object
Blocking Waiting Sessions
Active Process in DB
Current session wait activity in DB
Data Files free space
DB General Info
DB Global waits
Hard activities in DB
DB overall efficiency
Session blocking quiesce
How much DB undo generated
DB History
DB Segments Used (Type wise)