Wow!
Thanks Jonathan, for a breakdown on the cause and cure
of buffer busy waits.
I was taken in at one time, ( long time ago) by some of these
rules of thumb and quick tips, but it became apparent that
there's really no such thing for tuning.
The only rules of thumb I have any more are
Charlie,
Do you check 'table fetch continued row' stats before doing so?
If you're not waiting on chained rows, or the waits are
negligible, why bother?
Jared
On Friday 17 January 2003 13:56, [EMAIL PROTECTED] wrote:
What I've done, is I have some PL/SQL code which looks for chained rows.
Jared,
Thanks for the note - I loved the closing lines
especially.
I have to say that I've already spotted two error
in my note, one of them a silly slip, but the other
is likely to cause confusion.
Silly slip - in the bit about decreasing block sizes -
Good point - especially in Oracle
[EMAIL PROTECTED]
01/17/03 09:24AMHey guys-
Have any of you all messed around with the silent
install/response files?
I'm looking for tips, advice, do's, don'ts,etc,etc
Just wanted to point out that silent install is not a
solution if you lack X-windows connectivity to a server.
Charlie,
Would you please post your PL/SQL code here.I might wanted to use/tweak
it .
Also your formula for PCTFREE is pctfree = pctfree + 5 , if table exceeds 5%
of chained rows and some DBAs advocate to average row length.
Jared, whats u r idea on this , what would you do to alter
Thanks
for point it out.
-Original Message-From: Michael Fontana
[mailto:[EMAIL PROTECTED]]Sent: Saturday, January 18, 2003 5:59
PMTo: Multiple recipients of list ORACLE-LSubject: re:
Slient Install [EMAIL PROTECTED]
01/17/03 09:24AMHey guys- Have any of you all
Indeed you can do this. It's a bit involved, but it's documented in my
Oracle9i RMAN Backup and Recovery Book, and it is supported in 8i.
RF
-Original Message-
Hostetter
Sent: Friday, January 10, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L
But I don't anticipate having to
All of these views are pretty well documented in the Oracle9i docs too. The
doc's of the v$ tables is much better these days (but still isn't perfect).
Check out tahiti.oracle.com.
Robert
-Original Message-
Kirti
Sent: Friday, January 17, 2003 11:40 AM
To: Multiple recipients of list
Don't forget about the more important issue of detecting corrupted archived
redo logfiles. Datafile corruption can be bad; redo log file corruption is
always disastrous, especially if undetected until recovery time...
RMAN checks archivelogs for corruption while backing them up.
- Original
Jared,
I will say publicly that this list is great. It's a great source of
information and I've made some new friends to boot. Thanks for taking the
time to manage this thing.
Robert
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, January 17, 2003 11:30 AM
To: Multiple recipients
Hey Ya'all... (still got my southern roots even up here in Chicago!)
Anyone want to throw in some possible reasons why an execution plan might
change for a given table queryThis is on Oracle9iR2 on SUN. I've looked
at the obvious causes:
1. Object has changed - Appears not to have changed.
GASP... you mean I'm not the ONLY one who does that from time to time.
I feel so much better! :-)
WHEN does increasing the pctused to pctfree gap help ? And
should this be done by increasing the PCTFREE or decreasing
the PCTUSED -
** It's a mistake I make quite often because of
LOL... good point!!
-Original Message-
[EMAIL PROTECTED]
Sent: Friday, January 17, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
...incremental exports/imports are depreciated in 9i
They weren't worth much to start with. ;)
Jared
Freeman
13 matches
Mail list logo