|
||||
|
We have got a call from team asking about a high cpu usage, and here is our hunting down load averages: 97.5, 98.8, 100.0; up 11+22:24:01 01:14:52 410 processes: 276 sleeping, 118 running, 3 zombie, 13 on cpu CPU states: 0.0% idle, 89.6% user, 10.4% kernel, 0.0% iowait, 0.0% swap Memory: 32G phys mem, 17G […] The below is Gathered from various sources and listed out here, thanks to all who shared those in their respective blogs, Optimizer Blog, Tim hall, Ask Tom etc. Core Architecture Changes:- Container & Pluggable Databases – New parameter PGA_AGGREGATE_LIMIT, to limit the pga memory utilization New role CDB Administrator has been introduced Multi threaded database […] Oracle may introduce or leverage the multi threading architecture more. In turns, Oracle may reduce the number of process that it actually use to minimum, One process on behalf of all the other dedicated processes will work and drastically reduces the number of processes. There will be a new parameter for this could be […] Hello Readers, Thanks to Kirill for allowing me to share his blog posts on 12c database. Nice write up where you found the preliminary information on 12c pluggable databases which is coming soon. Architecture Overview:- http://www.dadbm.com/2013/01/oracle-12c-pluggable-database-fundamental-architectural-change/ Features Insight:- http://www.dadbm.com/2013/01/oracle-12c-pluggable-database-feature-insights/ Some hands on:- http://www.dadbm.com/2013/02/oracle-12c-pluggable-database-pdb-feature-hands-on-experience/ Plug & Unplug the databases in 12c:- http://www.dadbm.com/2013/02/oracle-12c-pluggable-database-plug-unplug-and-clone/ BTW, I missed to […] The following may appear in the upcoming release Oracle 12c database. Architecture in 12c: Multitenant Database , container CDB. Indexing in 12c: Allows multiple index on same column definition , appealing but not confirmed yet. Partitioning in 12c: Online move of partition, multiple partition merge in one go, partial indexing, interval reference partitioning Identity columns […]
WOW!!!! 12C database roadmap announced, as usual it is bringing us a big change in Oracle database architecture. Oracle Open world started last sunday and Oracle CEO Larry Ellison announced a complete new paradigm architecture of Oracle Database with 12c, which is going to launched in calendar 2013. From the architecture perspective, this is […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!