SR 4 DB

The following script allows us: Used percent, free space Details and properties Segments inside tablespaces Statistics of segments Statistics of IO per datafiles Datafiles of tablespace Quotas Script: view        : tbsinfo.sql download : tbsinfo.sql Example: Tablespace Name : DATACCSL02 --- Tablespaces Tablespace                         Size MB    Free MB    Used MB Used Pct ------------------------------ ---------- ---------- ---------- -------- DATACCSL02                          49158       48256         902 1.83 % Status    Logging    Extent Man Allocation ASSM    Next Extent KB Contents   Block Size --------- --------- ---------- ---------- ------ -------------- --------- ---------- ONLINE     LOGGING    LOCAL       UNIFORM      AUTO            131072 PERMANENT        8192 --- Quotas User                           Used  Quota ------------------------ ---------- --------------- UCS                             896 UNLI

----  ---- Pending ---- Alarm used 90%. ----- Version: 1.2.2 ----- Tables' Extents  ----- IO Stat (Reads and Write) per datafile ----- Created : 28/02/2014 ----- Updated : 11/06/2014 ----- Author: Eini Trujillo set lin 140 set pages 1001 set verif off set echo off SET FEEDBACK off set timing off set time off COL Used_Pct FORMAT A8 heading "Used Pct" col file_name for a64 col segment_name for a28 heading  "Segment Name" col partition_name FORMAT A30 heading "Partition Name" col segment_type FORMAT A18 heading  "Segment Type" col mon for a12 heading  "Year-Month" col used  for 9 , 999 , 999 heading  "Used " col QUOTA   for a15 heading  "Quota " col owner for a12 heading  "Owner" col USERNAME  for a24 heading  "User " col size_mb for 9 , 999 , 999 heading  "Size MB" col cnt_tables for 9 , 999 heading  "Nu