Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

– Good and not so good ideas on software development and Oracle databases in particular

Tag: Optimization

Reviewing statements with hints, using PL/Scope

December 10, 2018December 7, 2018 NiceTheoryVidarLeave a comment

In my previous post, I showed how you can add a fake hint to tag the origin of a duplicated statement and as a side-effect make it unique. What if you regret and can’t remember where it was. Or you want to review old hinted statements after an upgrade to a newer version of the database/optimizer.

Read More »

Differentiating between duplicated statements

December 7, 2018 NiceTheoryVidarLeave a comment

Finding duplicate SQL statements using PL/Scope is easy. If you cannot merge them, how can you differentiate between which source is being run?

Read More »

Find bad performing queries or code with PL/Scope

November 30, 2018December 4, 2018 NiceTheoryVidar5 Comments

On our production system we’ve enabled the collection of PL/Scope metadata. Since this is a SmartDB/PinkDB-application (business logic and queries in the database), this makes it really easy to find, inspect and modify the source code of queries that doesn’t run efficiently. Now it’s even easier using reports in Oracle SQL Developer.

Read More »

Function result cache and application context – don’t get burned

February 1, 2018February 1, 2018 NiceTheoryVidarLeave a comment

Oracles function result cache (FRC) can in certain cases give a considerable performance boost. Application context is another useful feature. How does FRC work when the function result relies on context-settings? And how can we make them play well together?

Read More »

Compression of Oracle database network traffic

January 11, 2018January 11, 2018 NiceTheoryVidarLeave a comment

I read this blog-post by Connor McDonald the other day about the Advanced Network Compression and network transfer savings. It reminded me of a feature not many know of and comes without an extra cost option. In fact, it’s on by default.

Read More »

Categories

  • Oracle (29)
  • PL/SQL (11)
  • Optimization (9)
  • Coding practice (7)
  • PL/Scope (7)

Tags

  • Oracle (16)
  • PL/SQL (11)
  • SmartDB (9)
  • 12c (6)
  • PL/Scope (6)

Year

  • 2022 (2)
  • 2021 (1)
  • 2020 (1)
  • 2019 (3)
  • 2018 (13)
Blog at WordPress.com.
Back to top
  • Follow Following
    • - nice theory...
    • Already have a WordPress.com account? Log in now.
    • - nice theory...
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar