|
||||
|
From the release notes:- https://access.redhat.com/knowledge/docs/en-US/Red_Hat_Enterprise_Linux/6/html-single/6.4_Release_Notes/index.html
As we aware that Oracle didn’t shipped the ASMLIB for RHEL, to progress on that, RHEL has came up with similar modules. Oracle ASMLib Availability and Support Oracle ASM (Automated Storage Management) is a data volume manager for Oracle databases. ASMLib is an optional utility that can be used […] Atleast I found hard checking in many other areas,hence writing this You may not find the no rows for gather_stats_job in 11g due to the enhancments in maintainence groups. The collection of statistics along with some other maintainence tasks have been incorporated in to dba auto task admin client procedure First you need to […] 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 […] Sometimes You may require to check the dependencies for the resources for example to stop a ASM you will need to find what are the dependent resources in CRS or to change a vip what are the dependent resources associated with it to bring them down and perform your activity like chaning vip etc. To […] In Oracle execution plan, you often see Nested loops/Hash Joins/Merge Joins etc. These are called Join methods between row sources (tables/result sets of query). You are can find more about Rowsource Join Methods here in the documentation There are many join methods, out of all the following were common and generic Nested loop join […] Typically we would have the following patterns when we use like operator. SEARCH-STRING% %SEARCH-STRING %SEARCH-STRING% SEARCH%STRING 1. a)The SEARCH-STRING% will perform INDEX RANGE SCAN data in least possible time. b)Also uses INDEX FULL SCAN when you have only indexed column list in the queries. c) If multiple predicates used, this may loose […] The question is tricky, I have asked accessed not modified/changed. If so modified/changed dba_tab_modifications can give you a clue. For both of this questions, the below query will help. Table is in use or not? This question may arise from App team that they have released a new module which may not require certain tables […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!