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

List control file structures with usage limits By: Gopu Gopi Apr 22 2008 Script to list control file structures with usage limits.   REM: List control file structures with usage limits REM: REM:***************************************** REM: Author: Gopu G REM: Date Submitted: 22-April-2008 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 pages 50000 col PCT_USED format 990.09 -- Controlfile creation parameters: -- Type DATAFILE is for MAXDATAFILES -- Type REDO LOG is for MAXLOGFILES -- Type LOG HISTORY is for MAXLOGHISTORY -- Type REDO THREAD is for MAXINSTANCES -- No entry for MAXLOGMEMBERS (?) select type, records_used, records_total, records_used/records_total*100 "PCT_USED" from sys.v_$controlfile_record_section ;

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor