Off to UKOUG 2025 in Birmingham tomorrow #ukoug
29.11.2025 11:31
👍 2
🔁 0
💬 0
📌 0
Network latency can make chattiness a problem. More generally I think that not using PL/SQL leads to chattiness and literals. Then parse can become a problem and an expense.
03.04.2025 20:50
👍 0
🔁 0
💬 0
📌 0
In PeopleSoft that would be close to 100%! I can't think of a practical use of such a ratio. Chatty apps usually aren't instrumented so can't identify chattiest parts.
03.04.2025 20:48
👍 0
🔁 0
💬 1
📌 0
Perhaps parse is the critical metric?
28.03.2025 20:54
👍 0
🔁 0
💬 1
📌 0
I was always impressed how well PeopleSoft could perform, given how badly it behaves. No PL/SQL, just a stream of SQL. Often dynamically generated with literals. HR with Time&Labor and Payroll on a pay week was always fun.
28.03.2025 20:50
👍 0
🔁 0
💬 0
📌 0
Today's gotcha: NB: PLAN_HASH_VALUE on DBA_SQL_QUARANTINE is the adaptive plan hash value (with all of its possible plan alternatives), and therefore it matches SQL_FULL_PLAN_HASH_VALUE in the ASH data, and not SQL_PLAN_HASH_VALUE (the plan that actually executed)! 🤦♂️
24.02.2025 16:00
👍 2
🔁 0
💬 0
📌 0
I have a memory that the RAC and AA keys would both open boxes for both organisations.
01.02.2025 21:59
👍 1
🔁 0
💬 0
📌 0
We had a Commodore PET at school in about 1981. Those were the days.
19.12.2024 16:54
👍 3
🔁 0
💬 1
📌 0
