DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Columns not used....

  1. #1
    Join Date
    Mar 2002
    Posts
    10

    Question

    Is there a way to find out the last time columns in Oracle db were used?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    nop

    but anyway your question is not very clear, what do you mean used? modified or used by a query?

  3. #3
    Join Date
    Mar 2002
    Posts
    10
    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.

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well no, I guess that would be too much overhead to keep track to that magnitude...

    in 9i you can however monitor index usage

  5. #5
    Join Date
    Mar 2002
    Posts
    10
    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?

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, no way.....
    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
  •  


Click Here to Expand Forum to Full Width