performance seeker;
Oracle ACE Alumnus;
proud member of @SYM_42;
Views are my own;
the time you gain by faster typing you loose by searching for typos.
(no, they do not need to care about _JAVA_OPtIONS )
the time you gain by faster typing you loose by searching for typos.
(no, they do not need to care about _JAVA_OPtIONS )
what happened between these 2 screenshots?
workload is exactly the same,
eCPUs are constant,
instances are constant,
no change in data, tables, indexes, ...
hint: 23ai
what happened between these 2 screenshots?
workload is exactly the same,
eCPUs are constant,
instances are constant,
no change in data, tables, indexes, ...
hint: 23ai
Thank you @luizafrompoland.bsky.social , @ora600pl.bsky.social , all the sponsors, speakers, attendees and people in the background.
Hope to see you all at #POUG2026 !
Thank you @luizafrompoland.bsky.social , @ora600pl.bsky.social , all the sponsors, speakers, attendees and people in the background.
Hope to see you all at #POUG2026 !
@christophlutz.bsky.social will for sure follow this tradition this year #POUG2025 😁
@christophlutz.bsky.social will for sure follow this tradition this year #POUG2025 😁
@dohdatabase.com tells us what (..) is going on under the hood - or what can be achieved manually.
@dohdatabase.com tells us what (..) is going on under the hood - or what can be achieved manually.
Introduced by @ludovico.bsky.social at #POUG2025
Introduced by @ludovico.bsky.social at #POUG2025
@julianfrey.ch keeps us awake with a great presentation about EM24 (ai)
@julianfrey.ch keeps us awake with a great presentation about EM24 (ai)
🎉
Happy birthday !
@luizafrompoland.bsky.social & @ora600pl.bsky.social
🎉
Happy birthday !
@luizafrompoland.bsky.social & @ora600pl.bsky.social
(Inside no photography is allowed. Just look & remember)
(Inside no photography is allowed. Just look & remember)
alter session set events 'trace[ SQL_Code_Generator.*] ';
there isn't a lot available on the open internet.
Together with SQL_Optimizer (and others) ot belongs to SQL_Compiler.
alter session set events 'trace[ SQL_Code_Generator.*] ';
there isn't a lot available on the open internet.
Together with SQL_Optimizer (and others) ot belongs to SQL_Compiler.
This piece might be "good enough" for many cases.
www.nyoug.org/Presentation...
This piece might be "good enough" for many cases.
www.nyoug.org/Presentation...
SELECT level, sysdate, my_sysdate
FROM dual
connect by level < 10;
L SYSDATE MY_SYSDATE
- ------------------- ----------
1 2025-06-05 06:58:10 2025-06-05 06:58:11
2 2025-06-05 06:58:10 2025-06-05 06:58:12
3 2025-06-05 06:58:10 2025-06-05 06:58:13
...
SELECT level, sysdate, my_sysdate
FROM dual
connect by level < 10;
L SYSDATE MY_SYSDATE
- ------------------- ----------
1 2025-06-05 06:58:10 2025-06-05 06:58:11
2 2025-06-05 06:58:10 2025-06-05 06:58:12
3 2025-06-05 06:58:10 2025-06-05 06:58:13
...
can you spot it?
can you spot it?