376 pages found, pages 1 to 10
https://oraclespin.wordpress.com/tag/vsga_resize_ops/    Similar Pages
... l, V$SGAINFO, V$SGASTAT, V$SGA_DYNAMIC_COMPONENTS, V$SGA_DYNAMIC_FREE_MEMORY, V$SGA_RESIZE_OPS, V$SG ... V$SGA_RESIZE_OPS « Oracle Spin – Flimatech Blog Oracle Spin – Flimatech Blog Sharing Our Database Experience ... Oracle Password for Expiration Posts Tagged ‘V$SGA_RESIZE_OPS’ Automatic Shared Memory Management (ASMM) ...
http://blog.tanelpoder.com/files/scripts/sgares.sql    Similar Pages
... final_size , status , start_time , end_time FROM v$sga_resize_ops ORDER BY start_time / ...
http://165.225.144.123/OPSGSamples/Ch18/sga_resize_ops.sql    Similar Pages
... sga_resize_ops.sql rem Description: Query on V$SGA_RESIZE_OPS rem rem From 'Oracle Performance Survival ... ROUND(final_size / 1048576) final_mb, status FROM v$sga_resize_ops o WHERE end_time > SYSDATE - NUMTODSINTERVAL(24 ...
https://jonathanlewis.wordpress.com/my-stats/feed/    Similar Pages
... Resizing: a script to report resizing operations (v$sga_resize_ops) What have I done: a script to report the ... Resizing: a script to report resizing operations (v$sga_resize_ops) What have I done: a script to report the ...
http://www.dba-oracle.com/o10g_v_dollar_sga.htm    Similar Pages
... operations. v$sga_resize_ops - Displays information about the last 100 completed SGA resize operations. v$sga ... 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 ...
http://www.dba-oracle.com/menu_v$_views_list.htm    Similar Pages
... v$sesstat v$sga v$sga_dynamic_components v$sga_resize_ops v$sgastat v$sort_segment v$sort_usage v$s ... esize_ops v$sga_resize_ops v$sga_dynamic_components v$sga_dynamic_free_memory v$pgastat v$sql_workar ... SQL Tuning v$lock v$sql v$sqlarea v$sesstat v$mystat v$sess_io v$sysstat v$statname v$osstat v$active_s ...
http://www.dba-oracle.com/t_amm_resize_scripts.htm    Similar Pages
... resize operations, you have to look into v$sga_resize_ops and v$memory_resize_ops and see how many times ... Also see these important notes on v$memory_resize_ops. v$sga_resize_ops -- Displays information about the ... resize operations.  See my notes on v$sga_dynamic_free_memory. v$memory_current_resize_ops -- displays ...
http://permalink.gmane.org/gmane.comp.db.oracle.general/19753    Similar Pages
... 0 Then looking at v$sga_resize_ops: select component , AVG(FINAL_SIZE)/102 ... MAX(FINAL_SIZE)/1024/1024/1024 "MAX FINAL" from v$sga_resize_ops group by component / COMPONENT ... of 101GB. Looking at v$sga I see this: select name, value/1024/1024/1024 from v$sga / NAME ...
https://fredericktang.wordpress.com/2007/09/20/resizing-db_cache_size/    Similar Pages
... operations are recorded in v$sga_resize_ops: SQL> select * from v$sga_resize_ops; COMPONENT       OPER_T ...
http://cbohl.blogspot.de/2010/12/dynamic-memory-components.html    Similar Pages
... e, 'YYYY-MM-DD HH24:MI:SS') "DATE" from v$sga_resize_ops ; -- version 11g show sga; -- memory dynamic ... "USER_SPECIFIED_SIZE" , last_oper_type "TYPE" from v$sga_dynamic_components ; -- sga dynamic free memory ... select current_size/1024/1024 "Current Size MB" from v$sga_dynamic_free_memory ; -- sga resize operations ...
Next Results