Skip to content
  • Oracle
  • About
  • Oracle
Search
Close

– nice theory…

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

Function result cache, yes or no?

May 31, 2023 NiceTheoryVidarLeave a comment

Oracles function result cache (FRC) works, in simplified terms, by caching the result of a PL/SQL function. This can greatly improve performance, but it can also lead to performance problems.

Read More »

Forall is still row-by-row

May 28, 2023 NiceTheoryVidarLeave a comment

I came over some code that used the forall construct to update rows in a large table. Quite a few rows were updated and the batch took some time to complete. Usually, using forall is a good idea, but sometimes other constructs can perform better.

Read More »

Which tables could need updated statistics?

May 22, 2023May 26, 2023 NiceTheoryVidarLeave a comment

Does your tables need updated statistics for the optimizer? Here’s a couple of views that could be useful in the gathering of information.

Read More »

Statistics gathering parameters for partitioned tables

May 20, 2023May 22, 2023 NiceTheoryVidarLeave a comment

When partitioned tables get a bit large, these parameters may be suitable to set.

Read More »

DataGrip cutting DDL short, case 2

May 19, 2023May 22, 2023 NiceTheoryVidarLeave a comment

My preferred tool for writing PL/SQL code has been DataGrip from JetBrains for the last few years. Working on a case with reference partitioned tables, I came over some strange errors. At first I thought Oracle had a lot of bugs in the partitioning syntax, but it turned out to be DataGrip messing with my DDL!

Read More »

DataGrip cutting DDL short, case 1

December 21, 2022December 21, 2022 NiceTheoryVidar1 Comment

My preferred tool for writing PL/SQL code has been DataGrip from JetBrains for the last few years. Working on a case with reference partitioned tables, I came over some strange errors. At first I thought Oracle had a lot of bugs in the partitioning syntax, but it turned out to be DataGrip messing with my DDL!

Read More »

Proxy user logon #JoelKallmanDay

October 11, 2022 NiceTheoryVidarLeave a comment

Are you using proxy logon when connecting to your Oracle database? Why not?

Read More »

Generating data: union all vs insert all

February 11, 2021December 21, 2022 NiceTheoryVidarLeave a comment

To test out different physical table lay-outs, I had to repeatedly generate some test-data. After a few runs, I wanted to speed it up a bit. This is how I did it.

Snail with rocket
Read More »

A small unexpected to_date oddity

September 28, 2020December 8, 2020 NiceTheoryVidarLeave a comment

I was about to do some date/time calculations as I got an unexpected result with the to_date-function.

Read More »

Yet another reason to unit test your (PL/SQL) code

April 15, 2019April 14, 2019 NiceTheoryVidarLeave a comment

The last few months, I’ve had the pleasure of using utPLSQL v3, a unit testing framework for PL/SQL, on a new project that I’m working on. Sure – writing tests takes a bit extra time, but it’s such a huge help when you’re constantly refactoring a system that grows from zero.

Read More »

Posts navigation

Older Posts

Categories

  • Oracle (34)
  • Optimization (13)
  • PL/SQL (13)
  • Coding practice (9)
  • Built-in functionality (7)

Tags

  • Oracle (21)
  • PL/SQL (11)
  • SmartDB (9)
  • Optimization (8)
  • 12c (6)

Year

  • 2023 (5)
  • 2022 (2)
  • 2021 (1)
  • 2020 (1)
  • 2019 (3)
Blog at WordPress.com.
Back to top
– nice theory…
Blog at WordPress.com.
  • 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
 

Loading Comments...