|
||||
|
Statistics gathering until 18c was on daily/weekly basis based on the maintainance tasks defined. Say 10PM every day with 8 hour window on weekdays and 24 hrs window on week ends. And how many times we have seen statistics have become stale between two collections and DBA’s has to manually intervene and collect stats. From […] Oracle’s Simple Oracle Document Store is an interface to manage Document Store type work loads in Oracle Database. Leveraging JSON Object Support with in Oracle Database. SchemaLess & NOSQL access but fully acid complaint. Collection Management through various implementations like Java, Rest, Python, Native SQL etc. Store and manage JSON and XML documents in Oracle […] Edited this post on 30-Apr, to correct my command in the test. Update the post on 22-May, not working in on-prem as expected. Whilst the documentation say’s the auto indexing feature is not available on-prem ones, I tried to test it out. Command to enable auto index mode is below, we have options “Implement”, “Report-Only”, […] Starting Oracle 19c, SQL Quarantine features helps to prevent reuse of same execution plan which was terminated by resource managers due to resource limits. This will help not to run the rouge queries again on the database if the resource manager is active. SQL Quarantine will need to setup configuration and define thresholds for specific […] Hi In this post we will see how to install Oracle 19c Database using RPM method with Vagrant Virtual box and via ansible playbook. Pre-reqs You need to have vagrant installed in your machine. Steps: Download the repository for Vagrant and Ansible playbook here Download 19c database rpm from Oracle downloads and copy into your […] Hi While I am exploring the Oracle 19c Database, I found that docker images are already available in https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance/dockerfiles/19.3.0 Along side, here is the excerpt from documentation , automatic indexing , quarantine, real time statistics are only available on Cloud versions not on normal EE on prem databases. So , Hail cloud 🙂 https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472 […] Hello All, Oracle 19c is available officially for download , cant wait to test automatic indexing feature. Keep you posted. https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Thanks Suresh Hello Today morning I opened twitter and saw lot of posts on Oracle 19c available on exadata, Thanks to Maria & others pointing me out to blogs.oracle.com. I started surfing through the links and found Oracle 19c Documentation is available and especially new features link. Here it is. For Database Admin and Dataguard new documentation […] Oracle 19c was on LiveSQL and I can’t wait to test out the 19c Automatic Indexing features, so I tried to create emp/dept tables and queried to use hint /*+ USE_AUTO_INDEXES */ to use automatic indexing. To my dismay, I forgot the fact that LiveSQL is on Exadata and index scans not possible unless settings. […] Yes, Oracle always strive to integrate latest trends in the industry to its Database. Now the new one is Kafka integration with Oracle Database through DBMS_KAFKA package. Where you can publish events and consume or load data into tables. This feature has been discussed in CodeOne 2018 by Melli Annamalai, Senior Principal Product Manager at […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!