• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar

The Geek Diary

HowTos | Basics | Concepts

  • Solaris
    • Solaris 11
    • SVM
    • ZFS
    • Zones
    • LDOMs
    • Hardware
  • Linux
    • CentOS/RHEL 7
    • RHCSA notes
    • SuSE Linux Enterprise
    • Linux Services
  • VCS
    • VxVM
  • Interview Questions
  • oracle
    • ASM
    • mysql
    • RAC
    • oracle 12c
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Hadoop
    • Hortonworks HDP
      • HDPCA
    • Cloudera
      • CCA 131

oracle 12c

How to do a Synchronous Refresh with Staging Logs in Oracle 12c

By Devraj

The distinguishing feature of synchronous refresh is that changes to a table and its MVs are loaded and refreshed together, hence the name synchronous refresh. In a typical data warehouse, data preparation consists of extracting the data from one or more sources, cleansing, and formatting it for consistency,and transforming into the data warehouse schema. The data preparation area is called the staging area and the base tables in a data warehouse are loaded from the tables in the staging … [Read more...] about How to do a Synchronous Refresh with Staging Logs in Oracle 12c

Filed Under: oracle, oracle 12c

Oracle Scheduler 12c New Features and Enhancements

By admin

The core architecture of the scheduler remains the same in 12c with some enhancements and few exceptions in case of the multitenant environment. Enhancements/Modifications Dictionary Views: The below additional columns are added to the *__SCHEDULER_JOB_RUN_DETAILS. Out of these, ERRORS and OUTPUT will be very helpful. ERRORS column shows the error messages related to the job run and the OUTPUT column shows the log of activity during the job run. Earlier, we used to use … [Read more...] about Oracle Scheduler 12c New Features and Enhancements

Filed Under: oracle, oracle 12c

Oracle Database 12c : Creating a Scheduler Job in a Multitenant Database

By admin

The post provides steps to create scheduler jobs in a multitenant database. It covers only DBMS_SCHEDULER jobs. The jobs created using DBMS_JOB jobs have not been covered here since DBMS_JOB has been retained in later versions of Oracle mainly for backward compatibility. It is highly recommended to migrate from DBMS_JOB to DBMS_SCHEDULER jobs. Scheduler job in a CDB Verify that this is a container DB and check the container IDs. SQL> select cdb from v$database; CDB --- YES SQL> … [Read more...] about Oracle Database 12c : Creating a Scheduler Job in a Multitenant Database

Filed Under: oracle, oracle 12c

Interview Questions : Oracle 12c Multitenant Database Architecture

By admin

General CDB / PDB Concept in 12c Multitenant Architecture What is a pluggable database (PDB) in Multitenant Architecture? Pluggable Databases (PDBs) is new in Oracle Database 12c Release 1 (12.1). You can have many pluggable databases inside a single Oracle Database occurrence. Pluggable Databases are fully backwards compatible with an ordinary pre-12.1 database. Why would I consider using the Multitenant option? You should consider following Database Consolidation Goals to … [Read more...] about Interview Questions : Oracle 12c Multitenant Database Architecture

Filed Under: Interview Questions, oracle, oracle 12c

Undo Modes in 12.2 Multitenant Databases – Local and Shared Modes

By Devraj

Till 12cR1 the Undo tablespace used to be shared or global across all the PDBs in a container. From 12cR2 onwards, the local Undo is introduced. When local undo is enabled, each container has its own undo tablespace for every instance in which it is open. When local undo is disabled, there is one undo tablespace for the entire CDB. The Undo mode, whether it’s local or shared, is the property of the entire CDB. Either all the PDBs are local undo mode or there’s shared undo for the entire CDB. … [Read more...] about Undo Modes in 12.2 Multitenant Databases – Local and Shared Modes

Filed Under: oracle, oracle 12c

How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup

By admin

The goal here is to move OCR, voting disk file and ASM spfile in a Grid Infrastructure with RAC cluster to a new ASM disk group. One example would be that you have created these components in the +DATA diskgroup and you wish to move the OCR, Vote File and ASM spfile to a NORMAL or HIGH redundant diskgroup. Basic steps to move to the new diskgroup are outlined below: Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files. Ensure that the new diskgroup is mounted on all … [Read more...] about How to Move OCR, Vote Disk File, ASM SPILE to new Diskgroup

Filed Under: ASM, oracle, Oracle 11g, oracle 12c

New Background Processes In Oracle Database 12c

By admin

The post provides information on new background processes introduced in 12c. Background ProcessDescription BWnnDatabase Writer Processes FENCFence Monitor Process IPC0IPC Service Background Process LDDnGlobal Enqueue Service Daemon Helper Slave LGnnLog Writer Worker LREGListener Registration Process OFSDOracle File Server Background Process RPOPInstant Recovery Repopulation Daemon SAnnSGA Allocator SCRBASM Disk Scrubbing Master Process SCRnASM Disk Scrubbing Slave … [Read more...] about New Background Processes In Oracle Database 12c

Filed Under: ASM, oracle, oracle 12c

Understanding Oracle Database Automatic SGA Memory Tuning

By Devraj

In Oracle Database 10g, Automatic Shared Memory Management (ASMM) feature is introduced to automatically determine the size of Database buffer cache (default pool), Shared Pool, Large pool and Java pool (starting with 10gR2, the streams pool is included) by setting the parameter SGA_TARGET. This feature reduces the tasks like dynamically analyzing the database workload and redistribute memory across the SGA pools. Benefits of Automatic Shared Memory Management Automatic Shared Memory … [Read more...] about Understanding Oracle Database Automatic SGA Memory Tuning

Filed Under: oracle, Oracle 10g, Oracle 11g, oracle 12c

Understanding Oracle Background Processes

By Devraj

Oracle Background Processes The background processes of the Oracle instance manage memory structures, asynchronously perform I/O to write data to a file on a disk, and perform general maintenance tasks. An Oracle database system consists of an Oracle database and an Oracle instance. The database consists of a set of disk files that store user data and metadata, while the Oracle/database instance contains the set of Oracle Database background processes that operate on the stored data and the … [Read more...] about Understanding Oracle Background Processes

Filed Under: oracle, Oracle 11g, oracle 12c

How to create password file for Database on 12c ASM diskgroup

By admin

The compatible.asm disk group attribute must be set to 12.1 or higher for the disk group where the password is to be placed. Steps 1. Create the password file using the following command. Go to the asmcmd command prompt and run : $ asmcmd ASMCMD> pwcreate --dbuniquename [dbuniquename] [file_path] [sys-password] Here, The --dbuniquename string option identifies the database unique name associated with the password file. The file_path value identifies the location where the password … [Read more...] about How to create password file for Database on 12c ASM diskgroup

Filed Under: oracle 12c

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4

Primary Sidebar

Recent Posts

  • How to set the order to load certain modules in CentOS/RHEL 7 and 8
  • How to configure initrd / initramfs to including kernel modules in CentOS/RHEL
  • How to configure systemd.path to trigger an event when any changes made to a directory
  • Script to monitor RMAN Backup and Restore Operations
  • Oracle RMAN Backup Shell Script Example
  • Archives
  • Contact Us
  • Copyright

© 2019 · The Geek Diary