RE: Extent grab ...
you'll have to capture that information manually. Of course if you need a shortcut, use DBA module of TOAD, when you view tablespaces, it can create scripts and dbms_job to activate space monitoring. It can then show you space usage in a graphical manner for tablespaces and datafiles. It doesn't work for individual tables, but the idea is you take their idea and extend it. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
Re: Extent grab ...
I guess I should be more specific. I am trying to find out the growth rate of a table on a 7.3.4 database. I did not get any info from the previous DBA. Can somebody tell me if there is a was to find out from the data dictionary how many extents by which this table has extended and when; the rate of growth. Any help/input will be greatly appreciated. Thanks in advance. Anjan Anjan Thakuria wrote: > Gurus, > > Is there any way to fond out the rate of extent grab by a segment from > the data dictionary. > > Thanks in advance. > > Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard
Extent grab ...
Gurus, Is there any way to fond out the rate of extent grab by a segment from the data dictionary. Thanks in advance. Anjan begin:vcard n:Thakuria;Anjan tel;work:817-963-3291 x-mozilla-html:TRUE url:www.eds.com org:EDS;Midrange Database Engineering adr:;;;Fort Worth;Texas;76155;U.S.A version:2.1 email;internet:[EMAIL PROTECTED] title:Infrastructure Specialist fn:Anjan Thakuria end:vcard