OraFAQ Forum: Performance Tuning » Performance Tuning in SQL queries and PL/SQL

Home » RDBMS Server » Performance Tuning » Performance Tuning in SQL queries and PL/SQL

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

Performance Tuning in SQL queries and PL/SQL [message #268821]

Wed, 19 September 2007 19:05

swapnajojo
Messages: 40
Registered: June 2007
Location: India

Member

Hi Team ,

I have attended many Oracle PL/SQL interviews but i am not able to give a correct answer for the question

" How you do preformance tuning in your work "

It would be highly appreciated if you could help me with this
question

Thanks In Advance
Binuja

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #268832 is a reply to message #268821]

Wed, 19 September 2007 21:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Which would you prefer that I read to you
http://www.orafaq.com/forum/t/84315/74940/
or
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #269161 is a reply to message #268821]

Thu, 20 September 2007 22:15

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello swapnajojo,

The topic is:

Quote:

Performance Tuning in SQL queries and PL/SQL

and you talk about "Oracle PL/SQL interviews".

Well... these 2 items...

SQL queries;
PL/SQL;

...are distinct.

One should take attention about "context switch" in PL/SQL.

Regards,

mson77

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #270305 is a reply to message #269161]

Wed, 26 September 2007 08:16

psiva_oracle
Messages: 25
Registered: August 2007
Location: india

Junior Member

Hi,

About performance tuning there are any item we have to do the below things in SQL and PL/SQL part query.

join
index
Group functions in SQL query
Explain plan
Table scaning
optimisation

etc,

Regards,
Siva.P
Bangalore

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #270323 is a reply to message #270305]

Wed, 26 September 2007 09:33

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello psiva_oracle,

I will try to help you in my best way. Please it does not intend to sound negative.

1) Please... follow anacedent advice. She is not kidding!
2) Can you read and understand one chapter per month? (per each 30 days) Then... if the "Performance Tuning Guide" has 12 chapter... in one year would will know all the issues... from official free oracle documentation.
One year is fast. "Yesterday" I was 18...

This is my thought and I use this in my life.
Regards,

mson77

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #270353 is a reply to message #270323]

Wed, 26 September 2007 10:52

psiva_oracle
Messages: 25
Registered: August 2007
Location: india

Junior Member

Hi,mson77,

Thanks for your advice,
So can you share the "Performance Tuning" Link with me?

Then i can go through the documents for performance tuning.

Regards,
Siva.P
Bangalore

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #270355 is a reply to message #270353]

Wed, 26 September 2007 11:03

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello psiva_oracle,

As your request... follows:

anacedent wrote

Which would you prefer that I read to you
http://www.orafaq.com/forum/t/84315/74940/
or
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

Besides... there is this page:
http://www.oracle.com/technology/documentation/database10gR2.html
You will realize that "B19306-01" gives you the whole 10gR2 documentation on your computer (450MB download).
Regards,

mson77

Report message to a moderator

Re: Performance Tuning in SQL queries and PL/SQL [message #270363 is a reply to message #270355]

Wed, 26 September 2007 11:34

psiva_oracle
Messages: 25
Registered: August 2007
Location: india

Junior Member

Thanks mson77,

Report message to a moderator

Previous Topic:	What is the different between the varchar2 and nvarchar2?
Next Topic:	Help :Getting Inner query executions from v$sql_plan_statistics_all

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 17:17:54 CST 2024