Home » RDBMS Server » Performance Tuning » 10g performance tuning (how can I practice?)
10g performance tuning (how can I practice?) [message #258430] Sat, 11 August 2007 22:43 Go to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

I am a very novice in the oracle world.
Beside this great forum... usually I am on my own... and I like to spend my spare time with some useful issue: Oracle for instance... and now I will study oracle.
Then I created an environment at home (one computer) to train... (instead of only read docs and google).
Well... I was read some thread in this "performance tuning"... trying to reproduce here... but I understood that tuning issue depends on the database dynamic... I mean... some application/users causing load on the oracle server.

I don't have this environment because my training environment is quite static.

How can I experience tuning by myself... here in my environment?
Thanks,

mson77
Re: 10g performance tuning (how can I practice?) [message #258433 is a reply to message #258430] Sat, 11 August 2007 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm

The most "bang for the buck" (biggest return for least effort) is obtained by tuning single SQL statements; one at a time.

SQL Tuning by Dan Tow
Language: English
ISBN-10: 0596005733
ISBN-13: 978-0596005733


Optimizing Oracle Performance by Cary Milsap
Language: English
ISBN-10: 059600527X
ISBN-13: 978-0596005276

Each of these provide a rigorous methodology for "tuning Oracle".
Re: 10g performance tuning (how can I practice?) [message #258435 is a reply to message #258433] Sat, 11 August 2007 23:20 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello anacedent,

I have already downloaded this oracle (b14211).
I will read this book to start being familiar with some terms like analyze, statspack, tkprof, awr, ash, wait events, sampling/snapshot, assm,...

Thank you again! Smile

mson77
Re: 10g performance tuning (how can I practice?) [message #258438 is a reply to message #258430] Sat, 11 August 2007 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
mson77,
Where in Brazil are you located? What timzone relative to GMT?

I visited Rio for a couple of days in the summer of 1969.
It is a beautiful city.

I hope someday to be able to take a tour of the Amazon.

HAND!
Re: 10g performance tuning (how can I practice?) [message #258442 is a reply to message #258438] Sat, 11 August 2007 23:44 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi anacedent,

I am at Sao Paulo city.
It is -3:00 GMT... and now 01:37am...

Rio de Janeiro is a great city... and the beaches are fabulous... hot sea water! Smile
The Amazon area also is fantastic... it really does worth!
My wife is a daughter of an american... and my father used to live in Salinas/Los Angeles.
Regards,

mson77
Re: 10g performance tuning (how can I practice?) [message #258483 is a reply to message #258442] Sun, 12 August 2007 11:38 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello ALL,

The attached image/gif shows tablespaces scenery of my test database CM3B. This image comes from toad screen.

Regarding the tablespaces usage... alloc/free/used... would you mind to write some comments related with performance? I mean... if this is okay, if some changes should be done,...

Thanks,


mson77
Re: 10g performance tuning (how can I practice?) [message #258485 is a reply to message #258430] Sun, 12 August 2007 12:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Regarding the tablespaces usage... alloc/free/used... would you mind to write some comments related with performance?
IMO, "tablespaces usage... alloc/free/used" NO measurable impact on SQL/application performance.
Re: 10g performance tuning (how can I practice?) [message #258498 is a reply to message #258485] Sun, 12 August 2007 15:25 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi anacedent,
THANK YOU VERY MUCH.
Now I am sure that tablespaces alloc/free/usage does not interfere in performance. Thank you!
Regards,

mson77
============ (edited)
Hi anacedent,

I was reading the topic:
http://www.orafaq.com/forum/m/258281/110238/?srch=imo#msg_258281

I have read at:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/design.htm#sthref173
about using PL/SQL instead of using SQL statements with DECODE... (item 4).

In oracle documentation I read to use PL/SQL when procedural job is needed. You say that PL/SQL makes programmers lazy.

?? and now?

Regards,

mson77

[Updated on: Sun, 12 August 2007 15:56]

Report message to a moderator

Re: 10g performance tuning (how can I practice?) [message #258514 is a reply to message #258498] Sun, 12 August 2007 22:24 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hi anacedente,

May I complement with some information about tablespaces size alloc/free/usage?
Please correct me... if any.

The optimal tablespaces in size should be with near by 95% in usage. Why? Because if the backup process is based on "as copy" tablespace/datafile... it will not consume extra time copying a large datafile with low usage.

Regards,

mson77
Re: 10g performance tuning (how can I practice?) [message #258515 is a reply to message #258430] Sun, 12 August 2007 22:42 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>You say that PL/SQL makes programmers lazy.
I see I was not as clear/explicit as I intended.
>>imo, it make programmers lazy.
The "it" above refered to EXECUTE IMMEDIATE not PL/SQL in general

As a general rule when I see the term "performance tuning" I tend to focus on OLTP application response time.


I tend not to be concerned about over sized datafiles because my database backup is a standby database on a different system.
Yes, it takes longer if/when datafiles are oversized to create the standby database initially; but I do that ony about once a year. Given that it takes about 12 hours now, another 30 or 60 minutes once a year is a cost I can bear.

With Oracle there is 1 firm & fast rule that is always true.
Every Orale rule has an exception; except this rule.

[Updated on: Sun, 12 August 2007 22:47] by Moderator

Report message to a moderator

Previous Topic: cached objects in buffer
Next Topic: Different Explain in Different Instances.
Goto Forum:
  


Current Time: Sun Dec 11 00:16:08 CST 2016

Total time taken to generate the page: 0.07109 seconds