Home » RDBMS Server » Performance Tuning » Tuning for Queuing (merged)
Tuning for Queuing (merged) [message #328725] Sun, 22 June 2008 07:41 Go to next message
kumar1234
Messages: 13
Registered: June 2008
Junior Member
Hi Friends,

I am developer in Oracle 9i and my project is basically advance dequeing of XML .
Currently I am facing problem of performance from my live (client's) box.
I work on Oracle 9i from HP 1800 unix server.
My issue is this that at my end the dequeing and response is done in 6 hrs for 60,000 XML's but at client side the same takes 11 hrs.
The issue is this i need to highlight to the DBA this issue.
I need to ask him to compare the parameters at my side and client's side.
Can anyone help and tell the parameters which I can compare to check performance.

I shall be very thankful to you..

cheers
Kumar

[Updated on: Sun, 22 June 2008 07:43]

Report message to a moderator

Re: Tuning for Queuing [message #328728 is a reply to message #328725] Sun, 22 June 2008 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

You can also have a look at Database Performance Tuning Guide.

Regards
Michel
Re: Tuning for Queuing [message #328811 is a reply to message #328728] Sun, 22 June 2008 23:17 Go to previous messageGo to next message
kumar1234
Messages: 13
Registered: June 2008
Junior Member
Hi Michel,

Thanks a lot for your guidance.I am going through the documents which u had suggested.
But I need to ask the DBA for some essential parameters urgent.

Can anyone working in the same or having knowledge ,tell me about he essential parameters which I should compare at my place and the others..

kindly respond

cheers Razz
Re: Tuning for Queuing [message #329016 is a reply to message #328725] Mon, 23 June 2008 13:48 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
maybe you client box is only half as fast as your box?

Kevin
Re: Tuning for Queuing [message #329044 is a reply to message #329016] Mon, 23 June 2008 22:21 Go to previous messageGo to next message
kumar1234
Messages: 13
Registered: June 2008
Junior Member
But how can I check that how fast is my box and client's

please elaborate

thanks a ton...
Peformance Issue [message #329093 is a reply to message #328725] Tue, 24 June 2008 01:22 Go to previous messageGo to next message
kumar1234
Messages: 13
Registered: June 2008
Junior Member
Hi.

I use AQ for XMLs' and face low performance .
Can anyone tell/share something to improve the performance ..

thanks a lot..
Re: Peformance Issue [message #329094 is a reply to message #329093] Tue, 24 June 2008 01:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think posting the same question with less information will give you more answers than in the other topic.

Don't crosspost/multipost your questions.

Regards
Michel
Re: Tuning for Queuing [message #329096 is a reply to message #329044] Tue, 24 June 2008 01:33 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
kumar1234 wrote on Tue, 24 June 2008 05:21
But how can I check that how fast is my box and client's

please elaborate

thanks a ton...

Search on the Web for peformances measuring tool, there are tons of them.

Regards
Michel

Previous Topic: Please help to Tuning
Next Topic: max number of users and sessions
Goto Forum:
  


Current Time: Sat Dec 03 13:55:24 CST 2016

Total time taken to generate the page: 0.09778 seconds