#oratidbit #db12cR2 Parameter AWR_PDB_AUTOFLUSH_ENABLED specifies whether to enable or disable automatic Automatic Workload Repository (AWR) snapshots for all the PDBs in a CDB or for individual PDBs in a CDB. By default, automatic AWR snapshots are disabled for all the PDBs.
#oratidbit #db12cR2 Parameter AUTOTASK_MAX_ACTIVE_PDBS specifies the maximum number of PDBs that can schedule automated maintenance tasks at the same time. By default, two PDBs and the CDB root can run tasks at the same time during a maintenance window.
#orcldb #db12cr2 Redo Volume Optimization in 12c R2 | Official Pythian® Blog https://buff.ly/2tAfQHo
#orcldb #db12cR2 12cR2 auditing all users with a role granted - Blog dbi services https://buff.ly/2HMW2p0
#orcldb #db12cr2 #OSWatcher, Tracefile Analyzer, and Oracle 12.2 single instance https://buff.ly/2FvHxpf
#oratidbit Starting with #db12cR2 release, you can use the INACTIVE_ACCOUNT_TIME profile parameter to automatically lock the account of a database user who has not logged in to the database instance in a specified number of days.
#oratidbit #DB12cR2 You can capture Automatic Workload Repository (AWR) data for Oracle Active Data Guard standby databases. This feature enables performance tuning of Oracle Active Data Guard standby databases.
#oratidbit #DB12cR2 You can use FLASHBACK PLUGGABLE DATABASE command to rewind a PDB to any SCN without affecting other PDBs in a CDB. You can also create a restore point specific for a PDB, and rewind the PDB to this restore point without affecting other PDB.
#oratidbit #DB12cR2 During a PDB clone operation, the source PDB no longer needs to be in read-only mode.
#oratidbit In Oracle #DB12cR2 many datatype conversion functions (TO_DATE TO_NUMBER etc) and CAST function includes data error handling using the "DEFAULT value ON CONVERSION ERROR" option. Example: TO_NUMBER('2,00' DEFAULT 0 ON CONVERSION ERROR) returns 0 instead of error.
#oratidbit #db12cR2 Init parameter DATA_GUARD_SYNC_LATENCY, defines the maximum amount of time (in seconds) that the primary database may wait before disconnecting subsequent standby destinations after at least one synchronous standby has acknowledged receipt of the redo.
#oratidbit #db12cR2 The AWR_PDB views show the local AWR data present on a CDB root or a PDB. When accessed from a CDB root, they show the AWR data stored on the CDB root. When accessed from a PDB, they show the AWR data stored on that PDB.
#oratidbit #db12cR2 The AWR_ROOT views are equivalent to the DBA_HIST views that show the AWR data present only on the CDB root. When the AWR_ROOT views are accessed from a PDB, they show the subset of the CDB root AWR data, which is specific to that PDB.
#oratidbit In #db12cR2, you can take an AWR snapshot at a CDB-level (on a CDB root) or at a PDB-level (individual PDB). The CDB-level snapshot data is stored in the SYSAUX tablespace of a CDB root. The PDB-level snapshot data is stored in the SYSAUX tablespace of a PDB.
#db12cR2 #db18c 1/17. Dallas. Oracle Master Class! https://buff.ly/2Duv6sL
#oratidbit #db12cR2 When the character set of the CDB root is AL32UTF8, any container in the CDB can use a... https://fb.me/8UKVnpk4c
#oratidbit #db12cR2 When the character set of the CDB root is AL32UTF8, any container in the CDB can use a character set that is different from the CDB root and different from other containers in the CDB.
#oratidbit #db12cR2 Init parameter PDB_OS_CREDENTIAL can be used to ensure that operating system interactions... https://fb.me/7Lw1x16w3
#oratidbit #db12cR2 Use the new -T option for the parallel upgrade utility (catctl.pl) to set user tablespaces... http://fb.me/2kkDua7z0
#oratidbit #db12cR2 Use the new -R option for the parallel upgrade utility (catctl.pl) to resume the upgrade at... http://fb.me/1qFoeGsI0
#oratidbit #db12cR2 Credentials created using the DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure are database... http://fb.me/9zms0E5Ao
#oratidbit #db12cR2 Init parameter PDB_OS_CREDENTIAL can be used to ensure that operating system interactions are... http://fb.me/82D6z31ww
#oratidbit #db12cr2 Oracle Diagnostic Pack (AWR/ADDM) can be used on an Oracle Active Data Guard standby database that is open read-only.
#oratidbit #db12cR2 The Parallel Upgrade Utility (catctl.pl) parameter -N controls the number of parallel SQL... http://fb.me/9mbpTa9lW
#oratidbit #db12cR2 Use the new -T option for the parallel upgrade utility (catctl.pl) to set user tablespaces... http://fb.me/9ciBthzUe
#orcldb #orclrac #db12cr2 New availability features in oracle rac 12c release 2 anair ss https://buff.ly/2l6qXpH
#oratidbit #db12cR2 Database Configuration Assistant (DBCA) supports creation of an Oracle Data Guard standby... http://fb.me/163r7H7ZV
