Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using temp tables for staging databases?

Re: using temp tables for staging databases?

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Tue, 21 Oct 2003 07:54:44 -0800
Message-ID: <F001.005D3DEF.20031021075444@fatcity.com>


Too many drugs?
Not enough??

Here's an exact quote from the vendor -- they placed this line in our init file. Sadly, they did not plan for any overhead . . .

(the app was installed before we had an oracle db on board)

###############################################################################
# The db_block_size is set at 9 multiples of 512 bytes(OpenVMS block size)
# This is to accomodate the WO table. The average row length of the WO table is
# 900 bytes. A 4608 parameter allows 5 rows to be stored in a single Oracle bloc
k
# Do not change without consulting NWI!!!!!!!!!
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: barbarabbaker_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Tue Oct 21 2003 - 10:54:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US