| 10g performance tuning (how can I practice?) [message #258430] |
Sat, 11 August 2007 22:43  |
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 #258435 is a reply to message #258433] |
Sat, 11 August 2007 23:20  |
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! 
mson77
|
|
|
|
|
|
|
|
| Re: 10g performance tuning (how can I practice?) [message #258483 is a reply to message #258442] |
Sun, 12 August 2007 11:38 |
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 #258514 is a reply to message #258498] |
Sun, 12 August 2007 22:24 |
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 |
 |
BlackSwan
Messages: 26766
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
