Performance Tuning by Identifying Poor SQLs using v$
To a user, an application is never fast enough to satisfy his/her needs. Similarly, to a database administrator, an application is never fast enough to satisfy the needs of the user community. Perception and unreasonable expectations are definitely a cause. However, , insufficient hardware, poorly tuned application code, a poorly tuned database, or an architecture that doesn’t […]
Continue reading
17
PeopleSoft 8.53: Creating PeopleSoft HCM9.2 Database
This post is in series of post for Installation of HCM9.2 on Windows 7. It’s one of the most important task in PeopleSoft Installation and require that you finish all the previous steps. PeopleSoft database creation is a long process and to make it easy to follow, below post has been divided into sections. Creation […]
Continue readingPeopleSoft Performance Tuning Using OEM
PeopleSoft Admins or PeopleSoft DBAs or Oracle DBAs know the importance of finding, analyzing, and correcting resource-intensive SQL statements. Those shops which run PeopleSoft on Oracle can make use of Oracle Enterprise Manager (OEM) in isolating and analyzing troublesome SQL statements. Using OEM, a DBA can quickly discover the SQL statements most responsible for performance degradation and then drill […]
Continue readingHow to Find Expected Time of Completion of an Oracle Query
Especially in case of poorly performing SQLs, all eyes are on the SQL and we’re eager to see when the SQL would complete. Upon completion, we can view the statistics and find ways to improve it. Wouldn’t it be better if there was a way to find the expected time of completion of an Oracle […]
Continue readingHow to Change SQL Plus Settings
I do not like the default size of the SQL *Plus window and prefer to customize it as per my preference. You can also do the same by changing the default parameters of SQL Plus. You can perform the following changing in SQL *Plus: Change cursor size Change command history Change fonts Change layout Change […]
Continue reading