| Script Name |
Description |
c_count_rec_1.sql |
Counts records in all tables in the database
if specified so. Calls ctl_count_rec_2.sql
creates TEMPORARY FILE --> record_cnt.tmp
OUTPUT FILE --> record_count.out
+----------------------------------------------------+
| Please Note that TABLES with UNDEFINED data type |
| !!!! will not work with this script !!!! |
| Make Sure To check For their exsistance |
+----------------------------------------------------+
|
c_count_rec_2.sql |
** DO NOT RUN THIS SCRIPT BY IT SELF **
** This file is called by c_count_rec_1.sql **
|
c_db_bk_HOT.sql |
Generates and runs HOT back-up script
backup`s one tablespace at a time
|
c_plan.sql |
This script prints execution plan for SQL which
is already been explained in the PLAN_TABLE.
It will list all available SQL statement ID from PLAN_TABLE
and prompt you for the one you need to pring the explain plan for.
To actually create an EXPLAIN PLAN for a SQL stmnt use the following:
SQL> explain plan
SQL> set statement_id = ``
SQL> for
SQL>
Before using explain plan you need to create PLAN_TABLE
use ORACLE provided script for your platform ... RDBMS/ADMIN/UTLXPLAN.SQL
|
c_plan7.sql |
Purpose:
q and d to execute explain plan (Oracle 7.3)
Preparation:
Run $ORACLE_HOME/rdbms/admin/utlxplan.sql as SYSTEM
Create public synonym plan_table for plan_table
Grant all on plan_table to public
Create an index (id,parent_id) on plan_table
Use:
Put the guilty SQL statement (with `,`) into a file called
target.sql
Start explain7.sql
The script displays the current audit id, then
the execution path, simultaneously writing the
execution path to a file identified by the audit id.
|
c_plan8.sql |
Purpose:
q and d to execute explain plan (Oracle 8.0)
Preparation:
Run $ORACLE_HOME/rdbms/admin/utlxplan.sql as SYSTEM
Create public synonym plan_table for plan_table
Grant all on plan_table to public
Create an index (id,parent_id) on plan_table
Use:
Put the guilty SQL statement (with `,`) into a file called
target.sql
Start explain8.sql
The script displays the current audit id, then
the execution path, simultaneously writing the
execution path to a file identified by the audit id.
|
c_plan_script.sql |
Creates execution plan for a given SQL script
|
c_recomp_v7-8.sql |
Recompile all invalid objects.
|
c_recomp_v8i.sql |
Recompile all invalid objects including JAVA and TYPE.
Allows compile of a single schema or all schemas.
|
c_tab_rec.sql |
Creates DDL script to re-create a table
|
s_tabsp_mig_local.sql |
This script will migrate a tablespace
from DICTIONARY management to LOCAL
|
u_ascii.sql |
Prints ASCII table
|
u_autotrace.sql |
Creates PLAN table by running $ORACLE_HOME/rdbms/admin/utlxplan.sql
sets AUTOTRACE ON (traceonly explain)
|
u_find_string.sql |
Searches for character string in all tables and views.
|
u_prompt.sql |
Chages SQL Prompt to "USER@INSTANCE_NAME:HOST_NAME> "
|
u_tab_data.sql |
Display table row in "vertical" format
|
u_tab_delete_commit.sql |
creates DELETE_COMMIT procedure developed by Oracle Support
|
u_tab_sqlldr_ctl.sql |
builds SQL*Loader control file for a table
|
u_tab_sqlldr_data.sql |
Formats table data for SQL*Loader
|