----- Original Message -----
Newsgroups:
public.remedy.arsystem.general
Sent: Thursday, November 09, 2006 8:28
AM
Subject: Re: Performance OracleDB
**
Alex:
Get with your DBA and have them run statistics on the
database. I HIGHLY recommend using DBA Studio to tune the database for
memory sizing. I also recommend examining what your users are doing with
form queries and adding appropriate indices. Tuning the database is more
an art then a science, but if done properly your users will thank you for
years (I still am and I have been gone from that position for over three
years.)
First recommendation: Give your database enough
space to 'live' in. This means tuning the SGA and PGA to be large enough
to reside in physical memory but not so small that there is a lot of data
swapping (physica memory is faster than reading from the hard drive and much
faster than virtual memory.)
Two: Give the ARS process sufficent threads
that user processes are not waiting on one. Using SQL logging will
determine if a user process is blocked from database access because there are
no threads.
Three: Using the log file from two above, you can
look for queries that are taking a long time to process. Using the
EXAMINE PLAN feature of Oracle, you can see if the query is using indices and
if not can the query be redone to use them.
Good luck with your 'tune-up' of both Remedy and
Oracle.
James McKenzie
L-3 GSI
**
Hi List
I am having problems with my performance DB.
Does somebody have any advice or experience to
improve the performance DB when Remedy execute queries ???
My environemnt is:
Oracle 9i R2 on Red Hat Linux Enterp.
3.
Remedy ARS 6.3
Does somebody know some parameters or something
to I have to check ??
Thanks in advance !!
Alex
__20060125_______________________This posting was
submitted with HTML in it___ __20060125_______________________This posting was
submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
