List of 11g New features
######################################################################################
############### others ##################
##########################################################################################
-- flashcache ****
-- rolling upgrade features -- ASM
-- Hot patching
-- ACL
-- adrci : :automatic diagnostic repository
-- 11g self managed database
-- datapump : compression / compatible / encryption / reuse_dumpfile , remap_table
-- secure file / LOB compression : http://www.oracle-base.com/articles/11g/SecureFiles_11gR1.php
-- compression : compression can be enabled at table, tablespace or partition level or both direct/conventional loads
-- enterprise manager support workbench
-- online shrink of temp tablespace/ tempfile : (keep option)
-- tablespace can be encrypted .
-- oracle database file system .
-- Optimal flexible architecture .--- OFA
-- 11g afresh for auditing .
-- LDAP_DIRECTORY_SYSAUTH and Oracle Internet Directory .
-- Sqlnet.ora parameter oci_result_cache_max_size
-- X$DBGALERTEXT -- for reading alert logs || alert log in html and txt format
-- Password is case sensitive .
-- compress archives : alter system set log_archive_dest_1 = 'SERVICE=DBA11GDR COMPRESSION=ENABLE';
-- password protected roles are no longer enabled by default
-- $ORACLE_HOME/network/admin/endpoints_listener.ora
-- flashback : we can enable flashback at open stage .
-- sql_exec_start column in v$sql
-- 11g datapump compression : COMPRESSION=ALL
-- advance compression
-- Multiple Shared Memory Segments Created by Default on 11.2.0.3 : (1399908.1) 15566.1 , 731658.1
-- DEINSTALL OF ORACLE HOME IN 11.2.0.2 . : In 11.2.0.2 , there is a new directory created when you install the binaries called deinstall
ADR :automatic diagnostic repository
-- default location is oracle base .
-- Default setting is of 1 year . after which incident metadata is purged from ADR and files are retained for one month .
####################################################################
############### rac ################################################
####################################################################
Oracle 11g R1 RAC :
-- ADDM for RAC
-- ADR command-line tool - Oracle Automatic Diagnostic repository (ADR) has a new command-line interface named ADRCI, ADR Command Interface.
ADRCI can be used to access the 11g alert log:
-- Optimized RAC cache fusion protocols
-- Oracle 11g RAC Grid provisioning .
Oracle 11g R2 RAC :
-- Oracle 11g Release 2 (11.2.0.2) Reboot less Node Fencing
-- Raw devices are not supported any longer in 11gR2, but they can be used
-- ASMCA
-- scan
-- gns
-- global awr
-- server pooling
-- default, LOAD_BALANCE is ON.
-- GSD, gsdctl introduced.
-- RAC OneNode
-- HAS , oracle restart
-- 11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
-- olr -- for has
-- grid Plug and play
-- out of place patching
-- ASM : fast start mirror resych and disk repair time
-- ASM : Disk check : “alter diskgroup diskgroup_name check .”
-- ASM : Diskgroup can be mounted as restricted . -- fast rebalance
-- ASM fasT rebalance
-- ASM preferred mirror read
-- ASM : Can use force option to mount / drop disk group.
-- ASM : mount by doing offline to unavailable disk if quorum exists : offline/online after 20m
-- Intelligent Data Placement
-- asm template : diskgroup attibutes
-- sysasm
-- can keep ocr and voting disk in asm
-- sysasm role
-- asm variable extent size ( increasing as per use ) , explicitly allocate au to diskgroup
-- md_backup/md_restore -- asm metadata backup
-- raw device concept is obsolete ,
-- can rename a diskgroup
-- hot patching
-- Oracle 11g RAC parallel upgrades ,
-- Oracle 11g have rolling upgrade features:
-- SRVM_TRACE enabled by default in 11.2 -- $ORACLE_BASE/grid/cv/log
With the 11g upgrade, you had the option of applying the patchset to an individual CRS_HOME at a time,
-- ADDM for RAC
-- Passwordless Automatic SSH Connectivity : can configure ssh at installation
-- Clusterware and ASM share the same Oracle Home :
The clusterware and ASM share the same home thus it is known as the Grid Infrastructure home (prior to
11gR2, ASM and RDBMS could be installed either in the same Oracle home or in separate Oracle homes).
-- Hangchecktimer and oprocd are replaced :
Oracle Clusterware 11g release 2 (11.2) replaces the oprocd and Hangcheck processes with the cluster
synchronization service daemon Agent and Monitor to provide more accurate recognition of hangs and to
avoid false termination.
-- HAIP :
In 11.2.0.2 the new HAIP (redundant Interconnect) facility is active and multiple interface selection will
support load balancing and failover. You can select more than 4 interfaces for private interconnect at install
time or add them dynamically using oifcfg.
-- local_listener and remote_listener parameters
-- asm need not needs to be bounced after drop disk . -- bug
-- sector_size for diskgroup
-- Time Synchronization is a new feature in Oracle 11g R2 that automatically synchronizes the timestamps
of all of the nodes in the cluster. In previous releases, third party tools were generally used.
Time Synchronization can be used in observer mode (if a Network Time Protocol is already in place) or active mode where one node is designated as the master node and all of the others are synchronized to it.
wsx-prod-73 [58]:crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
-- metadata back : ,md_backup/md_restore
-- 11gR2 Universal Collection is expanded diagcollection.pl to collect GI, ASM and database (RAC) diagnostics (logfile, trace file etc), the goal is to reduce back anf forth information request between Oracle Support and customers.
11gR2 GI/ASM/RAC Universal Collection Guide [ID 1485042.1]
-- Backup of Voting disk using “dd” command not supported
-- Voting disk and OCR can be keep in same disk-group or different disk-group
-- Voting disk and OCR automatic backup kept together in a single file.
-- we can use multiple private interconnect ( installation time or oifcfg setif) : link aggregation
-- adding node made easy
cluvfy stage -pre nodeadd -n serverC -verbose
addNode.sh -silent "CLUSTER_NEW_NODES={ServerC}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={ServerC-vip}"
cluvfy stage -post nodeadd -n serverC -verbose
-- removing node made easy
olsnodes -s -t
crsctl unpin css -n <ServerC>
$GI/crs/install/rootcrs.pl -dconfig -force ( on node to be deleted)
crsctl delete node -n <ServerC>
-- new commands : cluster wide
crsctl (check / start / stop ) cluster -all
-- Oracle Direct NFS
>>>>>>> Oracle 11g R1 RAC :
Oracle 11g RAC parallel upgrades - Oracle 11g have rolling upgrade features whereby RAC database can be upgraded without any downtime.
Hot patching - Zero downtime patch application.
Oracle RAC load balancing advisor - Starting from 10g R2 we have RAC load balancing advisor utility. 11g RAC load balancing advisor is only available with clients who use .NET, ODBC, or the Oracle Call Interface (OCI).
ADDM for RAC - Oracle has incorporated RAC into the automatic database diagnostic monitor, for cross-node advisories. The script addmrpt.sql run give report for single instance, will not report all instances in RAC, this is known as instance ADDM. But using the new package DBMS_ADDM, we can generate report for all instances of RAC, this known as database ADDM.
ADR command-line tool - Oracle Automatic Diagnostic repository (ADR) has a new command-line interface named ADRCI, ADR Command Interface. ADRCI can be used to access the 11g alert log:
$adrci
adrci> show alert
Optimized RAC cache fusion protocols - moves on from the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.
Oracle 11g RAC Grid provisioning - The Oracle grid control provisioning pack allows us to "blow-out" a RAC node without the time-consuming install, using a pre-installed "footprint".
Data Guard - Standby snapshot - The new standby snapshot feature allows us to encapsulate a snapshot for regression testing. We can collect a standby snapshot and move it into our QA database, ensuring that our regression test uses real production data.
Quick Fault Resolution - Automatic capture of diagnostics (dumps) for a fault.
>>>>>>>>>>>>>>>>>>>> Oracle 11g R2 RAC :
We can store everything on the ASM. We can store OCR & voting files also on the ASM.
ASMCA
Single Client Access Name (SCAN) - eliminates the need to change tns entry when nodes are added to or removed from the Cluster. RAC instances register to SCAN listeners as remote listeners. SCAN is fully qualified name. Oracle recommends assigning 3 addresses to SCAN, which create three SCAN listeners.
AWR is consolidated for the database.
11g Release 2 Real Application Cluster (RAC) has server pooling technologies so it’s easier to provision and manage database grids. This update is geared toward dynamically adjusting servers as corporations manage the ebb and flow between data requirements for datawarehousing and applications.
By default, LOAD_BALANCE is ON.
GSD, gsdctl introduced.
RAC OneNode is a new option that makes it easier to consolidate databases that aren’t mission critical, but need redundancy.
rac to rac data guard
11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
With Oracle Clusterware 11g release 2 and later, Database Configuration Agent (D
BCA) no longer sets the LOCAL_LISTENER parameter. The Oracle Clusterware agent t
hat starts the database sets the LOCAL_LISTENER parameter dynamically, and it se
ts it to the actual value, not an alias. So listener_alias entries are no longer
needed in the tnsnames.ora file. For the REMOTE_LISTENER parameter, Oracle Clus
terware uses the EZ connect syntax scanname:scanport, so no entries are needed f
or the REMOTE_LISTENER parameter in the tnsnames.ora file
Intelligent Data Placement can be managed with the ALTER DISKGROUP ADD or MODIFY TEMPLATE SQL and the ALTER DISKGROUP MODIFY FILE SQL statement, which include a disk region clause for setting hot/mirrorhot or cold/mirrorcold regions in a template:
ALTER DISKGROUP adndata1 ADD TEMPLATE datafile_hot
ATTRIBUTE ( HOT MIRRORHOT);
The ALTER DISKGROUP ... MODIFY FILE SQL statement that sets disk region attributes for hot/mirrorhot or cold/mirrorcold regions:
ALTER DISKGROUP adndata1 MODIFY FILE '+data/adn3/datafile/tools.255.765689507'
ATTRIBUTE ( HOT MIRRORHOT);
######################################################################################
########### data guard ################
##########################################################################################
-- active dataguard
-- snapshot standby
-- rac to rac data guard
-- creation of dataguard using grid
-- block change tracking enabled on dataguard
-- Role Based Services ( need dataguard enabled )
-- Fast Start Failover Improvements
-- CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
-- Using DBMS_SCHEDULER to Run Jobs on a Logical Standby Database (11g R1)
-- log transport : Redo Compression ,
-- DB_LOST_WRITE_PROTECT
-- Automatic Gap Resolution ( to cover network issues if not Maximum Protection. ) http://hongwang.wordpress.com/2011/12/29/data-guard-11gs-automatic-gap-resolution-and-ora-16401-error
-- LNS process
-- alter session set STANDBY_MAX_DATA_DELAY=1; || alter session sync with primary; ( whie db open for read only ) ()
-- Heterogeneous DataGuard.,
-- In Oracle Database 11g, you can temporarily convert the physical standby database to a logical standby to perform a rolling upgrade
-- RMAN Understands Data Guard Configurations : db_unique_name
-- compress archives : alter system set log_archive_dest_1 = 'SERVICE=DBA11GDR COMPRESSION=ENABLE';
-- Database Rolling Upgrade Using Transient Logical Standby:
#############################################################
########### rman ################
#############################################################
-- import recovery catalog of 10g in schema of 11g recovery catalog -- Merging Catalogs
-- Data recovery advisor .
-- Enable block change tracking file on standby . : fast incremental backup enhancement .
-- Intra-File Parallel Backup : Same datafile in parallel
-- Virtual private catalog
-- vALIDATE DATABASE ------enhancement-- Proactive Health Checks
-- VALIDATE DATAFILE 1 BLOCK 10;
-- Undo blocks that are not needed for transaction recovery are not backed up ;
-- Compress backupset enhancement (ZLIB algorithm)
-- Flashback Logs to Rescue - using flashback for block recovery
-- Set NEWNAME Flexibility (Release 2 Only) ( for tablespace and database )
-- Auto Block Repair (Release 2 Only) (from active data guard ) -- AUTO BMR( Block Media Recovery)
-- TO DESTINATION Clause (Release 2 Only)
-- More Comcodession Choices (Release 2 Only)
-- Backup to the Cloud (Release 2 Only)
-- CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
-- snapshot controlfile ( shared location , no enqueue required )
-- RMAN 11.2 duplicate now RESTORES the backup controlfile to the auxiliary host rather than CREATE it.
So you must ensure that there is a controlfile backup available to meet the duplicate time.
Import catalog from 10g database :
-- Merging catalog .
RMAN> connect catalog rco11/password@catdb
RMAN> import catalog rcat10/oracle@inst1 (no unregister);
-- They deregister all database registered in RCAT10 catalog .
-- They import metadata for all registered database in RCAT10 database .
-- They register all RCAT10 catalog registered database in RCO11 catalog .
Data recovery advisor .
-- list failure ( list failure reported in ADR . )
-- advice failure: { detects new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE. }
-- repair failure ( priview ) .
-- Change failure : It is used to explicitly close the open failures. ,
It is used to change failure priority only for HIGH or LOW priorities
Virtual private catalog
-- access to subset of catalog .
-- SQL> GRANT recovery_catalog_owner TO vpc1;
-- RMAN> CONNECT CATALOG catowner/password@catdb;
-- .RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1
-- RMAN> CONNECT CATALOG vpc1/password@catdb;
-- RMAN> CREATE VIRTUAL CATALOG;
VALIDATE DATABASE ------enhancement .
-- We can directly use validate database command instead of using “backup validate “
-- We can validate blocks using “validate datafile1 block 2”
-- records live corruption in v$database_block_corruption .
-- check database for intra block corruption and not inter block.
-- Failure is logged in ADR.
Compress backupset enhancement .
-- uses new ZLIB algorithm instead of old BZIP2 algorithm . ZLIB is 40% faster .
-- “configure compression algorithm to ZLIB”
More Comcodession Choices (Release 2 Only) :
-- Comcodession in RMAN is not new; it has been around for some time. Here is how you can create a comcodessed backupset of the tablespace ABCD_DATA.
RMAN> backup as comcodessed backupset
2> format '/u01/oraback/%U.rmb'
3> tablespace abcd_data
4> ;
-- In Oracle Database 11g Release 1 we saw the introduction of a new encryption algorithm called ZLIB that is quite fast (and consumes less CPU) but with reduced comcodession ratio. In the current version there are several options for comcodession.
-- The default comcodession is called BASIC, which does not require any extra cost option. Using Advanced Comcodession Option, you now have the ability to specify different types of comcodession levels: LOW, MEDIUM and HIGH – with comcodession ratios from least to highest and CPU consumption (and conversely RMAN throughput) from least to highest. Here is how you configure the comcodession option to high:
rman> configure comcodession algorithm 'high';
-- In a test, I got a comcodessed backupset using HIGH as 118947840 compared to 1048952832 uncomcodessed – almost 9X improvement. Of course it will vary from database to database. A high setting for the comcodession option creates smaller backupsets, which are great for slow networks but consume CPU cycles.
Set NEWNAME Flexibility (Release 2 Only) :
-- run
{
set newname for tablespace examples to '/u02/examples%b.dbf';
… }
-- run
{
set newname for database to '/u02/oradata/%b';
}
######################################################################################
####################### installation , migration . upgrade ,#############################
##########################################################################################
-- Upgrade option while software installation ( out of box patching )
-- diagnostic_dest
-- utlu111i.sql : on database to be upgraded .
-- utlu111s.sql / utlu1112s.sql : to see upgrade report .
-- utlrp.sql does parallel compilation
-- Startup upgrade
-- We can re-run catupgrd.sql if needed .
-- Automatic upgrade from 32bit to 64bit while upgrade . 62290.1
-- create spfile=’/u01/app/spfileorcl.bak’ from memory;
-- after upgrade we need to run catuppst.sql .
-- after upgrade we need to run utlpwdmg.sql – TO create new password verification function .
-- tablespace can be encrypted .
-- hot patching
Startup upgrade
--> it allows only sysdba connections
--> it sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
--> disables job queues
--> disable system triggers .
Hot patching :
-- consume more memory ,
-- can be applied online
-- detect conflict between two online patches .
-- fast .
-- to check if patch can be installed as hot patch :
Optach query –is_online_patch <patch_location> or
Opatch query <patch_location> -all
######################################################################################
########### cloning ################
##########################################################################################
-- active database duplication if no files transferred -- DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
-- if files transferred no need to connect to target database -- Duplicate Database from Backup (Release 2 Only)
--
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT 'primdb', 'stbydb'
SET DB_UNIQUE_NAME='stbydb'
SET DB_FILE_NAME_CONVERT='/u01/primdb/','/u02/stbydb/'
SET LOG_FILE_NAME_CONVERT='/u01/primdb/','/u01/stbydb/'
SET CONTROL_FILES='/u01/primdb/controlfile1.ctl'
SET LOG_ARCHIVE_MAX_PROCESSES='7'
SET FAL_CLIENT='stbydb'
SET FAL_SERVER='primdb'
SET STANDBY_FILE_MANAGEMENT='auto'
SET LOG_ARCHIVE_CONFIG='DG_CONFIG=('primdb','stbydb')
SET LOG_ARCHIVE_DEST_2='service=primdb SYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primdb')'
######################################################################################
########### objects ################
##########################################################################################
-- read only tables
-- After online redefinition of tables all objects except triggers remains valid .
-- invisible indexes
-- enhancements in partitioning : http://www.oracle-base.com/articles/11g/PartitioningEnhancements_11gR1.php
-- Virtual columns : http://www.oracle-base.com/articles/11g/VirtualColumns_11gR1.php
-- compress table for all operation : only data henceforth is compressed
-- flashback data archive : no need for log minner , no snapshot tool old : http://gavinsoorma.com/2009/11/11g-flashback-data-archive-part-one/
--
######################################################################################
########### tuning ################
##########################################################################################
--
-- memory_target/memory max_target AMM
-- sql plan baselines
-- sql tuning sets
-- sql monitoring -- V$SQL_MONITOR
-- 11g Compression
-- Automatic Memory Tuning (AMM)
-- sql profile
-- automatic sql tuning
-- Automatic Plan Capture
-- segment advisor , sql repair advisor , SQL Performance Analyzer
-- awr sql report / awr compare report / awr global report
-- work load replay
-- pending stats
-- increment stats for partition
-- invisible index
-- awr compare report
-- can remove particular sql statement from Shared Pool without flushing the entire Shared Pool!! -- dbms_shared_pool.purge -- purge sql id
-- health check
-- Adaptive Cursor Sharing : http://www.oracle-base.com/articles/11g/AdaptiveCursorSharing_11gR1.php
-- Query result cache
-- I/O calibration
-- Automated maintenance task .
-- RESULT_CACHE
-- temp_space_allocated to the v$session and V$active_session_history
-- Auto DOP is enabled by setting parallel_degree_policy = AUTO or LIMITED.
-- PARALLEL_FORCE_LOCAL_RAC
-- Statistics Have Improved from Oracle 10gR2 to 11gR2
--
,
Sql Plan Baselines :
-- Plan can be manually loaded in sql plan baselines .
-- Plan in sql plan baselines are verified and accepted plan .
-- For sql plan baselines to be accessible to optimizer , SYSAUX tablespace must be online .
Sql access advisor :
-- partitioning of tables and indexes
-- creation of bitmap , function-based, btree indexes
-- optimizing of materialized view for maximum query usage and fast refresh .
Sql tuning sets , sql management base
-- Every sql statements in STS is considered only once for execution .
-- execution plan and execution statistics are computed for each statement in STS.
Automatic SQL Tuning
-- part of auto task framework
-- Based on AWR top sql identification
http://www.oracle-base.com/articles/11g/AutomaticSqlTuning_11gR1.php
Performance Analyzer
– This is the codification of Oracle’s “holistic” approach, an empirical technique whereby SQL is tuned in a real-world environment. Designed to testing silver bullet impact of global changes (init.ora parameters, new indexes and materialized views, &c), SPA provides real-world evidence of the performance impact of major changes.
11g Compression
– with a late start out of the gate (other DBMS tools have had compression for decades), Oracle’s compression promises to improve the speed of full-scans operations (important to batch jobs and data warehouses).
SQL optimization improvements
– The cost-based optimizer (CBO) is continuously evolving, and we now see bind peeking fixed and extended optimizer statistics.
Automatic Memory Tuning
- Automatic PGA tuning was introduced in Oracle 9i. Automatic SGA tuning was introduced in Oracle 10g.
In 11g, all memory can be tuned automatically by setting one parameter. You literally tell Oracle how much memory it has and it determines how much to use for PGA, SGA and OS Processes.
AWR Baselines
- The AWR baselines of 10g have been extended to allow automatic creation of baselines for use in other features.
Adaptive Metric Baselines
- Notification thresholds in 10g were based on a fixed point. In 11g, notification thresholds can be associated with a baseline, so the notification thresholds vary throughout the day in line with the baseline.
I/O calibration :
-- only one can be run at a time .
-- time_statistics must be set to true
-- can be used to estimate maximum number of I/O and maximum latency time for
-- system
-- need to set parameter filesystemiooptions
Automated maintenance task .
-- database resource manager is automatically enabled in maintenance window that runs automated maintenance task
to prevent consuming excessive amount of memory.
-- Runs : segment advisor , automatic sql tuning advisor , optimizer statistics gathering .
Query result cache
-- can be set at system, session or table level
-- can store results from normal as well as flashback queries . result_cache_mode parameter and hint result_cache and result_cache
-- size is allocated from shared pool but is not flushed when we flush shared pool .
-- use dbms_result_cache to manage query result cache
http://www.oracle-developer.net/display.php?id=503
-- optimizer by default decides
select * from v$sgastat where pool='shared pool' and name like 'Result%';
select * from v$latchname where name like 'Result Cache%';
sql performance analyzer
-- it detects change in sql plan
-- it produces results that can be used to create sql plan baselines
-- it generates recommendations to run sql tuning advisor to tune regressed sql.
######################################################################################
########### Parameter : ################
##########################################################################################
1) DDL_LOCK_TIMEOUT -- for deadlock .
2) sec_protocol_error_further_action
3) Statistics_level to typical enables baselines by default in 11g
5) distributed_lock_timeout
6) PRE_PAGE_SGA
7) memory_target ( dynamic )
8) memory_max_target
9) db_securefile
10) resumeable_timeout
11) enable_ddl_logging
12) optimizer_use_plan_baselines
13) sec_max_failed_login_attempts
14) optimizer_use_pending_statistics
15) LDAP_DIRECTORY_SYSAUTH
16) Diagnostic_dest
17) db_ultra_safe: -- block corruption
-- check for logical self-consistency of data block when modified in memory .
-- checksum is calculated before and after the block change .
-- checks are performed for lost writes to physical standby database .
1) db_lost_write_protect . -- block corruption
2)
######################################################################################
########### deprecated parameters : ################
##########################################################################################
1. BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
2. OMMIT_WRITE
3. CORE_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
4. INSTANCE_GROUPS
5. LOG_ARCHIVE_LOCAL_FIRST
6. PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
7. PLSQL_V2_COMPATIBILITY
8. REMOTE_OS_AUTHENT
9. STANDBY_ARCHIVE_DEST
10. TRANSACTION_LAG (attribute of the CQ_NOTIFICATION$_REG_INFO object)
11. USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
######################################################################################
########### Views : ################
##########################################################################################
dba_temp_free_space
dba_sql_plan_baselines
DBA_USERS_WITH_DEFPWD -- to check user with default password .
V$DIAG_INFO
Dba_autotask_client
Dba_flashback_archive
v$memory_dynamic_components / v$memory_target_advisor / v$memory_resize_ops
DIRECT NFS VIEWS :
-- V$DNFS_FILES
-- V$DNFS_SERVERS
-- V$DNFS_STATS
-- V$DNFS_CHANNELS
######################################################################################
############### others ##################
##########################################################################################
-- flashcache ****
-- rolling upgrade features -- ASM
-- Hot patching
-- ACL
-- adrci : :automatic diagnostic repository
-- 11g self managed database
-- datapump : compression / compatible / encryption / reuse_dumpfile , remap_table
-- secure file / LOB compression : http://www.oracle-base.com/articles/11g/SecureFiles_11gR1.php
-- compression : compression can be enabled at table, tablespace or partition level or both direct/conventional loads
-- enterprise manager support workbench
-- online shrink of temp tablespace/ tempfile : (keep option)
-- tablespace can be encrypted .
-- oracle database file system .
-- Optimal flexible architecture .--- OFA
-- 11g afresh for auditing .
-- LDAP_DIRECTORY_SYSAUTH and Oracle Internet Directory .
-- Sqlnet.ora parameter oci_result_cache_max_size
-- X$DBGALERTEXT -- for reading alert logs || alert log in html and txt format
-- Password is case sensitive .
-- compress archives : alter system set log_archive_dest_1 = 'SERVICE=DBA11GDR COMPRESSION=ENABLE';
-- password protected roles are no longer enabled by default
-- $ORACLE_HOME/network/admin/endpoints_listener.ora
-- flashback : we can enable flashback at open stage .
-- sql_exec_start column in v$sql
-- 11g datapump compression : COMPRESSION=ALL
-- advance compression
-- Multiple Shared Memory Segments Created by Default on 11.2.0.3 : (1399908.1) 15566.1 , 731658.1
-- DEINSTALL OF ORACLE HOME IN 11.2.0.2 . : In 11.2.0.2 , there is a new directory created when you install the binaries called deinstall
ADR :automatic diagnostic repository
-- default location is oracle base .
-- Default setting is of 1 year . after which incident metadata is purged from ADR and files are retained for one month .
####################################################################
############### rac ################################################
####################################################################
Oracle 11g R1 RAC :
-- ADDM for RAC
-- ADR command-line tool - Oracle Automatic Diagnostic repository (ADR) has a new command-line interface named ADRCI, ADR Command Interface.
ADRCI can be used to access the 11g alert log:
-- Optimized RAC cache fusion protocols
-- Oracle 11g RAC Grid provisioning .
Oracle 11g R2 RAC :
-- Oracle 11g Release 2 (11.2.0.2) Reboot less Node Fencing
-- Raw devices are not supported any longer in 11gR2, but they can be used
-- ASMCA
-- scan
-- gns
-- global awr
-- server pooling
-- default, LOAD_BALANCE is ON.
-- GSD, gsdctl introduced.
-- RAC OneNode
-- HAS , oracle restart
-- 11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
-- olr -- for has
-- grid Plug and play
-- out of place patching
-- ASM : fast start mirror resych and disk repair time
-- ASM : Disk check : “alter diskgroup diskgroup_name check .”
-- ASM : Diskgroup can be mounted as restricted . -- fast rebalance
-- ASM fasT rebalance
-- ASM preferred mirror read
-- ASM : Can use force option to mount / drop disk group.
-- ASM : mount by doing offline to unavailable disk if quorum exists : offline/online after 20m
-- Intelligent Data Placement
-- asm template : diskgroup attibutes
-- sysasm
-- can keep ocr and voting disk in asm
-- sysasm role
-- asm variable extent size ( increasing as per use ) , explicitly allocate au to diskgroup
-- md_backup/md_restore -- asm metadata backup
-- raw device concept is obsolete ,
-- can rename a diskgroup
-- hot patching
-- Oracle 11g RAC parallel upgrades ,
-- Oracle 11g have rolling upgrade features:
-- SRVM_TRACE enabled by default in 11.2 -- $ORACLE_BASE/grid/cv/log
With the 11g upgrade, you had the option of applying the patchset to an individual CRS_HOME at a time,
-- ADDM for RAC
-- Passwordless Automatic SSH Connectivity : can configure ssh at installation
-- Clusterware and ASM share the same Oracle Home :
The clusterware and ASM share the same home thus it is known as the Grid Infrastructure home (prior to
11gR2, ASM and RDBMS could be installed either in the same Oracle home or in separate Oracle homes).
-- Hangchecktimer and oprocd are replaced :
Oracle Clusterware 11g release 2 (11.2) replaces the oprocd and Hangcheck processes with the cluster
synchronization service daemon Agent and Monitor to provide more accurate recognition of hangs and to
avoid false termination.
-- HAIP :
In 11.2.0.2 the new HAIP (redundant Interconnect) facility is active and multiple interface selection will
support load balancing and failover. You can select more than 4 interfaces for private interconnect at install
time or add them dynamically using oifcfg.
-- local_listener and remote_listener parameters
-- asm need not needs to be bounced after drop disk . -- bug
-- sector_size for diskgroup
-- Time Synchronization is a new feature in Oracle 11g R2 that automatically synchronizes the timestamps
of all of the nodes in the cluster. In previous releases, third party tools were generally used.
Time Synchronization can be used in observer mode (if a Network Time Protocol is already in place) or active mode where one node is designated as the master node and all of the others are synchronized to it.
wsx-prod-73 [58]:crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
-- metadata back : ,md_backup/md_restore
-- 11gR2 Universal Collection is expanded diagcollection.pl to collect GI, ASM and database (RAC) diagnostics (logfile, trace file etc), the goal is to reduce back anf forth information request between Oracle Support and customers.
11gR2 GI/ASM/RAC Universal Collection Guide [ID 1485042.1]
-- Backup of Voting disk using “dd” command not supported
-- Voting disk and OCR can be keep in same disk-group or different disk-group
-- Voting disk and OCR automatic backup kept together in a single file.
-- we can use multiple private interconnect ( installation time or oifcfg setif) : link aggregation
-- adding node made easy
cluvfy stage -pre nodeadd -n serverC -verbose
addNode.sh -silent "CLUSTER_NEW_NODES={ServerC}" "CLUSTER_NEW_VIRTUAL_HOSTNAMES={ServerC-vip}"
cluvfy stage -post nodeadd -n serverC -verbose
-- removing node made easy
olsnodes -s -t
crsctl unpin css -n <ServerC>
$GI/crs/install/rootcrs.pl -dconfig -force ( on node to be deleted)
crsctl delete node -n <ServerC>
-- new commands : cluster wide
crsctl (check / start / stop ) cluster -all
-- Oracle Direct NFS
>>>>>>> Oracle 11g R1 RAC :
Oracle 11g RAC parallel upgrades - Oracle 11g have rolling upgrade features whereby RAC database can be upgraded without any downtime.
Hot patching - Zero downtime patch application.
Oracle RAC load balancing advisor - Starting from 10g R2 we have RAC load balancing advisor utility. 11g RAC load balancing advisor is only available with clients who use .NET, ODBC, or the Oracle Call Interface (OCI).
ADDM for RAC - Oracle has incorporated RAC into the automatic database diagnostic monitor, for cross-node advisories. The script addmrpt.sql run give report for single instance, will not report all instances in RAC, this is known as instance ADDM. But using the new package DBMS_ADDM, we can generate report for all instances of RAC, this known as database ADDM.
ADR command-line tool - Oracle Automatic Diagnostic repository (ADR) has a new command-line interface named ADRCI, ADR Command Interface. ADRCI can be used to access the 11g alert log:
$adrci
adrci> show alert
Optimized RAC cache fusion protocols - moves on from the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.
Oracle 11g RAC Grid provisioning - The Oracle grid control provisioning pack allows us to "blow-out" a RAC node without the time-consuming install, using a pre-installed "footprint".
Data Guard - Standby snapshot - The new standby snapshot feature allows us to encapsulate a snapshot for regression testing. We can collect a standby snapshot and move it into our QA database, ensuring that our regression test uses real production data.
Quick Fault Resolution - Automatic capture of diagnostics (dumps) for a fault.
>>>>>>>>>>>>>>>>>>>> Oracle 11g R2 RAC :
We can store everything on the ASM. We can store OCR & voting files also on the ASM.
ASMCA
Single Client Access Name (SCAN) - eliminates the need to change tns entry when nodes are added to or removed from the Cluster. RAC instances register to SCAN listeners as remote listeners. SCAN is fully qualified name. Oracle recommends assigning 3 addresses to SCAN, which create three SCAN listeners.
AWR is consolidated for the database.
11g Release 2 Real Application Cluster (RAC) has server pooling technologies so it’s easier to provision and manage database grids. This update is geared toward dynamically adjusting servers as corporations manage the ebb and flow between data requirements for datawarehousing and applications.
By default, LOAD_BALANCE is ON.
GSD, gsdctl introduced.
RAC OneNode is a new option that makes it easier to consolidate databases that aren’t mission critical, but need redundancy.
rac to rac data guard
11gR2 Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip [ID 1210883.1]
With Oracle Clusterware 11g release 2 and later, Database Configuration Agent (D
BCA) no longer sets the LOCAL_LISTENER parameter. The Oracle Clusterware agent t
hat starts the database sets the LOCAL_LISTENER parameter dynamically, and it se
ts it to the actual value, not an alias. So listener_alias entries are no longer
needed in the tnsnames.ora file. For the REMOTE_LISTENER parameter, Oracle Clus
terware uses the EZ connect syntax scanname:scanport, so no entries are needed f
or the REMOTE_LISTENER parameter in the tnsnames.ora file
Intelligent Data Placement can be managed with the ALTER DISKGROUP ADD or MODIFY TEMPLATE SQL and the ALTER DISKGROUP MODIFY FILE SQL statement, which include a disk region clause for setting hot/mirrorhot or cold/mirrorcold regions in a template:
ALTER DISKGROUP adndata1 ADD TEMPLATE datafile_hot
ATTRIBUTE ( HOT MIRRORHOT);
The ALTER DISKGROUP ... MODIFY FILE SQL statement that sets disk region attributes for hot/mirrorhot or cold/mirrorcold regions:
ALTER DISKGROUP adndata1 MODIFY FILE '+data/adn3/datafile/tools.255.765689507'
ATTRIBUTE ( HOT MIRRORHOT);
######################################################################################
########### data guard ################
##########################################################################################
-- active dataguard
-- snapshot standby
-- rac to rac data guard
-- creation of dataguard using grid
-- block change tracking enabled on dataguard
-- Role Based Services ( need dataguard enabled )
-- Fast Start Failover Improvements
-- CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
-- Using DBMS_SCHEDULER to Run Jobs on a Logical Standby Database (11g R1)
-- log transport : Redo Compression ,
-- DB_LOST_WRITE_PROTECT
-- Automatic Gap Resolution ( to cover network issues if not Maximum Protection. ) http://hongwang.wordpress.com/2011/12/29/data-guard-11gs-automatic-gap-resolution-and-ora-16401-error
-- LNS process
-- alter session set STANDBY_MAX_DATA_DELAY=1; || alter session sync with primary; ( whie db open for read only ) ()
-- Heterogeneous DataGuard.,
-- In Oracle Database 11g, you can temporarily convert the physical standby database to a logical standby to perform a rolling upgrade
-- RMAN Understands Data Guard Configurations : db_unique_name
-- compress archives : alter system set log_archive_dest_1 = 'SERVICE=DBA11GDR COMPRESSION=ENABLE';
-- Database Rolling Upgrade Using Transient Logical Standby:
#############################################################
########### rman ################
#############################################################
-- import recovery catalog of 10g in schema of 11g recovery catalog -- Merging Catalogs
-- Data recovery advisor .
-- Enable block change tracking file on standby . : fast incremental backup enhancement .
-- Intra-File Parallel Backup : Same datafile in parallel
-- Virtual private catalog
-- vALIDATE DATABASE ------enhancement-- Proactive Health Checks
-- VALIDATE DATAFILE 1 BLOCK 10;
-- Undo blocks that are not needed for transaction recovery are not backed up ;
-- Compress backupset enhancement (ZLIB algorithm)
-- Flashback Logs to Rescue - using flashback for block recovery
-- Set NEWNAME Flexibility (Release 2 Only) ( for tablespace and database )
-- Auto Block Repair (Release 2 Only) (from active data guard ) -- AUTO BMR( Block Media Recovery)
-- TO DESTINATION Clause (Release 2 Only)
-- More Comcodession Choices (Release 2 Only)
-- Backup to the Cloud (Release 2 Only)
-- CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
-- snapshot controlfile ( shared location , no enqueue required )
-- RMAN 11.2 duplicate now RESTORES the backup controlfile to the auxiliary host rather than CREATE it.
So you must ensure that there is a controlfile backup available to meet the duplicate time.
Import catalog from 10g database :
-- Merging catalog .
RMAN> connect catalog rco11/password@catdb
RMAN> import catalog rcat10/oracle@inst1 (no unregister);
-- They deregister all database registered in RCAT10 catalog .
-- They import metadata for all registered database in RCAT10 database .
-- They register all RCAT10 catalog registered database in RCO11 catalog .
Data recovery advisor .
-- list failure ( list failure reported in ADR . )
-- advice failure: { detects new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE. }
-- repair failure ( priview ) .
-- Change failure : It is used to explicitly close the open failures. ,
It is used to change failure priority only for HIGH or LOW priorities
Virtual private catalog
-- access to subset of catalog .
-- SQL> GRANT recovery_catalog_owner TO vpc1;
-- RMAN> CONNECT CATALOG catowner/password@catdb;
-- .RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1
-- RMAN> CONNECT CATALOG vpc1/password@catdb;
-- RMAN> CREATE VIRTUAL CATALOG;
VALIDATE DATABASE ------enhancement .
-- We can directly use validate database command instead of using “backup validate “
-- We can validate blocks using “validate datafile1 block 2”
-- records live corruption in v$database_block_corruption .
-- check database for intra block corruption and not inter block.
-- Failure is logged in ADR.
Compress backupset enhancement .
-- uses new ZLIB algorithm instead of old BZIP2 algorithm . ZLIB is 40% faster .
-- “configure compression algorithm to ZLIB”
More Comcodession Choices (Release 2 Only) :
-- Comcodession in RMAN is not new; it has been around for some time. Here is how you can create a comcodessed backupset of the tablespace ABCD_DATA.
RMAN> backup as comcodessed backupset
2> format '/u01/oraback/%U.rmb'
3> tablespace abcd_data
4> ;
-- In Oracle Database 11g Release 1 we saw the introduction of a new encryption algorithm called ZLIB that is quite fast (and consumes less CPU) but with reduced comcodession ratio. In the current version there are several options for comcodession.
-- The default comcodession is called BASIC, which does not require any extra cost option. Using Advanced Comcodession Option, you now have the ability to specify different types of comcodession levels: LOW, MEDIUM and HIGH – with comcodession ratios from least to highest and CPU consumption (and conversely RMAN throughput) from least to highest. Here is how you configure the comcodession option to high:
rman> configure comcodession algorithm 'high';
-- In a test, I got a comcodessed backupset using HIGH as 118947840 compared to 1048952832 uncomcodessed – almost 9X improvement. Of course it will vary from database to database. A high setting for the comcodession option creates smaller backupsets, which are great for slow networks but consume CPU cycles.
Set NEWNAME Flexibility (Release 2 Only) :
-- run
{
set newname for tablespace examples to '/u02/examples%b.dbf';
… }
-- run
{
set newname for database to '/u02/oradata/%b';
}
######################################################################################
####################### installation , migration . upgrade ,#############################
##########################################################################################
-- Upgrade option while software installation ( out of box patching )
-- diagnostic_dest
-- utlu111i.sql : on database to be upgraded .
-- utlu111s.sql / utlu1112s.sql : to see upgrade report .
-- utlrp.sql does parallel compilation
-- Startup upgrade
-- We can re-run catupgrd.sql if needed .
-- Automatic upgrade from 32bit to 64bit while upgrade . 62290.1
-- create spfile=’/u01/app/spfileorcl.bak’ from memory;
-- after upgrade we need to run catuppst.sql .
-- after upgrade we need to run utlpwdmg.sql – TO create new password verification function .
-- tablespace can be encrypted .
-- hot patching
Startup upgrade
--> it allows only sysdba connections
--> it sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
--> disables job queues
--> disable system triggers .
Hot patching :
-- consume more memory ,
-- can be applied online
-- detect conflict between two online patches .
-- fast .
-- to check if patch can be installed as hot patch :
Optach query –is_online_patch <patch_location> or
Opatch query <patch_location> -all
######################################################################################
########### cloning ################
##########################################################################################
-- active database duplication if no files transferred -- DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
-- if files transferred no need to connect to target database -- Duplicate Database from Backup (Release 2 Only)
--
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT 'primdb', 'stbydb'
SET DB_UNIQUE_NAME='stbydb'
SET DB_FILE_NAME_CONVERT='/u01/primdb/','/u02/stbydb/'
SET LOG_FILE_NAME_CONVERT='/u01/primdb/','/u01/stbydb/'
SET CONTROL_FILES='/u01/primdb/controlfile1.ctl'
SET LOG_ARCHIVE_MAX_PROCESSES='7'
SET FAL_CLIENT='stbydb'
SET FAL_SERVER='primdb'
SET STANDBY_FILE_MANAGEMENT='auto'
SET LOG_ARCHIVE_CONFIG='DG_CONFIG=('primdb','stbydb')
SET LOG_ARCHIVE_DEST_2='service=primdb SYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=primdb')'
######################################################################################
########### objects ################
##########################################################################################
-- read only tables
-- After online redefinition of tables all objects except triggers remains valid .
-- invisible indexes
-- enhancements in partitioning : http://www.oracle-base.com/articles/11g/PartitioningEnhancements_11gR1.php
-- Virtual columns : http://www.oracle-base.com/articles/11g/VirtualColumns_11gR1.php
-- compress table for all operation : only data henceforth is compressed
-- flashback data archive : no need for log minner , no snapshot tool old : http://gavinsoorma.com/2009/11/11g-flashback-data-archive-part-one/
--
######################################################################################
########### tuning ################
##########################################################################################
--
-- memory_target/memory max_target AMM
-- sql plan baselines
-- sql tuning sets
-- sql monitoring -- V$SQL_MONITOR
-- 11g Compression
-- Automatic Memory Tuning (AMM)
-- sql profile
-- automatic sql tuning
-- Automatic Plan Capture
-- segment advisor , sql repair advisor , SQL Performance Analyzer
-- awr sql report / awr compare report / awr global report
-- work load replay
-- pending stats
-- increment stats for partition
-- invisible index
-- awr compare report
-- can remove particular sql statement from Shared Pool without flushing the entire Shared Pool!! -- dbms_shared_pool.purge -- purge sql id
-- health check
-- Adaptive Cursor Sharing : http://www.oracle-base.com/articles/11g/AdaptiveCursorSharing_11gR1.php
-- Query result cache
-- I/O calibration
-- Automated maintenance task .
-- RESULT_CACHE
-- temp_space_allocated to the v$session and V$active_session_history
-- Auto DOP is enabled by setting parallel_degree_policy = AUTO or LIMITED.
-- PARALLEL_FORCE_LOCAL_RAC
-- Statistics Have Improved from Oracle 10gR2 to 11gR2
--
,
Sql Plan Baselines :
-- Plan can be manually loaded in sql plan baselines .
-- Plan in sql plan baselines are verified and accepted plan .
-- For sql plan baselines to be accessible to optimizer , SYSAUX tablespace must be online .
Sql access advisor :
-- partitioning of tables and indexes
-- creation of bitmap , function-based, btree indexes
-- optimizing of materialized view for maximum query usage and fast refresh .
Sql tuning sets , sql management base
-- Every sql statements in STS is considered only once for execution .
-- execution plan and execution statistics are computed for each statement in STS.
Automatic SQL Tuning
-- part of auto task framework
-- Based on AWR top sql identification
http://www.oracle-base.com/articles/11g/AutomaticSqlTuning_11gR1.php
Performance Analyzer
– This is the codification of Oracle’s “holistic” approach, an empirical technique whereby SQL is tuned in a real-world environment. Designed to testing silver bullet impact of global changes (init.ora parameters, new indexes and materialized views, &c), SPA provides real-world evidence of the performance impact of major changes.
11g Compression
– with a late start out of the gate (other DBMS tools have had compression for decades), Oracle’s compression promises to improve the speed of full-scans operations (important to batch jobs and data warehouses).
SQL optimization improvements
– The cost-based optimizer (CBO) is continuously evolving, and we now see bind peeking fixed and extended optimizer statistics.
Automatic Memory Tuning
- Automatic PGA tuning was introduced in Oracle 9i. Automatic SGA tuning was introduced in Oracle 10g.
In 11g, all memory can be tuned automatically by setting one parameter. You literally tell Oracle how much memory it has and it determines how much to use for PGA, SGA and OS Processes.
AWR Baselines
- The AWR baselines of 10g have been extended to allow automatic creation of baselines for use in other features.
Adaptive Metric Baselines
- Notification thresholds in 10g were based on a fixed point. In 11g, notification thresholds can be associated with a baseline, so the notification thresholds vary throughout the day in line with the baseline.
I/O calibration :
-- only one can be run at a time .
-- time_statistics must be set to true
-- can be used to estimate maximum number of I/O and maximum latency time for
-- system
-- need to set parameter filesystemiooptions
Automated maintenance task .
-- database resource manager is automatically enabled in maintenance window that runs automated maintenance task
to prevent consuming excessive amount of memory.
-- Runs : segment advisor , automatic sql tuning advisor , optimizer statistics gathering .
Query result cache
-- can be set at system, session or table level
-- can store results from normal as well as flashback queries . result_cache_mode parameter and hint result_cache and result_cache
-- size is allocated from shared pool but is not flushed when we flush shared pool .
-- use dbms_result_cache to manage query result cache
http://www.oracle-developer.net/display.php?id=503
-- optimizer by default decides
select * from v$sgastat where pool='shared pool' and name like 'Result%';
select * from v$latchname where name like 'Result Cache%';
sql performance analyzer
-- it detects change in sql plan
-- it produces results that can be used to create sql plan baselines
-- it generates recommendations to run sql tuning advisor to tune regressed sql.
######################################################################################
########### Parameter : ################
##########################################################################################
1) DDL_LOCK_TIMEOUT -- for deadlock .
2) sec_protocol_error_further_action
3) Statistics_level to typical enables baselines by default in 11g
5) distributed_lock_timeout
6) PRE_PAGE_SGA
7) memory_target ( dynamic )
8) memory_max_target
9) db_securefile
10) resumeable_timeout
11) enable_ddl_logging
12) optimizer_use_plan_baselines
13) sec_max_failed_login_attempts
14) optimizer_use_pending_statistics
15) LDAP_DIRECTORY_SYSAUTH
16) Diagnostic_dest
17) db_ultra_safe: -- block corruption
-- check for logical self-consistency of data block when modified in memory .
-- checksum is calculated before and after the block change .
-- checks are performed for lost writes to physical standby database .
1) db_lost_write_protect . -- block corruption
2)
######################################################################################
########### deprecated parameters : ################
##########################################################################################
1. BACKGROUND_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
2. OMMIT_WRITE
3. CORE_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
4. INSTANCE_GROUPS
5. LOG_ARCHIVE_LOCAL_FIRST
6. PLSQL_DEBUG (replaced by PLSQL_OPTIMIZE_LEVEL)
7. PLSQL_V2_COMPATIBILITY
8. REMOTE_OS_AUTHENT
9. STANDBY_ARCHIVE_DEST
10. TRANSACTION_LAG (attribute of the CQ_NOTIFICATION$_REG_INFO object)
11. USER_DUMP_DEST (replaced by DIAGNOSTIC_DEST)
######################################################################################
########### Views : ################
##########################################################################################
dba_temp_free_space
dba_sql_plan_baselines
DBA_USERS_WITH_DEFPWD -- to check user with default password .
V$DIAG_INFO
Dba_autotask_client
Dba_flashback_archive
v$memory_dynamic_components / v$memory_target_advisor / v$memory_resize_ops
DIRECT NFS VIEWS :
-- V$DNFS_FILES
-- V$DNFS_SERVERS
-- V$DNFS_STATS
-- V$DNFS_CHANNELS
