Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    74

    Unanswered: How to find a High Water Mark on a Oracle Table

    Hi

    I'm running an oracle DB on 9.0.1 ( I know it's old) but we are due to upgrade the apps and database soon!

    We are having some performance problems and I would like to find out the high water mark on a few of the table.

    Can someone please help? I need a step by step instructions as what I'm reading on the internet is confusing me.

    Thanks

  2. #2
    Join Date
    May 2006
    Posts
    132
    This gives you a simple formula (Where can one find the high water mark for a table?).

  3. #3
    Join Date
    May 2006
    Posts
    132
    Quote Originally Posted by becklery
    This should do the trick:

    SELECT sessions_highwater FROM v$license;
    What on earth does "session_highwater" mark have to do with a table high water mark ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •