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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Two questions

Re: Two questions

From: <markp7832_at_my-deja.com>
Date: Tue, 14 Dec 1999 16:04:56 GMT
Message-ID: <835pr4$8bf$1@nnrp1.deja.com>


I will answer question 2 first. Try looking at this:  1 select to_char(to_date('9912101400','YYDDDSSSSS'),'YYYYMMDD HH24:MI:SS')
  2* from dual
OPS2> / TO_CHAR(TO_DATE('



19990501 00:23:20

OPS2> select to_char(to_date('99121','YYDDD') + 1400/86400,'YYYYMMDD HH24:MI:SS')
  2 from dual
  3 /

TO_CHAR(TO_DATE('



19990501 00:23:20

As for question 1 well:
1) Larger DB block size provides more space to hold rows before a new block must be obtained when empty blocks can be used, but changing the Oracle block size requires a database rebuild 2) Allocate multiple free lists to the table/indexes and run 2 insert jobs to reduce clock time, but not Oracle work. 3) Use sqlldr with direct load.

In article <835lof$545$1_at_nnrp1.deja.com>,   jdefreitas_at_my-deja.com wrote:
> Hi All -
>
> I have two quick questions - our environment is Oracle 8.0.5 running
> on Solaris.
>
> 1) What would be the best way to optimize a table for inserts?
Currently
> I've removed all indexes on the table & just accessing records
> based on ROWID. Are there any tricks like adjusting block size,
etc.,
> that could make inserts go faster?
>
> 2) Say that you have a data source that gives the day of the year in
> DDD form (e.g. today is day 348). A separate field gives the number
> of seconds since midnight of that daytIs there a quick way to
> transform these data into a Oracle DATE var?
>
> TIA,
> John de Freitas
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 14 1999 - 10:04:56 CST

Original text of this message

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