Re: Oracle on Windows 2000 AS with /3GB flag

Hi Kathy,
thanks for your feedback.

What do you mean by "Watch out for hyperthreading on cpus" ? The test system that failed to start the database has 2 CPUs on hyperthreading mode.

I was planning to activate /3GB because I want to increase the value allocated to the SGA (currently 1336MB). And I would like to continue to use ASMM (Automatic Shared Memory Management).

I started to read your metalink article and I had a feeling of "deja-vu".

Thanks.
I also would like to thank everyone of the list who gave me some feedback.

Best Regards,
Ricardo.

On 7/17/07, kathy duret <katpopins21_at_yahoo.com> wrote:
>
> Check Metalink. You will find all sorts of docs on /3G
> I am surprised to hear it didn't work on the test system.
>
> Watch out for hyperthreading on cpus. This affects alot of hidden
> parameters.
> I had to take off the auto sga and decrease my sga target quite a bit.
>
> No not applicable on 64 bit Windows.
>
> I did have issues with /PAE switch and performance.
>
> --- Shamless self promotion....
> You might want to check out my article on turning my windows woes into wow
> article
> on Metalink. I had alot of Windows issues I needed to work through.
>
> I am working with Orakill now to kill session vs using alter session kill.
>
> I found on windows killing sessions didn't always work and orakill does.
> I will add my orakill info to my article next week hopefully.
>
> Kathy
>
> *Richard Saints <saints.richard_at_gmail.com>* wrote:
>
>
> Hello to you all,
> I'm planning to activate the /3GB flag on a Windows server running Oracle
> Database, in order to extend the memory that can be used by Oracle.
> The server has the following characteristics:
> HP Proliant DL380
> 2 x Pentium Xeon 3,2 GHz
> 4 GB of RAM
> HP Smart Array SCSI controller
> 2x36GB SCSI RAID 1 internal discs with 2 logical drives:
> C drive for OS
> D drive for Logs
> 4x146 GB SCSI RAID 5 internal discs with 1 logical drive:
> F drive for data
> Paging size on C drive (2048-4096)
> SO: Windows 2000 Advanced Server SP4
> The Oracle SGA Target is 1336 MB
>
> I would like to know if there is any special care that I should take,
> before I activate this flag on boot.ini.
> I read the Oracle Documentation, but I didn't found any particular aspect.
>
> I'm asking this because I had a bad experience with a test server where
> with the /3G flag was activated and the Oracle instance didn't startup. I
> still haven't figured out why.
>
>
> Thanks for all your attention.
>
> Best Regards,
> Ricardo.
>
>
>
> ------------------------------
> Boardwalk for $500? In 2007? Ha!
> Play Monopoly Here and Now<http://us.rd.yahoo.com/evt=48223/*http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow>(it's updated for today's economy) at Yahoo! Games.
>
>

--
http://www.freelists.org/webpage/oracle-l