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

Thread: Extent allocation

  1. 05-01-2001, 08:44 PM #1
    svk
    svk is offline Advisor
    Join Date
    Jul 2000
    Posts
    521
    I am interested in knowing when a table grows.

    Is there a way to get notified when an extent gets allocated to a table ?
    Is there any dd view that has this info ?
    Is there any tool that does this ?
    Is there any event that can be set to get this info ?

    Any input will be greatly appreciated....
    svk
    Reply With Quote Reply With Quote
  2. 05-01-2001, 10:23 PM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I dunno for what reason you need this information but,You can get the number of extents from DBA_SEGMENTS view.

    Write a Sql scripts which tracks the number of extents in this view and send you a note whenever extents increments.
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 05-02-2001, 02:50 AM #3
    shawish_sababa
    shawish_sababa is offline Member
    Join Date
    Jul 2000
    Posts
    243
    Hi svk

    look in the otn. i found there some scripts for database object size and some reading material a year ago.
    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