Re: Import on oracle 8i slow?!?

SQL> SELECT NAME,VALUE FROM V_$PARAMETER WHERE NAME LIKE '%sort%';

NAME                                 VALUE
------------------------------------ -------------
nls_sort
sort_area_size                       65536
sort_area_retained_size              0
sort_multiblock_read_count           2

SQL> select Tablespace_name,Initial_Extent,Next_extent,pct_increase   2 from dba_tablespaces;

TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE --------------- -------------- ----------- ------------

SYSTEM            102400         102400            1
RBS               1048576        1048576           0
USERS             51200          51200             1
TEMP              102400         102400            0

SQL> select substr
(segment_name,1,10),segment_id,Initial_extent,Next_extent,pct_increase   2 from dba_rollback_segs;

SUBSTR(SEGMENT_NAME,1,10) SEGMENT_ID INITIAL_EXTENT NEXT_EXTENT PCT_INCREASE

------------------------------- ---------- -------------- ----------- --
----------
SYSTEM                                   0          51200
51200            0
SYSROL                                   1         102400
102400            0
RB0                                      2         153600
153600            0
RB1                                      3         153600
153600            0
RB2                                      4         153600
153600            0

In article <86hjlp$5no$1_at_mail.messe.de>,   "Reiner Neumann" <reiner.neumann_at_messe.de> wrote:
> Hi !
> What about your Rollback Segments ('storage next' - param)
> your Temporaray Tablespace (also 'storage next' - param)
> your init.ora - param SORT_AREA_SIZE ??
>
> Reiner
>
> <wy_at_fudan.edu> schrieb in im Newsbeitrag:
86hgdq$9eu$1_at_nnrp1.deja.com...
> > I have installed oracle 8i on a radhat6.1 (PIII 450 cpu 6.4G
harddisk
> > 196M memory)
> > Everything works well(query...) except the speed of import!
> > It takes 1.5 hour to import a 100M dmp file which contains a table
with
> > 360000 records!
> > In another computer installed radhat 5.1 and oracle 8.0.5 ,it import
> > more faster
> > (less than 15 minutes)
> > why ?
> > can someone help me get out the touble?
> > Thanks a lots.
> > YangWang.
> > Below are some system parameters!
> > [ora8_at_server450 ora8]$ vmstat 3
> > procs memory swap io
> > system cpu
> > r b w swpd free buff cache si so bi bo in cs
> > us sy id
> > 1 0 0 37532 5340 10808 30932 0 0 3 3 152 19
> > 1 0 99
> > 0 1 0 37532 4632 11148 31300 0 0 55 57 993 191
> > 2 3 95
> > 1 0 0 37532 3832 11468 31780 0 0 67 59 1111 181
> > 1 4 95
> > 0 1 0 37532 3144 11808 32128 0 0 55 57 1000 190
> > 1 3 96
> > 1 0 0 37532 3028 11816 32244 0 0 71 58 1136 188
> > 2 3 95
> > 1 0 0 37532 3068 11776 32244 0 0 59 59 1046 190
> > 1 3 96
> > 1 0 0 37532 2884 11788 32412 0 0 63 57 1062 188
> > 2 5 93
> > 0 1 0 37532 3028 11680 32376 0 0 60 59 1052 193
> > 2 5 94
> > 0 1 0 37532 3008 11712 32364 0 0 54 59 1006 193
> > 2 3 95
> > 1 0 0 37532 3096 11688 32300 0 0 55 59 1022 191
> > 0 5 95
> > 0 1 0 37632 3032 11664 32488 0 33 58 66 1096 204
> > 2 4 95
> > 0 1 0 37760 2984 11724 32604 0 43 66 68 1176 215
> > 2 4 94
> > 1 0 0 37760 3004 11616 32692 0 0 61 61 1081 196
> > 3 3 94
> > ?
> >
> > top result
> > 8:06pm up 1 day, 7:24, 2 users, load average: 1.08, 1.05, 0.94
> > 55 processes: 54 sleeping, 1 running, 0 zombie, 0 stopped
> > CPU states: 2.3% user, 4.9% system, 0.0% nice, 92.7% idle
> > Mem: 192840K av, 189736K used, 3104K free, 356588K shrd, 16272K
buff
> > Swap: 297160K av, 38092K used, 259068K free 30164K
> > cached
> >
> > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME
> > COMMAND
> > 1547 ora8 19 0 85532 83M 82636 D 0 5.9 44.3 2:41
> > oracle
> > 1585 ora8 9 0 1028 1028 824 R 0 1.3 0.5 0:00
top
> > 1 root 0 0 460 460 388 S 0 0.0 0.2 0:35
init
> > 2 root 0 0 0 0 0 SW 0 0.0 0.0 0:00
> > kflushd
> > 3 root 0 0 0 0 0 SW 0 0.0 0.0 0:01
> > kupdate
> > 4 root 0 0 0 0 0 SW 0 0.0 0.0 0:00
kpiod
> >
> > SVRMGR> connect internal
> > Connected.
> > SVRMGR> show sga
> > Total System Global Area 136945040 bytes
> > Fixed Size 64912 bytes
> > Variable Size 71270400 bytes
> > Database Buffers 65536000 bytes
> > Redo Buffers 73728 bytes
> > SVRMGR>
> >
> > [ora8_at_server450 ora8]$ df
> > Filesystem 1k-blocks Used Available Use% Mounted on
> > /dev/hda1 861728 702892 115064 86% /
> > /dev/hda5 5044156 3647028 1140896 76% /disk1
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 25 2000 - 04:51:19 CST