| **
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
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Alex Salgado Sent: Wednesday, November 08, 2006 10:12 PM To: [email protected] Subject: Performance OracleDB 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
|
- Re: Performance OracleDB McKenzie, James J C-E LCMC HQISEC/L3
- Re: Performance OracleDB Alex Salgado
- Re: Performance OracleDB Luke, Brian
