Hi!
Maybe it's a delayed commit cleanout issue, due massive deletes, so during
your first select most of your buffers involved in delete have to be cleaned
out (thus becoming dirty and generating extra redo).
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL
Robin,
Thanks for the reply. I figured it would. Thats what
we are working at now. It's unfortunate it was set up
this way to begin with, but I am starting to see the
light at the end of the tunnel.
Larry
--- Robin Li <[EMAIL PROTECTED]> wrote:
> I had the performance issue with CLOB in one of m
Raj,
I agree. I could see where that could affect the
overall performance. The analyze wouldnt have an
effect on a SELECT COUNT(*) though would it??? That is
the piece that really has me stumped at the moment.
--- "Jamadagni, Rajendra"
<[EMAIL PROTECTED]> wrote:
> After deleting lot of old data, a
I had the performance issue with CLOB in one of my databases. After I did a
re-org, and separated the tables,indexes and CLOB into different
tablespaces, the performance got tremendous improvement.
Robin
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Se
After deleting lot of old data, an analyze of the table is in order though ..
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, ha
t. there is no 'exact' very high and very low. you have to
interpret it.
>
> that is about it. Anyone who uses it for anymore than that is wrong.
> >
> > From: Mladen Gogala <[EMAIL PROTECTED]>
> > Date: 2003/10/28 Tue PM 12:09:34 EST
> > To: Multipl
to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: performance issue on select count(*)
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you con
t ORACLE-L <[EMAIL PROTECTED]>
> Subject: Re: performance issue on select count(*)
>
> So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
> and what do you consider "low"?
> What "HR" are you talking about?
> T
So, what exactly is indicated by a high or low hit rate? What, exactly, is "high"
and what do you consider "low"?
What "HR" are you talking about?
This would be the infamous BCHR:
select 'bc_hit_ratio' ratio,( sum(decode(name, 'consistent gets',value,0))
+ sum(decode(name,'db block gets', value
The symptom suggests caching is a big factor here - most likely
block-buffers.
Contrary to ?current? popular beliefs, BCHR is still a very relevant
performance indicator - either being very high, or being too low - both of
which gives a good indication of something that needs to be looked at.
gt;
Subject: Re: performance issue on select count(*)
Date: Mon, 27 Oct 2003 10:34:59 -0800
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the
Linda,
I am guessing that since your table is partitioned on an unspecified date
column, that the index on TID is either LOCAL or non-partitioned (i.e.
GLOBAL).
If it is LOCAL (you would have had to specify the keyword, as it is not the
default), then you will be performing indexed RANGE scans on
t; <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: performance issue on select count(*)
Date: Mon, 27 Oct 2003 05:49:24 -0800
Linda,
I guess that the key word is 'partition'. This type of query should
Linda,
I guess that the key word is 'partition'. This type of query should not require to
access the table if (hopefully) tid is indexed. If the index on tid is also
partitioned, all index partitions have to be searched. My feeling is that in such a
case what should run faster is some paralle
> Hi Lisetrs,
>
> I have enough free memory from shared_pool_size and
> I run stats every week but the BD still shows up the
> low hit ratio and some times the later full down to
> 15%!
> Here is some informations:
Are any of the users complaining that their business functions are
performing poo
same here.
DLLs all over the place, not the best situation to be in.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'inform
Jackson,
Was the OS actually upgraded to win2k, or was it reinstalled?
because Win2k UPG != Win2k installed
The concensus among SA's seems to be that upgrading from
NT to Win2k is not a good thing. Our SA's refuse to do it.
Jared
"Jackson Dumas" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTEC
Jackson Dumas,
Maybe we need to know whether your os upgrade caused oracle upgrade? I
mean if you did oracle exp/imp, patch, migration etc? I mean if there is anything
else is changed ?
Make a statspack and check what is the oracle doing. That will be
helpful:)
Hi Jackson Dumas,
Have check the virtual memory (paging space) of the OS ?
Because sometimes it's related. And, how big memory that you used in your
server ?
Thank's
Bernardus Deddy Hoeydiono.
-Original Message-
Dumas
Sent: Wednesday, January 08, 2003 2:59 PM
To: Multiple recipients of
>Hi guys
>
>Compliments of the new season.
>
>We have a database running on Oracle 817 and there are around 4 to 5
>applications running there. Initially the platform was Windows NT,
>service pack 6. Everything was working fine, now recently, the O/S was
>upgraded to Windows 2000. Then our problems
Seema,
See the problem that is arising here on
this post ?
It could be this and it could be that ...
what is the # of cpus ? what o/s ? try this and
try that and on and on we go asking question
after question until you say "Enough, I
am not getting anywhere with this."
This is why you gotta dri
It could be memory paging problem. Are you using UFS, VFS, etc?
If yes, see if there is any options where you can mount them in the direct
mode (bypass the fs cache layer)
Waleed
-Original Message-
Sent: Thursday, June 20, 2002 12:39 PM
To: Multiple recipients of list ORACLE-L
Hi
I am
Title: PERFORMANCE ISSUE
Seema,
Questions:
1. On what OS you are running your db?
2. How did u find memory leakage?
Regards,
Rao
-Original Message- From:
[EMAIL PROTECTED]@SUNGARD on behalf of "Seema Singh"
<[EMAIL PROTECTED]> Sent: Thu 6/20/2002 12:38 PM
To: Mult
Well, you don't give us much to go on and I fully agree with the other comment about
buying and using a good tuning book.
However, there is one experiment you might try the next time your instance gets slow.
Try flushing the shared pool (alter system flush shared_pool). If that works, you can
Seema,
So what does that tell you about how useful database
ratios are in diagnosing your problem ? I would
suggest you check out some sites about detecting
waits in your system. The information given here
gives no one a starting point to help you diagnose
the problem.
Consider buying Gaja
Stephane , thanks a lot !
actualy , i do not think that this is the case , because it would take
relatively much more time to construct the result set (my SQL contains
massive 'group by' and 'order by' and therefore the whole result set needs
to be constructed before returning even the 1st row), t
Thanks a lot Jonathan !
I TKPROFed these statements - nothing outstanding, it looks like the cursor
is not getting closed eafter each fetch.
Anyway , i would not expect the 100th fetch to take 100s times more time
than the first one
Also please note that the select contains 'group by' and 'ord
Do you keep the each batch of 5000 rows ? If yes, are you running out of
memory ?
Anjo.
Andrey Bronfin wrote:
> Dear gurus !
> We are facing a severe performance problems here that i have no idea of how
> to address.
> There is a C++ program , which uses OCI , that does the following.
> It in
Can you switch on SQL trace whilst this is running,
or peek into v$sql.
It sounds to me as if your code is "fetching
an array" by re-opening the cursor, fetching
and discarding all the rows up to the required
point, and then returning the required rows.
To answer your direct question - when doi
>Dear gurus !
>We are facing a severe performance problems here
>that i have no idea of how
>to address.
>There is a C++ program , which uses OCI , that does
>the following.
>It initiates a long running SQL select statement,
>and then fetches the
>result set from the DB in buffers of 5000 records.
I need to get the adue_cd and group by the sum of the adue_amt- amtpd based
on the decoded code ??
SELECT DECODE(adue_cd,'DS','STM','IS','INS','MS','OUI',
'PA','OD1','PN','OD2','PP','OD1')
,SUM(adue_amt - amt_pd)
FROM BSADUE
WHERE la_no = v_la_no
AND adue_cd IN ('DS','IS','M
Try to rebuild your index and use another tablespace for that (It'd be
better having a different disk).
Also, be aware about how defrag is your data onto disk. That affects
tremendously the performance.
HTH,
Jordi
-Original Message-
From: Pampati, Kiran [mailto:[EMAIL PROTECTED]]
Sent:
Title: RE: Performance issue
> -Original Message-
> From: Pampati, Kiran [mailto:[EMAIL PROTECTED]]
>
> I have a table with 1 million records, If I search for one
> value of a column
> it comes very fast and if I do the same query for a
> different value on
33 matches
Mail list logo