oracleUncategorized 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
oracleReviews 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
AdministrationoracleScripts Estimate tablespaces usage before database refresh Estimate tablespaces usage before database refresh We have been facing missing tablespaces/inadequate space in tablespaces…adiJuly 10, 2012
oracleScriptsUncategorized CPU Usage Queries CPU usage Queries Historical CPU Usage From the below query we can modify the END_INTERVAL_TIME…Nassyam BashaJune 20, 2012
oracleScriptsUncategorized 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
Administrationoracle 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