Articles

oracle Reviews

Book Review: Oracle Database XE 11gR2 Jump Start Guide - Asif Momen Asif Momen…

Nassyam BashaAugust 22, 2012

Administration oracle Scripts

Estimate tablespaces usage before database refresh We have been facing missing tablespaces/inadequate space in tablespaces…

July 10, 2012

oracle Scripts Uncategorized

CPU usage Queries Historical CPU Usage From the below query we can modify the END_INTERVAL_TIME…

oracle Scripts Uncategorized

Scripts for Object Locks and Blocking Sessions. Blocking Session using v$lock SELECT l1.sid ||…

Administration oracle

Advanced Compression with Oracle Database 11g for OLTP Oracle introduced Table Compression from version 9i,…

Administration oracle

Shrink Datafiles - Adjusting HWM This below example is derived from "Shrinking datafiles" scripts from…

Recent Posts