|
||||
|
Hi All – from previous community discussions, there is a bug in 11.2.0.4 which prevents remote connections as SYS if the SYS account has been locked – this also prevents DG Broker from working correctly, and led to our advice not to lock SYS for DG 11.2.0.4 systems. Oracle have issued a one-off patch for […] Issue: Post 12C upgrade: Oracle Bug – Virtual Column issue Fix: Set it at session level or system level – fix_control=’16237969:OFF’ Be aware of the virtual column getting created with function based index, which may lead to sub-optimal plans. In 11g , index is getting picked by the oracle optimizer and going with optimal Plan. […] When you run the awr report with non privileged user i.e custom user (even with dba privilege) you may receive the following error. @?/rdbms/admin/awrrpt.sql ORA-13605: The specified task or object does not exist for the current user. Error encountered in special section 99995 The possible cases are, missing grant on sys.dbms_advisor bug 17588463 — found […] Hello All, The Second wave of APACOUC – IAOUG ANZ Webinars registrations open now and you have more exciting presentations to come. And I am presenting topic Devops for Databases which details about Devops Principles to databases, why they are hard to implement, creating your own framework, strategy, approach, tools that needed for each approach […] Folks! this subject line may sound silly, but most of us really think how for a moment. Business Requirement is some want to add a column to high volatile table, So they want to understand, Does it cause issue as its high volatile and access by Website? What is the best time to add a […] Ever, interested in looking for statistics staleness for each table including how much percent they stale are. The following query helps you to get you the details. This query filter out the staleness for those tables which having more than or equal to 10%, you can adjust accordingly. However, you will need to […] If you are working a production support DBA and very often you will need to check the statistics of the table and how much change what changed in each columns etc. I have figured out two ways for it and seems very useful. Option 1:- 11gR1 has a package to show differences and comparison of […] Does any knows about flushing the PGA? Actually it can, not quite sure of release memory or not as it depends on high water mark (as like you try to shrink the datafile and it fails) similarly the following procedure also may not work if a memory chunk sitting at the edge of high water […] While running dbca we are receiving the ora-12547 and we could not able to create database using DBCA anymore. After googling and metalink search found many notes which does not resolve the issue, the reasons can be multifold Environments- SID, PATH, LD_LIBRARY_PATH – Not resolved Permission on oracle executable to 6751 – Not resolved Package […] Well, this is fairly an old topic but explored lately by me. Very big post click on read more to scroll down to full page. Ah, I was trying to explore the upgrade from 11gr2 to 12c but not traditional way, and go these two excellent white papers. http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-transientlogicalrollingu-1-131927.pdf http://www.oracle.com/technetwork/database/features/availability/maa-wp-11g-upgrades-made-easy-131972.pdf The high level overview of […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!