/explore
|
You are here 
|
jonathanlewis.wordpress.com | ||
| | | | |
tonyhasler.wordpress.com
Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility... |
|
| | | | | ||
| | | | |
oracle-base.com
ORACLE-BASE - Articles about Oracle database 8i new features. |
|
| | | | | ||
| | | | |
iusoltsev.wordpress.com
465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT... |
|
| | | | | ||
| | | | |
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.... |
|
| | | |||
