/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 afatkulin.blogspot.com
Alex Fatkulin's Blog: Update and rownum oddity
| | iusoltsev.wordpress.com
FIRST_ROWS CURSOR_SHARING_EXACT | Oracle mechanics
1.5 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...
| | oracletoday.blogspot.com
Oracle Today: Performance of Autotrace
1.6 parsecs away

Travel
| | I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...
| | rwijk.blogspot.com
About Oracle: Filter predicates with NVL on mandatory columns using the index
1.1 parsecs away

Travel
| |
| | chandlerdba.com
SQL Patch, and a Parallel mistake - Neil Chandler's DB Blog
12.6 parsecs away

Travel
| Photo by Brian Patrick Tagalog on Unsplash July 2024. Oracle 19c, 23ai There are 3 main types of SQL Plan Management: SQL Profile SQL Plan Baseline SQL Patch So first some quick background info about the 3 options and then I'll tell you about my mistake. SQL Profile A SQL Profile is a collections of...