Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:
Enable it by using the below command.
ALTER SYSTEM SET enable_ddl_logging=TRUE
All the DDL commands executed against the database will be recorded in the alert<SID>.log
More details of the DDL of the command executed can be found in the XML file in the alert directory
Enable it by using the below command.
ALTER SYSTEM SET enable_ddl_logging=TRUE
All the DDL commands executed against the database will be recorded in the alert<SID>.log
More details of the DDL of the command executed can be found in the XML file in the alert directory
Jacket Leather Indonesia 100US Dollar
ReplyDeleteCD
marinir
bantal-silikon15.blogspot.com
bumbu-pecel01.blogspot.com/
seo-guru01.blogspot.com/
seo-konsultasi-mudah.blogspot.com/l
marinir-seo-konsultan-12a.blogspot.com/
http://dfes12.blogspot.com/
agen-seo19.blogspot.com/
agen-seo20.blogspot.com/
agen-seo16.blogspot.com/
agen-seo18.blogspot.com/
jksbindo.blogspot.com/
jkt-49.blogspot.com/
seokonsultan1.blogspot.com
guru-seo-malang.blogspot.com/
seo-aaa.blogspot.com/
marinir-seo-8.blogspot.com/2015/05/rty.html
vvtiin.blogspot.com/2015/05/rqw.html
agen-seo17.blogspot.com/2015/05/rtq.html
asdf-14.blogspot.com/2015/05/qwr.html
bantaljkt1.blogspot.com/2015/05/qwa.html
larismanisyaluk.blogspot.com/2015/05/q.html
bantalku1.blogspot.com/2015/05/b.html
bantal999.blogspot.com/2015/05/r.html
distrobantal.blogspot.com/
bantalsilikon01.blogspot.com/
sabunherbalya.blogspot.com/
kesethandukmalang.blogspot.com/
bantalmalangmurah.blogspot.com/
restoran-seo.blogspot.com/
distro-seo.blogspot.com/
jualsangkarpleci.blogspot.com/
marinir-seo.blogspot.com/
kopiluwakliar01.blogspot.com/
bumbu-pecel-malang.blogspot.com/
Valuable information thanks for sharing Oracle DBA Online Training
ReplyDeleteRegards
ReplyDeleteSridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.