Oracle Tidbits – August 2016

Oracle *daily* TidBits” (#oratidbit) published at on weekdays in August 2016. 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…

#oratidbit All Oracle transactions obey the basic properties of a database transaction, known as ACID properties – Atomicity, Consistency, Isolation & Durability.
#oratidbit Oracle Database supports statement-level atomicity, which means that a SQL statement is an atomic unit of work and either completely succeeds or completely fails. The effect of the failure (rollback) is as if the statement had never been run.
#oratidbit A system change number (SCN) is a logical, internal time stamp used by Oracle Database. SCNs order events that occur within the database, which is necessary to satisfy the ACID properties of a transaction.
#oratidbit SHARING column in ALL_OBJECTS is new in 12c. In a PDB, value of METADATA LINK is a directive to get metadata from CDB$ROOT, OBJECT LINK is a directive get object from CDB$ROOT.
#oratidbit ORACLE_MAINTAINED column in ALL_OBJECTS is new in 12c. Objects with value Y in this column must not be changed in any way except by running an Oracle-supplied script.
#oratidbit When you request a trial subscription to an Oracle #Cloud service at, the system automatically assigns you three roles: account administrator, identity domain administrator, and service administrator.
#oratidbit Two types of subscriptions are available in Oracle Database as Service – Oracle Database #Cloud Service and Oracle Database Cloud Service Virtual Image.
#oratidbit Unicode (AL32UTF8) is the character set used by database instances created in Oracle #DBaaS #cloud.
#oratidbit Oracle Database #Cloud Database Schema Service is built on Oracle Database technology, running on the Oracle Exadata Database Machine. Service includes Enterprise Edition Database, Application Express, RESTFul Web Services and Packaged Applications Sample Code.
#oratidbit The Oracle Database #Cloud provides complete data isolation at the database or VM and network levels. With Database Schema Service, each tenant receives a dedicated Oracle Database schema. With Database as a Service, each tenant is provided a dedicated database instance on a virtual machine.
#oratidbit the SET NEWNAME FOR configuration in RMAN DUPLICATE can specify clauses FOR DATABASE (all files), FOR DATAFILE (only data files), FOR TEMPFILE (for temporary files) and FOR TABLESPACE (files belongin to tablespace).
#oratidbit If the database control file is restored from backup or re-created, all accumulated flashback log information is discarded. You cannot use FLASHBACK DATABASE to return to a point in time before the restore or re-creation of a control file.
#oratidbit Query the V$RMAN_BACKUP_JOB_DETAILS for the backup job history including backup type, status, start and end time, backup job speed, size of the backups.
#oratidbit Hybrid Column Compression and In-Memory Column Store (IM column store) are closely related. The primary difference is that Hybrid Column Compression optimizes disk storage, whereas the IM column store optimizes memory storage.
#oratidbit When an update occurs for a row in an uncompressed data block, only the updated row is locked. When using Hybrid Column Compression, the database must lock all rows in the compression unit if an update is made to any row in the unit.
#oratidbit Bitmap indexes can include keys that consist entirely of null values, whereas for B-Tree indexes Oracle Database does not index table rows in which all key columns are null.
#oratidbit Before you create a DBaaS instance on Oracle Database #Cloud (#DBaaS), you must setup an SSH public/private key pair to connect to compute node and optionally Oracle storage cloud service container to backup the database to cloud.
#oratidbit Oracle DBaaS Monitor provides monitoring and management of the Oracle database and listener on Oracle Database #Cloud #DBaaS. DBaaS Monitor provides quick and easy access to a variety of information about the database instance running.
#oratidbit #DBaas monitor, along with other management monitoring information, provides capabilities to start and stop database instance, open and close pluggable database, create, drop and clone pluggable database and start & stop listener.
#oratidbit Use the oracle-dbcs-cli utility on your Linux computer to connect to Oracle #Cloud and perform a variety of life-cycle and administration operations on Oracle Database Cloud.
#oratidbit The database services required to support Oracle #GoldenGate capture and apply must be enabled explicitly for an Oracle or greater database by setting init parameter ENABLE_GOLDENGATE_REPLICATION=true.
#oratidbit In Data Guard configuration, a switchover is a role reversal between the primary database and one of its standby databases. A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.
#oratidbit In Data Guard configuration, a failover is a role transition in which one of the standby databases is transitioned to the primary role after the primary database fails or has become unreachable. A failover may or may not result in data loss depending on the protection mode in effect at the time of the failover.

Leave a Reply

%d bloggers like this: