DBAToolZ - Scripts ( Data Files ) DBAToolZ Home
 (Last updated 05/21/2003)
Home     Download     Forums     SQL Scripts     Book Review     Links     Feedback


Script Name Description

c_dbf_trim.sql

	trims the last FREE CHUNK from a datafile
	by resizing it ...  Coalesces tablespace prior resize.

c_dbf_trim_all.sql

	trims the last FREE CHUNK from ALL datafiles
	by resizing it ...  Coalesces ALL tablespace prior resize.

s_db_ctl_file_recs.sql

	Displays number and types of records that
	are stored in database controlfile.

s_db_files_all.sql

	Reports all database files REDO LOG, DBF, CTL

s_dbf_ai.sql

     VERY HELPFULL TO BALANCE DBF`s on FILE SYSTEMS
     This script displays just about all you need to know
     about datafiles, storage, tablespaces and autoextend

s_dbf_free.sql

	Displays free space per datafile

s_dbf_in_backup.sql

	Reports Datafiles In Back Up Mode

s_dbf_io.sql

	This script will show IO by mount point

s_dbf_io_HAR.sql

	Reports on file IO statistics

s_dbf_io_JL.sql

	Reports DBF stats with 10 sec intervals

s_dbf_io_trac.sql

	Report v$filestat

s_dbf_migrate.sql

	When migrating to a different host sometimes
	it is necessary to balance datafiles on new
	file systems to make sure you do not go over
	the available space.
	--
	For instance if your original host had 20GB
	file systems and your new host is only 12GB
	you can find this script very handy.
	--
	This script should be ran on the sourse instance
	before the migration.  It will display a line "---"
	when SUM of all datafiles reached the limit you
	specified

s_dbf_tmp.sql

	Reports all temp files and tablesapces (8i)
	reports sort segments summary from v$temp_space_header
	v$temp_extent_pool and dba_temp_files
    

DBAToolZ Home | Contact Us
Copyright© 2001 DBAToolZ.com All Rights Reserved.