OraFAQ Forum: Performance Tuning » Tuning for Queuing (merged)

Home » RDBMS Server » Performance Tuning » Tuning for Queuing (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tuning for Queuing (merged) [message #328725]

Sun, 22 June 2008 07:41

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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Tuning for Queuing [message #328811 is a reply to message #328728]

Sun, 22 June 2008 23:17

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

Report message to a moderator

Re: Tuning for Queuing [message #329016 is a reply to message #328725]

Mon, 23 June 2008 13:48

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

maybe you client box is only half as fast as your box?

Kevin

Report message to a moderator

Re: Tuning for Queuing [message #329044 is a reply to message #329016]

Mon, 23 June 2008 22:21

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...

Report message to a moderator

Peformance Issue [message #329093 is a reply to message #328725]

Tue, 24 June 2008 01:22

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..

Report message to a moderator

Re: Peformance Issue [message #329094 is a reply to message #329093]

Tue, 24 June 2008 01:30

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: Tuning for Queuing [message #329096 is a reply to message #329044]

Tue, 24 June 2008 01:33

Michel Cadot
Messages: 68665
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 12:36:38 CDT 2024