Home » SQL & PL/SQL » SQL & PL/SQL » creating triggers for system generated views
creating triggers for system generated views [message #269744] Mon, 24 September 2007 06:54 Go to next message
gurumurthy4
Messages: 17
Registered: August 2007
Junior Member
i want to know whether there is a way to write triggers for system generated views like v$session.... I want to get all the sql's as and when they are inserted into v$session since they will get destroyed from v$session as soon as the session gets over......
Re: creating triggers for system generated views [message #269745 is a reply to message #269744] Mon, 24 September 2007 07:01 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Why don't you enable auditing?

MHE
Re: creating triggers for system generated views [message #269758 is a reply to message #269744] Mon, 24 September 2007 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, there is no way to create trigger on base SYS objects.

Regards
Michel

[Updated on: Mon, 24 September 2007 07:44]

Report message to a moderator

Re: creating triggers for system generated views [message #269835 is a reply to message #269758] Mon, 24 September 2007 16:06 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
additionally, views like v$session aren't based on regular transactional tables. They're based on memory and you can easily get inconsistent results when you join to them.

http://www-css.fnal.gov/dsg/external/oracle_dcm/9iv2/server.920/a96536/ch3.htm

Previous Topic: BULK collect performance is slow
Next Topic: Sqlplus running too long
Goto Forum:
  


Current Time: Sat Dec 10 12:34:57 CST 2016

Total time taken to generate the page: 0.08402 seconds