Oracle Developer Jr - READY TO HIRE! Next Step Systems US-CA-Thousand Oaks Post A Job | Post A Resume

• Tablespace Information Report - Script to display tablespace information (Added: 22-Sep-1999 Hits: 5502 Rating: 5.00 Votes: 5) Rate It

• Tablespace used space (Added: 18-Oct-1999 Hits: 4839 Rating: 6.33 Votes: 3) Rate It

• THE Tablespace Report - A more comprehensive T/S report (Added: 11-Nov-1999 Hits: 6273 Rating: 8.50 Votes: 16) Rate It

• Unused areas in a data file - When executed this store procedure lists the unused spots on a given data file. The procedure receives as parameters the file_id and the minimum size in db blocks of the unused spots to be reported.
  The additional script executes the stored procedure for all data files in the database and with unused spots larger than 100 database blocks.
  
  The owner of the stored procedure should have select privelege on the dba_extents and dba_data_files granted explicitely not through the DBA role. (Added: 16-Feb-2000 Hits: 4091 Rating: 6.50 Votes: 4) Rate It

• Used and Free Space Comparison - Compare Used and Free space in a Tablespace (Added: 13-Aug-1999 Hits: 5065 Rating: 4.00 Votes: 4) Rate It

• Useful Scripts for Tablespace Management - Check tablespace usage,max free extent,fragment
  List datafile extents allocation map (Added: 19-Aug-2002 Hits: 3459 Rating: 4.50 Votes: 2) Rate It

Prev 10