Re: Help....Oracle 8i Assistants not working !!!!!!

"Venkat Iyer" <venkat_p_iyer_at_yahoo.com> wrote in message news:3ab486d9.0_at_news2.tm.net.my...
> hi sybrand..
>
> thanx for looking over my prob.
> sorry about not givin more info..i should have done better than
> that......here is all u asked for...
>
> 1. I do not get any error messages. Nothing just happens.
> 2. Version --- Oracle 8i Enterprise Edition Release 8.1.5.0.0.
> 3. I have an IBM Thinkpad 600. running Windows NT Workstation 4.0
> 4. Memory -- 160 MB.
> 5. Output of show sga command at the Sql*Plus Command Prompt is as follows
:
> Total System Global Area -- 36437964 bytes
> Fixed Size -- 65484 bytes
> Variable Size -- 19521536 bytes
> Database Buffers -- 16777216 bytes
> Redo Buffers -- 73728 bytes
> 6. Oracle installed on C Drive : File System is FAT.
> 7. Capacity of the C Drive Partition is is 3.99 GB. Free Space on C is
 503
> MB.
> 8. The D: Partition is NTFS.
>
> This is the general background. If u need anything specific to diagnose
> this plz lemme know...i shall provide u with the relevant info
> immediately....
>
> Thanx a lot
> venkat
>
>

Very much looks like a virtual memory problem to me in combination with the JVM, as you have your pagefile on C:, right? with only 511 Mb free. I don't know what your pagefile settings are, but the guideline is max 2 times physical memory, so in your case 320 M and nothing more. You should also look into:
java_pool_size in init.ora. The default in 8.1.5 is 20M the minimum 1M. Set it to the minimum.
shared_pool_size, now below 20M, which is not overly big. SGA should not exceed 50m (one third of 160M, rounded down) Run msinfo or perfmon to see how much free memory you have. You will be shocked. I have seen systems (my own) after boot and one single excel session using all physical memory.

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Mar 18 2001 - 07:07:21 CST