Home » Infrastructure » Windows » High memory utilisation from a Oracle Process (Windows 2016)
High memory utilisation from a Oracle Process [message #681436] Fri, 17 July 2020 00:02 Go to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
Hi,

I will try to describe the scenario below :

Oracle is allocated 35GB RAM on server
Server has 64GB total RAM
Server has 9GB virtual memory.

Now , the issue is that Oracle is utilising 43GB RAM.
So is it possible that the extra memory used by Oracle is from servers virtual memory.

If yes then why it is showing in physical memory.
Re: High memory utilisation from a Oracle Process [message #681438 is a reply to message #681436] Fri, 17 July 2020 00:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Show us what you do and get to post these figures.
It is not clear if these figures refer to all Oracle processes/threads, to SGA...

Re: High memory utilisation from a Oracle Process [message #681440 is a reply to message #681436] Fri, 17 July 2020 07:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Akmmhto wrote on Thu, 16 July 2020 22:02
Hi,

I will try to describe the scenario below :

Oracle is allocated 35GB RAM on server
Server has 64GB total RAM
Server has 9GB virtual memory.

Now , the issue is that Oracle is utilising 43GB RAM.
So is it possible that the extra memory used by Oracle is from servers virtual memory.

If yes then why it is showing in physical memory.

You have an idle & meaningless observation.
There is no problem that needs to be solved.
You should spend your time on more productive tasks.

Re: High memory utilisation from a Oracle Process [message #681441 is a reply to message #681440] Fri, 17 July 2020 08:35 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
Appreciate your immediate decision to judge my observation.

How ever thanks , I will find it in my way.

By the way actually here we get alerts from solrwind tool about high memory utilisation from Oracle services and when I tried to get some details about it then I found it that Oracle is consuming more memory then actually allocated to it.

I checked memory consumed by every Oracle process but that was not enough to tell the customer that this is the culprit of high memory utilisation.

Even Oracle support is suggesting to restart the instance without actually understanding the root cause.

The same is happening here....you guys are genius ...keep it up.

[Updated on: Fri, 17 July 2020 08:36]

Report message to a moderator

Re: High memory utilisation from a Oracle Process [message #681442 is a reply to message #681441] Fri, 17 July 2020 09:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Which metric at what value shows that RAM is a system bottleneck?

A problem is that Windows badly misreport RAM usage when Oracle is installed because every Oracle session/thread has SGA size mapped into its memory space.
Therefore WINDOWS overcounts RAM usage.
If you manually add up the "MEMORY" reported by Windows for all Oracle processes, it routinely total more than TOTAL RAM.
Simply put Windows misreport RAM usage when Oracle database is running. Best wishes at solving a problem that does not really exist.
How will you decide when problem has been resolved?

At Windows/OS level, how do you know when system would benefit from more RAM?
Re: High memory utilisation from a Oracle Process [message #681443 is a reply to message #681442] Fri, 17 July 2020 09:34 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
So how can I deal in this case. Customer asking from database team that why Oracle is consuming such high memory.
There is no issue at all. But as per customer concern we need to provide some findings that this is the actual reason.

As described by you above is really good to study , I will definitely read more on that.

My last question is : suppose I have given sga 2GB PGA 500MB

So , Oracle is limited to 2.5GB or it will use more memory as it's requirment?
Re: High memory utilisation from a Oracle Process [message #681444 is a reply to message #681443] Fri, 17 July 2020 09:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Akmmhto wrote on Fri, 17 July 2020 07:34
So how can I deal in this case. Customer asking from database team that why Oracle is consuming such high memory.
There is no issue at all. But as per customer concern we need to provide some findings that this is the actual reason.

As described by you above is really good to study , I will definitely read more on that.

My last question is : suppose I have given sga 2GB PGA 500MB

So , Oracle is limited to 2.5GB or it will use more memory as it's requirment?

You have neglected to provide Oracle version to 4 decimal places & many answers are VERSION dependent.

post FULL results from SQL below

SELECT * FROM V$VERSION;

Oracle is MORE, much more, than just SGA & PGA.
Using COPY & PASTE, show us what you do & how system responds that make you claim Oracle is using "high memory".

CONSIDER to show yourself & us the total MEMORY SIZE for every Oracle process running.
Re: High memory utilisation from a Oracle Process [message #681445 is a reply to message #681443] Fri, 17 July 2020 10:07 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Akmmhto wrote on Fri, 17 July 2020 15:34
So how can I deal in this case. Customer asking from database team that why Oracle is consuming such high memory.
There is no issue at all. But as per customer concern we need to provide some findings that this is the actual reason.

As described by you above is really good to study , I will definitely read more on that.

My last question is : suppose I have given sga 2GB PGA 500MB

So , Oracle is limited to 2.5GB or it will use more memory as it's requirment?
The 2GB limit on SGA is a hard limit, he 500MB limit on PGA is a soft limit: a target that in many cases may be exceeded, possibly hugely. In a little databgase instance I have here, the memory usage is as folllows:
orclz>
orclz> show parameter sga_Target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_target                           big integer 1G
orclz> show parameter pga_Aggregate_target

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 250M
orclz> select sum(bytes) from v$sgastat;

SUM(BYTES)
----------
1073738560

orclz> select sum(PGA_ALLOC_MEM) from v$process;

SUM(PGA_ALLOC_MEM)
------------------
         357537446

orclz>
so the total memory usage right now is over the 1.25GB budgetted. I'm not too good with Windows, but the Task Manager shows me the "Peak Working Set" of memory for the oracle.exe process as being 1.5GB, so I think my instance has never gone very far over budget. Perhaps your has. That could be because you simply have not given Oracle as much PGA as it needs, or it could be that your application needs some tuning. So it comes back to MC's question: from where did you get the figures about which you are concerned?

--update: corrected some numbers

[Updated on: Fri, 17 July 2020 10:10]

Report message to a moderator

Re: High memory utilisation from a Oracle Process [message #681453 is a reply to message #681445] Sun, 19 July 2020 00:03 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
Oracle_Memory_Utilization
---------------------------------
https://pasteboard.co/Jik8eA5.png

OS Details
------------
https://pasteboard.co/Jik8Ij0.jpg

Virtual Memory Details
---------------------------
https://pasteboard.co/Jik8R07.png


SQL> select * from v$version;

BANNER                                                                               CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production                0
PL/SQL Release 12.2.0.1.0 - Production                                                    0
CORE    12.2.0.1.0      Production                                                                0
TNS for 64-bit Windows: Version 12.2.0.1.0 - Production                                   0
NLSRTL Version 12.2.0.1.0 - Production                                                    0

SQL> sho parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
allow_group_access_to_sga            boolean     FALSE
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     TRUE
sga_max_size                         big integer 31808M
sga_min_size                         big integer 0
sga_target                           big integer 0
unified_audit_sga_queue_size         integer     1048576
SQL>
SQL> sho parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit                  big integer 8G
pga_aggregate_target                 big integer 4G
SQL>
SQL>
SQL>
SQL>
SQL> select sum(bytes)/1024/1024 from v$sgastat;

SUM(BYTES)/1024/1024
--------------------
          31807.9979

SQL> select sum(pga_alloc_mem)/1024/1024 from v$process;

SUM(PGA_ALLOC_MEM)/1024/1024
----------------------------
                   943.84967

SQL>
SQL> COLUMN alme HEADING "Allocated MB" FORMAT 99999D9
SQL> COLUMN usme HEADING "Used MB" FORMAT 99999D9
SQL> COLUMN frme HEADING "Freeable MB" FORMAT 99999D9
SQL> COLUMN mame HEADING "Max MB" FORMAT 99999D9
SQL> COLUMN username FORMAT a15
SQL> COLUMN program FORMAT a22
SQL> COLUMN sid FORMAT a5
SQL> COLUMN spid FORMAT a8
SQL> SET LINESIZE 300
SQL> SELECT s.username, SUBSTR(s.sid,1,5) sid, p.spid, logon_time,
  2  SUBSTR(s.program,1,22) program , s.process pid_remote,
  3  s.status,
  4  ROUND(pga_used_mem/1024/1024) usme,
  5  ROUND(pga_alloc_mem/1024/1024) alme,
  6  ROUND(pga_freeable_mem/1024/1024) frme,
  7  ROUND(pga_max_mem/1024/1024) mame
  8  FROM v$session s,v$process p
  9  WHERE p.addr=s.paddr
 10  ORDER BY pga_max_mem,logon_time;

USERNAME        SID   SPID     LOGON_TIM PROGRAM                PID_REMOTE               STATUS    Used MB Allocated MB Freeable MB   Max MB
--------------- ----- -------- --------- ---------------------- ------------------------ -------- -------- ------------ ----------- --------
                1     14272    27-FEB-20 ORACLE.EXE (TT02)      14272                    ACTIVE        1.0          1.0          .0      1.0
                800   15468    27-FEB-20 ORACLE.EXE (TT01)      15468                    ACTIVE        1.0          1.0          .0      1.0
                716   11036    27-FEB-20 ORACLE.EXE (QM02)      11036                    ACTIVE        1.0          1.0          .0      1.0
                479   20076    27-FEB-20 ORACLE.EXE (O000)      20076                    ACTIVE        1.0          1.0          .0      1.0
                173   22604    28-FEB-20 ORACLE.EXE (O001)      22604                    ACTIVE        1.0          1.0          .0      1.0
                512   39788    19-JUL-20 ORACLE.EXE (W00C)      39788                    ACTIVE        1.0          1.0          .0      1.0
                227   24508    19-JUL-20 ORACLE.EXE (J004)      24508                    ACTIVE        1.0          1.0          .0      1.0
                668   49024    19-JUL-20 ORACLE.EXE (W003)      49024                    ACTIVE        1.0          1.0          .0      1.0
                69    12544    27-FEB-20 ORACLE.EXE (PSP0)      12544                    ACTIVE        1.0          1.0          .0      1.0
                154   12568    27-FEB-20 ORACLE.EXE (GEN1)      12568                    ACTIVE        1.0          1.0          .0      1.0
                86    12552    27-FEB-20 ORACLE.EXE (VKTM)      12552                    ACTIVE        1.0          1.0          .0      1.0
                120   12560    27-FEB-20 ORACLE.EXE (MMAN)      12560                    ACTIVE        1.0          1.0          .0      1.0
                222   12584    27-FEB-20 ORACLE.EXE (VKRM)      12584                    ACTIVE        1.0          1.0          .0      1.0
                188   12596    27-FEB-20 ORACLE.EXE (PMAN)      12596                    ACTIVE        1.0          1.0          .0      1.0
                137   12868    27-FEB-20 ORACLE.EXE (SMCO)      12868                    ACTIVE        1.0          1.0          .0      1.0
                528   12984    27-FEB-20 ORACLE.EXE (PXMN)      12984                    ACTIVE        1.0          1.0          .0      1.0
                579   13004    27-FEB-20 ORACLE.EXE (FENC)      13004                    ACTIVE        1.0          1.0          .0      1.0
                664   13028    27-FEB-20 ORACLE.EXE (TMON)      13028                    ACTIVE        1.0          1.0          .0      1.0
AMDSMTR         401   63152    19-JUL-20 python.exe             1320:656                 INACTIVE      1.0          1.0          .0      1.0
CCMSPFM         20    59540    19-JUL-20 NBM_MPPS.exe           6736:5328                INACTIVE      1.0          1.0          .0      1.0
                35    12536    27-FEB-20 ORACLE.EXE (PMON)      12536                    ACTIVE        1.0          1.0          .0      1.0
                52    12540    27-FEB-20 ORACLE.EXE (CLMN)      12540                    ACTIVE        1.0          1.0          .0      1.0
                239   12588    27-FEB-20 ORACLE.EXE (SVCB)      12588                    ACTIVE        1.0          1.0          .0      1.0
                171   12572    27-FEB-20 ORACLE.EXE (DIAG)      12572                    ACTIVE        1.0          1.0          .0      1.0
                562   13000    27-FEB-20 ORACLE.EXE (ASMB)      13000                    ACTIVE        1.0          1.0          .0      1.0
SAPMII          621   27348    19-JUL-20 JDBC Thin Client       1234                     INACTIVE      1.0          1.0          .0      1.0
POLLCS          451   63844    19-JUL-20 ORACLE.EXE             5408:8584                INACTIVE      1.0          1.0          .0      1.0
                545   12996    27-FEB-20 ORACLE.EXE (RBAL)      12996                    ACTIVE        1.0          1.0          .0      1.0
TSKMTR          362   12160    17-JUL-20 AMDSMTRTSKService.exe  8600:1                   INACTIVE      1.0          1.0          .0      1.0
POLLCS          452   19016    19-JUL-20 ORACLE.EXE             3764:16228               INACTIVE      1.0          1.0          .0      1.0
POLLCS          381   62012    19-JUL-20 ORACLE.EXE             3764:7396                INACTIVE      1.0          1.0          .0      1.0
AMDSMTR         788   66544    17-JUL-20 AMDSMTRService.exe     4160:1                   INACTIVE      1.0          1.0          .0      1.0
AMDSMTR         265   46756    17-JUL-20 AMDSMTRService2.exe    6268:1                   INACTIVE      1.0          1.0          .0      1.0
CMSDBA          193   38340    19-JUL-20 AMDSMTRService.exe     36728:1                  INACTIVE      1.0          1.0          .0      1.0
MPPS            722   47336    19-JUL-20 w3wp.exe               8316:2                   INACTIVE      1.0          1.0          .0      1.0
                89    44520    19-JUL-20 ORACLE.EXE (J003)      44520                    ACTIVE        1.0          2.0          .0      2.0
AMDSMTR         435   27512    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          2.0          .0      2.0
                54    58880    19-JUL-20 ORACLE.EXE (W002)      58880                    ACTIVE        1.0          2.0          .0      2.0
                682   11128    19-JUL-20 ORACLE.EXE (W000)      11128                    ACTIVE        2.0          2.0          .0      2.0
                409   12756    27-FEB-20 ORACLE.EXE (LG00)      12756                    ACTIVE        2.0          2.0          .0      2.0
                443   12872    27-FEB-20 ORACLE.EXE (LG01)      12872                    ACTIVE        2.0          2.0          .0      2.0
TSKMTR          308   6784     09-JUL-20 rsession.exe           14024:20356              INACTIVE      1.0          2.0          .0      2.0
AMDSMTR         127   23892    09-JUL-20 rsession.exe           14024:20356              INACTIVE      1.0          2.0          .0      2.0
AMDSMTR         60    19496    09-JUL-20 rsession.exe           14024:20356              INACTIVE      1.0          2.0          .0      2.0
TSKMTR          121   1200     09-JUL-20 rsession.exe           14024:20356              INACTIVE      1.0          2.0          .0      2.0
TSKMTR          143   30780    18-JUL-20 rsession.exe           5588:7708                INACTIVE      1.0          2.0          .0      2.0
AMDSMTR         232   57168    18-JUL-20 rsession.exe           5588:7708                INACTIVE      1.0          2.0          .0      2.0
TSKMTR          266   9064     18-JUL-20 rsession.exe           5588:7708                INACTIVE      1.0          2.0          .0      2.0
CMSDBA          412   34064    19-JUL-20 CMSWCFService1.exe     54760:49432              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          415   59180    19-JUL-20 CMSWCFService2.exe     18124:21968              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          244   49496    19-JUL-20 CMSWCFService4.exe     17320:31712              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          537   27392    19-JUL-20 CMSWCFService5.exe     34848:10656              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          45    16456    19-JUL-20 TiltDriveDataTransferS 79072:19044              INACTIVE      1.0          2.0         1.0      2.0
CMSDBA          247   57512    19-JUL-20 PDMDataTransferService 47416:14392              INACTIVE      1.0          2.0         1.0      2.0
AMDSMTR         161   62700    19-JUL-20 Rscript.exe            13400:7832               INACTIVE      1.0          2.0          .0      2.0
TSKMTR          223   48108    19-JUL-20 Rscript.exe            13400:7832               INACTIVE      1.0          2.0          .0      2.0
CMSDBA          190   53368    19-JUL-20 TiltDriveDataTransferS 53308:63212              INACTIVE      1.0          2.0          .0      2.0
CMSDBA          195   36340    19-JUL-20 PDMDataTransferService 43068:26628              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          399   14976    19-JUL-20 PDMDataTransferService 43068:26628              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          733   26832    19-JUL-20 PDMDataTransferService 43068:26628              INACTIVE      1.0          2.0          .0      2.0
CMSDBA          503   15476    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          531   58220    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         350   11160    19-JUL-20 TiltDriveDataTransferS 53308:64344              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         243   36200    19-JUL-20 TiltDriveDataTransferS 53308:64344              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         293   29276    19-JUL-20 TiltDriveDataTransferS 53308:64344              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         453   40712    19-JUL-20 PDMDataTransferService 43068:24504              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         685   62776    19-JUL-20 PDMDataTransferService 43068:24504              INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         570   61672    19-JUL-20 PDMDataTransferService 43068:24504              INACTIVE      2.0          2.0          .0      2.0
POLLCS          79    9880     19-JUL-20 ORACLE.EXE             5408:8096                INACTIVE      2.0          2.0          .0      2.0
CMSDBA          23    42660    14-JUL-20 TiltDriveDataTransferS 17728:27160              ACTIVE        1.0          2.0          .0      2.0
POLLCS          400   43712    19-JUL-20 ORACLE.EXE             5408:1704                INACTIVE      2.0          2.0          .0      2.0
POLLCS          617   53552    19-JUL-20 ORACLE.EXE             5408:7248                INACTIVE      2.0          2.0          .0      2.0
PMSMDBA         43    46540    19-JUL-20 TiltDriveDataTransferS 53308:64344              INACTIVE      1.0          2.0          .0      2.0
PMSMDBA         449   63920    19-JUL-20 PDMDataTransferService 43068:24504              INACTIVE      1.0          2.0          .0      2.0
SAPMII          281   1312     19-JUL-20 JDBC Thin Client       1234                     INACTIVE      2.0          2.0          .0      2.0
                766   15852    27-FEB-20 ORACLE.EXE (AQPC)      15852                    ACTIVE        2.0          2.0          .0      2.0
POLLCS          690   11576    15-JUL-20 ORACLE.EXE             2260:22236               INACTIVE      2.0          2.0          .0      2.0
                93    36680    18-JUL-20 ORACLE.EXE (Q004)      36680                    ACTIVE        2.0          2.0          .0      2.0
                312   64384    18-JUL-20 ORACLE.EXE (Q001)      64384                    ACTIVE        2.0          2.0          .0      2.0
CMSDBA          652   30544    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          211   43240    19-JUL-20 FFT_Algorithm_Implemen 9480:1                   ACTIVE        2.0          2.0          .0      2.0
CMSDBA          463   29188    19-JUL-20 CMSWCFService.exe      12260:51576              ACTIVE        2.0          2.0          .0      2.0
CMSDBA          789   55560    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          2.0          .0      2.0
CMSDBA          737   60124    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          2.0          .0      2.0
SYS             95    60536    19-JUL-20 ORACLE.EXE (J002)      60536                    ACTIVE        2.0          2.0          .0      2.0
                147   62232    19-JUL-20 ORACLE.EXE (J001)      62232                    ACTIVE        2.0          2.0          .0      2.0
PMSMDBA         309   25892    19-JUL-20 PDMDataTransferService 43068:20964              INACTIVE      2.0          2.0          .0      2.0
AMDSMTR         192   28528    18-JUL-20 rsession.exe           5588:7708                INACTIVE      2.0          2.0          .0      2.0
MPPS            274   48608    18-JUL-20 w3wp.exe               6024:2                   INACTIVE      2.0          3.0          .0      3.0
CMSDBA          481   35952    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          3.0          .0      3.0
PMSMDBA         275   30316    19-JUL-20 TiltDriveDataTransferS 53308:64344              INACTIVE      2.0          3.0         1.0      3.0
PMSMDBA         618   46576    19-JUL-20 PDMDataTransferService 43068:24504              INACTIVE      2.0          3.0          .0      3.0
                205   12580    27-FEB-20 ORACLE.EXE (DBRM)      12580                    ACTIVE        1.0          3.0          .0      3.0
CMSDBA          348   53260    19-JUL-20 DataMigrator.exe       39216:29368              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          467   10316    19-JUL-20 CMSWCFService.exe      12260:36500              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          501   36472    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          514   18136    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          37    58876    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          516   66048    19-JUL-20 CMSWCFService.exe      12260:34556              ACTIVE        2.0          3.0          .0      3.0
CMSDBA          8     20780    19-JUL-20 CMSWCFService.exe      12260:34556              INACTIVE      2.0          3.0          .0      3.0
                460   12968    27-FEB-20 ORACLE.EXE (RECO)      12968                    ACTIVE        2.0          3.0          .0      3.0
AMDSMTR         124   61128    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         210   37620    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         462   40848    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         413   33036    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         333   45512    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         498   44348    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         334   39064    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         751   27240    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         802   57428    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         599   50760    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         477   24748    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         297   45884    10-JUL-20 python.exe             10800:16612              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         499   57368    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         108   24300    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         517   21700    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         549   64128    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         582   47780    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         770   20492    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         245   26352    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         315   54184    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         450   11240    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         721   45912    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         55    60780    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         111   32280    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         600   46396    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         735   39288    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         633   26852    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         755   48032    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         347   44548    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         257   11748    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         719   9664     10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         177   62604    10-JUL-20 python.exe             19820:17164              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         128   33084    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         569   64380    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         326   55384    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         649   22412    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         790   51508    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         144   62828    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         291   38024    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         586   7656     10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         110   16940    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         529   7448     10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         669   26836    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         25    22092    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         380   62488    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         7     24740    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         18    25800    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         511   54388    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         773   54420    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         805   30216    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         2     46536    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         24    35260    10-JUL-20 python.exe             6240:8772                INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         363   36604    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         230   23720    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         636   46412    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         359   48140    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         620   32792    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         681   50336    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         349   63884    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         40    8964     10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         752   47200    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         705   59556    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         803   54892    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         39    65096    10-JUL-20 python.exe             23308:2096               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         702   44020    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         603   64152    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         634   60460    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         214   59500    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         162   42092    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         461   63904    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         332   62492    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         376   29252    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         650   13532    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         59    48528    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         74    5340     10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         207   65716    10-JUL-20 python.exe             21652:23236              INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         394   28856    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         732   61444    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         71    47576    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         552   45084    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         630   16832    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         666   52852    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         771   55972    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         585   19416    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         277   23428    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         262   62296    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         604   47152    10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         602   7964     10-JUL-20 python.exe             17636:4164               INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         299   14708    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         478   37224    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         580   25252    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         568   24448    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         282   54908    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         651   9956     19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         671   53980    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         756   52760    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         294   45020    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         105   34840    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         571   21992    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         683   54844    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
AMDSMTR         259   52156    19-JUL-20 python.exe             1320:656                 INACTIVE      2.0          3.0          .0      3.0
CMSDBA          72    10908    09-JUL-20 rsession.exe           14024:20356              INACTIVE      2.0          3.0         1.0      3.0
SAPMII          427   47852    17-JUL-20 JDBC Thin Client       1234                     INACTIVE      2.0          2.0          .0      3.0
TSKMTR          197   7088     19-JUL-20 Rscript.exe            13400:7832               INACTIVE      2.0          3.0          .0      3.0
                494   12976    27-FEB-20 ORACLE.EXE (LREG)      12976                    ACTIVE        2.0          3.0          .0      3.0
CMSDBA          122   43980    18-JUL-20 rsession.exe           5588:7708                INACTIVE      2.0          3.0          .0      3.0
                426   12760    27-FEB-20 ORACLE.EXE (SMON)      12760                    ACTIVE        2.0          3.0         1.0      3.0
SAPMII          703   33784    19-JUL-20 JDBC Thin Client       1234                     INACTIVE      2.0          2.0         1.0      3.0
SAPMII          428   54076    19-JUL-20 JDBC Thin Client       1234                     INACTIVE      2.0          2.0         1.0      3.0
CMSDBA          615   39104    19-JUL-20 ORACLE.EXE (J000)      39104                    ACTIVE        2.0          2.0          .0      3.0
AMDSMTR         106   21664    14-JUL-20 python.exe             19588:21276              INACTIVE      2.0          3.0          .0      3.0
CMSDBA          181   37728    17-JUL-20 Toad.exe               1928:23680               INACTIVE      2.0          2.0          .0      3.0
                103   12556    27-FEB-20 ORACLE.EXE (GEN0)      12556                    ACTIVE        2.0          3.0          .0      3.0
AMDSMTR         76    21512    03-JUL-20 pythonw.exe            17144:7384               INACTIVE      2.0          3.0          .0      4.0
CMSDBA          178   58732    18-JUL-20 rsession.exe           5588:7708                INACTIVE      2.0          2.0          .0      4.0
MPPS            364   29336    23-MAY-20 NBM_MPPS.exe           6736:5328                INACTIVE      3.0          4.0         1.0      4.0
CMSDBA          157   24352    09-JUL-20 rsession.exe           14024:20356              INACTIVE      3.0          4.0         1.0      4.0
SAPMII          417   8108     17-JUL-20 JDBC Thin Client       1234                     INACTIVE      2.0          3.0         1.0      4.0
PMSMDBA         97    23564    18-JUL-20 PdMSMWCFService.exe    59764:66112              INACTIVE      3.0          3.0          .0      5.0
                392   12752    27-FEB-20 ORACLE.EXE (CKPT)      12752                    ACTIVE        2.0          3.0          .0      5.0
SYSTEM          163   56352    19-JUL-20 sqlplus.exe            1448:12752               ACTIVE        3.0          5.0          .0      5.0
                256   12604    27-FEB-20 ORACLE.EXE (DIA0)      12604                    ACTIVE        5.0          6.0          .0      6.0
CMSDBA          768   60008    19-JUL-20 MatModelWCFService.exe 12880:13172              INACTIVE      2.0          2.0          .0      6.0
CMSDBA          172   16028    19-JUL-20 Rscript.exe            13400:7832               ACTIVE        2.0          3.0          .0      6.0
CMSDBA          5     64576    17-JUL-20 Toad.exe               12532:16232              INACTIVE      2.0          3.0         1.0      7.0
                375   12748    27-FEB-20 ORACLE.EXE (LGWR)      12748                    ACTIVE        2.0          3.0          .0      8.0
CMSDBA          209   29008    17-JUL-20 Toad.exe               1928:23680               INACTIVE      3.0          4.0          .0      9.0
CMSDBA          550   61912    19-JUL-20 CMSWCFService.exe      12260:30016              INACTIVE      3.0          3.0          .0     10.0
MPPS            87    57444    13-JUL-20 SQL Developer          596                      INACTIVE      3.0          3.0          .0     10.0
                749   15988    27-FEB-20 ORACLE.EXE (CJQ0)      15988                    ACTIVE        4.0          5.0         1.0     10.0
CMSDBA          156   38052    19-JUL-20 CMSWCFService2.exe     38044:63700              INACTIVE      3.0          4.0          .0     10.0
                801   12592    27-FEB-20 ORACLE.EXE (Q003)      12592                    ACTIVE        3.0          3.0          .0     12.0
                307   12732    27-FEB-20 ORACLE.EXE (DBW2)      12732                    ACTIVE       10.0         13.0          .0     14.0
                290   12612    27-FEB-20 ORACLE.EXE (DBW1)      12612                    ACTIVE       10.0         12.0          .0     14.0
                358   12744    27-FEB-20 ORACLE.EXE (DBW5)      12744                    ACTIVE       10.0         13.0          .0     14.0
                325   12736    27-FEB-20 ORACLE.EXE (DBW3)      12736                    ACTIVE       10.0         12.0          .0     15.0
                341   12740    27-FEB-20 ORACLE.EXE (DBW4)      12740                    ACTIVE       10.0         12.0          .0     15.0
CCMSPFM         715   22228    23-MAY-20 ORACLE.EXE             3796:29336               INACTIVE      2.0          3.0         1.0     15.0
PMSMDBA         534   59312    17-JUL-20 Toad.exe               76092:64644              INACTIVE      6.0          7.0         1.0     15.0
                273   12608    27-FEB-20 ORACLE.EXE (DBW0)      12608                    ACTIVE       10.0         13.0          .0     15.0
AMDSMTR         57    51220    16-JUL-20 Toad.exe               3588:3324                INACTIVE      6.0          7.0          .0     19.0
                783   13788    27-FEB-20 ORACLE.EXE (TT00)      13788                    ACTIVE       18.0         20.0          .0     20.0
CMSDBA          411   26356    14-JUL-20 AMDSMTRService3.exe    14948:1                  INACTIVE      3.0          4.0          .0     22.0
AMDSMTR         139   32632    07-JUL-20 AMDSMTRService2.exe    29520:1                  INACTIVE      3.0          4.0          .0     22.0
                596   13008    27-FEB-20 ORACLE.EXE (MMON)      13008                    ACTIVE       22.0         23.0         1.0     25.0
                698   11616    27-FEB-20 ORACLE.EXE (MARK)      11616                    ACTIVE       60.0         60.0          .0     60.0
CMSDBA          229   50928    17-JUL-20 Toad.exe               12532:16232              INACTIVE      4.0          6.0         1.0     68.0
CMSDBA          484   8284     26-JUN-20 CMSWCFService3.exe     17644:28972              INACTIVE     23.0         26.0          .0     70.0
                429   32320    22-JUN-20 ORACLE.EXE (MMNL)      32320                    ACTIVE      150.0        159.0          .0    159.0

250 rows selected.

SQL>

[Updated on: Sun, 19 July 2020 00:15]

Report message to a moderator

Re: High memory utilisation from a Oracle Process [message #681455 is a reply to message #681453] Sun, 19 July 2020 09:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
nice numbers.
What do you do next?
Re: High memory utilisation from a Oracle Process [message #681456 is a reply to message #681455] Mon, 20 July 2020 01:05 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
Nothing , Thanks Smile

Re: High memory utilisation from a Oracle Process [message #681463 is a reply to message #681456] Mon, 20 July 2020 07:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
How did high memory utilization get resolved?
Re: High memory utilisation from a Oracle Process [message #681464 is a reply to message #681463] Mon, 20 July 2020 08:03 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
It is still unsolved , I am trying other ways to find out more on it.
I have provided all details here as per my understanding but didn't got any proper solution.

So , if I get any solution I will post here..
Re: High memory utilisation from a Oracle Process [message #681469 is a reply to message #681464] Tue, 21 July 2020 01:32 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I have provided all details here as per my understanding
You have shown details of how much memory your instance is using: about 33GB. You have not shown anything that justifies your assertion that it is actually using 43GB RAM. Why do you think that it is?
Re: High memory utilisation from a Oracle Process [message #681487 is a reply to message #681469] Wed, 22 July 2020 10:40 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
As per my knowledge I have shared task manager screenshot , which clearly shows the memory usage.
And at the 1st point anyone will see that only ,whether a system admin or a customer (In windows case).

However from inside Oracle there is no way actually to defend that the data shown by windows task manager is wrong.

That's why I was curious about it , But unfortunately no success till now..
Re: High memory utilisation from a Oracle Process [message #681519 is a reply to message #681487] Sat, 25 July 2020 22:40 Go to previous messageGo to next message
Akmmhto
Messages: 38
Registered: September 2018
Member
Server restarted by System admin , now memory utilisation by Oracle is normal.

Root cause is unknown.
Re: High memory utilisation from a Oracle Process [message #681521 is a reply to message #681519] Sun, 26 July 2020 12:46 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Root cause is Windows OS reports Oracle's memory usage incorrectly due to SGA mapped into every client process.
BTW, *NIX has same problem.
Previous Topic: Installation gets to a certain point and then just goes backwards
Next Topic: temporary table
Goto Forum:
  


Current Time: Thu Mar 28 18:47:18 CDT 2024