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
Database Bounce History by Triggers
Database Bounce History Whenever Instance was started or shutdown, These information not stored in Oracle…
Nassyam BashaMarch 16, 2012
Tablespace Usage
Tablespace Used , Free & Total Sizes of each tablespaces set linesize 160 set pagesize…
Nassyam BashaMarch 15, 2012