Trace access to one specific table

From: Frank Foss <fozzie_beer_at_hotmail.com>
Date: Wed, 3 Dec 2003 10:20:22 -0800
Message-ID: <bql9h4$23avd3$1@ID-190416.news.uni-berlin.de>

Greetings
I am running Oracle Ent.Ed with partitioning 9.2.0.4 on HP-UX 11.00

I was wondering if it is possible to trace all SQL statements from multiple sessions that touches a specific table in a specific schema?

The reason why I want this is that I am looking at converting about half a dozen tables to Index-Organized tables, and I would like to know the access pattern for these tables.
Armed with this knowledge, I could weigh pro/con of conversion, or perhaps have the programmers alter the code to conform with column order or something to make the most of the IOTs.

It would be nice if I didn't have to do full traces of all sessions, that would take a long time to sift thru, but I will if that is the only way.

Best regards,
Frank Foss
Junior DBA Received on Wed Dec 03 2003 - 12:20:22 CST