Marcin Przepiorowski's Avatar

Marcin Przepiorowski

@pioro

382
Followers
209
Following
4
Posts
16.08.2023
Joined
Posts Following

Latest posts by Marcin Przepiorowski @pioro

Preview
ORA-43907: Potential behavior change with Oracle RU 19.28.0 As I said multiple times, we have the best and most knowledgeable customers out there. Julian Frey is one of them, and there is a good and legit reason why he is an ACE Director since (I think) two years. Julian alerted me the other day about an ORA-43907: Potential behavior change with Oracle RU 19.28.0. And I guess, some of you would like to learn about this, too.

ORA-43907: Potential behavior change with Oracle RU 19.28.0

As I said multiple times, we have the best and most knowledgeable customers out there. Julian Frey is one of them, and there is a good and legit reason why he is an ACE Director since (I think) two years. Julian alerted me the other day…

22.09.2025 09:00 👍 7 🔁 4 💬 0 📌 0
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 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

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
Post image

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
Partitioning on a budget
Partitioning on a budget YouTube video by SQL and Database explained!

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
Video thumbnail

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
Post image

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
Post image

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
&udm=14 | the disenshittification Konami code A quick way to get an AI-free search without any extra work.

How am I just now finding out about
udm14.com

Cheers @oraclebase.bsky.social !!

01.11.2024 18:24 👍 6 🔁 3 💬 1 📌 0