Re: Oracle Back End Question

Nocera (nocera_at_haven.ios.com) wrote:
: I am running Oracle 7.0 on the GIS 3500 machine and currently involved
: in tuning the database and its configuration. I have noticed that
: when I hit a busy table that my application process is sucking up
: tremendous amounts of CPU time. When I truss or use crash to view the
: processes (oracle front end or back end) , it is communicating in a
: very inefficient manner. The oracle front end is doing small reads
: and writes using a FIFO to the oracle backend, which is also doing
: small reads and writes to the oracle front end.
 

: I am not using multi-threaded server.
 

: If anyone whats to observe this for themselves try using
 

: truss -p <pid of oracle front end>
: and
: truss -p <pid of oracle back end>
 

: My question is does anyone know of a option to tell Oracle to use
: shared memory to communicate between its front and backend instead of
: this FIFO. The problem with the FIFO is that small reads and writes
: are causing lots of context switching, and lots of copyin and copyout
: of kernel space. Using shared memory, the data can be passed between
: the front and back end without context switching and copying and
: improve its CPU utilization.

I believe you can do this by using the fast driver ("f:<sid>") though I am not sure if this is available anymore in v7.

jc Received on Tue Aug 22 1995 - 00:00:00 CEST