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
0-9740716-0-9 
ISBN 13
978-0974071602
Library of Congress Number: 2003097635
527 Pages - Perfect bind 9x7 PD 1103
Shelving: Databases/Oracle Oracle In-Focus Series # 12

  Oracle Database 10g New Features 
Oracle10g Reference for Advanced Tuning & Administration

Mike Ault, Daniel Liu, Madhu Tumma

Retail Price $34.95
/ £20.75 

Order now and get 40% off and get the online code depot! Only $19.95  
(40% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     
Get the RAC Pack - Half price!
Six Pack RAC for $79.95 - A $168.00 value
Oracle 10g Grid & Real Application Clusters $69.95
Personal Oracle RAC Clusters $27.95
Oracle on VMware $34.95
Oracle SQL Internals eBook $19.95
Oracle Space Management eBook $24.95
Oracle 10g DBA Reference Poster

$8.95


Written by the world's most widely-read authors of best-selling Oracle books, Mike Ault, Daniel Liu and Madhu Tumma target their substantial knowledge of evaluating Oracle new features in this important book. With decades of experience evaluating new Oracle features, this book focuses on the most important new DBA features of Oracle 10g as they relate to database administration and Oracle tuning.

This book provides honest feedback about those Oracle 10g features that you should use, and those you should not use. The text takes an in-depth look at those Oracle10g features that are the most important to system performance and Oracle10g database administration.

Best of all, the authors have created dozens of working samples in the Oracle10g online code depot. Examples from all areas of Oracle10g are covered with working scripts and code snippets. Your time savings from a single script is worth the price of this great book.
 

 
Key Features

* Receive an online code depot to get you started fast with Oracle10g.

* Learn a complete conceptual framework for all areas of Oracle10g new features for DBAs.

* Learn about important changes to the Oracle10g SQL optimizer.

* Examine the automated SQLAccess Advisor for SQL tuning.

* Automate your Oracle10g storage with Automated Storage Management (ASM).

* See how to use the 20 new Oracle10g initialization parameters.

* Load your Oracle10g database fast with the new Oracle10g data pump utility.

* Understand important enhancements to Oracle Real Application Clusters 10g.

About the Authors:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 

Daniel Liu

Daniel Liu is a senior Oracle Database Administrator at First American Real Estate Solutions in Anaheim, CA. He has many years of industry experience in database administration and software development.  He has worked with large-scale databases in multi-platform environments.  His expertise includes Oracle database administration, performance tuning, Oracle networking, and Oracle Application Server. 

As an Oracle Certified Professional, he taught Oracle certified DBA classes at Elite Consulting Group in Chicago. Daniel also taught IOUG University Seminar in Orlando.  Daniel has published articles with DBAzine, Oracle Internals, and SELECT Journal.  Daniel has received SELECT Editorial Award for Best Article in 2001.  He has also given presentations at IOUG-A Live, LAOUG, OCOUG, NoCOUG, Oracle Open World and Oracle World.   Daniel has served as panelist on Oracles of Oracle at Oracle World and IOUG-Live.  Daniel holds a Master of Science degree in computer science from Northern Illinois University.
 


Madhu Tumma

Madhu Tumma has been working as Software Developer, IT Manager, Database Administrator, and Technical Consultant for about 18 years. He has worked on a wide variety of projects and environments ranging from mainframe, client-server, eBusiness to managed services. He has provided consultancy to variety of clients on database clusters, business continuity and high availability solutions.

His experience ranges across multiple relational database systems. Madhu is frequent speaker at Oracle World and IOUG where he presented many technical papers. Madhu has Master Degree in science and attended Business Management graduate program. He lives in New Jersey with his wife Hema and two children Sandi and Sudeep.

Table of Contents:
Chapter 1: New Features for Database Creation and Deletion
SYSAUX Tablespace
Automated Storage Management Configuration
Automated RAC Services Configuration
Simplified Upgrade for RAC and OPS Databases
Drop Database
 
Chapter 2: Database Tuning and Performance Improvements
Database Resource Manager Improvements
  • Database Resource Manager Overview
  • Adaptive Consumer Group Mapping
  • Fixed CPU Quota
  • Integration of Resource Manager and Profiles
Tuning Improvements
  • Buffer Cache Flushing - User Initiated
  • Automated Checkpoint Tuning
  • CPU Costing
  • Dynamic Sampling
Tuning Transaction Recovery
  • Easy Transaction Recovery Monitoring
Oracle Enterprise Manager Changes
  • Overview of the changes
  • SQL Reporting
  • New Performance Overview Charts
Single-Set Aggregates in DML Returning Clause
New and Updated Optimizer Hints
Wait Model Improvements
  • Overview of enhancements
  • Changes and updates
Application Tuning
  • Overview of improvements
  • SQL Access Advisor
  • Materialized View Tuning API - The new TUNE_MVIEW API
New Static Data Dictionary Views
  • Overview
  • List of Views and Explanation
New Dynamic Performance Views
  • Overview
  • List of Views
Static data dictionary views have new columns
Dynamic performance views have new columns
 
CHAPTER 3 - New Features for Tablespace Management
Temporary Tablespace
·        Temporary Tablespace Group Overview
·        Temporary Tablespace Group Benefits
·        Examples
Rename Tablespace
·        Tablespace Rename Overview
·        Tablespace Rename Benefits
·        Examples
Bigfile Tablespace
·        Bigfile Tablespace Overview
·        Bigfile Tablespace Benefits
·        Extended ROWID Format
·        Examples
Automated Storage Management (ASM)
·        Automated Storage Management Overview
·        Automated Storage Management Benefits
·        ASM Disk Group
·        ASM Disk
·        ASM Files
·        ASM Instance
 
Chapter 4: New Table and Index Features
Creating a Sorted Hash Cluster
  • Benefits
  • Examples
 
Partitioning Improvement
  • Overview of Improvements in Partitioning
  • Global Partitioned Indexes - Hash Partitioning
  • Enhancements for Partitioned Index-Organized Tables
   - List Partitioning
   - LOB Support
   - Global Index Maintenance
  • Local Partitioned Indexes Manageability Improvements
  • Enhanced Partition Management in Enterprise Manager
 
Enhanced Bitmap Index Performance and Space Management
 
Chapter 5: New DML Features: Insert, Update and Delete
Single-Set Aggregates in DML Returning Clause
Upsert through SQL Interrow Calculations
 
Chapter 6: New SELECT features
SQLAccess Advisor
Materialized View Tuning API
Grouped Table Outer Join
Increased Number of Aggregates per Query
SQL Interrow Calculations
Remote Stored Functions in SELECT Statements
Native Net Over Fast Interconnects
Native Net Over TCP/IP
Case-Insensitive and Accent-Insensitive Query and Sort
Enhanced Collections
Enhanced CONNECT BY Support
Oracle Expression Filter
SQL Regular
Row Timestamp
 
 
Chapter 7: Improved Features: MERGE, EXTERNAL TABLES, MINSERT
Asynchronous Change Data
Cross-Platform Transportable Tablespaces
Enhanced Table Functions
External Tables Unload
Enhanced MERGE Functionality
 
 
CHAPTER 8 – New Initialization Parameters
Type of Initialization Parameters
Twenty New Parameters
            CREATE_STORED_OUTLINES
            DB_ALLOWED_LOGIN_VERSION
            DB_FLASHBACK_RETENTION_TARGET
            DB_RECOVERY_FILE_DEST
            DB_RECOVERY_FILE_DEST_SIZE
            DDL_WAIT_FOR_LICKS
            INSTANCE_TYPE
            LDAP_DIRECTORY_ACCESS
            LOG_ARCHIVE_CONFIG
            OSM_DISK_REPARIR_TIME
            OSM_DISKGROUPS
            OSM_DISKSTRING
            OSM_POWER_LIMIT
            PLSQL_OPTIMIZE_LEVEL
            PLSQL_WARNINGS
            RESUMABLE_TIMEOUT
            SKIP_UNUSABLE_INDESES
            SMTP_OUT_SERVER
            SP_NAME
            STREAMS_POOL_SIZE
 
 
Chapter 9 - New Management Features
Database Startup and Shutdown
  • Overview of enhancements
  • Database Automated Startup and Shutdown Configuration
Database Install
  • Simplified Database Install
Improvements in Auditing
  • Uniform Audit Trail
  • Extended SQL Support in FGA
Easier Database Registration
Unified User Model
 
Chapter 10 – Utilities Improvements
Data Pump Utilities
·        Data Pump Overview
·        Data Pump Benefits
·        Data Pump Export
·        Data Pump Export Examples
·        Data Pump Import
·        Data Pump Import Examples
SQL*Loader Improvements
·        Direct Path Support for ROWID Datatype
·        Direct Path Support for VARRAY Datatype
·        Direct Path Support for XML Type Tables
SQL*Plus Enhancements
·        Session Configuration
·        SQL Prompt Runtime Variable Substitution
·        DESCRIBE Command Improvements
·        SPOOL Command Improvements
·        Show Recycle Bin
·        SQL*Plus Compatibility
iSQL*Plus Enhancements        
·        Input Prompting
·        Command Changes     
New Scheduler Utilities
·        Introduction to Scheduler
·        Scheduler Architecture
·        Program and Job Concepts
·        Managing Jobs and Programs
·        Data Dictionary View for Scheduler                 
·        Examples
 
Chapter 11: New Network Features
Back Up Directory Naming Entries to Local Naming File
Dynamic Connection Manager Configuration
Easy Connect Naming Method
Easy OCI/JDBC Install
Improved Network Outage Detection
Simplified Directory Usage Configuration
Improved Connection Manager Access Rules
Automated Shared Server Configuration
Simplified Shared Server Configuration Parameters
Certificate Validation with Certificate Revocation Lists (CRLs)
Centralized CRL Management
Centralized User Management for Kerberos Users
Kerberos-Enabled Database Links
Operating System Credential Cache
Access to Single Sign On Wallet
Key Store Interface
End-to-End Identity Propagation
Database Authentication with Standard LDAP Password Verifiers
Single Station Administration for Password Authentication to Oracle Database
Smart Card Support for X509v3 Certificates
.Transport Layer Security (TLS) Support
SSL Session Renegotiation
Performance Improvements
4096-Bit Key Size Support
 
Chapter 12 – Backup and Recovery New Features
Extended Flashback Functions
·        Flashback Database
·        Flashback Standby Database
·        Flashback Re-instantiation
·        Flashback Drop
·        Flashback Table
·        Flashback Row History
·        Flashback Transaction History
RMAN Enhancements
·        Automated Channel Failover for Backup and Restore
·        Automated File Creation During Recovery
·        Simplified Backups to Disk
·        Proxy Copy Backup of Archivelogs
·        Incrementally Updated Backups
·        Simplified Recovery Through Resetlogs
·        Restore Tolerates Corrupt or Missing Backups
·        Full Database Begin Backup Command
·        Change-Aware Incremental Backups
·        Automated Disk-Based Backup and Recovery
·        RMAN Database Deregistration
·        Backup of Standby Control File
·        Automated TSPITR Instantiation
·        Simplified Recovery Manager Cataloging of Backup Files
 
Chapter 13 - High Availability Improvements
Log Miner
  • Overview of the improvements
  • Automated LogMiner Configuration
  • Support for Index-Organized Tables
  • Support for Additional Types
  • LONG, Multibyte CLOB and NCLOB
Real Application Clusters
  • Overview of the Improvements
  • Data guard broker support
  • CRS (Cluster Ready Services)
  • workload management improvements
- manage, and monitor application workloads as a service
  • Improved Streams RAC Support
- supports hot mining,
- automatically restart processes after failover
- supplemental logging
  • Installtion and configuration
- Overview of the improvements
- Changes to OUI
- Changes to DBCA
            - suppot for ASM
            - Support for OMF
- Virtual Internet Protocol Assistant (VIPCA)
  • Improvements to adding a node
  • Support for rolling upgrades for one-off patches
- using Cluster File System
  • Optimizing the Cache Fusion
- Dynamic affinity policy enhancements
  • Enhancements to SRVCTL utility
  • New Cluster Database Management Tools
  • OEM enhancements
Data Guard
  • Simplified Zero Data Loss for Data Guard SQL Apply
  • Real Time Apply
  • Named Data Guard Configurations
  • Secured Redo Transmission
  • Zero Downtime Instantiation for SQL Apply
Supplemental Logging
  • Fine-Grained
Enhanced Online Redefinition
Improved Handling of DDL Locks on Busy Tables
Signature-Based Dependency Tracking Using Synonyms
 
Chapter 14 - Oracle Streams
Overview of Streams
  • Batch Enqueue/Dequeue
Downstream Capture
  • Downstream Capture Overview
  • Creating a Downstream Capture Process
Performance Enhancements for greater work loads
  • Enhanced Capture and Apply Performance
  • Performance Enhancements for AnyData Queues, Rules, and Propagation
Updates to the Rules
  • Easy Rules Engine Transformation Management
  • Negative Rules
  • Tuning Rules
Improved Enqueue Handler
Access to Additional LCR Attributes
Row Subsetting
Additional Support
  • for Long and NCLOB datatypes
  • for IOT Support
High-Level API for Message Queuing
LCR.EXECUTE procedure improvements
Streams packaged procedures Enhancements
  • Set Instantiation SCN at Apply Site
  • Clean Up Rules Sets
  • Instantiation Through Transportable Tablespaces
  • New APIs to Grant Privileges
Improved Capture and Apply Error Handling
Methods for providing faster instantiation
  • Using RMAN
Expose Commit Order of Changes 
Advanced Replication to Streams Migration Tool
Improved Monitoring methods
Better interoperation with Oracle RAC
  • capture changes from redo log as well as the archived redo log
  • automatic transfer of the queue
New streams related dynamic performance views
New streams related initialization parameters
 
Chapter 15: Security Enhancements
VPD Support for Parallel Query
VPD Static and Dynamic Policies
Column-level VPD
 
Chapter 16 - Business Intelligence
Data Warehousing Enhancements
  • Interrow Calculations
  • SQLAccess Advisor tool
    • DBMS_ADVISOR package
    • for Indexing
    • for materialized view
  • Partitioning Enhancements
    • partitioning for index-organized tables.
    • partitioning materialized views in OLAP
    • Hash-partitioned global indexes.
  • ETL Enhancements
SQL Support for Analytic Applications
  • Grouped Table Outer Join
  • Size of aggregations in a single SQL statement.
  • SQL Inter-row Calculations
Summary Management
  • Enhanced Partition-aware Materialized View Refresh
  • EXPLAIN PLAN Shows Materialized View Access The
  • Enhanced Dimensions
  • Nested Materialized View Refresh Materialized
  • Enhanced PCT Refresh Partition
  • Query Rewrite Uses Multiple Materialized Views
New OLAP capabilities
  • Parallel AGGREGATE Command
  • Parallel SQL IMPORT Command
  • PL/SQL Creation of Analytic Workspaces
  • Intra-Dimensional (Attribute) Aggregation
  • Enhanced Composite Dimensions Indexing
  • PL/SQL OLAP Measure Calculation Definition
  • Complete Analytical Workspace Management
  • Multi-Writer Support
  • XML Interface for Analytic Workspace
Support for Bioinformatics
  • DOUBLE and FLOAT Datatypes
  • Blast Queries
  • Statistical Functions
  • Document Clustering
  • Document Named Entity Extraction
  • Support Vector Machines
  • Document Clustering Non-negative Matrix Factorization
  • Document Clustering Neural Nets
  • Taxonomy Builder
Data Mining for Analytical 
  • Attribute Importance Algorithms
  • Enhanced Data Preprocessing
  • PMML Producers / Consumers
  • Data Mining Rapid Application Development
  • Multi-User Access Control
  • JSR-73 RI & TCK (Java Data Mining)
  • Complete Oracle Data Mining Management GUI
  • Enhanced Adaptive Bayes Network
  • Enhanced Model Seeker
 
Chapter 17: Globalization Improvements
Globalization Development Kit
Enhanced Character Set Scanner and Converter
CLOB and NCLOB Implicit Conversions
Unicode 3.2 Support
Expanded Locale Coverage
 

Please note that the correct name for the new Oracle Database is "Oracle Database 10g". Incorrect  references to the new Oracle Database 10g include: Oracle Database 10g, Oracle 10g, Oracle Database10 g, OracleDB 10g, The Oracle Database 10g, Oracle  RAC 10g, Oracle10g.

BEI offers Oracle10g training classes, Oracle10g consulting, and Oracle10g tuning.

This book has Oracle10g database administration and Oracle10g DBA concepts.

Reviews:

Sandi from Ft. Lauderdale, FL says:
This is one of the best new features book that I have seen in quite some time. It goes beyond the high-level overview of the new 10g features and give working examples about how the features relate to existing Oracle9i systems.

This is one book that I expect to use very frequently as I get started in 10g.


Mladen from Connecticut says:

This is an excellent and exhaustive review of oracle 10g new features. It contains a great list of new features, together with clear explanations and numerous examples. Being a senior DBA, I find this book to be a great help in my study of 10g.

Coming from Mike Ault, a well known author of database management books and a long time DBA himself, I expected nothing short of excellence, and, once again, Mike and his co-authors delivered. Excellent book, a must have for anybody who wants to learn about the oracle latest and the greatest database software.

Dan Hotka from Iowa says:

Rating: *****

I purchased this book to get a jump-start on the new features of the latest Oracle database product…and reading this book…that is exactly what I received. The book is organized into general topics about the new database product. DB Management, Tuning & Performance, and various features including backup and recovery, high availability, and topics including new RAC features, initialization parameters, Streams, Enterprise Manager, and more.

Like all books Mike Ault is involved with, this book is loaded with scripts and practical examples for each topic. I found this book an essential part of my Oracle10g learning process.

Thank you Mike, Daniel, and Madhu for assembling a fine book in a timely manner.

Errata:

The index in the Oracle 10g New Features book has various broken page number links.  The page numbers should correspond to the correct indexed term in this version.  The corrected index is in PDF form and should be formatted to print, cut and insert the new index into the back cover of the book.


Note: Oracle changed the names of the following views from v$osm to v$asm, and they may be different, depending on your release level of Oracle10g:

http://otn.oracle.com/pls/db10g/db10g.drilldown?word=v$osm_alias


The DML statements that can use the single-set aggregates in their returning clauses are UPDATE and DELETE. We will begin with the UPDATE statement.
 

Single-set Aggregates in UPDATE Statements

The general format for the UPDATE statement when using a RETURING clause is for a single table UPDATE, using the INTO clause is shown below.

UPDATE <table|MV|view> SET <column>=<exprs>|<subquery>
RETURNING <exprs> INTO <data_items>;

Where:

  • Table or expression -- This is a valid table, materialized view or updatable view
  • Column,… -- A comma-separated list of column names or a single column name
  • Subquery - a valid subquery to generate updated values
  • Exprs -- A set of expressions based on the affected row
  • Data_items -- A valid set of variables in which to load the values returned by the expressions

The purpose of the RETURNING clause is to return the rows affected by the UPDATE statement. The RETURNING clause can only be used with single tables and materialized views and regular views based on a single table.

When the target of the UPDATE is a single row, the RETURNING clause can retrieve column expressions using the affected row, rowid, and REFs to the affected row.

Single-set aggregates can only be used when the returning clause returns a single row. Single-set aggregates cannot be combined with simple expressions in the same returning clause. Single-set aggregates cannot contain the DISTINCT keyword. Single-set aggregates cannot be used with an INSERT statement.

An example UPDATE using the RETURNING clause and a single-set aggregate would be:

Set serveroutput on
Variable tot_sal number;
begin
UPDATE emp SET sal=sal*1.1
RETURNING sum(sal) INTO :tot_sal;
dbms_output.put_line('Total Company Payroll now : ' || to_char(:tot_sal,'$999,999.00'));
end;
/

An example of running this would be:

SQL> Set serveroutput on
SQL> Variable tot_sal number;
SQL> begin
  2  UPDATE emp SET sal=sal*1.1
  3  RETURNING sum(sal) INTO :tot_sal;
  4  dbms_output.put_line('Total Company Payroll now : ' || to_char(:tot_sal,'$999,999.00'));
  5  end;
  6  /
Total Company Payroll now :   $31,927.50
 
PL/SQL procedure successfully completed.

 

 


Index Topics:

A
act
active_sess_pool_p
add_elementary_attribute
add_functions
add_global_propagation_rule
add_global_rule
add_message_propagation_rule
add_message_rule
add_subset_propagation_rules
add_subset_rules
all_logfiles
all_roles
alter_apply
alter_capture
alter_change_set
alter_index_split_partition
alter_propagation
archival_source
assign_attribute_set
attribute
attribute_name
attribute_set_instance
attribute_value
audit_trail
auto_degree
Automated Memory Management
Automatic Database Diagnostic Monitor
Automatic Maintenance Tasks
Automatic Memory Management
Automatic Storage Management
Automatic Workload Repository
AUXSYS
B
Bioinformatics
buffer
buffer_cache
buffer_pool_keep
build_exception_table
C
CARDINALITY
catexf.sql
catnoexf.sql
cell_assignment
cell_reference_options
charset
circuits
clear_exprset_stats
client_id_stat_disable
client_id_stat_enable
close_iterator
cluster_database
cman.ora
column_type_list
commit
compatible
compile
compress
connect_by_iscycle
connect_by_isleaf
connect_by_root
connect_data
Connection Manager
cons_constraint
cons_index
cons_trigger
consumer_group
context_sensitive
control_files
copy_attribute_set
copy_orig_params
copy_table_dependents
cpu_costing
cpu_p#
create_apply
create_attribute_set
create_baseline
create_plan_directive
create_rule_set
create_schedule
create_simple_plan
create_snapshot
create_stored_outlines
create_tuning_task
D
Data Guard Log Apply Services
Database Configuration Assistant
Database Resource Manager
database_role
db_block_buffers
db_block_size
db_cache_advice
db_cache_size
db_create_file_dest
db_create_online_log_dest_n
db_domain
db_file_name_convert
db_flashback_retention_target
db_keep_cache_size
db_name
db_recovery_file_dest
db_recovery_file_dest_size
db_recycle_cache_size
db_unique_name
db_xk_cache_size
dba_apply
dba_capture
dba_datapump_jobs
dba_datapump_sessions
dba_dim_attributes
dba_dimensions
dba_feature_usage_statistics
dba_high_water_mark_statistics
dba_logstdby_log
dba_logstdby_progress
dba_logstdby_unsupported
dba_propagation
dba_recyclebin
dba_registered_archived_log
dba_rule_set_rules
dba_streams_message_consumers
dba_streams_message_rules
dba_streams_table_rules
dba_streams_transform_function
dba_tablespace_groups
dba_tablespaces
dba_transaction_query
dba_tune_mview
DBCA
dbms_apply_adm
dbms_aw_xml
dbms_capture_adm
dbms_dimension
dbms_distributed_trust_admin
dbms_expfil
dbms_fga
dbms_flashback
dbms_logmnr
dbms_logmnr_d
dbms_monitor
dbms_mview
dbms_olap
dbms_propagation_adm
dbms_redefinition
dbms_registry
dbms_resource_manager
dbms_rowid
dbms_rule_adm
dbms_scheduler
dbms_service
dbms_sqltune
dbms_stats
dbms_streams_adm
dbms_streams_auth
dbms_streams_messaging
dbms_workload_repository
ddl_wait_for_locks
default_consumer_group
default_degree
default_index_parameters
default_xpindex_parameters
defrag_index
degree
DELETE
delete_fixed_objects_stats
Deprecated Hints
and_equal
expand_gset_to_union
hash_aj
hash_sj
merge_aj
merge_sj
nl_aj
nl_sj
ordered_predicates
ROWID
STAR
dequeue_mode
describe_dimension
dimension_exceptions
direct
dispatchers
DISTINCT
drop_attribute_set
drop_baseline
drop_snapshot_range
dst
dynamic
E
end_logmnr
estimate_only
estimated_mttr
exclude
execute_tuning_task
exf$table_alias
exfeapvs.plb
exfimpvs.plb
exfpbs.sql
exfsppvs.plb
exftab.sql
exftyp.sql
exfview.sql
exfxppvs.plb
export_fixed_objects_stats
expression_column
 
F
fast_start_mttr_target
fast_start_parallel_rollback
filesize
finish_redef_table
flashback_scn
flashback_time
G
gather_database_stats
gather_dictionary_stats
gather_fixed
gather_fixed_objects_stats
gather_schema_stats
gather_sys
gather_table_stats
get_commit_scn
get_compatible
get_exprset_stats
get_extra_attribute
get_next_hit
global_dbname
grant_admin_privilege
grant_privilege
grant_privileges
group_or_subplan
H
hash_area_size
hs_call_name
I
ignore nav
import_fixed_objects_stats
in_expr
include
include_extra_attribute
include_notification
inclusion_rule
index_parameters
index_ss
index_ss_asc
index_ss_desc
initexf.sql
initsid.ora
INSERT
instance_number
instance_type
INTO
iot_storage_clause
J
java.nio.charset
java.nio.charsetjava
java_pool_size
job_name
job_queue_processes
K
keep nav
keep_master
kill_job
L
large_pool_size
ldap_directory_access
like_expr
listener.ora
local_listener
lock_name_space
log_archive_config
log_archive_dest_
log_archive_dest_
log_archive_dest_n
log_archive_dest_state_n
log_archive_format
log_archive_start
log_buffer
log_purge_policy
M
main_spreadsheet
max_dispatchers
max_est_exec_time
max_idle_blocker_time
max_idle_time
max_shared_servers
maxvalue
maybe_rules_iterator
merge_insert_clause
merge_update_clause
modify_snapshot_settings
mts_circuits See circuits
mts_dispatchers See dispatchers
mts_listener_address See local_listener
mts_max_servers See max_shared_servers
mts_max-dispatchers See max_dispatchers
mts_multiple_listeners See local_listener
mts_servers See shared_servers
mts_sessions See shared_server_sessions
multi_col_for_loop
multi_column_for_loop
N
negative_rule_set_name
negative_rule_set_owner
network_link
nls_date_format
nls_lang
nls_language
nls_sort
nls_territory
no_cpu_costing
no_index_ffs
no_index_ss
no_parallel
no_parallel_index
no_rewrite
no_star_transformation
no_use_hash
no_use_merge
no_use_nl
nologfile
noparallel See no_parallel
noparallel_index See no_parallel_index
norewrite See no_rewrite
O
online_logfile
open_cursors
optimizer_auto_learn
optimizer_dynamic_sampling
optimizer_mode
ora_rowscn
Oracle Connection Manager Control Utility
Oracle Universal Installer
Oracle Wallet Manager
oracle_datapump
oracle_sid
Oracle-managed files
orapki
ORB#
orcldbpassword
order_by_clause
orderby_cols
organization_external
osm_diskgroups
osm_diskstring
osm_power_limit
P
parallel
parallel_degree_limit_p
pga_aggregate_target
plan
plsql_code_type
plsql_debug
plsql_optimize_level
plsql_warnings
policy_type
precommit_handler
primary_role
private
processes
program_type
props$
Q
query
queueing_p
R
rank_on_sum_mv
RBAL
rc_proxy_archivelog
recordlength
reference_spreadsheet
regexp_instr
register_dependent_object
remap_datafile
remap_schema
remap_tablespace
remote_listener
remote_login_passwordfile
remove_logfile
remove_streams_configuration
rename tablespace
report_plans
report_tuning_task
resumable
resumable_name
resumable_timeout
RETURING
return_rows_clause
reuse_datafiles
revoke_privilege
rewrite_or_error
rewrite_table
rollback_segments
rule_list
S
sal_proj
schemas
scn_to_timestamp
SELECTIVITY
serv_mod_act_stat_disable
serv_mod_act_stat_enable
Server Generated Alerts
sessions
set
set_global_instantiation_scn
set_initial_consumer_group
set_mapping_priority
set_message_notification
set_rule_transform_function
set_schema_instantiation_scn
 
sga_max_size
sga_target
shared_context_sensitive
shared_pool_size
shared_server_sessions
shared_servers
single_col_for_loop
single_column_for_loop
skip_unusable_indexes
smtp_out_server
sort_area_size
sp-name
spread_min_analysis
spread_no_analysis
spread_sheet
SPREADSHEET
spreadsheet_clause
spreadsheet_column
spreadsheet_column_values
spreadsheet_columns_clauses
spreadsheet_rules_clause
SQL Tuning Advisor
sqlfile
sqlnet.expire_time
sqlnet.inbound_connect_timeout
sqlnet.kerberos_cc_name
sqlnet.kerberos_keytab
sqlnet.ora
sqlnet.recv_buf_size
sqlnet.recv_timeout
sqlnet.send_buf_size
sqlnet.send_timeout
sqltune_catalog
sqltune_category
src
srv
SRVCTL
ssl_cert_revocation
standby_archive_dest
standby_logfile
standby_role
star_transformation_enabled
start_logmnr
start_redef_table
statement_type
statistics
statistics_level
status
stop_job
streams$_apply_progress
streams_instantiation
streams_pool_size
streams_type
subquery_factoring_clause
switch_back_at_call_end
switch_consumer_group_for_user
switch_consummer_group_for_sess
switch_current_consumer_group
switch_estimate
switch_group
switch_time
SYSAUX
T
table_exists_action
tablespace point in time recovery
target_mttr
toid_novalidate
transport_full_check
trcsess utility
true_rules_interator
tts_owners
tune_mview
U
unassign_attribute_set
undo_management
undo_pool
undo_retention
undo_tablespace
unique dimension
unique single reference
unregister_dependent_object
UPDATE
use_dedicated_server
use_nl_with_index
user_datapump_job
user_expfil_aset_functions
user_expfil_attribute_sets
user_expfil_attributes
user_expfil_def_index_params
user_expfil_expression_sets
user_expfil_exprset_stats
user_expfil_index_params
user_expfil_indexes
user_expfil_predtab_attributes
user_expfil_privileges
user_ind_partitions
user_recyclebin
userid
V
v$active_session_history
v$archive_dest
v$archive_dest_status
v$archived_log
v$buffered_publishers
v$buffered_queues
v$buffered_subscribers
v$database
v$db_cache_advice
v$dispatcher
v$dispatcher_config
v$event_histogram
v$fast_start_servers
v$fast_start_transactions
v$file_histogram
v$flashback_database_log
v$hs_parameter
v$instance_recovery
v$log_history
v$logmnr_contents
v$metricname
v$offline_range
v$osm_alias
v$osm_client
v$osm_disk
v$osm_diskgroup
v$osm_file
v$osm_operation
v$osm_template
v$platform
v$rman_output
v$session
v$session_longops
v$session_wait
v$session_wait_class
v$session_wait_history
v$sesstat
v$sga
v$sga_current_resize_ops
v$sga_dynamic_components
v$sga_dynamic_free_memory
v$sga_resize_ops
v$sgainfo
v$sgastat
v$shared_pool_advice
v$sql_plan
v$streams_apply_reader
v$streams_apply_server
v$streams_pool_advice
v$sysstat
v$system_wait_class
v$tablespace
v$temp_histogram
v$transportable_platform
validate_dimension
validate_expressions
value
version
volsize
W
where_clause
X
x$kcbrbh
xpindex_parameters


 


 


 

   

 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