Comonly used Tags12c Audio Big Data birthday Database DBMS_XPLAN Docker events Exadata Execution Plans Github Hints histograms In-Memory IoT JSON Multitenant My_Activities OOW optimizer Oracle Oracle Database 12c Partitioning Performance REST Security Sharding SQL Monitor statistics syntax top_tip UKOUG Usergroup video
Category Archives: New Features
Since it’s introduction in Oracle Database 8i, the DBMS_STATS package is Oracle’s preferred method for gathering statistics. With each new database release the DBMS_STATS package is extended to accommodate new approaches to gather statistics and new types of statistics. Over … Continue reading
Over the last month or so I’ve been on the road presenting at different user group conferences and meeting with customers. I’ve gotten a number of requests via blog comments to share the slides for the sessions I presented. One … Continue reading
Prior to Oracle Database 12c Release 2, all object names had been limited to just 30 bytes. This limitation lead to some interesting problems, especially if you wanted to use descriptive names for the database objects you were creating.
Take for example the dictionary tables we wanted to create in 12.1 to help manage SQL Plan Directives. The first table was DBA_SQL_PLAN_DIRECTIVES, with 23 characters, which wasn’t problem. However, the second table we wanted was DBA_SQL_PLAN_DIRECTIVES_OBJECTS. Continue reading