OracleNotes

Author: Biju

  • Oracle ACED Briefing and Open World

    My first Oracle HQ visit was for the Oracle ACE Director briefing. Had two good days at the HQ. The briefing started with a super cool session by Thomas Kurian (President, Product Development). He was ready to answer any and all questions we had. Learned a lot about the Oracle cloud products that are on the way and the improvements / improvisations in existing Cloud Offerings. You will be seeing many of these announcements we learned under NDA from Larry and other executives during the Open World Conference keynotes. Stay tuned!

    A visit to HQ is not complete without taking a picture, so I did a few too.

    It was so good to meet many Oracle ACED in person!

    Thanks to Oracle ACE Program and OTN for taking care of my travel, hotel and Oracle Open World!

    If you are in San Francisco this week, I would be elated to say “hello”!

    And I would be updating intersting sessions and tips and news through my social media channels…

    Facebook

    Twitter

     

     

  • Oracle Tidbits – August 2016

    “Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes 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 cloud.oracle.com, 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 11.2.0.4 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.