Results 1 to 2 of 2

Thread: fragmentation

  1. #1
    Join Date
    Jul 2003
    Posts
    11

    Unanswered: fragmentation

    Dear All,
    Using 12.5.0.3 on Sun solaris,
    What is the best way to find out the fragmentation in databases.
    Iam using APL locking scheme.
    Regards
    Lalit

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: fragmentation

    Not the whole database, rather can be obtained at the table level using optdiag.

    Cluster ratios measure the fragmentation of the data.

    Originally posted by suraj_c
    Dear All,
    Using 12.5.0.3 on Sun solaris,
    What is the best way to find out the fragmentation in databases.
    Iam using APL locking scheme.
    Regards
    Lalit

Posting Permissions

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