FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE
undo_retention target).
Check out V%UNDOSTAT to see how it's going.
Cheers
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Let's hope he's not on long service leave :)
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 08, 2004 8:44 PM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
Title: Message
Hi Thomas,
Never say never (oh bugger, I've just gone and done
it myself).
A large table accessed via a FTS for various
important reporting requirementshas permanently shrunk in size from 10G to
100M (say list of Informix customers ;)
Business requirements have changed and
the exams :)
Cheers
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
), move on to the next question and report back to
Oracle what the hell they meant by the bloody thing.
Cheers (and good luck)
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
;)
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
And if enough attend, Cary has promised to related
the little tale of a certain rat called Rupert.
Cary, dare ya !!
Richard ;)
- Original Message -
From:
Murali Vallath
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 07, 2004 10:59
PM
Subject:
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network
recipients during the
presentation
- Act imporant and smarter than everyone else
- Hold up our shafts for a publicity photo
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
Little competition for you all :)
It's a two part question:
What's wrong with the
followingpiece of expert analysis?
Which well know "Oracle Guru"
published this (and continues to display it on his web-page) ?
"Sadly, Oracle9i doesnt allow you to specify the
value for PCTFREE
: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Terse ?
You haven't heard me terse until youhear me
trying to get the kids to sleep at night.
Don got it easy ;)
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 10, 2003 8:14
AM
Subject: Re:
the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web
ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
???
I'd hate to see a long article! ;-)
--- Richard Foote [EMAIL PROTECTED] wrote:
Hi Yong,
Saying there are a few errors is being a little kind to Don's
Inside
Oracle Indexing article.
In part, these are some of the issues I raised directly with Don in a
number
of emails (warning
-
Paul Baumgartel
Sent: Monday, December 08, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L
somewhat on the longish side???
I'd hate to see a long article! ;-)
--- Richard Foote [EMAIL PROTECTED] wrote:
Hi Yong,
Saying there are a few errors is being a little kind to Don's
therefore should look like:
(del_lf_rows_len / lf_blk_len)
Hopefully these comments will do some good not only to Don but to anyone
trying to understand this whole issue.
Regards
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from
100 GB .05%
--
--
From that, it would follow that free lists as such are gone in ASSM
tablespaces
and are replaced by bitmaps. As Richard Foote has shown, PCTFREE is not
ignored,
but without free lists
send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
it because proceses
RESERVING lots of swap.
We change to manual PGA (we use sort_area_size, etc.)
It was on 9.2.0.1
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de
Richard Foote
Enviado el: martes, 11 de noviembre de 2003 13:35
Para: Multiple recipients of list
5011213
As we can see, the results are very similar. The table with a high pctfree
has a massive number of blocks and (potential) wasted space relative to the
table with a low pctfree.
PCTFREE is most definitely *NOT* ignored with ASSM !!
Cheers
Richard Foote
--
Please see
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
?
On 2003.11.07 17:59, Richard Foote wrote:
Hi (again) Mladen,
I'm sure I mentioned this previously but ASSM only deals with FREELISTS,
FREELIST GROUPS and PCTUSED (with possibly significant overheads).
You still need to set *PCTFREE*, which means you can still have over
allocation
see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
with a ruptured calf muscle :(
Cheers
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Richard Foote
Sent: Friday, October 17, 2003 6:29 AM
To: Multiple recipients of list ORACLE-L
Separate
Hi Hemant,
One word perfectly describes the Metalink article
(*)
--
1
only one poor block (the header) has survived the experience :(
Hope this clears something up !!
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 10:59 PM
Mike:
I guess we
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL
') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
will
be
detrimental to the system. However, there are still plenty of
misconceptions
about indexes that result in DBAs the world over wasting valuable time
and
effort rebuilding indexes unnecessarily.
Amen to that !!
Cheers ;)
Richard
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat
indexes degrade the performance of index range scan
operations.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list
deletes caused by indexed columns value
changes.
Fragmentated indexes degrade the performance of index range scan
operations.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
On Wed, 2003-10-15 at 18:04, M Rafiq
wrote: Jared,Those tables are transit
type of tables and depending on your volume of data, there are lot
of deletes and inserts all the time resuling index
fragmentation(holes due to deletes) and space usage.
The rebuilding not only release
Title: Message
Hi All,I'm having all sorts of problems
getting these emails in a logical order (if at all). This is the first post on
this subject I've received since I posted to Rachael, I haven't even received my
own post yet !!Anyways, going back in orderFirst to John, no,
not all
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
one's particular workload
conditions and determine whether or not it's beneficial.
Maybe others have similar real life experiences to share ?
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 02, 2003
with.
But I've always thought giving away free David Bowie Cds at training
courses
was a better way to go :)
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
of IT specialists that result
from such a program should be running the show.
Unfortunately, we don't live in an ideal world ... But perhaps by voicing
one's concerns and opinions, we might just get a little closer ;)
Cheers
Richard Foote
- Original Message -
To: Multiple recipients
workload
conditions and determine whether or not it's beneficial.
Maybe others have similar real life experiences to share ?
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 3:44 AM
Richard,
Thanks
see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
:)
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
AM, Richard Foote at [EMAIL PROTECTED] wrote:
Hi Tim,
There are couple of parts of the conversation we've missed out ;)
Firstly, the server process when talking to the P_A_T instance should have
said, What the hell is going on here, what do you mean I can't have my
full
100M, this keeps
of free memory (generally sitting around 1G),
disk sorts have disappeared entirely (in four months, we've had 2 disk
sorts) and hash joins have improved considerably.
Based on my experience, P_A_T is the best thing Oracle has introduced since
LMT !!
Cheers
Richard Foote
- Original Message
of free memory (generally sitting around 1G),
disk sorts have disappeared entirely (in four months, we've had 2 disk
sorts) and hash joins have improved considerably.
Based on my experience, P_A_T is the best thing Oracle has introduced since
LMT !!
Cheers
Richard Foote
- Original Message
Title: Message
Hi Mladen,
I can't help you with your problem, I haven't had
the pleasure on NT or Tru64 but I just wanted to point out that you can't forget
about PCTFREE even with ASSM.
Cheers
Richard
- Original Message -
From:
Mladen
Gogala
To: Multiple recipients
Title: Message
Hi Mladen,
Because when you insert a row, Oracle has
absolutely no idea by how much it might grow (should the insertion of that 18th
row use up the remaining space in the block or should we save some, who's to
know ...). Therefore the setting of some magic PCTFREE is not
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat
Hi Scott,
Although the recommendation of RTFM often has it's merits, where precisely
do you suggest Seema should look for the above mentioned FM within the
*8.1.6* doco set for the sp* statspack scripts ?
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L
our backup(s). dbms_repair should be used if all else fails (or you don't
really mind losing that "bit" of your database).
Good Luck
Richard Foote
- Original Message -
From:
Stefick Ronald S Contr
ESC/HRIDD
To: Multiple recipients of list ORACLE-L
Sent: Thu
perform the block cleanout continues on and on and on ...
Hence the suggestion to guarantee block cleanout while the tablespace is in
a position to do so (in read/write mode).
Cheers
Richard Foote
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL
management auto;
Tablespace created.
SQL create table bowie2 (x clob) lob (x) store as (disable storage in row)
tablespace new;
Table created.
Cheers
Richard
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network
to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego
: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
of changes, you can end up
generating quite a bit of the redo.
Not as much as a non-GTT but enough to certainly invalidate the above
statement.
Cheers
Richard Foote
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network
a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat
, getting back to your actual situation, if table access is only to
be made via the order date or by order date and order id (and not
necessarily by order id only), then you may find a single index order date
|| order id would meet all your requirements.
Cheers
Richard Foote
- Original Message
, getting back to your actual situation, if table access is only to
be made via the order date or by order date and order id (and not
necessarily by order id only), then you may find a single index order date
|| order id would meet all your requirements.
Cheers
Richard Foote
- Original Message
: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
(and not
necessarily by order id only), then you may find a single index order date
|| order id would meet all your requirements.
Cheers
Richard Foote
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 28, 2003 8:59 PM
Okay, I have
want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED
list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself
BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL
the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Richard Foote
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
82 matches
Mail list logo