Table that is highly fragmented
- This script reports the table that is highly fragmented
pop
(Added: 1-Sep-1999 Hits: 9505 Rating: 2.09 Votes: 11) Rate It
Fragmentation Monitor
- Look for the number of chunks which are free,look for also the number of extents being used by objects..primarily for indexes..Also thi
(Added: 11-Jan-2000 Hits: 8903 Rating: 5.11 Votes: 9) Rate It
Reaching Max Extents
- List all objects reaching max extents
(Added: 13-Aug-1999 Hits: 5581 Rating: 3.67 Votes: 6) Rate It
show tablespace usage
- show all tablespaces usage
(Added: 28-Dec-1999 Hits: 6736 Rating: 10.00 Votes: 1) Rate It
Simple script to show Tablespace Size,Freespace and Usage
- Why going for large scripts? This script shows available space,used space, free space and its percentage values. Tablespaces which are 100% free are not listed.
(Added: 5-Nov-1999 Hits: 6375 Rating: 7.40 Votes: 10) Rate It
Tablespace Coalesce Script
- This script may be used as a cronjob to coalesce the tablespaces periodically. This is especially useful if all your tablespace pctincrease value is set to 0. Uses /etc/oratab to read all instance names, and operating system authentication to log into the database. Sun users change it to /var/opt/oracle/oratab
(Added: 29-Aug-1999 Hits: 5912 Rating: 6.33 Votes: 3) Rate It
Tablespace Space Usage
- Keep tablespace usage < 80% Keep contiguous free space
(Added: 24-Aug-1999 Hits: 6649 Rating: 8.67 Votes: 3) Rate It
