Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Two questions
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('
OPS2> select to_char(to_date('99121','YYDDD') + 1400/86400,'YYYYMMDD
HH24:MI:SS')
2 from dual
3 /
TO_CHAR(TO_DATE('
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
![]() |
![]() |