Gopal, Ganesh, ...
Small correction:
1. v$session_event does not have file#, block# and
blocks. They are in v$session_wait, which may be hard to catch.
2. Absolute best methode. But field name is "flag".
not "class", you can use bitand(flag,power(2,19) > 0 as a condition. When
join to dba_objects(user_objects) one should use field data_object_id, not
object_id. Take care about clusters, as all object in cluster share the same
data_object_id. Anothe (but slower) way is join with
dba_extents(user_extents).
4. This give accurate info to the file level, not
segment level.
Alex.
|
- RE: how to know ,the tables which are accessed via FTS? K Gopalakrishnan
- RE: how to know ,the tables which are accessed via ... Alex Feinstein
- RE: how to know ,the tables which are accessed via ... K Gopalakrishnan
- Re: how to know ,the tables which are accessed via ... hemantchitale
- Re: how to know ,the tables which are accessed via ... Jonathan Lewis
- RE: how to know ,the tables which are accessed via ... MacGregor, Ian A.
- Re: how to know ,the tables which are accessed via ... hemantchitale
- Re: how to know ,the tables which are accessed via ... Alex Feinstein
- RE: how to know ,the tables which are accessed via ... MacGregor, Ian A.
- Re: how to know ,the tables which are accessed via ... hemantchitale