Book of Expert tips for Oracle Utilities
Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN 10: 
0-9797951-3-3
ISBN 13:
978-0-9797951-3-8
Library of Congress Number: 2008944147
791 pages
Hardcover - 9x7
PD 1208
Shelving:  Databases/Oracle Oracle In-Focus Series #31

  Advanced Oracle Utilities
The Definitive Reference

Bert Scalzo
Donald K. Burleson
Steve Callan

Retail Price $59.95 /  £44.95
 

Order now at 30% off and get access to the code depot! Only $41.95
(30% off)

 

     
Key Features About the Author Reader Comments
Table of Contents Index Topics Errata
     

 


This is the definitive guide to all Oracle utilities, and it is targeted at experienced Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases.

The authors approach Oracle Utilities from a functional perspective, adding value by explaining the "why" and "how" for the use of all Oracle Utilities.  This comprehensive book includes details on all of the Oracle utilities, including experts-only sections on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities.

This indispensable book covers all areas of Oracle database administration and includes secrets for database migration (with Data Pump and SQL*Loader) and detailed tips for using The Oracle OS utilities (e.g. BBED, dbv, orastack, orakill).  The book also covers Oracle tuning utilities, including ADDM and the SQL tuning advisors as well as the traditional command-line tuning utilities such as dbms_alert and dbms_xplan, tkprof and dbms_debug.

This book is special because noted Oracle experts supplement the operational considerations of Oracle utilities with expert insights and working scripts.  The time savings from a single utility script is easily worth the price of this definitive book.

This book is not for beginners.  These are powerful utilities to be used only by experienced DBAs and developers who need to perform powerful system-wide operating system internal operations on their Oracle databases.


 

 
 

               
           Expert secrets
          & hidden utility
            tips & tricks

 

 

Key Features

• Understand how to automate database management with Oracle utilities.

• Learn about Oracle's secret hidden utilities.

• See how to use the Oracle DBMS package utilities.

• Get working examples of all Oracle utilities on the code depot download.

• Discover the secrets used by professional DBAs to perform advanced diagnostics.
 

About the Authors:
 

Bert Scalzo

 

Bert Scalzo is a Database Expert for Quest Software and a member of the TOAD dev team. He has worked with Oracle databases for well over two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and an extensive academic background - including a BS and MS in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE.

Mr. Scalzo is accomplished speaker and has presented at numerous Oracle conferences and user groups - including OOW, ODTUG, IOUG, OAUG, RMOUG and many others. His key areas of DBA interest are Data Modeling, Database Benchmarking, Database Tuning & Optimization, "Star Schema" Data Warehouses, Linux and VMware.

 Mr. Scalzo has written numerous articles, papers and blogs - including for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, Ask Toad and Toad World.

 Mr. Scalzo has also written six books: Oracle DBA Guide to Data Warehousing and Star Schemas, TOAD Handbook, TOAD Pocket Reference (2nd Ed),Database Benchmarking: Practical Methods for Oracle & SQL Server, Advanced Oracle Utilities: The Definitive Reference and Oracle on VMware: Expert Tips for Database Virtualization.



Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written more than 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle OpenWorld and other international database conferences.

 

Free Oracle Tips

HTML Text




Steve Callan
Steve Callan is an Oracle certified professional with over 20 years of progressive hands-on technical experience and nearly a decade managing mission-critical Oracle databases.  He is also a Microsoft Certified Professional (MCP), and is proficient in SQL Server 2005.  Steve has a Masters degree in Software and Information Systems from Regis University, and a Masters degree in Industrial Engineering from New Mexico State University.  He has also completed all Ph.D. coursework for his pending doctorate in Mathematical & Computer Sciences at the Colorado School of Mines.

A former senior U.S. Military officer, Steve is a graduate of the prestigious United States Military Academy at West Point, earning his wings as an attack helicopter pilot.  He has over 1,000 hours of operational aviation unit experience with Apache and Cobra attack choppers and won an Army senior aviator award for his piloting skills.

Steve lives in the Denver area and spends his spare time trying new wines, playing with computers, and writing a science fiction novel.

Table of Contents:

Using the Online Code Depot
Conventions Used in this Book
Acknowledgements

Chapter 1: Introduction to Oracle Utilities

Introduction
Definition of a Utility
What is a Hidden Utility?
Utility Locations

Methods of Discovery
Package Discovery
Package Utilities

UNIX Utilities and Shell Scripts
Windows Executables
Conclusion

Chapter 2: UNIX/Linux Oracle OS Utilities

Finding the OS Utilities in Linux/UNIX
Binary Discovery
UNIX/Linux Utilities for the Oracle Professional

Introduction to the UNIX Architecture
Dialects of UNIX
UNIX Access Control Management
UNIX and DOS Commands

Introduction to UNIX Utilities
Appending Data to UNIX Files
Redirecting Output to a NULL Device
Common Oracle UNIX Commands
File Management in UNIX
Directory Management in UNIX
The Oracle environment in UNIX
Dissecting Complex UNIX commands
Deciphering a Complex UNIX Command

Conclusion

Chapter 3: Windows Oracle OS Utilities

Reasons for Using Oracle on Windows
Windows Utilities for Monitoring Oracle

Checking Windows Services for Oracle
Test the Windows Oracle Service

Oracle Scripts for Windows
Sample Invocation of Oracle from Windows
Running a Data Pump Export from Windows
Sending Oracle Output via Windows Email
Monitoring Trace and Dump Files in Windows
Starting and Stopping Oracle on Windows

Conclusion

Chapter 4: Oracle Utilities for Server-Side Functions

Server Management
Database Creation and the DBCA
SQL*NET Configuration Files:  NETCA

External Functions
Auto Start and Auto Stop
lsnrctl
emca
emctl
relink
External job scheduling
Using the OPatch Utility
Utilities for Analyzing Oracle Trace Files
Using the Trace Analyzer Utility

Remote Connection Management
Using orapwd

Server Monitoring Utilities
Using vmstat

Server RAM and Oracle

Tracking External Server Metrics with AWR
Enterprise Manager for Server & Environment
Using AWR and STATSPACK for Server Monitoring
Vmstat to the Rescue
Using the ltom utility

File analysis
Using the BBED Block Editor Utility
Using and Linking BBED

File Analysis
The DBV Utility (Database Verify)

dbv

The dbms_repair Utility
Configuring the Environment
Finding Corrupt Blocks
Repairing Corrupt Blocks
Rebuilding Freelists

Process Management
kill
orakill
renice
trcsess
TKPROF

Using the Orastack Utility

RAC Management
VIPCA
crsctl
crs_start
crs_stop
crs_stat
srvctl

Storage Management
ocfs2console
mkfs.ocfs2
tunefs.ocfs2
fsck.ocfs2
mounted.ocfs2
asmtool
asmtoolg
asmcmd

Conclusion

Chapter 5: Oracle SQL Management Utilities

Introduction

SQL Utilities
SQL*Plus
SQL Developer
Toad for Oracle®

Advanced SQL Techniques
Login Scripts
Dynamic SQL Scripting
SET TIMING ON
TIMING START & STOP
Obtaining Explain Plans
SQL*Plus AUTOTRACE
Interpreting Explain Plans

Conclusion

Chapter 6: Oracle DBA Utilities

Introduction

Reorganization Utilities
Data Pump (EXPDP)
Export Transportable Tablespaces
IMPDP
Import Transportable Tablespaces
Import Partition Options
Import Remapping Options
DBMS_REDEFINITION
DBMS_METADATA


Recovery Utilities
DBMS_FLASHBACK
DBMS_LOGMNR

Job Scheduling
DBMS_JOBS
DBMS_SCHEDULER

Access Security
DBMS_RLS

File Security
DBMS_CRYPTO
DBMS_OBFUSCATION_TOOLKIT
UTL_COMPRESS
UTL_ENCODE

Replication
DBMS_AQADM
DBMS_AQ
DBMS_REPUTIL

Space Management
DBMS_SPACE_ADMIN
DBMS_SPACE

Data Corruption Utilities
DBVERIFY
DBMS_REPAIR

Database Session Management
DBMS_SESSION

File Management
DBMS_FILE_TRANSFER
UTL_SMTP
UTL_TCP
ASMCMD

Instance Management
DBMS_SHARED_POOL

Conclusion

 

Chapter 7: Oracle Tuning and Monitoring Utilities

Introduction

Tuning Utilities
DBMS_WORKLOAD_REPOSITORY
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
DBMS_ADVISOR

SQL Tuning
DBMS_ADVANCED_REWRITE
DBMS_STATS
DBMS_SQLTUNE

Monitoring
DBMS_ALERT
DBMS_SERVER_ALERT
DBMS_WARNING
DBMS_MONITOR

Conclusion

Chapter 8: Oracle Advisory and Diagnostic Utilities

Introduction

ADRCI: ADR Command Interpreter
Changes in Oracle 11g
ADRCI Command Line Interface

SQL Performance Analyzer
Defining a Workflow

Other Utilities
Advisor Central
Traditional Tracing Methods

Conclusion

Chapter 9: Oracle Developer Utilities

Introduction

UTL Utilities
UTL_COLL
UTL_COMPRESS
UTL_DBWS
UTL_ENCODE
UTL_FILE
UTL_HTTP
UTL_I18N
UTL_INADDR
UTL_LMS
UTL_MAIL
UTL_NLA
UTL_RAW
UTL_RECOMP
UTL_REF
UTL_SMTP
UTL_SPADV
UTL_TCP
UTL_URL

XML Utilities
DBMS_XMLGEN
DBMS_XMLSAVE
DBMS_XMLSTORE

Other Useful Utilities
Oerr
DBMS_PROFILER
DBMS_DEBUG

Conclusion

Chapter 10: BBED: The Block Browser and Editor Tool

Introduction
ROWID_INFO Procedure

Starting a Session
Altering Data
Undeleting a Row
Corrupted Blocks
Restoring Data
Restoring a File

Conclusion
Additional information

Chapter 11: Oracle  Job Scheduling

Introduction to Job Scheduling

Fundamentals of Job Scheduling
UNIX Job Scheduling (cron) vs dbms_scheduler
Job Scheduling Components

Using cron and crontab to Schedule Oracle Jobs

The crontab Options
The Format of the crontab File
Using the Windows Job Scheduler at.exe utility

Internal Oracle Job Scheduling
Oracle Scheduler Overview

Configuring Oracle Job Scheduling
Setting up a Test Environment

Overview of the dbms_scheduler Functions
Programs
Schedules

Creating Oracle Jobs
Job Classes
Oracle Job Scheduling Windows
Job Scheduling Window Groups
Enabling, Disabling and Setting Attributes of Scheduler Objects

Time-based Job Scheduling
Setting Job Execution Dates
Intervals and Interval Literals

Calendar Syntax in Oracle Job Scheduling

Complex Date Rules for Job Execution

Creating an Oracle Job Chain
Conditional Job Creation
Conditional Job Enabling
Conditional Job Runs Using Oracle Advanced Queuing
Conditional Job Runs Using a Custom Table Solution

Implementing Error Checking Routines

Sending Email Notifications of Job Errors
Using UTL_SMTP
Using UTL_MAIL in Oracle

Monitoring Oracle Job Execution

Killing Oracle Job Sessions
Setting Job Scheduler Attributes

Job Priorities

Scheduler Logging
Job Logs
Displaying Job Run Details
Window Logs
Purging Logs

Using the Job Resource Manager

Export/Import and the Scheduler

Job Services and Instance Stickiness

Conclusion

Index

About Bert Scalzo

About Donald K. Burleson

About Steve Callan

About Mike Reed

About Jeff Smith

Index:

$
$ORACLE_HOME

.
.bash_history
.bshrc
.cshrc
.ksh_history
.kshrc
.profile
.sh_history

@
@PRIOR_VERSION

_
_optimizer_cost_model

A
accept_sql_profile

active_plan.sql
Add Scheduled Task

add_alias_to_ldap

add_filter

add_grouped_policy
add_policy
add_policy_context

add_sqlset_reference
add_sqlwkld_ref
add_sts_ref

add_subscriber

add_warning_setting_cat
add_warning_setting_num
add_window_group_member

Advanced Queuing
after_index
all_directories
all_objects
alter_aq_agent
alter_propagation_schedule

alter_queue
alter_queue_table

alter_rewrite_equivalence
alter_sql_profile
alter_stats_history_retention

alter_subscriber

analyze
analyze table

analyze_table
APEX
Application Express
AQ

aq_administrator_role
aq_user_role

argument_name

argument_position

argument_type
argument_value

ash_report_html
ash_report_text

asmcmd
ASMCMD
asmtool
asmtoolg
assm_segment_verify
assm_tablespace_verify
AT

attach

ATTR5

attrib
auto_commit

auto_drop

a
uto_restrict
Automated Storage Management

automated_email_alert.sql
automated_email_alert_10g.sql

automatic data recording
Automatic Database Diagnostic Monitor
Automatic Diagnostic Repository
Automatic Session Tracing
Automatic Storage Management
Automatic Workload Repository
autostart
AUTOTRACE
awk

awr_diff_report_html
awr_diff_report_text
awr_sql_report_html
awr_sql_report_text

B
base64_decode
base64_encode
BATCH
BBED utility
before_index
Block Browser and Editor
block_end
block_size
block_start
Bourne shell

build_safe_rewrite_equivalence

C
calendar_string

calibrate
cancel_replay
cancel_task
cancel_tuning_task
capture_cursor_cache_sqlset

cd

check_object

chmod
chown
cjq0
clear_all_context
clear_context
clear_identifier
clear_set_identifier

client_id_stat_disable
client_id_stat_enable
client_id_trace_disable
client_id_trace_enable

close_all_connections
close_connection
close_data

close_window

Cluster Ready Services
Clusterware Control
command
command_replies
comments
Conditional job creation
Conditional job enabling
Conditional job runs
connect
connect internal

consumer_group_usage.sql
consumer_groups.sql
control_management_pack_access
convert_raw_value
convert_raw_value_nvarchar
convert_raw_value_rowid

copy_file

copy_job
copy_sqlwkld_tosts
copy_table_stats

coraenv

corrupt_count

corrupt_option
CPU-bound

create_10g_job_failure.sql

create_10g_job_max_runs.sql

create_action
create_aq_agent

create_baseline
create_baseline_template

create_consumer_groups.sql

create_extended_stats
create_file

create_index_cost

create_job
create_job_class

create_job_classes.sql
create_job_failure.sql

create_np_queue

create_object

create_plan_directive

create_policy_group
create_program
create_queue
create_queue_table

create_schedule
create_snapshot
create_sqlset
create_stat_table
create_stgtab_sqlprof
create_stgtab_sqlset_sqlprof

create_table_cost
create_table_cost_columns

create_task
create_tuning_task
create_window
create_window_group

Critical Patch Update
CRON
cron daemon
crontab
CRS
crs_start
crs_stat
crs_stop
crsctl
c-Shell

current_open_window

D
data
Data Definition Language
Data Encryption Standard
Data Pump Export
Data pump import
Data Recovery Advisor
Database Configuration Assistant
Database Control
Database Creation Assistant
Database Manager
Database Replay
Database Verify utility

database_trace_disable
database_trace_enable

datapump

DATE
DAY TO SECOND

day_plan.sql

day_precision
db_file_multiblock_read_count
db_writers
dba_advisor_actions
dba_advisor_findings
dba_advisor_objects
dba_advisor_recommendations
dba_advisor_tasks

dba_jobs

dba_jobs_running
dba_objects

dba_rsrc_%

dba_rsrc_consumer_groups

dba_rsrc_plan_directives
dba_scheduler_%

dba_scheduler_job_args
dba_scheduler_job_classes

dba_scheduler_job_log
dba_scheduler_job_run_details

dba_scheduler_jobs
dba_scheduler_program_args
dba_scheduler_programs

dba_scheduler_running_jobs

dba_scheduler_schedules

dba_scheduler_window_details

dba_scheduler_window_groups

dba_scheduler_window_log

dba_scheduler_windows
dba_scheduler_wingroup_members

DBA_SQLSET_STATEMENTS
dba_tab_columns

DBA_WORKLOAD_REPLAYS

dbca

DBCA

DBMS_ALERT
dbms_application_info

dbms_aqdbms_aqadm
dbms_crypto
dbms_datapump
DBMS_DEBUG
dbms_file_transfer
dbms_flashback
dbms_job
dbms_jobs
dbms_metadata

DBMS_MONITOR

dbms_obfuscation_toolkit

dbms_pipe

DBMS_PROFILER
dbms_redefinition
dbms_repair
dbms_reputil

dbms_resource_manager
dbms_resource_manager_privs

dbms_rls
dbms_scheduler

DBMS_SERVER_ALERT

dbms_service

dbms_session
dbms_shared_pool
dbms_space
dbms_space_admin
dbms_sqadm
DBMS_SQLPA
DBMS_SQLTUNE
dbms_system
dbms_system.ksdwrt

DBMS_WARNING
DBMS_WORKLOAD_REPLAY
DBMS_WORKLOAD_ REPOSITORY

DBMS_XPLAN
DBMS-TTS
dbshut
dbstart
dbv

dbv.cmd
dbv.ksh

DBVerify
DDL

declare_rewrite_equivalence

decrypt

default_action

DEFAULT_JOB_CLASS

default_timezone

DEFAULT_TIMEZONE
default_value

define_metadata_argument
define_program_argument

del_alias_from_ldap

delete_capture_info
delete_column_stats

delete_consumer_group

delete_database_prefs
delete_database_stats
delete_dictionary_stats
delete_filter
delete_fixed_object_stats
delete_index_stats
delete_pending_stats

delete_plan
delete_plans.sql

delete_policy_group

delete_replay_info
delete_schema_prefs
delete_schema_stats
delete_sqlset
delete_sts_ref
delete_system_stats
delete_table_prefs
delete_table_stats
delete_task

dequeue
dequeue_array
Des3decrypt
Des3getkey
Desdecrypt
diagnostic_dest

diff_table_stats_in_history
diff_table_stats_in_pending
diff_table_stats_in_stattab

dircmp
disable_db_access
disable_grouped_policy
disable_propagation_schedule
disabled_jobs.sql
drop_action
drop_aq_agent

drop_baseline
drop_baseline_template
drop_extended_stats

drop_grouped_policy

drop_job
drop_job_class

drop_job_classes.sql

drop_policy
drop_policy_context

drop_program
drop_program_argument

drop_queue
drop_queue_table

drop_rewrite_equivalence
drop_schedule
drop_snapshot_range
drop_sql_profile
drop_sqlset

DROP_SQLSET

drop_stat_table
drop_tuning_task

drop_window

drop_window_group

dump

dump_option

dump_orphan_keys
duration

E
EHLO
EM
emacs

enable

enable_db_access
enable_grouped_policy
enable_jms_types
enable_policy
enable_propagation_schedule
enabled
encrypt
end_date
enqueue
enqueue_array
Enterprise Manager
Enterprise Manager Command Line Utility
Enterprise Manager Configuration Assistant
errnum

evaluate_calendar_string
exception_job_proc_1.sql

EXECUTABLE
EXECUTE_ANALYSIS_TASK

execute_task
execute_tuning_task

execution plan

exp

exp_full_data

expand_message

expdp

EXPDP
explain
Explain Plan

export_awr
export_column_stats
export_database_prefs
export_database_stats
export_dictionary_stats
export_fixed_object_stats
export_index_stats
export_pending_stats
export_schema_prefs
export_schema_stats
export_system_stats
export_table_prefs
export_table_stats
extension

F
facility

fast_start_io_target

fast_start_mttr_target
find

finish_capture

fix_corrupt_blocks

fix_count

flags
flashback query
FLASHBACK TABLE
flashback_transaction_query
flush

flush_database_monitoring_info

force

fraction_second_precision
free_blocks
from_remote
fsck.ocfs2

G
gather_database_stats
gather_dictionary_stats
gather_fixed_object_stats
gather_index_stats
gather_schema_stats
gather_system_stats
gather_table_stats
generate_job_name
generate_stats
get_capture_info
get_category
get_column_stats

get_file

get_index_stats

get_line
get_line_nchar

get_prefs

get_raw

get_replay_info

get_rowinfo

get_scheduler_attribute

get_stats_history_availability
get_stats_history_retention
get_system_stats
get_table_stats
get_task_report
get_task_script

get_text
get_text_nchar

get_threshold
get_warning_setting_cat
get_warning_setting_num
get_warning_setting_string

get_watermark
glance
Global Services Daemon
global_name
grant_queue_privilege

grant_switch_consumer_group

grant_system_privilege
graves
grep
group_name
GSD

H
hanganalyze
hash
HELO
help

high water mark

Hotsos

I
ifconfig
ignorecase

imp

imp_full_database

impdp

IMPDP

implement_task
implement_tuning_task
import_awr
import_database_prefs
import_database_stats
import_dictionary_stats
import_fixed_object_stats
import_index_stats
import_schema_prefs
import_schema_stats
import_system_stats
import_table_prefs
import_table_stats

Index Organized Tables
index_object
init.ora

initialize_replay

inittab

instance_stickiness

interrupt_task
interrupt_tuning_task

interval
Intervals
isopen

J
job coordinator
job run history
job slave
job table

job_and_window_log
job_chain
job_chain_aq.sql

job_chain_aq_jobs.sql

job_chain_aq_query.sql
job_chain_aq_setup.sql
job_chain_create.sql
job_chain_create_job.sql

job_chain_custom_jobs.sql

job_chain_enable_jobs.sql
job_chain_locks
job_chain_locks_query.sql

job_chain_query.sql

job_chain_queue_tab

job_chain_table.sql
job_class

job_class_name

job_class_resource_privileges.sql
job_classes.sql

job_log

job_log_lifecycle.sql

job_name

job_priority

job_queue_processes

job_queue_query.sql
job_run_failures_10g.sql
job_run_history.sql
job_user

jobs_10g.sql

jobs_running.sql
jobs_running_10g.sql

John the Ripper
JServer
Julian dates

K
kcvcptim
kcvfhccc
kcvfhcpc
kill
Korn shell
kscnbas

L
language
Lempel-Ziv
listen
listener.ora

load_sqlset
lock_partition_stats
lock_schema_stats
lock_table_stats

log_checkpoint_interval
log_checkpoint_timeout

log_history

logging_full

logging_level
logging_off

logging_runs

ls..
ls
al
lsattr
lsinventory
lsnrctl
lsnsctl
ltom
lz_compress
lz_compress_add
lz_compress_close
lz_compress_open
lz_uncompress
lz_uncompress_close
lz_uncompress_extract
lz_uncompress_open

M
MAC
mail
mailto
make_internal_package
MANAGE SCHEDULER

mark_recommendation

max_failures
max_job_slave_processes
max_runs

max_users

maxmem

message

messagefile

metadata
migrate_queue_table
mimeheader_decode
mimeheader_encode
mkfs.ocfs2

modify_baseline_window_size
modify_snapshot_settings

mounted.ocfs2
MOVIERENTAL
mv

my_schedule_function.sql

N
name

Network Configuration Assistant
new_job

next_date

next_run_date

night_plan.sql

nls_date_format
NOOP
number_of_arguments
numuse

O
object_dependent_segments
object_growth_trend
object_name
object_type
ocfs2console

oemctl utility

oerr utility
old_job
OLTP

oltp_job_class

OLTP_SERVICE
Opatch
open_connection
open_data

open_window

optimizer_index_cost_adj
Oracle Cluster File System
Oracle Counters
Oracle Database Listener
Oracle Enterprise Manager
Oracle Forensics
Oracle Lite Onboard Monitor
Oracle Managed File
Oracle Parallel Server
Oracle Stream Advanced Queuing
oradebug
oradim
oraenv
orakill
orapwd

orastack

orcl
orphan_table

out_argument

P
p_mail_host

pack_stgtab_sqlprof
pack_stgtab_sqlset

page-in
page-out
page-stealing daemon
parfile
partition_name
patch_storage
peek
perfmon
pfile
PGA Advisor
pipe

plan_stat

PLSQL_BLOCK
PLUSTRACE
PLUSTRC

pname

post

prepare_column_value
prepare_replay

Print Working Directory
Privilege
Procedure Builder
Process Explorer

process_capture

product
program_action

program_args.sql
program_name

program_type

programs.sql

prtconf
ps
ps
ef
PStat

publis_pending_stats

purge_action
purge_options
purge_queue_table

purge_stats

put_file
pwd

Q
query_rewrite_enabled
query_rewrite_integrity

Queue Tables

quick_tune

QuickSlice
quit

quoted_printable_decode
quoted_printable_encode

R
RAC

raise_application_error

RCPT
read_line
read_raw
read_text
Real Application Clusters
Real Application Testing

rebuild_freelists

recyclebin
refresh_grouped_policy
refresh_policy
Regedit
register
relative_fno
relink

remap_connection

remap_data

remap_stgtab_sqlprof
remap_stgtab_sqlset

remap_table
remote_login_passwordfile

remove
remove_sqlset_reference

remove_subscriber

remove_window_group_member
removeall
rename_baseline

repair_table
repair_table_name
repeat_interval

REPLAY_CONNECTION

replication_is_on
replication_off
replication_on

report
report_auto_tuning_task
report_sql_monitor
report_tuning_task
reset_global_prefs_defaults
reset_param_defaults
reset_task
reset_tuning_task

resource_consumer_group

resource_manager_plan

resource_plan

resource_plan_directives.sql

restore_database_stats
restore_dictionary_stats
restore_fixed_object_stats
restore_schema_stats
restore_system_stats
restore_table_stats
resume_tuning_task

RETENTION GUARANTEE
return_after_date
revoke_queue_privilege
revoke_system_privilege
rm
rmdir

round

row level security
ROWID
RSET

run_job

running_job_consumer_groups.sql

S
sar
SAVEPOINT
scan_limit

schedule_name

schedule_propagation
Scheduled Tasks Wizard

scheduled_job_details.sql

scheduled_jobs.sql

scheduled_jobs_running.sql

schema_export
schema_name
SCHTASKS

script_tuning_task

sed
Segment Advisor
segment_corrupt
segment_drop_corrupt
segment_dump
segment_dump_bitmap_summary
segment_dump_extent_map
segment_id
segment_mark_corrupt
segment_mark_valid
segment_option
segment_verify
segment_verify_basic
segment_verify_deep
segment_verify_extents
segment_verify_extents_global

select_cursor_cache
select_sqlset
select_workload_repository
send_mail.sql

Sendmail

serv_mod_act_stat_disable
serv_mod_act_stat_enable
serv_mod_act_trace_disable

serv_mod_act_trace_enable

Server Control

service

session_trace_disable
session_trace_enable

SET TIMING

set_attribute
set_attribute_null
set_column_stats

set_context

set_database_prefs
set_default_task_parameter
set_defaults
set_global_prefs

set_identifier

set_index_stats

set_scheduler_attribute

set_schema_prefs
set_system_stats
set_table_prefs
set_table_stats
set_task_parameter
set_threshold
set_tuning_task_parameter
set_warning_setting_string

set_watermark
SGA Advisor

show_extended_stats_name

show_scheduler_attribute.sql

shutmode
shuttype

signal

smtp_out_server
snap-in

sort_area_size

space_usage
SQL Access Advisor
SQL Developer
SQL Performance Advisor
SQL Performance Analyzer
SQL Repair Advisor
SQL Tuning Advisor
SQL Tuning Sets
SQL*Loader
SQL*Plus
SQL*Trace

sqlfile

sqlnet.ora

sqltext_to_signature

srcvtl

srvctl

start_capture

start_date
start_queue

start_replay
statistics_level

Statspack
StatsPack

stop_job

stop_queue
storage_clause
STORED_PROCEDURE

sts_name

switch_group
switch_time

sync_up_rep

sysdate
systimestamp

T
table_comments.sql

table_object
table_type
tablespace_fix_bitmaps
tablespace_fix_segment_states
tablespace_migrate_from_local
tablespace_migrate_to_local
tablespace_rebuild_bitmaps
tablespace_rebuild_quotas
tablespace_relocate_bitmaps
tablespace_verify
taskkill

test_calendar_string.sql

test_date_string

test_resource_manager_job_1.sql

test_stored_procedure_prog

test_timestamp_string
text_decode
text_encode
timeout
TIMESTAMP
TIMING START
TIMING STOP
TKPROF

tnslsnr.exe

tnsnames.ora
Toad
top
Trace Analyzer
transaction_backout
transport_full_check
transportable tablespace
trcasst
trcsess
Triple DES

trunc

ts_option
ts_segments

tune_mview

tunefs.ocfs2

U
umask
uname
unbind
Undo Advisor

unlock_partition_stats
unlock_schema_stats
unlock_table_stats
unpack_stgtab_sqlprof
unpack_stgtab_sqlset

unregister
unschedule_propagation
unused_space

update_object
update_rec_attributes
update_sqlset
update_task_attributes
upgrade_stat_table

use_current_session
user_dump_dest
Utility
Utility Locations
UTL_COMPRESS
UTL_ENCODE
UTL_FILE
utl_file_dir
UTL_MAIL
UTL_SMTP
UTL_TCP
UUDECODE
UUENCODE

V
v$active_session_history

v$datafile
v$datafile.db_block_size

v$instance_recovery
v$logmnr_contents
v$mttr_target_advice
v$process

v$rsrc_consumer_group
v$rsrc_plan

v$session

v$session_longops

v$sql_monitor
v$sql_plan
v$sql_plan_monitor
v$sql_plan_statistics_all

validate_rewrite_equivalence

verify_option
vi
VIPCA
Virtual IP Configuration Assistant
Virtual Private Database
virtual private databases
vmstat
VRFY

W
waitany

wc
which
which_log
who

window_groups.sql

window_list

window_log
window_logs.sql

window_name
window_priority
Windows Performance Monitor

windows.sql

wordcount
write_data
write_line
write_raw
write_raw_data
write_text

Y
year_precision


 

Reviews:

From the series Editor:


 

Errata:

 

 

 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks