You are here |
alexzeng.wordpress.com | ||
| | | |
sqlmaria.com
|
|
| | | | Back in January, I promised I would write a series of blogs on some of my favorite new 12c enhancements, designed to make your life easier. I'm finally getting around to keeping that promise with t... | |
| | | |
hoopercharles.wordpress.com
|
|
| | | | May 9, 2010 (Back to the Previous Post in the Series)(Forward to theNext Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers,if the answers to those questions depend on the source of the informationfound through Internet searches. Today's quiz is on the topic... | |
| | | |
connor-mcdonald.com
|
|
| | | | Anyone who has used APEX will know that in addition to the Builder UI, there is a comprehensive data dictionary for APEX-prefixed views to expose all the metadata associated with APEX applications and workspaces. SQL> select view_name 2 from dba_views 3 where owner = 'APEX_240200' 4 and view_name like 'APEX%' 5 order by 1;... | |
| | | |
dincosman.com
|
|
| | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter.... |