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
Administrationoracle How to Shrink Datafiles – Adjusting HWM Shrink Datafiles - Adjusting HWM This below example is derived from "Shrinking datafiles" scripts from…Nassyam BashaJune 14, 2012