Troubleshooting DataGuard Environment – Snapper
Troubleshooting DataGuard EnvironmentHelping in the OTN forums - Data Guard (OTN) , They used to…
Nassyam BashaMarch 23, 2012
Tracking Alert Log file by x$dbgalertext
Instead of reviewing whole alert log file for any Particular information, We can search using…
Nassyam BashaMarch 21, 2012
User Administration scripts
User session Monitor from Shell Script $ cat user_session_monitor.sh #!/bin/sh if then echo "Usage: $0…
Table Fragmentation
Table Fragmentation To get Actual, Optimal, Reclaimable Size from the tables of a specific user.…
Nassyam BashaMarch 20, 2012
Database Administration
Tablespace Usage Database Bounce History by Triggers Table Fragmentation Tracking Alert Log file by x$dbgalertext…
Nassyam BashaMarch 20, 2012
Drop User with ORA-26500
Drop User with ORA-26500 When trying to Replicate the data from one machine to another…
Nassyam BashaMarch 17, 2012