Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
By default row estimates for pipelined table functions are poor
Dynamic stats for PL/SQL functions (23.8)
Improve row estimates for PL/SQL functions in SQL with dynamic stats
With dynamic PL/SQL stats in 23.8, get accurate row estimates for pipelined functions
Oracle Database Free 23.8 is now available
Get it at
www.oracle.com/database/fre...
This has a neat tweak if you're getting poor row estimates for PL/SQL in SQL:
Enhanced dynamic stats for PL/SQL in FROM & WHERE
This can be particularly useful for estimating pipelined table functions
13.05.2025 15:01 —
👍 25
🔁 12
💬 1
📌 0
Do you know that at the #POUG2025, you can win a lifetime free POUG ticket? This will be the award in our 10th anniversary celebration contest!
So, by buying a ticket now with a 20% discount, you might be purchasing a ticket for life to our conferences 😎
poug2025.konfeo.com
17.04.2025 08:59 —
👍 11
🔁 6
💬 0
📌 2
YouTube video by SQL and Database explained!
Partitioning on a budget
Fresh video! There are amazing features available with the partitioning license, but if you're on a tight budget you CAN get the basic features without it. This will work on Standard Edition as well, but maybe just move to Autonomous and stop worrying :-)
youtu.be/QxZEVLKckuA
03.04.2025 01:31 —
👍 6
🔁 3
💬 0
📌 0
I'm gonna pop....
01.04.2025 07:12 —
👍 12
🔁 2
💬 3
📌 2
Only one more day to submit for
POUG 2025
CfP ends TOMORROW!
Take this final chance to be part of this event and enter your abstract on https://sessionize.com/poug-2025/.
@POUG_ORG #POUG25
See all Events and CfPs on www.clocwise.org.
30.03.2025 12:02 —
👍 4
🔁 2
💬 0
📌 0
My name is Kim and I’m a #POUGoholic
26.02.2025 18:40 —
👍 3
🔁 1
💬 1
📌 1
Another day to mark in your calendars: #POUG2025 CfP opens on February 1st! Stay tuned. 🙌
15.01.2025 09:59 —
👍 20
🔁 7
💬 0
📌 2
so next step will be asm or inline operands ? :)
27.11.2024 08:10 —
👍 1
🔁 0
💬 0
📌 0
After 2 hours of investigations why my host can connect to 2 of 3 containers, I fully agree reboot is a quicker fix :)
27.11.2024 07:57 —
👍 2
🔁 0
💬 0
📌 0
@pdevisser.bsky.social Hey Piet, are you punlishing somewhere your python plus AI work ? I am really interested in using local model to catalog my photos
24.11.2024 08:55 —
👍 2
🔁 0
💬 1
📌 0
The @sym42.bsky.social delegation at #DOAG2024
So many friends and colleagues, loved to meet you all in my home area!
#Nuremberg #Germany
@fsimondba.bsky.social @oraesque.bsky.social @dohdatabase.com @mirelarooug.bsky.social @pioro.bsky.social @chandlerdba.bsky.social @gianniceresa.bsky.social ++
22.11.2024 08:36 —
👍 39
🔁 8
💬 1
📌 2
I will be there
17.11.2024 09:32 —
👍 3
🔁 0
💬 0
📌 0
List of Bluesky profiles of members of Symposium 42:
bsky.app/profile/did:...
@sym42.bsky.social sym42.org/members/
Can be pinned as feed if you're interested in posts by these people.
14.11.2024 10:55 —
👍 12
🔁 9
💬 0
📌 0