Oracle 23c New Features for DBA'sChatbots, an intelligent assistants which/who can interact with opposite parties and address the concerns or respond to simple questions or questions that are generic or non-generic in nature where we can put pre-determined answers and actions, widely popular in lot of industries especially in customer care support to do some mundane stuff like providing information, […]
|
||||
|
Cloud Feature – Not working in On Prem installation. Oracle Database 12c introduced online statistics gathering for CREATE TABLE AS SELECT statements and direct-path inserts. Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements. Because statistics can go stale between DBMS_STATS jobs, real-time statistics helps the optimizer generate more optimal […] 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 […] Some New wait events that I learnt today, acknowledge over PGA limit (12.1) The “Acknowledge Over PGA limit” is a new wait event that was introduced with PGA_AGGREGATE_LIMIT in 12.1, and it will force a process that wants more PGA to wait a bit if the instance is getting close to hitting the limit. Set […] 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 |
||||
Follow Me!!!