iya, maksudnya saya selama ini make perintah console-based, macam top, free,vmstat, dll.
Tanya lagi, berhubungan dengan ini juga, bagaimana cara membatasi jumlah maksimum memori PGA (kalau SGA bisa diatur di Enterprise Manager) ? On 2/21/07, Ade Octora <[EMAIL PROTECTED]> wrote: > > bukankah dengan remote SSH perintah TOP juga masih bisa d gunakan? > > Thanks And Regards, > ============================ > Ade Veria Octora > Email : [EMAIL PROTECTED] <Octora01%40yahoo.com> > > > ----- Original Message ---- > From: indra syafruddin <[EMAIL PROTECTED] <indra.e00%40gmail.com>> > To: [email protected] <indo-oracle%40yahoogroups.com> > Sent: Wednesday, February 21, 2007 9:31:08 AM > Subject: Re: [indo-oracle] tanya memori > > pake perintah "top", servernya bukan di sini, jadi saya cuma bisa remote > > dengan ssh, kalau GUI, koneksinya kurang kuat. > > On 2/21/07, Johannes Christian <johannes.sitorus@ pacomnet. com> wrote: > > > > > > Free memori itu anda lihat darimana? > > > utntuk lebih real nya, silahkan lihat di task manager, used real memori > > > nya berapa > > > > > > --jo-- > > > > > > indra syafruddin wrote: > > > > > > > > Saya menginstall aplikasi oracle 10gR2 di server RHEL4 Itanium 64 bit, > > > > 32 GB > > > > RAM > > > > ketika saya jalankan oracle, memori yg tersisa masih sekitar 30,5. > > > > > > > > Tetapi ketika saya menjalankan query : Select count(*) from > test.LOADER, > > > > free memori nya langsung drop hingga 20 MB. > > > > Dari tablespace, ukuran table LOADER sekitar 20 GB (4 [EMAIL PROTECTED] > > > disk), 140 > > > > juta > > > > record. > > > > > > > > Setelah oracle saya matikan, free memori masih berkisar di 3,5 GB. SGA > > > di > > > > database 3,5 GB dengan maksimum 8 GB. dengan PGA 1,5 GB. > > > > > > > > Ada yang tahu kenapa ? > > > > > > > > Terima kasih sebelumnya.. .. > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial,helvetica,clean,sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% > arial,helvetica,clean,sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0; > } > #ygrp-tpmsgs{ > font-family:Arial; > clear:both; > } > #ygrp-vitnav{ > padding-top:10px; > font-family:Verdana; > font-size:77%; > margin:0; > } > #ygrp-vitnav a{ > padding:0 1px; > } > #ygrp-actbar{ > clear:both; > margin:25px 0; > white-space:nowrap; > color:#666; > text-align:right; > } > #ygrp-actbar .left{ > float:left; > white-space:nowrap; > } > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana; > font-size:77%; > padding:15px 0; > } > #ygrp-ft{ > font-family:verdana; > font-size:77%; > border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px; > } > > #ygrp-vital{ > background-color:#e0ecee; > margin-bottom:20px; > padding:2px 0 8px 8px; > } > #ygrp-vital #vithd{ > font-size:77%; > font-family:Verdana; > font-weight:bold; > color:#333; > text-transform:uppercase; > } > #ygrp-vital ul{ > padding:0; > margin:2px 0; > } > #ygrp-vital ul li{ > list-style-type:none; > clear:both; > border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight:bold; > color:#ff7900; > float:right; > width:2em; > text-align:right; > padding-right:.5em; > } > #ygrp-vital ul li .cat{ > font-weight:bold; > } > #ygrp-vital a { > text-decoration:none; > } > > #ygrp-vital a:hover{ > text-decoration:underline; > } > > #ygrp-sponsor #hd{ > color:#999; > font-size:77%; > } > #ygrp-sponsor #ov{ > padding:6px 13px; > background-color:#e0ecee; > margin-bottom:20px; > } > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px; > margin:0; > } > #ygrp-sponsor #ov li{ > list-style-type:square; > padding:6px 0; > font-size:77%; > } > #ygrp-sponsor #ov li a{ > text-decoration:none; > font-size:130%; > } > #ygrp-sponsor #nc { > background-color:#eee; > margin-bottom:20px; > padding:0 8px; > } > #ygrp-sponsor .ad{ > padding:8px 0; > } > #ygrp-sponsor .ad #hd1{ > font-family:Arial; > font-weight:bold; > color:#628c2a; > font-size:100%; > line-height:122%; > } > #ygrp-sponsor .ad a{ > text-decoration:none; > } > #ygrp-sponsor .ad a:hover{ > text-decoration:underline; > } > #ygrp-sponsor .ad p{ > margin:0; > } > o {font-size:0;} > .MsoNormal { > margin:0 0 0 0; > } > #ygrp-text tt{ > font-size:120%; > } > blockquote{margin:0 0 0 4px;} > .replbq {margin:4;} > --> > > __________________________________________________________ > Don't pick lemons. > See all the new 2007 cars at Yahoo! Autos. > http://autos.yahoo.com/new_cars.html > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
