what loading can i expect from adding oracle?

Solaris 9, sparc.

I have oracle installed, and it's reasonably happy. I'm told the use is about to go a lot higher.

I think I have plenty of CPU and enough memory. I know how to watch for disk bottlenecks.

I don't know how to monitor things like semaphores, shared memory, message queues. Is there something I can do there? Does Oracle even use them?

Oracle 9.2.0.4.0
Infrastructure 9.2.0.3.0
App Server 9.2.0.3.0

I'm a sysadmin, not a DBA. I won't be asked to look at oracle proper.

Seems to me that until something starts to happen, ie, until I see a bottleneck, I won't be able to predict the bottleneck. I don't have any input on whether the coming oracle load will have any particular behavior, and if it did, it would only be someone else's prediction. This whole thing is new to everybody -- we've never had a previous system. Perhaps the user base won't even be interested in it....

Comments?

j.

-- 
Jay Scott		512-835-3553		gl_at_arlut.utexas.edu
Head of Sun Support, Sr. Operating Systems Specialist
Applied Research Labs, Computer Science Div.                   S224
University of Texas at Austin