Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Script to check next extent requirement By: Vigyan Kaushik Sep 22 2005 This script will help you to figure out space requirement for extents in the database.   REM: Script to check next extent requirement. REM: REM: Author: Vigyan Kaushik REM: Date Submitted: 22-Sep-2005 REM: Date Posted: 22-Sep-2005 REM: REM:***************************************** REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** SET pagesize 200 SET linesize 120 COL tablespace_name format a20 COL owner format a25 COL segment_name format a30 PROMPT Checking Requirement of Next extents. SELECT s.owner, s.segment_name, s.segment_type, s.tablespace_name, s.next_extent FROM dba_segments s WHERE s.next_extent > (SELECT MAX (f.BYTES) FROM dba_free_space f WHERE f.tablespace_name = s.tablespace_name);

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor