m77m78的个人空间

暂无签名

  • 博客访问: 267658
  • 博文数量: 177
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-25 15:43
  • 认证徽章:
个人简介

上善若水,厚德载物

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2007年(150)

2006年(18)

2005年(2)

2004年(7)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2007-06-18 22:15:03

要求归档模式 SQL>; archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 14 Next log sequence to archive 16 Current log sequence 16[@more@]要求归档模式 SQL>; archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 14 Next log sequence to archive 16 Current log sequence 16 ------------- 先看用户管理的热备份......【阅读全文】

阅读(477) | 评论(0) | 转发(0)

发布时间:2007-06-18 22:11:51

什么是latch?latch是一种低级别的序列化的内存锁,用于保护SGA中的共享内存结构.(1)确保内核代码序列执行;(2)防止因缓存区崩溃导致的物理块的坏块任何内核代码在执行前,必须获取latch,执行完后释放latch.latch通常通过两种方式来获取:immediate和willing to wait.当进程以immeidate方式请求latch失败时,控制权将转会到进程并产生一次immediate miss;当进程以willing to wait方式请求latch时将以”spinning and sleeping”的循环方式重复请求获取latch,spin一次如果仍然不能得到latch则sleep一定间隔(间隔时间成指数级增长)直至获得latch或达......【阅读全文】

阅读(776) | 评论(0) | 转发(0)

发布时间:2007-06-18 22:07:48

keeper.sqlMarking objects for keeping in the library cache is vital to library cache and shared pool performance. This script is intended to be run regularly from cron to automate keeping. It follows our "keep everything that moves" philosophy. It keeps all in-use keep-able database objects. It also keeps some often reused cursors early in the life of the instance, while more than 20% of the shared pool body is still reserved in permanent memory. It is smart enough to avoid keeping cur......【阅读全文】

阅读(3888) | 评论(0) | 转发(0)

发布时间:2007-06-18 21:55:51

Oracle Tables[@more@]GeneralTable Related Data Dictionary Objectstab$col$ DBAALLUSERdba_col_commentsall_col_commentsuser_col_commentsdba_external_tablesall_external_tablesuser_external_tablesdba_external_locationsall_external_locationsuser_external_locationsdba_partial_drop_tabsall_partial_drop_tabsuser_partial_drop_tabsdba_tablesall_tablesuser_tablesdba_tab_colsall_tab_colsuser_tab_colsdba_tab_columnsall_tab_columnsuser_tab_columnsdba_tab_col_statisticsall_tab_col_statisticsuser_tab_col_statist......【阅读全文】

阅读(1450) | 评论(0) | 转发(0)

发布时间:2007-06-18 21:45:38

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.[@more@]ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.*************************************************************You have the following choices to free up space fromflash recovery area:1. Consider changing your RMAN retention policy.If you are using dataguard, then consider changing yourRMAN archivelog ......【阅读全文】

阅读(789) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册