Explore >> Select a destination

You are here

 savvinov.com
Troubleshooting stuck queries - Oracle Diagnostician
| | nenadnoveljic.com
Performance Problem with Incremental Statistics Calculation - All-round Database Topics
2.2 parsecs away

Travel
| | A frequently executed SQL causes problems with the initial incremental statistics calculation.
| | iusoltsev.wordpress.com
??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT | Oracle mechanics
2.2 parsecs away

Travel
| | ??????? ?????? ?? ??????? ??????????? 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...
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
2.3 parsecs away

Travel
| |
| | www.bobbydurrettdba.com
Cardinality errors across joins | Bobby Durrett's DBA Blog
15.3 parsecs away

Travel
| We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...