52 pages found, pages 1 to 10
https://sites.google.com/site/embtdbo/wait-event-documentation/oracle-buffer-exterminate    Similar Pages
... resize operations since instance startup.  V$SGA_CURRENT_RESIZE_OPS displays information about SGA resize ... dynamically resized Alter system set db_cache_size=50M;  V$SGA_DYNAMIC_COMPONENTS displays information about ... be a grow or a shrink of a dynamic SGA component.  V$SGA_DYNAMIC_FREE_MEMORY displays information about ...
http://www.dba-oracle.com/o10g_v_dollar_sga.htm    Similar Pages
... dynamic resizing: v$sga - Displays summary information about the system global area (SGA). v$sgainfo - Displays ... size, and free memory. v$sgastat - Displays detailed information about the SGA. v$sga_dynamic_components ... operations. v$sga_resize_ops - Displays information about the last 100 completed SGA resize operations. v$sga ...
http://oracledba.ru/fv11gr2/gv$sga_current_resize_ops.html    Similar Pages
... GV$SGA_CURRENT_RESIZE_OPS definition in Oracle Database 11.2 GV$SGA_CURRENT_RESIZE_OPS select sc.inst_id ... -- LAST_UPDATE_TIME DATE from x$kmgsct sc, v$parameter pn where (sc.parno = pn.num) and (sc.opcode ...
http://www.dba-oracle.com/menu_v$_views_list.htm    Similar Pages
... SQL Tuning v$lock v$sql v$sqlarea v$sesstat v$mystat v$sess_io v$sysstat v$statname v$osstat v$active_s ... v$latch v$librarycache v$lock v$locked_object v$log v$log_history v$logfile v$logmnr_contents v$logstdby v$ ... r v$pgastat v$process v$pwfile_users v$recover_file v$reserved_words v$resource_limit v$rollname v$rollstat ...
http://www.dba-oracle.com/t_amm_resize_scripts.htm    Similar Pages
... instance PGA, or a dynamic SGA component. v$sga_current_resize_ops -- displays information about dynamic ... resize operations, you have to look into v$sga_resize_ops and v$memory_resize_ops and see how many times ... resize operations.  See my notes on v$sga_dynamic_free_memory. v$memory_current_resize_ops -- displays ...
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/memory005.htm    Similar Pages
... instance PGA, or a dynamic SGA component. V$SGA_CURRENT_RESIZE_OPS Displays information about dynamic SGA ... View Description V$SGA Displays summary information about the system global area (SGA). V$SGAINFO Displays ... set). Cumulative values in V$PGASTAT are accumulated since instance startup. V$MEMORY_DYNAMIC_COMPONENTS ...
http://orakhoj.blogspot.in/2012_04_01_archive.html    Similar Pages
... instance PGA, or a dynamic SGA component. V$SGA_CURRENT_RESIZE_OPS  --  Displays information about dynamic ... TOP 5 Times Events, One has to look into v$sga_resize_ops and v$memory_resize_ops and see how many times ... various memory resizing operations you can use the V$MEMORY_RESIZE_OPS view. This view contains a list ...
http://orakhoj.blogspot.in/2012/04/top-5-timed-foreground-events-buffer.html    Similar Pages
... instance PGA, or a dynamic SGA component. V$SGA_CURRENT_RESIZE_OPS  --  Displays information about dynamic ... TOP 5 Times Events, One has to look into v$sga_resize_ops and v$memory_resize_ops and see how many times ... various memory resizing operations you can use the V$MEMORY_RESIZE_OPS view. This view contains a list ...
http://www.databaseskill.com/5006968/    Similar Pages
... v$sga_current_resize_ops v$db_cache_advice v$sga_dynamic ... dictionary V $ Views: [SQL] v $ access v $ sga v $ buffer_pool v $ sgastat v $ buffer_pool_statistics v $ s ... instance V $ Views: [SQL] v $ active_instances v $ sga v $ bgprocess v $ sgastat v $ database v $ bloc ...
https://oraclespin.wordpress.com/2009/04/19/automatic-shared-memory-management-asmm/#    Similar Pages
... l, V$SGAINFO, V$SGASTAT, V$SGA_DYNAMIC_COMPONENTS, V$SGA_DYNAMIC_FREE_MEMORY, V$SGA_RESIZE_OPS, V$SG ... components. V$SGA_DYNAMIC_FREE_MEMORY – Shows free memory available for future SGA memory resize. V$SGA_CU ... progress. V$SGAINFO – has usage and free size informaton on SGA size of different components. V$SGASTAT ...
Next Results