RE: Performance tuning

I am impressed.

Alex Hillman

-----Original Message-----
Sent: Wednesday, May 30, 2001 5:18 PM
To: Multiple recipients of list ORACLE-L

"You are above average in awareness, so one would have to  work harder than normal to slip something by you."

In my fractured metaphor,
early-ness in the morning maps to degree of awareness, and wool over the eyes maps to unawareness.

The original metaphors are "the early bird gets the worm" and "you can't pull the wool over my eyes".

http://www.cs.nmsu.edu/atmet/Databank/root.html

http://www.wam.umd.edu/~mturn/

(Mark was my ONLY non math/science/engineering instructor  in nine years of "higher" education. A genius. He did ran  a class on Classic Style ( viz. LaRouchefoucauld, et al.)

http://www.wam.umd.edu/~mturn/WWW/blending.html

 (His work on cognitive blending deserves an award, or   at least a small impervious plaque somewhere. )

http://www.reversespeech.com/index.html

I don't buy this, but neither have I read it. It is simply interesting and tangentially connected to metaphor generation and usage.

hth,

Ross

|| -----Original Message-----
|| From: Hillman, Alex [mailto:Alex.Hillman_at_usmint.treas.gov]
|| Sent: Wednesday, May 30, 2001 4:21 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Performance tuning
||
||
|| Translation please.
||
|| Alex Hillman
||
|| -----Original Message-----
|| Sent: Wednesday, May 30, 2001 3:32 PM
|| To: Multiple recipients of list ORACLE-L
||
||
|| You have to get up pretty early in
|| the morning to pull the wool over
|| your eyes, Mr. Hillman.
||
|| :)
||
|| || -----Original Message-----
|| || From: Hillman, Alex [mailto:Alex.Hillman_at_usmint.treas.gov]
|| || Sent: Wednesday, May 30, 2001 1:22 PM
|| || To: Multiple recipients of list ORACLE-L
|| || Subject: RE: Performance tuning
|| ||
|| ||
|| || Why putting DB in noarchivelog will avoid redo generation?
|| || There will be no
|| || archiving, but redo will continue to be generated.
|| ||
|| || Alex Hillman
|| ||
|| || -----Original Message-----
|| || Sent: Wednesday, May 30, 2001 10:21 AM
|| || To: Multiple recipients of list ORACLE-L
|| ||
|| ||
|| || Azhar,
|| ||
|| || Just two thoughts off the top of my head to improve loading
|| || of records:
|| || 1. Put database in noarchivelog mode to avoid redo
|| generation (if
|| || possible).
|| || 2. Drop all indexes on target tables (if possible), then
|| || load data, then
|| || recreate all indexes on target tables.
|| ||
|| || Jim
|| ||
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO 633376
|| || 9636) 474-7832
|| || jhawkins_at_memc.com (work)
|| || jhawkins_at_primary.net (home)
|| ||
|| || >
|| || > HI ALL,
|| || > We have to load almost 3 millions records of average row
|| || size of 150
|| || bytes.
|| || > We are importing data using sqloader with ROWS=4000 and
|| || bindsize=8450000 .
|| || > We have adjusted the rollback segment to almost 10 m with
|| || 8 extents
|| || enough
|| || > for single transaction size and considering 30% rollback
|| || overhead. We
|| || > adjusted the OPTIMAL TO 10 M to have avoid rollback extension
|| || > Rollback segment, databuffer cache have hit ratio of 100%.
|| || >
|| || > The loading was fast only for first 10 commits but then it
|| || slowed like
|| || > snail. LOADING TOOK 22 hours in the first run on ORACLE8i
|| || NT4 128 megs RAM
|| || > .
|| || > SGA figures in M :
|| || > NAME VALUE
|| || > -------------------- ---------
|| || > Fixed Size .0676384
|| || > Variable Size 239.02734
|| || > Database Buffers 39.0625
|| || > Redo Buffers 7.8203125
|| || > ---------
|| || > sum 285.97779
|| || > ( we can't use direct path due to functions in sqlldr
|| || controlfile). .
|| || > Couldn't figure out the bottleneck yet.
|| || > Any ideas.
|| || > TIA
|| || > Azhar Siddiq,
|| || > DBA
|| || > LMK Resources
|| || >
|| || > --
|| || > Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || > --
|| || > Author:
|| || > INET: azhar_at_mathtech-pk.com
|| || >
|| || > Fat City Network Services -- (858) 538-5051 FAX:
|| (858) 538-5051
|| || > San Diego, California -- Public Internet access /
|| || Mailing Lists
|| || >
|| ||
|| --------------------------------------------------------------------
|| || > To REMOVE yourself from this mailing list, send an
|| E-Mail message
|| || > to: ListGuru_at_fatcity.com (note EXACT spelling of
|| 'ListGuru') 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).
|| || >
|| || >
|| ||
|| ||
|| || --
|| || Jim Hawkins
|| || Lead SAPR/3 Oracle Database Administrator
|| || MEMC Electronic Materials, Inc.
|| || 600 Pearl Drive
|| || St. Louis, MO 633376
|| || 9636) 474-7832
|| || jhawkins_at_memc.com (work)
|| || jhawkins_at_primary.net (home)
|| ||
|| || --
|| || Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| || --
|| || Author: Jim Hawkins
|| || INET: jhawkins_at_primary.net
|| ||
|| || Fat City Network Services -- (858) 538-5051 FAX:
|| (858) 538-5051
|| || San Diego, California -- Public Internet access /
|| || Mailing Lists
|| ||
|| --------------------------------------------------------------------
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: ListGuru_at_fatcity.com (note EXACT spelling of
|| 'ListGuru') 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.com
|| || --
|| || Author: Hillman, Alex
|| || INET: Alex.Hillman_at_usmint.treas.gov
|| ||
|| || Fat City Network Services -- (858) 538-5051 FAX:
|| (858) 538-5051
|| || San Diego, California -- Public Internet access /
|| || Mailing Lists
|| ||
|| --------------------------------------------------------------------
|| || To REMOVE yourself from this mailing list, send an E-Mail message
|| || to: ListGuru_at_fatcity.com (note EXACT spelling of
|| 'ListGuru') 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.com
|| --
|| Author: Mohan, Ross
|| INET: MohanR_at_STARS-SMI.com
||
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access /
|| Mailing Lists
|| --------------------------------------------------------------------
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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.com
|| --
|| Author: Hillman, Alex
|| INET: Alex.Hillman_at_usmint.treas.gov
||
|| Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|| San Diego, California -- Public Internet access /
|| Mailing Lists
|| --------------------------------------------------------------------
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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.com
-- 
Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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.com
-- 
Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') 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).