What is the pinning in Shared pool Oracle Applications requires space in the ORACLE System Global Area (SGA) for stored packages and functions. If SGA space is fragmented, there may not be enough space to load a package or function. You should pre-allocate space in the SGA shared pool for packages, functions, and sequences by …
Why pinning objects into the shared pool? Read More »
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 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 …
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 …
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 »
