|
||||
|
In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases. You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same. The […] Here is the filtered tables after comparison of 11g with 12c Background Processes. Name Expanded Name Short Description Long Description External Properties AQPC AQ Process Coordinator Per instance AQ global coordinator AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is […] Architecture of Data dictionary in view of multiple containers in a Single SGA The above diagram requires a explanation. Data Dictionary A data dictionary resides in CDB is shared (definitions) between CDB & PDB, for those objects that are system (internal) For example: AWR is global, TAB$, OBJ$ etc.A data dictionary objects or […] Before to 12c, when using a single database the user management is pretty straight , create a user and assign the privileges or roles and manage it. In view of multitenant architecture, where multiple databases exists managing multiple databases with a single users can be cumbersome, For example you a host that hosts 10 applications […] From the release 12c Database, the new architecture has been introduced similar to MS-SQL concepts a master database and the multiple databases attached to that master database shares a single SGA. In same way Oracle Introduced multitenant architecture where the multiple databases share same SGA and all databases are interlinked to master database called Root […] Excellent step by step document from my colleague, Venkat, with his kind permission I am publishing the same for all benefit. Please note the following can be done using Duplicate database from active database without moving any backups etc. But that is another variant. ########################################################################################### Copy RAC database to another RAC Server ########################################################################################### Task: Copy […] The first part I.e Grid Infrastructure (RAC) Installation is here And the Final part You can download it from here http://db.geeksinsight.com/wp-content/uploads/2013/07/Step-by-Step-Oracle-12c-RAC-Database-on-Linux-64bit.docx -Thanks Geek DBA Hello, While installing 12c grid infrastructure, observed that vktm and LMS process are consuming high CPU top – 23:48:23 up 4:58, 4 users, load average: 13.38, 13.80, 12.08 Tasks: 217 total, 2 running, 215 sleeping, 0 stopped, 0 zombie Cpu(s): 27.5%us, 26.1%sy, 0.0%ni, 0.7%id, 0.7%wa, 0.0%hi, 45.1%si, 0.0%st Mem: 3519360k total, 3416516k used, 102844k free, […] Hello All Finally able to install the 12c Grid Infrastructure and here is the procedural document. You can download from below link, Also added in downloads link http://db.geeksinsight.com/wp-content/uploads/2013/07/Step-by-Step-Oracle-12c-Grid-Infrastructure_Installation.docx -Thanks Geek DBA New ASMCMD commands, now ASMCMD has the ability to do password file management, patches on asm instances, and version pwcopy Copies a password file to the specified location. pwcreate Creates a password file at the specified location. pwdelete Deletes a password file at the specified location. pwget Returns the location of the password file. pwmove […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!