William Hill
Mon Aug 02, 2010 |
* Show database uptime in days and hours - http://www.orafaq.com/scripts/sql/uptime.txt
* Create database user like an exiting user (with exact privs) - http://www.orafaq.com/scripts/sql/cre8like.txt
* Switch from one database user to another without password (su.sql) -http://www.orafaq.com/scripts/sql/su.txt
* Dynamically ZIP large process trace files - http://www.orafaq.com/scripts/sql/trc_zip.txt
* Tabular display of redo-log archiving history (logs/hour) - http://www.orafaq.com/scripts/sql/archdist.txt
* List control file structures with usage limits - http://www.orafaq.com/scripts/sql/ctlimits.txt
* Log all database errors to a table - http://www.orafaq.com/scripts/plsql/db-error.txt
* Demonstrate database and schema level triggers - http://www.orafaq.com/scripts/plsql/db-trig.txt
* Limit resources using the Database Resource Manager - http://www.orafaq.com/scripts/sql/rsrc.txt
* Log Miner - extract undo statements from log files - http://www.orafaq.com/scripts/sql/logmnr.txt
* Database cursor usage (open_cursors parameter) - http://www.orafaq.com/scripts/sql/cursors.txt
* On-line table reorganizaton using the DBMS_REDEFINITION package - http://www.orafaq.com/scripts/sql/tabreorg.txt
* Create a Primary key column on a table were this is not yet available - http://www.orafaq.com/scripts/plsql/add_pk.txt |
Invite Friends
