OK, I used to teach DBA courses and that was one of my favorite topics so let
me give it a shot here:
1) If the free space percentage in the block falls below PCTFREE, the block is
taken off the free list. Heuristically speaking, we can say that oracle does
its best to keep the block PCTFREE
the data is very skewed, but i included 'for all indexes' and for all
indexed columns. doesnt that create histograms? or do i have the syntax
wrong. what i really needed was histograms, Ill bet.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday,
Hi!
Note that a block can come off freelist also when it's usage is under
PCTFREE but above PCTUSED *and* an insert is attempted, but rejected for
this block because it would have filled the block above PCTFREE.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L
Thank you all. Your suggestions have clarified A LOT
of grey areas for me. I'm not an expert shell
programmer but I can certainly get by on these
suggestions!
Thanks again.
Saira
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Saira Somani
INET: [EMAIL PROTECTED]
Redhat recommending windoze for desktop.
http://zdnet.com.com/2100-1104_2-5101690.html
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joe Testa
INET: [EMAIL
--- Mladen Gogala [EMAIL PROTECTED] wrote:
[snip]
2) When the block is taken off the free list and records are deleted,
the block is not returned to the free list until the percentage of
used
space doesn't fall below PCTUSED.
Mladen--
You did mean percentage of used space falls below
See? I might have been onto something with that spoof.
On 2003.11.04 19:19, Joe Testa wrote:
Redhat recommending windoze for desktop.
http://zdnet.com.com/2100-1104_2-5101690.html
--
Joseph S Testa
Chief Technology Officer
Data Management Consulting
614-791-9000
It's all about the CACHE
--
Your example block can be 60% full and not be on the free list.
Once your block reaches 90% full, it is removed from the free list.
So, you are implying that it can be removed from the free list
based on the PCTFREE value too, right? So far I was under the
impression that it can be removed
At 06:34 PM 11/4/2003, you wrote:
1) If the free space percentage in the block falls below PCTFREE, the
block is
taken off the free list. Heuristically speaking, we can say that oracle
does
its best to keep the block PCTFREE free.
So, if pctfree is 10%, oracle does its best to keep it full
Orr, Steve wrote:
Ditto. (But what about OS X? :)
I keep asking my boss for a powerbookG4, but he won't bite for some reason ;). I
keep telling him I need one to test the development version of Oracle on OSX.
I use the Ximian Evolution interface to MS Exchange. The problems are:
MS Outlook rules
At 06:34 PM 11/4/2003, you wrote:
So, PCTFREE and PCTUSED are kind of like boundary values, or kind-of-like
FREE SPACE IS BETWEEN PCTUSED and PCTFREE values, right?
I think I should have said :
USED SPACE IS BETWEEN PCTUSED and PCTFREE values, right?
maa
--
Please see the official
Ummm ... Mladen?
MG 1) If the free space percentage in the block falls
MG below PCTFREE, , the block is
MG taken off the free list.
Don't you mean if the free space percentage goes
*above* the value in PCTFREE?
Unless I'm reading you incorrectly, don't you mean
that, say, if the PCTFREE value
Tuesday, November 4, 2003, 7:19:25 PM, Joe Testa ([EMAIL PROTECTED]) wrote:
JT Redhat recommending windoze for desktop.
JT http://zdnet.com.com/2100-1104_2-5101690.html
I find that assessment reasonable. It's no slam against
Linux, just a recognition that for perhaps the vast majority
of
No, I don't mean that. If the free space percentage goes above PCTFREE, that
means that there is more then PCTFREE % free space in the block. Block is
thus eligible for free list. If the percentage of free space falls below
PCTFREE, that means that there is less then PCTFREE % of free
I did. Thanks.
On 2003.11.04 19:29, Paul Baumgartel wrote:
--- Mladen Gogala [EMAIL PROTECTED] wrote:
[snip]
2) When the block is taken off the free list and records are deleted,
the block is not returned to the free list until the percentage of
used
space doesn't fall below PCTUSED.
Mladen--
On 2003.11.04 19:54, Maryann Atkinson wrote:
At 06:34 PM 11/4/2003, you wrote:
1) If the free space percentage in the block falls below PCTFREE, the
block is
taken off the free list. Heuristically speaking, we can say that oracle
does
its best to keep the block PCTFREE free.
So, if pctfree
Jonathan, you're a very smart guy and a very nice one as well but I cannot
make sense of this clarification of yours. Would you care to explain it a bit?
What confuses me is that you agree that one version of Unix (Linux) is not
appropriate for a home user, but then, in the same message,
Or due to lack of free ITL slots during inserts
--
Denny Koovakattu
Quoting Tanel Poder [EMAIL PROTECTED]:
Hi!
Note that a block can come off freelist also when it's usage is under
PCTFREE but above PCTUSED *and* an insert is attempted, but rejected for
this block because it would
OK.
I think we're essentially saying the same thing. But
in two different ways.
--- Mladen Gogala [EMAIL PROTECTED] wrote:
No, I don't mean that. If the free space percentage
goes above PCTFREE, that
means that there is more then PCTFREE % free space
in the block. Block is
thus
Uh, oh. No wonder I confused you with what I wrote
Mladen.
The below should read if the PCTFREE value is 10, NOT
90.
See what happens when you compose emails when taking
antihistamines. Don't worry. I'm not doing any
storage tuning at the present moment ... :)
Melanie
--- Melanie Caffrey
If the query
is a part of the cursor then you can simply write the cursor query
as:
SELECT
emp_id
FROM emp
WHERE dept =
:dept
AND salary
:min_sal;
and then open the cursor only if the condition "select_sen_emp_chk_first
= 'Y'" evaluates to true
e.g.
IF select_sen_emp_chk_first =
101 - 121 of 121 matches
Mail list logo