“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in January 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use…
| Publish Date | TidBit |
| 2-Jan | #oratidbit the SCHEMA_EXPORT_OBJECTS view shows the valid values you can use with EXCLUDE and INCLUDE parameters when using schema level export/import. DATABASE_EXPORT_OBJECTS and TABLE_EXPORT_OBJECTS are views for full database and table level export/import respectively. |
| 5-Jan | #oratidbit The tables beginning with ROLLING$ owned by SYSTEM are internal system tables used by the DBMS_ROLLING PL/SQL package used to implement the Rolling Upgrade Using Active Data Guard feature, which streamlines the process of upgrading Oracle Database software in a Data Guard configuration in a rolling fashion. |
| 6-Jan | #oratidbit The SYSTEM_PRIVILEGE_MAP table lists all system privileges in the Oracle database. Similar table is STMT_AUDIT_OPTION_MAP. |
| 7-Jan | #oratidbit The EXPTIME column in SYS.USER$ shows the actual password expiration time of the user. The LTIME column shows time when account is locked. |
| 8-Jan | #oratidbit Transparent sensitive data protection (TSDP) is a new feature in #DB12c that enables you to quickly find all table columns in a database that hold sensitive data. |
| 9-Jan | #oratidbit Starting with 11g, the $ORACLE_HOME/rdbms/admin/sql.bsq script is modularized, and calls multiple *.bsq scripts. In #DB12c 12.1.0, there are 25 *.bsq scripts called in sql.bsq. |
| 14-Jan | #oratidbit In #DB12c when Unified Auditing is enabled, audit records are queried from UNIFIED_AUDIT_TRAIL view. For better efficiency, audit records are written to SGA first and not written to disk until the in-memory queues are full. You may force a flush using SYS.DBMS_AUDIT_MGMT.FLUSH_UNIFIED_AUDIT_TRAIL procedure. |
| 15-Jan | #oratidbit AUDIT_SYSLOG_LEVEL init parameter enables SYS and standard OS audit records to be written to the system audit log using the SYSLOG utility. |
| 16-Jan | #oratidbit To enable unified auditing in #DB12c, relink the oracle executable using the uniaud_on option. cd $ORACLE_HOME /rdbms/lib make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME |
| 19-Jan | #ortidbit Per MOS DOC 161818.1 Oracle Database (RDBMS) Releases Support Status Summary, 12.1.0.2 is the terminal 12.1 Patch Set and is currently only available for Enterprise Edition. |
| 20-Jan | #oratidbit RAC and DB Support Tools Bundle MOS in Doc 1594347.1. Tools include ORAchk (formerly RACcheck) Trace File Analyzer Collector (TFA) OSWatcher Procwatcher ORATOP SQLT Remote Diagnostic Agent (RDA) Diagnostic Assistant (DA) |
| 21-Jan | #oratidbit Check out the Databsae Diagnostic tools in MOS DOC 559339.1. Tools include ORA-600 Troubleshooting Tool ORA-1578 Troubleshooting Tool ORA-2730x Troubleshooting Tool ORA-3137 Troubleshooting Tool ORA-4030 Troubleshooting Tool ORA-4031 Troubleshooting Tool ORA-7445 Troubleshooting Tool ORA-600/ORA-7445 Error Look-up Tool Database Upgrade Troubleshooting Tool RAC Node Eviction Troubleshooting Tool EMDIAG Troubleshooting Tool |
| 22-Jan | #oratidbit Oracle Database Recommended Pathces in MOS DOC 756671.1. Be proactive! |
| 23-Jan | #oratidbit Check out MOS Doc 1555012.2 Troubleshooting Assistant: Oracle Database – Client / Install / Deinstall / Cloning |
| 26-Jan | #oratidbit Use the DBMS_PDB.DESCRIBE procedure on the non-CDB to generate the XML file, which you can use to plug in the non-CDB as PDB to a CDB. |
| 27-Jan | #oratidbit According to MOS Note 742060.1, Oracle Database 12c Release 2 is expected in First Half 2016. |
| 29-Jan | #oratidbit If Oracle Restart is installed, you can manage ASM instance, database instance, ASM diskgroup, listener, database service and Oracle Notification Services (ONS) using SRVCTL. |
| 30-Jan | #oratidbit “srvctl start home” starts all of the components that are managed by Oracle Restart in the specified Oracle home. |