-
Notifications
You must be signed in to change notification settings - Fork 30
/
README.txt
137 lines (108 loc) · 6.6 KB
/
README.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
+------------------------------------------------------------------------------+
| DBA Scripts Archive for Oracle |
| README.txt |
| ---------------------------------------------------------------------------- |
| Jeffrey M. Hunter |
| jhunter@idevelopment.info |
| www.idevelopment.info |
| ---------------------------------------------------------------------------- |
| Copyright (c) 1998-2015 Jeffrey M. Hunter. All rights reserved. |
| ---------------------------------------------------------------------------- |
| All scripts and material located at the Internet address of |
| http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is |
| protected under copyright laws of the United States. These scripts may not |
| be hosted on any other site without my express, prior, written permission. |
| Application to host any of the material elsewhere can be made by contacting |
| me at jhunter@idevelopment.info. |
| |
| I have made every effort and taken great care in making sure that the |
| scripts included on my web site are technically accurate, but I disclaim any |
| and all responsibility for any loss, damage or destruction of data or any |
| other property which may arise from relying on it. I will in no case be |
| liable for any monetary damages arising from such loss, damage or |
| destruction. |
| ---------------------------------------------------------------------------- |
| This README.txt file provides notes on how to configure your operating |
| system environment to run the DBA Scripts Archive for Oracle provided from |
| the www.idevelopment.info website. |
+------------------------------------------------------------------------------+
=============================
INSTALLATION
=============================
Available from the www.idevelopment.info web site, the DBA Scripts Archive for
Oracle comes archived in the popular ZIP format. The same archived file can be
used for both Microsoft Windows and UNIX.
The DBA Scripts Archive for Oracle is typically installed as the Oracle
Database software owner (for example, "oracle") in the ORACLE_BASE directory,
although any directory will work. To install, simply download the archived file
to the ORACLE_BASE directory (i.e. c:\oracle) and run the appropriate command
to extract its contents:
-----------------------
UNIX
-----------------------
cd $ORACLE_BASE
unzip dba_scripts_archive_Oracle.zip
-----------------------
MS WINDOWS
-----------------------
cd %ORACLE_BASE%
unzip dba_scripts_archive_Oracle.zip
=============================
CONFIGURATION
=============================
After successfully extracting the DBA Scripts Archive for Oracle to the
ORACLE_BASE directory, configure the appropriate environment variable(s) in
the operating system environment for the current UNIX shell to ensure the
Oracle SQL scripts can be run from SQL*Plus while in any directory.
-----------------------
UNIX
-----------------------
PATH=/u01/app/oracle/dba_scripts/bin:$PATH
ORACLE_PATH=.:$ORACLE_BASE/dba_scripts/sql:$ORACLE_HOME/rdbms/admin
-----------------------
MS WINDOWS
-----------------------
PATH=c:\oracle\dba_scripts\bin;%PATH%
SQLPATH=.;%ORACLE_BASE%\dba_scripts\sql;%ORACLE_HOME%\rdbms\admin
=============================
RUNNING SQL SCRIPTS
=============================
DBA's rely on Oracle's data dictionary views and dynamic performance views in
order to support and better manage their databases. Although these views
provide a simple and easy mechanism to query critical information regarding
the database, it helps to have a collection of accurate and readily available
SQL scripts to query these views.
Once the DBA Scripts Archive for Oracle has been extracted and the appropriate
environment variables set, users will be able to run any of the SQL scripts
located in the ORACLE_BASE/dba_scripts/sql directory while logged into
SQL*Plus.
For example, to query tablespace information while logged into the Oracle
database as a DBA user:
SQL> @dba_tablespaces
Status Tablespace Name TS Type Ext. Mgt. Seg. Mgt. Tablespace Size Used (in bytes) Pct. Used
-------- ----------------- ----------- ---------- --------- ----------------- ----------------- ---------
ONLINE SYSAUX PERMANENT LOCAL AUTO 1,073,741,824 528,547,840 49
ONLINE UNDOTBS1 UNDO LOCAL MANUAL 524,288,000 12,058,624 2
ONLINE USERS PERMANENT LOCAL AUTO 104,857,600 1,048,576 1
ONLINE SYSTEM PERMANENT LOCAL MANUAL 1,073,741,824 714,866,688 67
ONLINE EXAMPLE PERMANENT LOCAL AUTO 524,288,000 85,131,264 16
ONLINE TEMP TEMPORARY LOCAL MANUAL 524,288,000 66,060,288 13
----------------- ----------------- ---------
avg 25
sum 3,825,205,248 1,407,713,280
6 rows selected.
NOTE: The ORACLE_PATH (in UNIX) and SQLPATH (in Windows) environment variables
do not work in Oracle Release 8.1.7.4.0 and 9.2.0.4.0. Users will have
to either run SQL*Plus from the directory containing the Oracle SQL
scripts or simply provide the absolute path to the SQL scripts.
From example:
SQL> @C:\oracle\dba_scripts\sql\dba_tablespaces
=============================
RUNNING EXECUTABLE SCRIPTS
=============================
Executable operating system scripts are located in the
ORACLE_BASE/dba_scripts/bin directory for both UNIX and MS Windows.
These scripts can be used to assist the DBA in managing and monitoring
databases hosted on that machine.
UNIX shell scripts can be identified with either an sh or ksh extension while
command scripts for MS Windows will have ps1, cmd, vbs, js, or bat extensions.