Marcin Przepiorowski's Avatar

Marcin Przepiorowski

@pioro.bsky.social

378 Followers  |  209 Following  |  4 Posts  |  Joined: 16.08.2023  |  1.7915

Latest posts by pioro.bsky.social on Bluesky

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 โ€” ๐Ÿ‘ 40    ๐Ÿ” 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

@pioro is following 20 prominent accounts