We do have Oracle 7 (7.2.3 at first, 7.3.2 now) on a 969-120 and a 979-300.
You may experience troubles connecting in C/S mode to Oracle if you do not
have enough contiguous disk space available. Also, adding memory would help,
but if you tell that when access to Oracle seems to be slow but you cannot
put the finger on it with glance, there might be something else. When a
Oracle server process takes a lot of ressources (I/O, CPU, etc), you should
see it in glancexl as the TNSLSNR process. In fact, the server process is
ORACLE.PUB.something, but glancexl sees it as TNSLSNR. Anyway, you should
see it if it the cause of your troubles.
If you're running with 7.2.3 or older, the only MPE way to get an exhaustive
list of the server processes is to make a SHOWPROC ;SYSTEM and than count
each occurence of ORACLE.PUB.something (because they're all system
processes). Starting with 7.3.2, every single process server runs under the
NETSRV2 process, which is lunched thru a job: you can then see then thru
glancexl. Also, the PIN can be seen thru some Oracle's dynamic views
(V$stuff).
At last, by default Oracle uses only 4 Mb memory if you don't tell to use
more (thru the db_block_buffers and shared_pool_size parameters). So maybe
it is your case. To use more, you should change these parms and run the
Oracle sgautil tool to reserve more memory (to accomodate the new value of
your parms).
Well, setting an Oracle DB is not as easy as SQL/Server7 (or TurboImage),
but once you get thru it, it becomes quite satisfying!
Michel Gauthier
Donohue Inc.
<[log in to unmask]> wrote in message news:7k3d4j$u14$1@nnrp1.deja.com...
> Hi,
>    I've been around 3000 technology for quite a while, but this is my
> first post here in a lot of years - if anyone has any thoughts or
> suggestions, I'd certainly appreciate the feedback.
>
>    I am currently looking at a 969/120 that is running Oracle version 7,
> the system looks to me to be a bit stretched in terms of system memory
> and the overall performance of the box can be poor when certain key
> processes are initiated by the users.
>    When using glancexl it may appear that all is well, but it is clear
> that is not necessarily so. A lot of child processes are hidden under an
> oracle batch job .... is there any feature of glancexl that I can use to
> get a better handle on what is going on? Alternatively, are there any
> system tools (3rd party?) that might help?
>
>     Some technical details are: 512MB memory, 42GB disc storage (mostly
> ST15150W), 10 to 30 Oracle users (but which don't show up as sessions),
> only 5 or 6 actual 3000 sessions (that do show up) and a handlful of
> batch jobs.
>
>     Increasing the 512MB would obviously help, but I'd like to get some
> supporting evidence that the system is not performing under the current
> configuration.
>
> TIA,
>
> Robert.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.