Oracle 23c New Features for DBA'sUpdated answers
|
||||
|
Learnt new thing today, thanks to my colleague Gagan. Alert log showing this error, whilst checking the trace shows an update statement into a table which is capturing the sid,serial# from gv$session. So then why ora-600, As per metalink note:- Ora-00600 [13030], [20] During Update Statement Using V$ tables [ID 1400439.1] For updates we use […] Another little feature in 11g is undo backup optimization. Prior to Oracle 11g, RMAN always backed up all UNDO with a full backup, including UNDO for committed blocks. However in 11g, RMAN is able to skip the UNDO information for those blocks that are already committed and exceeded undo_retnention threshold. This optimization brings in […] Hello Everyone, Thanks to Satish / Shanawaz for sharing this piece. What if , if you been assigned on, A brand new database with new application designed , new tables and short volume of data, asked you to verify the database performance and provide suggestions and recommendations for any improvements. You can assume this is […] 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 […] |
||||
Follow Me!!!