Re: lvoug@googlegroups.com īssavilkums - 1 ziņojums, 1 tēma

[Andrey Chervonets]

>ļæ½ļæ½ļæ½ļæ½ Veiktspļæ½jas problļæ½mas pļæ½rejas no 10.2.0.4 uz 11.2.0.3 [1 atjauninļæ½jums]
>
>ļæ½ Veiktspļæ½jas problļæ½mas pļæ½rejas no 10.2.0.4 uz 11.2.0.3
>
>ļæ½ļæ½ļæ½ļæ½ "Uldis Pļæ½vuls" <uldi...@gmail.com> Jun 05 01:00AM -0700ļæ½
>
>ļæ½ļæ½ļæ½ļæ½ Sveiki!
>ļæ½ļæ½ļæ½ļæ½ Man jļæ½lļæ½dz palļæ½dzļæ½ba 11.2 un 10.2 atļæ½ļæ½irļæ½bu jautļæ½jumļæ½,.

0. Atkarļæ½bļæ½ no upgrade metodes un izpildļæ½tas pirm/pļæ½c upgrade/migration procedļæ½ram jebkura versija var strļæ½dļæ½t sliktļæ½k par iepriekļæ½ļæ½jo.
Upgrade pats no sevis neko negarante.

1. Salļæ½dzini Top waits katrai videi - vispar DB instancei un atseviļæ½ļæ½iem SQL pieprasļæ½jumiem (kur ir slikti)
ar AWR vai STATSPACK

2. Salļæ½dzini Execution Plan konkrļæ½tiem SQL kam response time ir sliktļæ½k

3. Vai salidzļæ½nļæ½ja DB parametrus?

4. Vai savakta svaiga statistika visiem objektiem?
Vai savakta System statistic?

5. Noderļæ½gi documenti:
FAQ: Database Performance Frequently Asked Questions [ID 1360119.1]ļæ½ļæ½
ļæ½Note:402983.1 * Master Note: Database Performance Overview
Note:199083.1 * Master Note: SQL Query Performance Overview
Note:398838.1 * FAQ: SQL Query Performance - Frequently Asked Questions
ļæ½ļæ½ļæ½ ļæ½eit bļæ½s sadaļæ½a " Why is a particular query slower since upgrading?"
Document 1377446.1 Troubleshooting Performance Issues


Ar cieļæ½u,

Andrejs ļæ½ervoļæ½ecs
-------------------------
SIA CoMinder
http://www.cominder.eu/
GSM: +371 26517848