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

Thread: Contigous Extent

  1. 09-13-2002, 01:02 AM #1
    Upeshp
    Upeshp is offline Member
    Join Date
    Mar 2001
    Posts
    131
    Hi Friends,

    Can anyone give me a script which gives me output of free space in the tablespace including the largest contigous block.

    The second help I want is,

    Does anyone give the PPS (power point slide) presentation on STANDBY DATABASE.

    Thanks,

    UpeshP
    Reply With Quote Reply With Quote
  2. 09-13-2002, 01:42 AM #2
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    select tablespace_name, sum(bytes), max(bytes) from dba_free_space
group by tablespace_name;
    Sanjay
    Reply With Quote Reply With Quote
  3. 09-13-2002, 02:51 AM #3
    Upeshp
    Upeshp is offline Member
    Join Date
    Mar 2001
    Posts
    131
    Dear Sanjay,

    Where it is giving the Largest Contiguous Extents size in your script ?

    thanks
    Reply With Quote Reply With Quote
  4. 09-13-2002, 03:10 AM #4
    SANJAY_G's Avatar
    SANJAY_G
    SANJAY_G is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    max(byte) is the largest free chunk of space.

    Sanjay
    Reply With Quote Reply With Quote
  5. 09-13-2002, 07:20 AM #5
    Upeshp
    Upeshp is offline Member
    Join Date
    Mar 2001
    Posts
    131
    Thanks,

    Sanjay,


    Can anyone helps me in my second problem ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width