Oracle Internals Monitoring Tuning Scripts Storage Object Internal Scripting Tables Chained Rows Analyze v$sesstat

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Chapter 7 Oracle Storage and Object Internal Scripting

rem        Target table must have column that is the leading portion
rem        of an index and is defined as not null.
rem        Uses the V$SESSTAT table. USERNAME is the current user.
rem        A problem if > 1 session active with that USERID.
rem        V$SESSTAT may change between releases and
rem        platforms. Make sure that 'table fetch continued row' is
rem        a valid statistic.
rem        This routine can be run by AUTO_CHN.sql by remarking the
rem        two accepts and un-remarking the two defines.
rem
rem INPUTS: obj_own = the owner of the table.
rem          obj_nam = the name of the table.
rem
rem *******************************************************************
ACCEPT obj_own PROMPT 'Enter the table owner''s name: '
ACCEPT obj_nam PROMPT 'Enter the name of the table: '

rem DEFINE obj_own = &1   ﬂ Remove comment to use with auto_chain
rem DEFINE obj_nam = &2   ﬂ Remove comment to use with auto_chain

SET TERMOUT OFF FEEDBACK OFF VERIFY OFF ECHO OFF HEADING OFF
SET EMBEDDED ON

The above text is an excerpt from:

Mike Ault’s Oracle Internals Monitoring & Tuning Scripts

Written by the world's top DBA and author of over 20 Oracle books, Mike Ault shares his secrets for Oracle DBA management scripts. This handy reference is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts.

This stellar book comes complete with an online code depot full of over 200 pre-tested Oracle DBA scripts, and covers all areas of Oracle database administration including data files, tablespace, table and index management scripts. Based on more than 20 years full-time experience, Mike Ault brings his expertise to the public with this fantastic book. Your time savings from a single script is worth the price of this great book.

http://www.rampant-books.com/download_adv_mon_tuning.htm

http://rampant-books.com/book_2003_2_audit.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books