The PeopleSoft DBA Blog

This blog contains things about PeopleSoft, mostly performance related, that DBAs might find interesting.
Or then again they might not! The non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk.

Announcements

▼

Friday, July 25, 2025

Determining Optimal Index Key Compression Length

›

In 2008, Richard Foote wrote this still excellent 4-part guide to index key compression. Index Compression Part I (Low) Index Comp...

Monday, June 30, 2025

Optimising Journal Line Queries: 5. Conclusion

›

This is the last of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). Problem St...

Friday, June 27, 2025

Optimising Journal Line Queries: 4. Compression

›

This is the fourth of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). Problem Sta...

Thursday, June 26, 2025

Optimising Journal Line Queries: 3. Partitioning

›

This is the third of a series of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN). ...

Tuesday, June 24, 2025

Optimising Journal Line Queries: 2. Exadata System Statistics

›

This is the second of a series of five articles that examine the challenges posed by typical queries on the journal line table (PS_JRNL_LN)....

›

Home

View web version

Powered by Blogger.