CPU Usage Queries
CPU usage Queries Historical CPU Usage From the below query we can modify the END_INTERVAL_TIME…
Nassyam BashaJune 20, 2012
Scripts for Locks and Blocking sessions
Scripts for Object Locks and Blocking Sessions. Blocking Session using v$lock SELECT l1.sid ||…
Nassyam BashaJune 20, 2012
Advanced Table Compression with Oracle Database 11g for OLTP
Advanced Compression with Oracle Database 11g for OLTP Oracle introduced Table Compression from version 9i,…
Nassyam BashaJune 16, 2012
How to Shrink Datafiles – Adjusting HWM
Shrink Datafiles - Adjusting HWM This below example is derived from "Shrinking datafiles" scripts from…
Nassyam BashaJune 14, 2012
Applying CPU patch on DataGuard Physical Standby Configuration.
Applying CPU Patch in a DataGuard Physical Standby Database Configuration I seen lot of questions…
Nassyam BashaMay 26, 2012
Interview with Kellyn Pot’Vin
Kellyn Pot'Vin - Oracle ACE & Expert A talented and accomplished multi-platform database…
Nassyam BashaMay 17, 2012