Database Administration (MOSC)

MOSC Banner

To find highwatermark

Comments

  • Nael-OC
    Nael-OC Posts: 12 Green Ribbon
    Hi,
    It is a good. i have two questions:

    1. What I know that  the Highwatermark is at the level of the table, your query is returning it at the level of datafile.
    2. If I knew the high water mark at the datafile level, what steps can i do ? in what this info can help me?

    Regards,
  • SusanA-Oracle
    SusanA-Oracle Posts: 32 Blue Ribbon
    Hi,
    It is a good. i have two questions:

    1. What I know that  the Highwatermark is at the level of the table, your query is returning it at the level of datafile.
    2. If I knew the high water mark at the datafile level, what steps can i do ? in what this info can help me?

    Regards,
     Hi Nael,
    1. Yes. This shows the maximum allocated extent in a datafile. Or beyond this, there are no extents allocated in the datafile.
    2. This is helpful when you want to resize a datafile, without encountering ORA-3297 error.

    Regards,

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center