KRONOS Technical Analyst Professional Technical Resources US-OR-Portland Post A Job | Post A Resume

• 9i Tablespace Growth - This script will show you your tablespace size, what percentage is used and free, and the number of fragments that happened. (Added: 14-Jun-2004 Hits: 5133 Rating: 6.00 Votes: 2) Rate It

• Connect to Database Without Setting Environment - This script will gather the information from /var/opt/oracle/oratab, will set the environment and will prompt you to type a valid sid. (Added: 14-Jun-2004 Hits: 3408 Rating: 0 Votes: 0) Rate It

• database_size_8i_or_9i.sql - "Database Size"
  
  Data Mb Temp Mb Redo Mb Total Mb
  ------------ ------------ ------------ -----------
  2,535.0 500.0 600.0 3,635.0 (Added: 25-Jun-2003 Hits: 4368 Rating: 1.50 Votes: 2) Rate It

• Find Datafiles Added per Month - To find datafiles added per month for version 8 and above (Added: 14-Jun-2004 Hits: 3189 Rating: 0 Votes: 0) Rate It

• find out information about a constraint - Script prompts for a constraint name
  then it returns information about the constraint (Added: 30-Mar-2000 Hits: 3448 Rating: 1.67 Votes: 3) Rate It

• Find the Schema or User Size - This script finds the Schema or user Size. (Added: 15-Jul-2004 Hits: 3593 Rating: 8.00 Votes: 3) Rate It

• Quota By User - Display Quota Allocated By User (Added: 13-Aug-1999 Hits: 3903 Rating: 6.67 Votes: 3) Rate It

• Rate of Storage Usage in the Tablespace - A script that shows tablespace usage in %, blocks used and empty etc. (Added: 7-Jan-2000 Hits: 5242 Rating: 6.25 Votes: 8) Rate It

• Table size information - Display all tables in current schema, with tablespace name and table size in gigabytes. Useful when space becomes a problem. (Added: 3-Oct-2003 Hits: 4649 Rating: 8.25 Votes: 4) Rate It

• Tables spanning across multiple datafiles - This script would be useful to findout how rows in a table are spread across different datafiles.
  To know how many rows are there in each datafile
  for that table.
  
  Works for the version 8+ and above where dbms_rowid package is available. (Added: 19-Feb-2003 Hits: 2857 Rating: 0 Votes: 0) Rate It

Next 10