Oracle Import Takes Longer When Using Buffered VxFS Then Using Unbuffered VxFS

(Doc ID 1018755.1)

Last updated on AUGUST 01, 2016

Applies to:

Solaris Operating System - Version 8.0 and later
All Platforms

Symptoms

Customer is importing data into an Oracle database under VxFS 3.3.3 and Solaris[TM] 7. At first the data rate is 2000 records a minute and gradually goes down to 100 records a minute. The stack of oracle import process when it is running slowly has vx_putpage_dirty vx_do_putpage and vx_fsync. A normal running import process has aiowait and kaio on the Oracle import stack.

###
CPU 0x8 is RUNNING READY CONFIGURED ENABLED ### CPU=8 (8) ###
### cpu addr 0x104a9b48

 

running thread addr 0x30030dcd9a0

pause thread addr 0x2a10034dd60

dispatched thread addr 0x30030dcd9a0

runrun is 0x1, kprunrun is 0x0

interrupt stack is 0x2a100349f50

interrupt thread list starts at 0x2a100345d60

cpu8: SUNW,UltraSPARC-II (upaid 8 impl 0x11 ver 0xa0 clock 400 MHz)

in_prom 0

***

process id 29785 is oracleORACIPP4 (LOCAL=NO), parent process is 1

uid is 0x81 0t129, gid is 0x74 0t116

thread addr 0x30030dcd9a0, proc addr 0x300059ed5b8, lwp addr 0x3000d088df0

t_state is 0x4 - TS_ONPROC

Scheduling info:

t_pri is 0x0, t_epri is 0x0, t_cid is 0x1

scheduling class is: TS

t_disp_time: is 0x60478b, 0t6309771

last switched: 0 secs ago on cpu 0x8

pc is 0x10007274, sp is 0x2a1008f9350, t_stk 0x2a1008f9af0

stack trace is:

unix: priv_rtt

INTERRUPT FRAME: 2a1008f9360

pc=0x0, npc=0x1041f130 (page_freelists+0)

unix: sfmmu_mlist_exit+0x4 (0x1,0x2a755c24000,0x7fffffff,0x0,0x2a1008f8c91,0x7816be84)

0x0+0x0 (0x0,0x0,0x0,0x0,0x0,0x0)

Stack may be incomplete TRY this stack 2a1008f9760

vxfs: vx_putpage_dirty+0xf4 (0x0,0x30002f7ad28,0x0,0x500,0x0,0x3000bcedc80)

vxfs: vx_do_putpage+0xa0 (0x3000bcedc80,0x0,0x400,0x500,0x0,0x3000ac4f2e8)

vxfs: vx_fsync+0x17c (0x3000bcedc80,0x34,0x30002f7ad28,0x3000bcedc80,0x3000ab6e588,0x0)

genunix: fdsync+0x30 (0x18a,0x10,0x18a,0x1a8a104,0xff1b5e10,0xd95a64)

unix: syscall_trap32+0xa8 (0x18a,0x10,0x1a6d9e4,0x1a8a104,0xff1b5e10,0xd95a64)

idlethread is 0x2a10030fd60

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms