How to know if Free list and Free Group in table is sufficient..?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to know if Free list and Free Group in table is sufficient..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    How to know if Free list and Free Group in table is sufficient..?

    How to know if Free list and Free Group in table is sufficient...?

  2. #2
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    If there is no wait event for segment header
    .
    ~KD.DBA~

  3. #3
    Join Date
    Jul 2002
    Posts
    205
    How to find out if there is any wait event for segment header

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Ypu can use..

    v$system_event
    v$session_event

    V$session_wait

    v$waitstat this view will tell you , if waits r for segment header..

    what type of tablespaces r u using and also oracle version ??
    ~KD.DBA~

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