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 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: 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...
ukoug.org
UKOUG Conferences - UK Oracle User Group
http://www.ukoug.org/conferences2015
This site makes use of cookies. If you continue we'll assume you are happy to receive them. Read our cookie policy. Join the UKOUG Community. Join the largest gathering of Oracle Users in the UK! Join in conversation on Twitter via #ukoug apps16. Join in the conversation on Twitter via #ukoug jde16. Join in the conversation on Twitter via #ukoug tech16. View the photos from the 2015 conferences. Find out about how you can get involved with 2016 opportunities. Thank you to our sponsors.
polarisassociates.com
Oracle E-Business Suite ERP System - Polaris Associates
http://polarisassociates.com/company/news-events
News & Events. News & Events. News & Events. News & Events. UKOUG Financials Special Interest Group. 8211; September 7, 2016. Location: The Studio – Birmingham, United Kingdom. Polaris Associates is a proud sponsor of the upcoming UKOUG Oracle Financials Special Interest Group meeting in Birmingham. View the Agenda. Oracle OpenWorld Conference 2016. 8211; September 18 22, 2016. Location: Moscone Center – San Francisco, California. NWOUG Annual Fall Conference. 8211; October 10, 2016. Sangam 16 –. Join Po...
orbitanalytics.com
ORBIT Analytics Upcoming Events
http://orbitanalytics.com/company/news-events
News & Events. ORBIT Analytics Free Trial. News & Events. ORBIT Analytics Free Trial. News & Events. News & Events. 8211; September 8 9, 2016. Location: Seaport World Trade Center – Boston, Massachusetts. ORBIT Analytics will be exhibiting at Data Viz 2016, a two-day event focused exclusively around data design and analysis. Visit our exhibit space for a live demonstration of the power of self service analytics. Oracle OpenWorld Conference 2016. 8211; September 18 22, 2016. 8211; October 4-6, 2016. UKOUG...
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...