Hi,
A simple rollback segment question. If I do not set a optimal then can I assume following
1) rollback segment will not shrink.
2) It will keep growing till tablespace fills up.
3) And there will be no 'snapshot too old' errors?
ThanksA Joshi <[EMAIL PROTECTED]> wrote:
Hi,
One r
Quite a surprise to find this on the front page of OTN
http://otn.oracle.com/pub/articles/dulaney_sed.html
Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.
It would appear that the values for _smm_max_size and _smm_px_max_size
are specified in K, though not explicitly.
In a test 9.2.0.4 database:
pga_aggregate_target = 25165824
_smm_max_size = 1228
_smm_px_max_size = 7371
Anyone know this for sure?
Jared
On Sat, 2003-12-27 at 08:59, Tanel Poder
Hi Jonathan,
I'm not sure what you really think about this new feature!
Are you saying that Oracle is capable now of releasing the extra memory
something it was not capable of before?
If yes, then what does it have to do with the work policy?
I see this feature useful (not really) for a databas
Jonathan,
Which exact behaviour were you talking about?
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, December 27, 2003 11:34 PM
>
> Good news !
> That "bug" has been fixed in 9.2.0.4
>
> Regards
>
> Jonathan Lewis
> http
> > > #2. How do you determine whether your buffer cache is sized
> > properly?
> >
> > Your application meets it's defined operational response time
> > and throughput constraints.
>
> Actually that is an interesting answer, since it doesn't answer the
question
> asked 'How do I know if my buffer
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of Ryan
> Sent: 27 December 2003 21:59
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Correct way to accuse BCHR tuning method (Was: Hit ratio)
>
>
> Performance 'problems' are dependent on w
Performance 'problems' are dependent on what the marketing department gets
in the SLA.
So if your marketing guys negotiate very strict response time requirements
and you dont meet them, then you have a performance problem. How do I know
if my buffer cache is having any effect on that?
- Origi
Good news !
That "bug" has been fixed in 9.2.0.4
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial
> > #2. How do you determine whether your buffer cache is sized
> properly?
>
> Your application meets it's defined operational response time
> and throughput constraints.
Actually that is an interesting answer, since it doesn't answer the question
asked 'How do I know if my buffer cache is siz
Title: Exporting a partition with transport tablespace
Make sure that you use novalidate and exchange
indexes as well - that way Oracle won't make unnecessary work.
Also, you should export the metadata at the time
when required partitions are exchanged to "transport tables".
Tanel.
I agree that this difference might be only because
sqlnet is much more "fat" that ICMP.
But anyway, could some overhead be added be because
the failover & load balancing clauses that require extra work?
Also, if listener logs every connection, this might
add some extra IO time as well (if w
Note that when finding sessionid, querying from
v$mystat where rownum=1 is faster than selecting sys_context from dual, because
dual access requires full table scan on it, which means 3-5 LIOs, depending on
version, buffer pins, latches etc..
Even when you don't select sys_context from dual
JP, Juan, and Prem,
Prem is correct. Standby is certainly a feature of SE, just not the
"managed recovery" and "SQL*Net log shipping" parts, which only come with
EE. Essentially, Standby Database features in SE is just like Standby
Database features from 7.3 through 8.0.
I have some shell scrip
There are two things that I can theorize could cause this problem.
1) Oracle bug (have you logged a tar with OWS?)
2) The block sampled is below the high water mark, but does not contain any data. I
don't know the
exact sampling algorithm, but this seems to be the 2nd simplest explanation (bug bei
Thanks Tanel. I wasn't aware of those parameters.
-Original Message-
From: Tanel Poder [mailto:[EMAIL PROTECTED]
Sent: Sat 12/27/2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Cc:
Subject:Re: pga_aggregate_target
> Also, consider that any single serial sessio
Saturday, December 27, 2003, 11:14:25 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
bnini> Hello list, Can someone please explain to me why the
bnini> following order by clauses are valid and yield the
bnini> same results :
bnini> select empno, deptno from emp
bnini> order by sqrt (1) ;
The cl
> I think the JDBC driver has connection pooling also, but not session
> pooling. OCCI might have both. But I haven't checked.
OCCI is AFAIK just an OO wrapper around OCI so it should have every
functionality that OCI has.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
> #1. what is the difference in the 4 BCHR's in 9i?
What do you mean by that? Are you refferring to different buffer pool stats
here?
> #2. How do you determine whether your buffer cache is sized properly?
Your application meets it's defined operational response time and throughput
constraints.
Hi!
You may want to set _smm_max_size parameter to higher value (see my recent
post about pga_aggregate_target), but I think setting your sessions pga
management temporarily to manual + setting sort_area_size, as Jared and
Jonathan already recommended, is better solution for your current issue.
T
Because both expressions evaluate to
1 and cause the output to be sorted by the first column? Oracle seems
to ignore the values after the decimal point.
SQL> select a, c from x
2 where rownum < 10 3 order by 1.7;
A C--
- 4861 Y
4862 N 4863
Y 48
> Also, consider that any single serial session will never get more than 5%
of
> pga_aggregate_target. For parallel operations, total is limited to 30%.
The maximum can be controlled using "_smm_max_size" parameter which states
how many kilobytes a serial session can use for its workarea operatio
The credit for that goes to Gary Dodge. It has been his email signature for
better than 10 years...
"Building tomorrow's legacy systems today - one crisis at a time"
Gene Fosnight (a successfully retired Oracle consultant) had an email
signature that was, if anything, even better:
"Look, listen
Hello list,
Can someone please explain to me why the following order by clauses are
valid and yield the same results :
select empno, deptno from emp
order by sqrt (1) ;
and
select empno, deptno from emp
order by sqrt ( 3.14234 ) ;
The docs say that in the order by clause you could specify only
#1. what is the difference in the 4 BCHR's in 9i?
#2. How do you determine whether your buffer cache is sized properly?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, December 27, 2003 9:34 AM
> Hi Yong
> > I agree that "It's not the ra
Hi Yong
> I agree that "It's not the ratio that needs condemning, it's
> the advice about..." What I disagree is the wrong educational
> tool people on public forums have recently used again and
> again to show the inadequacy of the BCHR tuning method.
The thing is most people who have used thi
Notes in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
Three-day seminar:
see http
27 matches
Mail list logo
