Why oracle.exe is taking 8G virtual; bytes,  memroy target can not go beyond 5G. How to minimized the virtual byte in perfmon

Advertisement

Dear Experts,
Please help me in checking why virtual bytes in perfmon is taking more than memory we allocated.
OS
Windows Server 2003 R2 Enterprise x64 Edition Service Pack 2 (build 3790)
ORACLE
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE    11.1.0.6.0      Production
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production
Total RAM on box is 8G
Page File
Windows virtual memory equal on C,D,E,F drives is set to  12273M and allocated now is 11262M
LPENABLED is not set
SQL> show parameter pga_
pga_aggregate_target   0
SQL> show sga
Total System Global Area 5344731136 bytes
Fixed Size                  2114736 bytes
Variable Size            4630514512 bytes
Database Buffers          671088640 bytes
Redo Buffers               41013248 bytes
SQL> show parameter memory
hi_shared_memory_address  0      
memory_max_target    5G                
memory_target      5G                  
shared_memory_address  0             
SQL> show parameter sga
lock_sga   FALSE                         
pre_page_sga     FALSE                   
sga_max_size   5G                     
sga_target      0
Question :
Why oracle.exe is taking 8G virtual; bytes,  memroy target can not go beyond 5G. How to minimized the virtual byte in perfmon
Thanks in advance your time and help.

Advertisement

John, Thanks for the reply.
Please find the output of query
SQL> select pool,sum(bytes) from v$sgastat group by pool;
POOL         SUM(BYTES)
              915543216
java pool      67108864
streams pool  268503944
shared pool  2147494008
large pool     67108864
SQL>
SQL> select * from v$pgastat;
NAME                                                                  VALUE UNIT
aggregate PGA target parameter                                    671088640 bytes
aggregate PGA auto target                                         147564544 bytes
global memory bound                                               104857600 bytes
total PGA inuse                                                   533962752 bytes
total PGA allocated                                               810819584 bytes
maximum PGA allocated                                            1244466176 bytes
total freeable PGA memory                                          90243072 bytes
process count                                                           450
max processes count                                                     588
PGA memory freed back to OS                                      1.9883E+10 bytes
total PGA used for auto workareas                                  28210176 bytes
maximum PGA used for auto workareas                                39973888 bytes
total PGA used for manual workareas                                       0 bytes
maximum PGA used for manual workareas                                531456 bytes
over allocation count                                                     7
bytes processed                                                  2.6307E+10 bytes
extra bytes read/written                                                  0 bytes
cache hit percentage                                                    100 percent
recompute count (total)                                               72720
19 rows selected.
SQL>
SQL>  show parameter _target
NAME                                 TYPE                             VALUE
archive_lag_target                   integer                          0
db_flashback_retention_target        integer                          1440
fast_start_io_target                 integer                          0
fast_start_mttr_target               integer                          0
memory_max_target                    big integer                      5G
memory_target                        big integer                      5G
pga_aggregate_target                 big integer                      0
sga_target                           big integer                      0
SQL> sho parameter sga_max
NAME                                 TYPE                             VALUE
sga_max_size                         big integer                      5G

October 11, 2015

Why oracle.exe is taking 8G virtual; bytes,  memroy target can not go beyond 5G. How to minimized the virtual byte in perfmon

Dear Experts, Please help me in checking why virtual bytes in perfmon is taking more than memory we allocated. OS Windows Server 2003 R2 Enterprise x64 Edition Service Pack 2 (build 3790) ORACLE Oracle Database 11g Enterprise Edition Release 11.1.0.6

Why is there no "none" option of payment methods? , Can not modify About Me!

Why is there no "none" option of payment methods? , Can not modify About Me!How to Get Apps From the App Store Without a Credit Card http://ipadhelp.com/ipad-help/how-to-get-free-apps-from-the-app-store-without-a- credit-card/ Creating an iTunes

How to replace the virtual system as the real system in the TMS?

Hi, I have a standard 3 systems TMS, which is 1 development system (real system, transport domain) and 2 virtual system(QAS and PRD). And now, I will install the QAS system and replace the virtual system as the real one, How can I do in TMS? I should

What's the point of a virtual copy if it can't be in a different folder from the master?

When I spotted "Make virtual copy" on the context menu, I thought "Great - I can organize my photos in different ways without wasting disk space by using aliases!" But when I tried to move the virtual copy to another folder, LR said No

HT5052 why i can not update to iOS5 even i have the 10.6.3 itunes???

why i an not upgrade to iOS5 even I have the 10.6.3 itnunes?Thanks, I searched more on google and found out that The MC086LL "3rd Gen" 8GB Ipod Touch cannot be updated to IOS 5. In actuality, only the 32GB and 64GB models were actually 3rd gen.

How to handle the double byte fonts in SAP ?

Hi all, Can anyone provide me some links/documentations on using double byte fonts in generating PDF outputs using Adobe Document Services (ADS). Thanks in advance. Regards, Ravikiran.CHi Ravikiran there are no SAP documents specifically on this topi

Why are my photos taking up 6.2GB when I do not have that many pictures in my photos?

I'm trying to reduce my used storage.  When I checked my storage it said that I had used 6.3GB in photos. I was very confused.  So I clicked on it and it said that 6.2GB are being used by your photo library. Now I only have about 100 pictures and vid

How to install the Virtual Sound send by Toshiba?

I am a complete novice. Toshiba have sent an update for Virtual Sound. It has been downloaded but I have no idea where the file should be stored. Is it left as a zip file or does it need unzipping? Any suggestions gratefully received. PeterHi I have

ABAP how to receive the control byte [] type of argument?

I use C # to write a control that contains a method: public byte [] CutBytePicture (); I refer to the following link: http://help.sap.com/saphelp_nw04/helpdata/en/85/c80ec6e9464c4ab8ca829a7b9e8a48/frameset.htm Use XSTING type to receive the byte [] t

How to flush the loaded bytes of a Sound object

Hi all, I've now been looking for a solution to my problem for quite a while now, but so far without any success, so I thought I'll give this forum a try.. maybe someone in here can help ;-) Ok here's the deal: I'm trying to create a simple audio pla

How to use the Oracle 10g JDBC OCI driver in JBoss ?

Greetings, I deployed ojdbc14.jar in JBoss and I created an Oracle datasource. I have the following questions: 1. In the datasource descriptor file I have: <connection-url>jdbc:oracle:oci:@(description=(address=(host=localhost)(protocol=tcp)(port=15

Why the applied_scn can not increase?

I use the Oracle stream while I find the change of the source databse can apply in the remote database,but the applied_scn can not increase for a long time after the change has success.If this scn can not increase,I can not delete some logfile,which

How to install the user_lock package for Oracle 11g(11.2.0.1.0)

Hi, I have installed Oracle DB 11g(11.2.0.1.0) on Windows 2003 server. According to my product requirement its say "you must install the user_lock package.". Can you Please help me how to install the user_lock package. Thanks Krishnaprovided lin

How to get the number of bytes at ethernt port using tcp/ip?

I have data with variable sizes.I am getting the data from another sytem using software C. How can I get the exact number of bytes coming at the port before using the read command so that the no. of bytes at port has to be given as the input to the t

Windows環境におけるOracle.exeプロセスのメモリ使用領域について

はじめまして Windows環境において.OracleDatabase11gを使用しております. Oracleインスタンスの初期化パラメータ"Memory_max_target"及び."Memory_target"で 1GBの設定をしております. 運用テスト中にOracle.exeプロセスが4GBものメモリ領域を使用している事が判明しました. (OSのカウンタログから) Windows版のOracle.exeプロセスのメモリ使用領域は.以下の通りである事を調査しまし

Can not create "Virtual Machine" - Oracle VM 3.0.2

I seem to have everything built right as previous VMs I have created. Steps taken so far (not sure if these are in the exact order but it is close): New NFS storage device. Created a new Repository using new NFS storage. Installed a new Oracle VM ser

Oracle.exe consuming 100% CPU on windows and database hang

Hi all, every time my oracle database is hanging when the application run, the problem is the oracle.exe consum 100% CPU but not memory and the server hang and the dabase is going to inaccessible, we need to restart oracle instance service or server

Why Oracle BPM Suite not included

Why Oracle BPM Suite is not included in this event as it is part of OFM ? Thanks in advance.Hi, Thanks for your question! The Middleware track in this particular Virtual Technology Summit is focused on mobile application development and architectures

Oracle.exe and java.exe are running my CPU 100% under XP Prof SP3

11gR1 oracle.exe and java.exe are running 100% CPU I have increased virtual memory to 4 gig I have defragmented the drive. I checked the drive for errors. I am searching the whole drive for viruses I do not have the problem with Redhat Fedora 12 runn

Application builder - Why my .exe opens with running status?

I have no problem in building the application. But when I open the application, it is always in running status. Thus I couldn't input control variables. The other applications I built don't have this problem though. The .vi and .exe files are attache