Home » RDBMS Server » Server Administration » Next Extent Fail
Next Extent Fail [message #52271] Thu, 11 July 2002 15:27 Go to next message
Suri
Messages: 6
Registered: July 2002
Junior Member
Hi,

I am using the following script to identify the objects that will have trouble in throwing next extents I have configured this script through OEM to run for every 12 Hrs. Last week we had space issues on one of our server and this script was not able to identify the tables before hand that will fail when throwing the next extent. Can somebody tell if there is anything wrong in with the script.

SELECT
seg.owner,
seg.segment_name,
seg.segment_type,
seg.tablespace_name,
seg.next_extent/1024 next_extent
FROM dba_segments seg
WHERE seg.next_extent IS NOT NULL
AND NOT EXISTS
(select tablespace_name
from dba_free_space free
where free.tablespace_name = seg.tablespace_name
and bytes >= seg.next_extent)

Thanks in Advance

Report message to a moderator

Re: Next Extent Fail [message #52294 is a reply to message #52271] Fri, 12 July 2002 08:04 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Take look on this working one

You can change it to catch 2 or 5 extents before the limit is reached.

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com]Click Here

Report message to a moderator

Previous Topic: locking of packages
Next Topic: Re: NMI errors after reboot
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 18 21:37:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.