Scripts


SQLplus Environment

login.sql

set pages 500
set lines 200
col object_name for a30
col segment_name for a30
col name for a70
col bytes for 999,999,999,999,999
col sum(bytes) for 999,999,999,999,999
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE> "


SQL to Generate SQL

SQL to Get Information

SQL for Performance Tuning

RMAN Scripts
Shell Scripts
 

No comments: