Marcin Przepiorowski's Avatar

Marcin Przepiorowski

@pioro.bsky.social

382 Followers  |  209 Following  |  4 Posts  |  Joined: 16.08.2023
Posts Following

Posts by Marcin Przepiorowski (@pioro.bsky.social)

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