Major cloud providers have begun to offer a plethora of services tailored to meet the demands of various industries. Oracle Database Service for Azure is…
Leave a CommentExpert Oracle Posts
SQL Profile and SQL Baseline are both used to optimize the performance of SQL statements in Oracle databases. However, they work in slightly different ways:…
Leave a CommentQ: What is Oracle RAC and what benefits does it offer? Ans: Oracle RAC (Real Application Clusters) is a cluster database technology that allows multiple…
Leave a CommentIn this post, we will focus on the Metrics Explorer page in the Oracle Cloud Infrastructure (OCI) Console. The Metrics Explorer page in the Oracle…
Leave a CommentPL/SQL lock timer wait event in Oracle occurs when a session is waiting for a lock held by another session to be released. This can…
Leave a CommentIn this post, we will see how to view metric charts that use predefined service queries. Default metric charts are available on the Service Metrics…
Leave a CommentFrom the user and application perspective, the data dictionary in each container in a CDB is separate, as it would be in a non-CDB.
For example, the DBA_OBJECTS view in each PDB can show a different number of rows. This dictionary separation enables Oracle Database to manage the PDBs separately from each other and from the root.
Leave a Comment
Oracle Multitenant database can provide few good benefits if we plan carefully and specially by having a non-traditional approach. In the starting it may seem intimidating to the seasoned DBAs as this architecture need some learning and practice. Few of the key benefits which Oracle describes are mentioned below:
Leave a CommentThe multitenant architecture enables an Oracle database to function as a multitenant container database (CDB).
This feature is available in Oracle Database 12c or later releases so you must install or upgrade to Oracle Database 12c or later releases. The database compatibility level must be set to 12.0.0 or later to utilize the multitenant feature.
Leave a Comment
Oracle Cloud Infrastructure (OCI) Monitoring is a vital part of managing and optimizing your cloud resources. However, the terminology used in OCI Monitoring can be…
Leave a Comment