Re: Performance issue with locking which appears to be fixed by increasing system tablespace.
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: ftilly@xxxxxxxxxxxxxx
- Date: Wed, 16 Mar 2011 10:59:14 +0530
just a random guess,
may be dba is right, the stats pack report date is '21-Feb-11 08:27', early
morning( hardly users login and hardly there are jobs running)..how many
sessions were active at that time..
if there werre no user sessions, jobs and backups then waits may be only
because of system tablespace
thanks..subodh
On 15 March 2011 16:40, Fred Tilly <ftilly@xxxxxxxxxxxxxx> wrote:
> Hi All,
>
> Was recently asked to look at a performance issue on a customer site.
>
> I was not granted access to the server so asked for a statspack report
> covering
> a 15 minute period during poor performance.
>
> I have shown below what I believe to be the relavent parts in the attached
> file:
>
> Looking at this statspack output I started looking at the code in the
> application to see why it
> would be holding locks for a long period of time.
>
> While investigating the issue it was apparently resolved by the onsite DBA
> by
> increasing the size
>
> of the system tablespace.
>
> Now what I would like to know is how increasing the size of the system
> tablespace would impact this type of
> locking issue ?
>
> Thanks
>
> Fred
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
