Date of Last Instance Startup
- Find the date when the Oracle Instance was last started
pop
(Added: 14-Sep-1999 Hits: 11008 Rating: 3.95 Votes: 18) Rate It
Code Generation for Table Triggers
- Creates a procedure in which table names may be passed to create an AFTER UPDATE audit trigger for the table.
INSTRUCTIONS 1.Run this procedure in a plsql editor 2.Set ServerOutPut on 3.Call the procedure with a valid table name 4.Copy and paste the output in an iSQL*Plus session and run to create a trigger.
(Added: 15-Jun-2007 Hits: 3710 Rating: 0 Votes: 0) Rate It
Database Start Time for Oracle 7 & 8
- This script will work with both Oracle 7 and Oracle 8. It returns the date and time that the instance was started as well as the version number.
(Added: 13-Jul-2000 Hits: 6387 Rating: 5.67 Votes: 9) Rate It
Database Uptime/Start time
- Database uptime and startup time Found code a long time ago on the web..
(Added: 8-May-2006 Hits: 2993 Rating: 0 Votes: 0) Rate It
Enabled Audits
- Information of Statement, privilege and object audits enabled on database
(Added: 17-Aug-1999 Hits: 8278 Rating: 5.33 Votes: 3) Rate It
Password Maintenance Script
- Is it possible to know the password of your users when the password has expired? Of course, it is! By making your own "verify_function", you can access old and new passwords! To test that your "verify_function" inhibits obvious passwords like 'qwerty' or 'zeus', here is a little sample script to check the password of your users.
(Added: 16-Sep-2002 Hits: 5710 Rating: 6.25 Votes: 8) Rate It
