| 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
|