Data Guardoracle UNNAMED file in standby after adding new file to primary – ORA-01111, ORA-01110, ORA-01157 How to resolve ORA-01111, ORA-01110, ORA-01157 There are many reasons for a file being created…Nassyam BashaMarch 23, 2012
AdministrationData GuardoracleScripts Troubleshooting DataGuard Environment – Snapper Troubleshooting DataGuard Environment Helping in the OTN forums - Data Guard (OTN) , They used…Nassyam BashaMarch 23, 2012
AdministrationoracleScripts 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
AdministrationoracleScripts User Administration scripts User session Monitor from Shell Script $ cat user_session_monitor.sh #!/bin/sh if then echo "Usage: $0…farhanMarch 20, 2012
AdministrationoracleScripts Table Fragmentation Table Fragmentation To get Actual, Optimal, Reclaimable Size from the tables of a specific user.…Nassyam BashaMarch 20, 2012
AdministrationoracleScripts Database Administration Tablespace Usage Database Bounce History by Triggers Table Fragmentation Tracking Alert Log file by x$dbgalertext…Nassyam BashaMarch 20, 2012