Tag Archive

Tag Archives for " Oracle "

PeopleSoft 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 reading

How 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