Current SQL’s running on Instance
Current SQL's running on Instance This below query useful to find out current running SQL…
Nassyam BashaSeptember 18, 2012
Book Review: Oracle Database XE 11gR2 Jump Start Guide – Asif Momen
Book Review: Oracle Database XE 11gR2 Jump Start Guide - Asif Momen Asif Momen…
Nassyam BashaAugust 22, 2012
Estimate tablespaces usage before database refresh
Estimate tablespaces usage before database refresh We have been facing missing tablespaces/inadequate space in tablespaces…
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