|
||||
|
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 […] Hi, In view of multiple databases sharing single SGA how to distinguish which database you will need to see. Now all dynamic views has two new columns for example:- V$process SQL> desc v$process Column Datatype ADDR RAW(4 | 8) PID NUMBER SOSID VARCHAR2(24) SPID VARCHAR2(24) STID VARCHAR2(24) EXECUTION_TYPE VARCHAR2(10) PNAME VARCHAR2(5) USERNAME VARCHAR2(15) SERIAL# NUMBER […] Here is the list of deprecated parameters as of 12.1.0.1 SQL> SELECT name from v$parameter WHERE isdeprecated = ‘TRUE’ ORDER BY name; active_instance_count background_dump_dest buffer_pool_keep buffer_pool_recycle commit_write cursor_space_for_time fast_start_io_target global_context_pool_size instance_groups lock_name_space log_archive_local_first log_archive_start max_enabled_roles parallel_automatic_tuning parallel_io_cap_enabled parallel_server parallel_server_instances plsql_v2_compatibility remote_os_authent resource_manager_cpu_allocation sec_case_sensitive_logon serial_reuse sql_trace standby_archive_dest user_dump_dest |
||||
Oracle 23c New Features for DBA's
Follow Me!!!