<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hardware Info on Application Server is<br>
<br>
processor : 0<br>
vendor_id : GenuineIntel<br>
cpu family : 6<br>
model : 15<br>
model name : Intel(R) Xeon(R) CPU 5120 @ 1.86GHz<br>
stepping : 6<br>
cpu MHz : 1866.868<br>
cache size : 64 KB<br>
physical id : 0<br>
siblings : 2<br>
fdiv_bug : no<br>
hlt_bug : no<br>
f00f_bug : no<br>
coma_bug : no<br>
fpu : yes<br>
fpu_exception : yes<br>
cpuid level : 10<br>
wp : yes<br>
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t<br>
m pbe nx lm pni monitor ds_cpl est tm2 xtpr<br>
bogomips : 3702.78<br>
<br>
<b>processor : 1<br>
vendor_id : GenuineIntel<br>
cpu family : 6<br>
model : 15<br>
model name : Intel(R) Xeon(R) CPU 5120 @ 1.86GHz<br>
stepping : 6<br>
cpu MHz : 1866.868<br>
cache size : 64 KB<br>
physical id : 0<br>
siblings : 2<br>
fdiv_bug : no<br>
hlt_bug : no<br>
f00f_bug : no<br>
coma_bug : no<br>
fpu : yes<br>
fpu_exception : yes<br>
cpuid level : 10<br>
wp : yes<br>
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t<br>
m pbe nx lm pni monitor ds_cpl est tm2 xtpr<br>
bogomips : 3727.36</b><span style="color: rgb(255, 153, 0);"></span><br>
<br>
<br>
On database server is <br>
<br>
<b>processor : 0<br>
vendor_id : GenuineIntel<br>
cpu family : 15<br>
model : 4<br>
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz<br>
stepping : 1<br>
cpu MHz : 3000.234<br>
cache size : 1024 KB<br>
physical id : 0<br>
siblings : 2<br>
runqueue : 0<br>
fdiv_bug : no<br>
hlt_bug : no<br>
f00f_bug : no<br>
coma_bug : no<br>
fpu : yes<br>
fpu_exception : yes<br>
cpuid level : 5<br>
wp : yes<br>
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t<br>
m<br>
bogomips : 5989.99<br>
<br>
processor : 1<br>
vendor_id : GenuineIntel<br>
cpu family : 15<br>
model : 4<br>
model name : Intel(R) Pentium(R) 4 CPU 3.00GHz<br>
stepping : 1<br>
cpu MHz : 3000.234<br>
cache size : 1024 KB<br>
physical id : 0<br>
siblings : 2<br>
runqueue : 0<br>
fdiv_bug : no<br>
hlt_bug : no<br>
f00f_bug : no<br>
coma_bug : no<br>
fpu : yes<br>
fpu_exception : yes<br>
cpuid level : 5<br>
wp : yes<br>
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge
mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht t<br>
m<br>
bogomips : 5989.99</b><br>
<br>
Joop wrote:
<blockquote cite="mid:4A4B0A20.8040701@mococo.nl" type="cite">Varun
Vyas wrote:
<br>
<blockquote type="cite">Hello All
<br>
<br>
In my RT application my creating, updating and closing of tickets are
very slow and takes almost 20 sec to insert a ticket and nearly 35
seconds to update a ticket. We have applied many changes on our
database side and application side too. But still our RT application is
not stabilized. We have oracle 9i as our database with indexing enabled
and we also have implemented COMPUTE stats gathering and apart from
that we have also tried to trace SQL for finding the cause that which
queries are taking long time. But still we are not able to find the
cause of sluggishness. And i need to know if anyone has faced such kind
of performance problem before and if yes then where should i look for
improving my performance. And make RT more responsive.
<br>
</blockquote>
We skipped Oracle9i as a production platform and went from 8i to 10g.
We had a few customers who ran 9i but can't say if they had performance
problems which were related to 9i specifically. As already suggested
you can turn on sqltracing in the DBD and/or DBI layer. Check the
documentation of DBI and DBD(::Oracle). Further you could use the info
inside the SGA to findout which queries are running real slow by either
using Statspack of EnterpriseManager.
<br>
<br>
As a last resort you could install an instance of OracleXE, which in
essence is Oracle10g, and see what kind of performance you get with
that. Keep in mind though that XE has a few limitations on database
size.
<br>
<br>
What I and probably the rest of the list would like to know is what is
your hardware config and what is your software config, OS/perl versions
etc.
<br>
It could be that someone knows that your config combinations is
problematic, now we're all shooting in the dark hoping to hit the magic
button.
<br>
<br>
<br>
Regards,
<br>
<br>
Joop
<br>
<br>
<br>
<br>
<br>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
Thanks & Regards
Varun Vyas
Software Engineer - Automation
Elitecore Technologies
</pre>
</body>
</html>