| log 'alter system' command [message #378268] |
Mon, 29 December 2008 11:22  |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
Hi
I am looking for a way to track alter system / alter database commands.
Database triggers are not logging them : I do have a database trigger for DDLs tracking that works great but alter system commands are not captured by it . also trigger 'alter alter on database ' - do not log alter system or alter database
Is there a way for me to force a command to appear in the alert log ?
Or any other way you can think of ?
thanks
Orna
|
|
|
|
|
|
| Re: log 'alter system' command [message #378275 is a reply to message #378272] |
Mon, 29 December 2008 13:17  |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
Can't I force logging of a certain command into the alert log,even if its not currently logged.
let's say I want each 'alter system flush shared_pool' to be logged.
Is it possible ?
|
|
|
|
|
|
|
|
|
|
| Re: log 'alter system' command [message #378450 is a reply to message #378338] |
Tue, 30 December 2008 08:23 |
Orna
Messages: 62
Registered: November 2008
|
Member |
|
|
No, its not that I do not want to give my DBA the privilege, I just want to have a way to track it.
Since I already have my customize trigger that logs all the DDLs in the system, I was hoping to complete the picture by monitoring also alter system commands.
I will look at the audit option - thanks
orna
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
