lvoug@googlegroups.com īssavilkums - 1 ziņojums, 1 tēma - Latvian Oracle User Group

Google grupu iepriekšējā versija drīzumā vairs nebūs pieejama, un jūsu pārlūkprogramma nav saderīga ar jauno versiju.
Ziņojums no diskusijas lvoug@googlegroups.com īssavilkums - 1 ziņojums, 1 tēma
Skatīt parsēti - Rādīt tikai ziņojumu tekstu
Received-SPF: pass (google.com: domain of a.chervon...@gmail.com designates 209.85.212.172 as permitted sender) client-ip=209.85.212.172;
Message-ID: <4FCEC7AF.2030...@gmail.com>
Date: Wed, 06 Jun 2012 05:59:59 +0300
From: Andrey Chervonets <a.chervon...@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: lvoug@googlegroups.com
Subject: Re: lvoug@googlegroups.com =?ISO-8859-13?Q?=EEssavilkums_-_1?=
 =?ISO-8859-13?Q?=A0zi=F2ojums=2C_1=A0t=E7ma?=
References: <bcaec51d23681360fc04c1bee...@google.com>
In-Reply-To: <bcaec51d23681360fc04c1bee...@google.com>
Content-Type: multipart/alternative;
 boundary="------------020602010007080008020905"

This is a multi-part message in MIME format.
--------------020602010007080008020905
Content-Type: text/plain; charset=ISO-8859-13; format=flowed
Content-Transfer-Encoding: 8bit

 >     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" <uldis...@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

--------------020602010007080008020905
Content-Type: text/html; charset=ISO-8859-13
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-13"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    &gt;ï¿½ï¿½ï¿½ï¿½ Veiktspï¿½jas problï¿½mas pï¿½rejas no 10.2.0.4 uz 11.2.0.3 [1
    atjauninï¿½jums]<br>
    &gt;<br>
    &gt;ï¿½ Veiktspï¿½jas problï¿½mas pï¿½rejas no 10.2.0.4 uz 11.2.0.3<br>
    &gt;<br>
    &gt;ï¿½ï¿½ï¿½ï¿½ "Uldis Pï¿½vuls" <a class="moz-txt-link-rfc2396E" href="mailto:uldis...@gmail.com">&lt;uldis...@gmail.com&gt;</a> Jun 05 01:00AM
    -0700ï¿½ <br>
    &gt;<br>
    &gt;ï¿½ï¿½ï¿½ï¿½ Sveiki!<br>
    &gt;ï¿½ï¿½ï¿½ï¿½ Man jï¿½lï¿½dz palï¿½dzï¿½ba 11.2 un 10.2 atï¿½ï¿½irï¿½bu jautï¿½jumï¿½,.<br>
    <br>
    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.<br>
    Upgrade pats no sevis neko negarante.<br>
    <br>
    1. Salï¿½dzini Top waits katrai videi - vispar DB instancei un
    atseviï¿½ï¿½iem SQL pieprasï¿½jumiem (kur ir slikti)<br>
    ar AWR vai STATSPACK<br>
    <br>
    2. Salï¿½dzini Execution Plan konkrï¿½tiem SQL kam response time ir
    sliktï¿½k<br>
    <br>
    3. Vai salidzï¿½nï¿½ja DB parametrus?<br>
    <br>
    4. Vai savakta svaiga statistika visiem objektiem?<br>
    Vai savakta System statistic?<br>
    <br>
    5. Noderï¿½gi documenti:<br>
    FAQ: Database Performance Frequently Asked Questions [ID
    1360119.1]ï¿½ï¿½ <br>
    ï¿½Note:402983.1 * Master Note: Database Performance Overview<br>
    Note:199083.1 * Master Note: SQL Query Performance Overview<br>
    Note:398838.1 * FAQ: SQL Query Performance - Frequently Asked
    Questions<br>
    ï¿½ï¿½<b>ï¿½ ï¿½eit bï¿½s sadaï¿½a " Why is a particular query slower since
      upgrading?"</b><br>
    Document 1377446.1 Troubleshooting Performance Issues<br>
    <br>
    <br>
    Ar cieï¿½u,<br>
    <br>
    Andrejs ï¿½ervoï¿½ecs<br>
    -------------------------<br>
    SIA CoMinder<br>
    <a class="moz-txt-link-freetext" href="http://www.cominder.eu/">http://www.cominder.eu/</a><br>
    GSM: +371 26517848<br>
  </body>
</html>

--------------020602010007080008020905--
Izveidot grupu — Google grupas — Google mājaslapa — Pakalpojuma noteikumi — Konfidencialitātes politika
Account Options
