blog.psftdba.com
The PeopleSoft DBA Blog: November 2012
http://blog.psftdba.com/2012_11_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Friday, November 23, 2012. PeopleTools 8.52 Application Engine sets MODULE and ACTION. Update 4.3.2015. See also Undocumented Application Engine Parameter: EnableAEMonitoring. I have written and spoken often about the huge importance of instrumentation. These values appear in Oracle Enterprise Manager. For the process, ...
blog.psftdba.com
The PeopleSoft DBA Blog: PeopleTools 8.54: Performance Performance Monitor Enhancements
http://blog.psftdba.com/2015/03/peopletools-854-performance-performance.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Tuesday, March 10, 2015. PeopleTools 8.54: Performance Performance Monitor Enhancements. This is part of a series of articles. About new features and differences in PeopleTools 8.54. That will be of interest to the Oracle DBA. Transaction History Search Component. There are a number of changes:. ROUND( CAST( CAST(SYSTIM...
blog.psftdba.com
The PeopleSoft DBA Blog: July 2012
http://blog.psftdba.com/2012_07_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Thursday, July 19, 2012. Gathering Aggregated Cost-Based Optimiser Statistics on Partitioned Objects. Recently, I have been looking into how to gather cost-based optimizer statistics on composite partitioned objects. I have now published the second of two documents on my website. That examine aspects of statistics on pa...
blog.psftdba.com
The PeopleSoft DBA Blog: November 2014
http://blog.psftdba.com/2014_11_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Monday, November 03, 2014. Filtering PeopleTools SQL from Performance Monitor Traces. In verbose mode, the PPM traces collect a lot of additional transactions capturing executions and fetches against PeopleTools tables. The PPM analytic components cannot always manage the resultant volume of transactions. Another conseq...
blog.psftdba.com
The PeopleSoft DBA Blog: July 2014
http://blog.psftdba.com/2014_07_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Wednesday, July 09, 2014. Introducing the Analytic Keep Clause for Effective-Dated/Sequence Queries in PeopleSoft. Therefore, I am interested in the rows marked below with the asterisks. KF0018 0 22-JAN-96 0 PAY 13000 FRF 318,575 KF0018 0 01-JAN-98 0 PAY 13000 FRF 346,156 KF0018 0 01-JAN-00 0 DTA 13000 FRF 346,156 KF001...
blog.psftdba.com
The PeopleSoft DBA Blog: August 2014
http://blog.psftdba.com/2014_08_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Monday, August 25, 2014. To Hint or not to hint (Application Engine), that is the question. It is possible to produce a SQL profile from a plan captured by AWR. A part of distribution for the SQLT Diagnostic Tool (Doc ID 215187.1). Is a script called coe xfr sql profile.sql. Written by Carlos Sierra. Of course, the stat...
blog.psftdba.com
The PeopleSoft DBA Blog: September 2012
http://blog.psftdba.com/2012_09_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Sunday, September 30, 2012. Maintaining Optimizer Statistics on PeopleSoft on Oracle 11g. In 2009, I wrote a series of blog postings on the subject of collecting statistics. I also recommended that statistics on tables created for use as temporary records in Application Engine programs should have their statistics delet...
blog.psftdba.com
The PeopleSoft DBA Blog: October 2014
http://blog.psftdba.com/2014_10_01_archive.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Friday, October 24, 2014. Minimising Parse Time in Application Engine with ReUseStatement. I originally wrote about the Performance Benefits of ReUseStatement in Application Engine. Application Engine Batch Timings. If an Application Engine step is not reused, then it is compiled prior to every execution during which th...
blog.psftdba.com
The PeopleSoft DBA Blog: PeopleTools 8.54: %SelectDummyTable Meta-SQL
http://blog.psftdba.com/2015/02/peopletools-854-selectdummytable-meta.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Sunday, February 22, 2015. PeopleTools 8.54: %SelectDummyTable Meta-SQL. This is part of a series of articles. About new features and differences in PeopleTools 8.54. That will be of interest to the Oracle DBA. PeopleTools simply evaluates this meta-SQL as 'DUAL' on Oracle. Select(IF FLAG) SELECT 'X' FROM PS INSTALLATION.
blog.psftdba.com
The PeopleSoft DBA Blog: Undocumented Application Engine Parameter: EnableAEMonitoring
http://blog.psftdba.com/2015/03/undocumented-application-engine.html
The PeopleSoft DBA Blog. This blog contains things about PeopleSoft that DBAs might find interesting. Or then again they might not! Non-PeopleSoft Oracle stuff is at blog.go-faster.co.uk. Wednesday, March 04, 2015. Undocumented Application Engine Parameter: EnableAEMonitoring. This is part of a series of articles. About new features and differences in PeopleTools 8.54. That will be of interest to the Oracle DBA. Each time it goes round the loop. Updated 8 May 2015:. This new parameter is not described in...