Home » RDBMS Server » Performance Tuning » Performance Tuning in SQL queries and PL/SQL
Performance Tuning in SQL queries and PL/SQL [message #268821] Wed, 19 September 2007 19:05 Go to next message
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

Re: Performance Tuning in SQL queries and PL/SQL [message #268832 is a reply to message #268821] Wed, 19 September 2007 21:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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

Re: Performance Tuning in SQL queries and PL/SQL [message #269161 is a reply to message #268821] Thu, 20 September 2007 22:15 Go to previous messageGo to next message
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
Re: Performance Tuning in SQL queries and PL/SQL [message #270305 is a reply to message #269161] Wed, 26 September 2007 08:16 Go to previous messageGo to next message
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


Re: Performance Tuning in SQL queries and PL/SQL [message #270323 is a reply to message #270305] Wed, 26 September 2007 09:33 Go to previous messageGo to next message
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
Re: Performance Tuning in SQL queries and PL/SQL [message #270353 is a reply to message #270323] Wed, 26 September 2007 10:52 Go to previous messageGo to next message
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
Re: Performance Tuning in SQL queries and PL/SQL [message #270355 is a reply to message #270353] Wed, 26 September 2007 11:03 Go to previous messageGo to next message
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
Re: Performance Tuning in SQL queries and PL/SQL [message #270363 is a reply to message #270355] Wed, 26 September 2007 11:34 Go to previous message
psiva_oracle
Messages: 25
Registered: August 2007
Location: india
Junior Member
Thanks mson77,
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:
  


Current Time: Sat Dec 10 09:23:26 CST 2016

Total time taken to generate the page: 0.08995 seconds