Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: Log database errors Jump to:  
Category: >> Oracle PL/SQL >> Log database errors Bookmark and Share

<< lastnext >>

Snippet Name: Log database errors

Description: Logs all database errors to a table.

NOTE: DBA or CREATE ANY TRIGGER privs and GRANT SELECT ON SYS.V_$SESSION required

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Database Links: CURRENT_USER
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

DROP TRIGGER log_errors_trig;
DROP TABLE   log_errors_tab;
 
CREATE TABLE log_errors_tab (
     error     VARCHAR2(30),
     TIMESTAMP DATE,
     username  VARCHAR2(30),
        osuser    VARCHAR2(30),
        machine   VARCHAR2(64),
     process   VARCHAR2(8),
     program   VARCHAR2(48));
 
CREATE OR REPLACE TRIGGER log_errors_trig 
     after servererror ON database
DECLARE
     var_user     VARCHAR2(30);
     var_osuser   VARCHAR2(30);
     var_machine  VARCHAR2(64);
     var_process  VARCHAR2(8);
     var_program  VARCHAR2(48);
BEGIN
     SELECT username, osuser, machine, process, program
     INTO   var_user, var_osuser, var_machine, var_process, var_program
     FROM   sys.v_$session
     WHERE  audsid = USERENV('sessionid');
 
     INSERT INTO log_errors_tab
       VALUES(dbms_standard.server_error(1),SYSDATE,var_user,
              var_osuser,var_machine,var_process,var_program);
END;


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 241 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?