The 12c AWR Report section on Segment Statistics now reports both Obj# (OBJECT_ID) and DataObj# (DATA_OBJECT_ID).
The DIRECT parameter for SQLLoader Command-Line enables Direct Path Load which uses a Direct Path API instead of a regular INSERT statement to load data into the target table.
Here are some extracts from an 18.104.22.168 AWR Report I ran a simulated workload on this server for about 40minutes and generated this report.
Marko Sutic’s blog post on Adaptive Cursor Sharing and SQL Plan Baselines, with an example of SQL Patch as well....
In my previous blog post, I had demonstrated a few custom services created and started with DBMS_SERVICE.