Slow response time for LOBs

View previous topic View next topic Go down

Slow response time for LOBs

Post  giby.varghese@gmail.com on Mon Jun 07, 2010 10:26 am

The response time is slow for large object (LOB) writes when using Oracle with
Sun Solaris and Veritas Volume manager. The following symptoms were found in
internal tests:
 An ITSM 7.0 Incident submission took 18 seconds.
 The Oracle process clocked CPU for almost the same amount of time (18 seconds).
 The arserverd process took approximately 2 seconds of CPU time.
 The SQL log from arserver showed an SQL time of approximately 1 second.
 The pstack output for the Oracle server process shows a wait on the fdsync system call.

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

Re: Slow response time for LOBs

Post  giby.varghese@gmail.com on Mon Jun 07, 2010 10:26 am

Enable Quick I/O for Oracle database files to resolve the issue.

giby.varghese@gmail.com

Posts : 107
Points : 222
Reputation : 3
Join date : 2009-11-11

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum