David Kurtz /*+Go-Faster*/ Consultancy
banner
go-faster.co.uk
David Kurtz /*+Go-Faster*/ Consultancy
@go-faster.co.uk
Oracle Database Performance Specialist. People Performance Specialist. Independent Consultant. Oracle ACE Director. OakTable. Sym42. Cyclist. Cat herder.
https://www.go-faster.co.uk
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.
April 3, 2025 at 8:50 PM
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.
April 3, 2025 at 8:48 PM
Perhaps parse is the critical metric?
March 28, 2025 at 8:54 PM
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.
March 28, 2025 at 8:50 PM
I have a memory that the RAC and AA keys would both open boxes for both organisations.
February 1, 2025 at 9:59 PM
We had a Commodore PET at school in about 1981. Those were the days.
December 19, 2024 at 4:54 PM