Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> How I know which acquired the Memories
Abdullah 2030
post Sep 25 2017, 01:59 AM
Post #1


Newbie
*

Group: Members
Posts: 4
Joined: 23-August 17
From: Riyadh
Member No.: 52,131



Hi Expert,

Is it any query to know in details which (applications, processes) acquired how much Memories. Suppose I have total memory 51 GB.

The Details have given below :::

Total Memory size: 52224 Megabytes

Page Summary ---- Pages------ Bytes ----- %Tot
---------------------- ---------------- ---------------- ----
Kernel--------------- 734377------ 5.6G----- 11%
Guest--------------- 0------ 0----- 0%
ZFS Metadata------ 83065------ 648.9M----- 1%
ZFS File Data------ 45822------ 357.9M----- 1%
Anon--------------- 5522249------ 42.1G----- 83%
Exec and libs------ 88353------ 690.2M----- 1%
Page cache-------- 27573------ 215.4M----- 0%
Free (cachelist)--- 472------ 3.6M----- 0%
Free (freelist)----- 182761------ 1.3G----- 3%
Total--------------- 6684672 51G

SQL> show parameter target

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer ----- 0
db_big_table_cache_percent_target string ----- 0
db_flashback_retention_target integer ----- 1440
fast_start_io_target integer ----- 0
fast_start_mttr_target integer ----- 0
memory_max_target big integer ----- 0
memory_target big integer ----- 0
parallel_servers_target integer ----- 512
pga_aggregate_target big integer ----- 2270M
sga_target big integer ----- 10944M


Thanks in Advance

Regards
Abdullah
Go to the top of the page
 
+Quote Post
burleson
post Sep 25 2017, 10:32 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,577
Joined: 26-January 04
Member No.: 13



Hi Abdullah,

When using AMM, oracle controls the RAM and you cannot see the allocations, since they may change dynamically.

Please read:

http://www.dba-oracle.com/t_amm_automatic_memory.htm

Good luck!


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Abdullah 2030
post Sep 27 2017, 08:46 AM
Post #3


Newbie
*

Group: Members
Posts: 4
Joined: 23-August 17
From: Riyadh
Member No.: 52,131



QUOTE (burleson @ Sep 25 2017, 11:32 AM) *
Hi Abdullah,

When using AMM, oracle controls the RAM and you cannot see the allocations, since they may change dynamically.

Please read:

http://www.dba-oracle.com/t_amm_automatic_memory.htm

Good luck!


Thanks
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd October 2017 - 03:47 PM