Trace

Are you talking about tracing table changes for a complete schema?  Or are you thinking something else?

Follow these links, They elaborate on how to set up TRACE in Oracle.

http://www-rohan.sdsu.edu/doc/oracle/oem140/A53700_01/ch_prfpk.htm
http://www-rohan.sdsu.edu/doc/oracle/server803/A54638_01/otrace.htm

hi

Oracle Trace was introduced in Oracle7 release: 7.3.2.1      I
t is enabled by default (when installed) in 7.3.2 onwards

You can use Oracle Trace to collect server performance data for a specific database session or for the entire instance. You can also select the server event set for which you want to collect

i think with Oracle Expert Methodology u can trace schema level as well...

please follow

http://www-rohan.sdsu.edu/doc/oracle/oem140/A53696_01/evt.htm 
http://www.csee.umbc.edu/help/oracle8/server.815/a67775/ch15_otr.htm
http://www.proligence.com/pr_oracle_trace.pdf.

these links

regards

i had already looked at the above stuff, can some one just give me steps to set up a trace at schema/user level, do not refere 10 page documents please.

appreaciate your help!

Thanks.

I would if you'd clarify what you want traced.  What do you mean by the schema/user level?

hi

if u r not goin to refer the documents "boy"... immm ...i think will be difficuilt and
i  dont think everytime we will get all the answers by reading 1 page(or even 100 page)
here its not very much clear that schema/user level means?
and in the first reply itself  someone pointing it ..and till now its not cleared

regards

jrb1,

appreciate your responce, we have an instance ABC and we would like to trace the activity on one schema on that instance.
is it possible? Hope this makes sense.

Thanks.

Do you mean all selects, changes, etc.?  Only data changes?  What about creating or deleting objects in the schema (new tables, procedures, triggers, etc.)?

any changes from the application.

hi

yes if u want to do it for sqls and all the best method is auditing ...but mind u it will take some space and may make ur db slow

regards