Re: Performance problem

From: Sanjay D.S. <sanjay_at_fsg.prusec.com>
Date: 1996/03/29
Message-ID: <4jfa7d$bnn_at_prufire4.prusec.com>#1/1

-- 
mda_at_kuwait.net (Information Systems Departement) wrote:

>

>Our system performs unsatisfactorily especially during peak hours. We observed 

>the trace file signals an error ORA-01575 time out waiting for space 

>management resource.

>

This is probably because more than one users are continuously requresting for
newer extent of blocks. 
1. Resize your database objects with proper storage requirement clause.
   (Less the number of extents, better the performance)
2. Add additional temporary tablespaces and assign them to different group of
users.
   (Reduce the contention on temporary tablespace segments)

Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc.

Received on Fri Mar 29 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Bole-Feysot E. France: "How to write a script to shutdown Oracle 7 NT?"
Previous message: Lam, Siu Chun: "Using 32bit ODBC for Oracle in Win95"
In reply to: Information Systems Departement: "Performance problem"
Next in thread: Austin Moseley: "Re: help need in Pro *c"
Reply: Randy Dewoolfson: "Re: Performance problem"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message