1.This quiz consists of 35 questions .It is recommended to complete the test in 60 min2. It consists both single choice and more than one choice questions to test your knowledge3. You can press the submit button at the end of your test and get the final score4.You will also get the know the correct […]
Oracle performance & tuning Quiz Read More »
Oracle database 12c Release 2 provides flashback capability at the individual PDB level. Lets discuss the new feature. we can learn about Flashback database in general from below links Flashback Database explained and limitation For the oracle database to be flashback, archive log mode and flashback mode should be on How to put database in
Flashback PDB in Oracle Database 12c Release 2 Read More »
Many times, we may need to copy the remote PDB to Local PDB for testing purpose. The case would be copying Production PDB to Development PDB box. Some times , we may want to migrate the non-CDB to PDB to make sure Multitenant features in the Oracle database Restriction for doing this 1)The default tablespaces
How to remotely clone a PDB or non-CDB in Oracle Database 12.1 Read More »
Oracle database is the widely used database in industry .Here I am trying to explains about oracle locks,oracle table locks What is Oracle Enqueue and locks Enqueue are Oracle locks which serialize the operations to the shared structure. The shared structure could be table, redo threads and transactions. When a user A updates a row
Oracle Locks & table locks: How it works Read More »
Unable To Authenticate Session or Unable to create session is one of the most common errors in R12 instance ERROR———————–“Unable to authenticate session” This can happen after the instance is cloned or any changes happened to the system with wrong parameter The first log which you should check in case of this error is $INST_TOP/logs/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log
Unable To Authenticate Session in R12 Read More »
Oracle ASM Rebalance: Any change in the storage configuration like disk addition or dropping will trigger a oracle ASM rebalance operation The main objective of the oracle ASM rebalance operation is to always provide an even distribution of file extents and space usage across all disks in the diskgroup. Rebalancing is performed on all database
How Oracle ASM Rebalance works Read More »
