Articles

Data Guard oracle

How to resolve ORA-01111, ORA-01110, ORA-01157 There are many reasons for a file being created…

Nassyam BashaMarch 23, 2012

Administration Data Guard oracle Scripts

Troubleshooting DataGuard EnvironmentHelping in the OTN forums - Data Guard (OTN) , They used to…

Nassyam BashaMarch 23, 2012

Administration oracle Scripts

Instead of reviewing whole alert log file for any Particular information, We can search using…

Nassyam BashaMarch 21, 2012

Administration oracle Scripts

User session Monitor from Shell Script $ cat user_session_monitor.sh #!/bin/sh if then echo "Usage: $0…

March 20, 2012

Administration oracle Scripts

Table Fragmentation To get Actual, Optimal, Reclaimable Size from the tables of a specific user.…

Nassyam BashaMarch 20, 2012

Administration oracle Scripts

Tablespace Usage Database Bounce History by Triggers Table Fragmentation Tracking Alert Log file by x$dbgalertext…

Nassyam BashaMarch 20, 2012

Recent Posts