Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Statspack Report

Re: Statspack Report

From: srivenu <srivenu_at_hotmail.com>
Date: 8 Jan 2003 02:29:00 -0800
Message-ID: <1a68177.0301080229.b3b8a11@posting.google.com> 





You have to monitor the instance for certain time and also collect
locking info using locking scripts.


Most of the times, the locking problem is due to not indexing your
foreign key columns.


regards


Srivenu
Received on Wed Jan 08 2003 - 04:29:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US