 |
|
Oracle Tips by Burleson |
SQL Statements by Database
Gets
The SQL statement is a select from the table
named “foo”, so it is desirable to get more information about “foo”.
In this case, the script segment_info.sql can be used to find out
more about a segment which is a table.
* segment_info.sql
--
*************************************************
-- Copyright © 2003 by Rampant TechPress
-- This script is free for non-commercial
purposes
-- with no warranties. Use at your own
risk.
--
-- To license this script for a commercial
purpose,
-- contact info@rampant.cc
--
*************************************************
select
segment_name,
partition_name,
segment_type,
tablespace_name,
sum(bytes)/1024/1024 "MBytes"
from
dba_extents
where:
See Code Depot
The above book excerpt is from:
Oracle Wait Event Tuning
High Performance with Wait
Event Iinterface Analysis
ISBN 0-9745993-7-9
Stephen Andert
http://www.rampant-books.com/book_2004_2_wait_tuning.htm |
