OraFAQ Forum: Performance Tuning » Need help in performance tunning for querying table

Home » RDBMS Server » Performance Tuning » Need help in performance tunning for querying table (oracle 10g)

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

Need help in performance tunning for querying table [message #584836]

Sun, 19 May 2013 07:01

supiash
Messages: 70
Registered: May 2012
Location: bangalore

Member

Hi,

I have an application which access couple of table and do select,update,delete,insert very often and parallely.

As the size of this table grows(no of rows), How can I maintain the response time of each of the above transactions so that my performance is not degraded.

I thought of using the indexing on the column, or there any other best methods please?

Could you help?

Report message to a moderator

Re: Need help in performance tunning for querying table [message #584837 is a reply to message #584836]

Sun, 19 May 2013 07:20

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ Do not it in PL/SQL or any loop
2/ Properly index

Regards
Michel

[Edit: fix typo]

[Updated on: Sun, 19 May 2013 08:35]

Report message to a moderator

Re: Need help in performance tunning for querying table [message #584838 is a reply to message #584837]

Sun, 19 May 2013 07:32

supiash
Messages: 70
Registered: May 2012
Location: bangalore

Member

Michel,

Thanks, sorry I dint get your 1 point could you please elaborate.

Also, Could you please let me know does the time for output of the query on the table depends on the no of users logged in Database/Schema and parallel accessing?

Report message to a moderator

Re: Need help in performance tunning for querying table [message #584840 is a reply to message #584838]

Sun, 19 May 2013 08:36

supiash
Messages: 70
Registered: May 2012
Location: bangalore

Member

To add My insert statement and delete statement is always constant,its update keep changing
To check for the presence of a row is select is select is the best method(ex; Select count(*) from emp where empname='SUPI' ... where clause could be on single or multiple column but on same table)

Report message to a moderator

Re: Need help in performance tunning for querying table [message #584841 is a reply to message #584838]

Sun, 19 May 2013 08:39

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, there was a typo (fixed), point 1 is "Do not it in PL/SQL or any loop".

The time of the output depends on 2 things: 1/ the array size the client uses, 2/ the load of each component between client and database server, including the network.

Regards
Michel

Report message to a moderator

Previous Topic:	enable row movement - ok, but why internally this thing is needed
Next Topic:	Best disk config for SME scale datawarehouse

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 03:02:53 CDT 2025