Performance is one aspect, which can never satisfy a person on. It is just not enough to keep improving the performance. Oracle understands this and regularly releases Benchmark papers on the same. Advantage of using these benchmarks is that the benchmarks show a level of acceptable performance and you can tune your application to meet […]
Continue readingOracle has hundreds of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems. However, because these are “undocumented” parameters, most Oracle professionals rely on publications such as “Oracle Internals” to get insights into the proper setting for the […]
Continue readingAfter finishing installation of PT8.53 application using Oracle Virtual Box, next thing you would definitely want to do is to configure Application Designer. PeopleSoft Image that you installed also comes with setup files to help you install App Designer very easily. Before you start with installation and configuration of PeopleSoft Application Designer, make sure that […]
Continue readingPeopleSoft Images are a great way to get started with PeopleSoft within couple of hours. PeopleSoft application installed in Oracle Virtual Box VM, may be accessed from the Windows Client machine where developers/DBA might want to use Oracle Client, App Designer, Data Mover for variety of purposes. For PeopleTools Clients like App Designer, Datamover to […]
Continue readingYou need to identify if Automatic SQL Tuning job is enabled and regularly running. Use the following query to determine if any Automatic SQL Tuning jobs are enabled: SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name; If the Automatic SQL Tuning job is enabled, you will see something like this: […]
Continue reading