设为首页收藏本站

Bo's Oracle Station

查看: 1252|回复: 0

(52-37)第58次:2016-03-02星期三

[复制链接]

60

主题

98

帖子

1469

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1469
发表于 2016-3-3 10:23:21 | 显示全部楼层 |阅读模式
(52-35)上完1Z0-052第13章
(52-36)上完1Z0-053第13章
(52-37)上完1Z0-053第14章

2016-03-02a.sql:
  1. select  * from v$memory_dynamic_components
  2. minus
  3. select  * from v$sga_dynamic_components;

  4. select  s.COMPONENT  ,  s.CURRENT_SIZE/1024/1024
  5. from v_$sga_dynamic_components s;

  6. ---
  7. select  * from v$fixed_table  where name like 'V%ADVICE';

  8. select  * from V$MEMORY_TARGET_ADVICE;

  9. select  * from V$SGA_TARGET_ADVICE;

  10. select  * from V$PGA_TARGET_ADVICE;

  11. select  * from V$DB_CACHE_ADVICE;

  12. select  * from V$SHARED_POOL_ADVICE;
  13. --
  14. select  * from V$MEMORY_TARGET_ADVICE;

  15. select  * from V$SGA_TARGET_ADVICE;

  16. select  * from V$PGA_TARGET_ADVICE;

  17. select  * from V$SHARED_POOL_ADVICE;

  18. select  * from V$DB_CACHE_ADVICE;

  19. ---

  20. select  s.SID, s.USERNAME, n.NAME, se.VALUE
  21.   from v_$session s , v_$sesstat se , v_$statname n
  22.   where s.SID=se.SID  and se.STATISTIC#=n.STATISTIC#
  23.   and s.TERMINAL='pts/3'  and n.NAME='redo size';
  24.   
  25.   select  o.object_name, o.status
  26.    from dba_objects o
  27.     where o.owner='HR' and o.object_name='PROC1';
  28.    
  29.     alter procedure hr.proc1 compile;




  30. select  * from v$sga_dynamic_components;

  31. alter system set db_keep_cache_size=1M;

  32. select  t.buffer_pool
  33. from dba_tables t where t.owner='HR' and t.table_name='EMPLOYEES';

  34. alter table hr.employees storage ( buffer_pool keep ) ;


  35. select  * from v_$db_object_cache o  where
  36. o.OWNER='HR' and o.NAME='PROC1';

  37. begin
  38.   dbms_shared_pool.keep( 'HR.PROC1');
  39. end;
  40. ---

  41. select  * from v$memory_resize_ops;

  42. ---

  43. select   s.sql_id  ,s.sql_hash_value
  44. from v_$session s where s.terminal='pts/3';

  45. ---
  46. select  * from v$sqlarea where sql_id='dh73w3ss300hp';

  47. ---

  48. select  * from dba_tab_stat_prefs;
  49. begin
  50. dbms_stats.set_table_prefs('SH','SALES','STALE_PERCENT','13');

  51. begin
  52.    dbms_stats.gather_schema_stats('SH');
  53.    end;
  54. end;

复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2019-1-19 08:36 , Processed in 0.155942 second(s), 24 queries .

快速回复 返回顶部 返回列表