-
Is there a way to find out the last time columns in Oracle db were used?
-
nop
but anyway your question is not very clear, what do you mean used? modified or used by a query?
-
Originally posted by pando
nop
but anyway your question is not very clear, what do you mean used? modified or used by a query?
What I meant is the last time any user accessed a given column for quering purposes.
-
well no, I guess that would be too much overhead to keep track to that magnitude...
in 9i you can however monitor index usage
-
Originally posted by pando
well no, I guess that would be too much overhead to keep track to that magnitude...
in 9i you can however monitor index usage
What about the columns accessed for one table?
-
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|