当前位置:  数据库>oracle

oracle10g 知识篇

    来源: 互联网  发布时间:2017-03-17

    本文导语: 1.Oracle10g帐户被自动锁定问题.SQL> connect / as sysdba;Connected.SQL> ALTER PROFILE DEFAULT LIMIT2 FAILED_LOGIN_ATTEMPTS UNLIMITED;Profile altered. 2.10.2.0.1 Memory Notification: Library Cache Object loaded into SGASubject: Memory Notification: Library Cache Object Loaded Into SgaDoc ID: N...

1.Oracle10g帐户被自动锁定问题.

SQL> connect / as sysdba;
Connected.
SQL> ALTER PROFILE DEFAULT LIMIT
2 FAILED_LOGIN_ATTEMPTS UNLIMITED;

Profile altered.

2.10.2.0.1 Memory Notification: Library Cache Object loaded into SGA

Subject: Memory Notification: Library Cache Object Loaded Into Sga
Doc ID: Note:330239.1 Type: PROBLEM

Applies to:
Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.
Symptoms
The following messages are reported in alert.log after 10g Release 2 is installed.
Memory Notification: Library Cache Object loaded into SGA
Heap size 2294K exceeds notification threshold (2048K)
Changes
Installed / Upgraded to 10g Release 2
Cause
These are warning messages that should not cause the program responsible for these errors to fail. They appear as a result of new event messaging mechanism and memory manager in 10g Release 2. The meaning is that the process is just spending a lot of time in finding free memory extents during an allocate as the memory may be heavily fragmented. Fragmentation in memory is impossible to eliminate completely, however, continued messages of large allocations in memory indicate there are tuning opportunities on the application. The messages do not imply that an ORA-403X is about to happen.

Solution
In 10g we have a new undocumented parameter that sets the KGL heap size warning threshold. This parameter was not present in 10gR1. Warnings are written if heap size exceeds this threshold.

Set _kgl_large_heap_warning_threshold to a reasonable high value or zero to prevent these warning messages. Value needs to be set in bytes.

If you want to set this to 8192 (8192 * 1024) and are using an spfile:

(logged in as "/ as sysdba")

SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

SQL> shutdown immediate SQL> startup

SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 8388608

If using an "old-style" init parameter,

Edit the init parameter file and add

_kgl_large_heap_warning_threshold=8388608
In 10.2.0.2, the threshold is increased to 50MB after regression tests, so this should be a reasonable and recommended value.

请看:

Symptoms:
The following messages are reported in alert.log after 10g Release 2 is installed.
Memory Notification: Library Cache Object loaded into SGA
Heap size 2294K exceeds notification threshold (2048K)
--该情况一般发生在10.2.0.1中,因为_kgl_large_heap_warning_threshold这个版本中的缺省设置太小了。如果升级到10.2.0.2,则该情形可避免。因为它的缺省是50M,而不是2M。

























































    
 
 

您可能感兴趣的文章:

  • Linux下Oracle数据库相关知识集粹
  • Oracle相关基础知识教程集锦
  • oracle 创建数据库小知识
  • Oracle 知识问答
  • Oracle小知识集锦
  • oracle数据库入门知识简述
  • 想学习UNIX,LINUX,ORACLE方面的知识。请帮忙。
  • Oracle数据库基本知识学习笔记
  • 浅析基于Oracle案例知识库设计
  • Linux中Oracle使用相关知识集锦
  • 基础知识:Oracle数据库的启动方式
  • Oracle SQL基础知识
  • 浅谈应该如何理解Oracle的架构知识
  • Oracle系统表知识
  • Oracle数据库中安全知识介绍
  • Oracle日期函数知识整理
  • oracle 合并查询 事务 sql函数小知识学习
  • Oracle与连接相关知识
  • Oracle基本知识与问题解决
  • Oracle数据库相关知识
  • Oracle 10g和Oracle 11g网格技术介绍
  • 虚拟机装Oracle R12与Oracle10g
  • Oracle 10g中导出到Oracle 9的问题小结
  • 安装Oracle 10g忘记sys密码
  • Oracle 10G进程体系学习笔记
  • [官方最新消息]Oracle 10G 认证考试新变化
  • SOLARIS 下如何卸载ORACLE10G
  • oracle10g 数据备份与导入
  • 为何用dbstart启动oracle10g不好用
  • linux下oracle 10g如何完全卸载?
  • Oracle 10g client for Solaris
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • Oracle 12c发布简单介绍及官方下载地址
  • 在linux下安装oracle,如何设置让oracle自动启动!也就是让oracle那个服务自动启动,不是手动的
  • oracle 11g最新版官方下载地址
  • 请问su oracle 和su - oracle有什么不同?
  • Oracle 数据库(oracle Database)Select 多表关联查询方式
  • Oracle 数据库开发工具 Oracle SQL Developer
  • Oracle数据库(Oracle Database)体系结构及基本组成介绍
  • Oracle EBS R12 支持 Oracle Database 11g
  • 如何设置让Oracle SQL Developer显示的时间包含时分秒
  • SCO unix下安装oracle,但没有光盘,请大家推荐一个oracle下载站点(unix版本的)。谢谢!!!!
  • oracle中如何把表中具有相同值列的多行数据合并成一行
  • 请问大家用oracle数据库, 用import oracle.*;下的东西么? 还是用标准库?
  • Oracle 数据库(oracle Database)性能调优技术详解
  • Linux /$ORACLE_HOME $ORACLE_HOME
  • ORACLE日期相关操作
  • Linux系统下Oracle的启动与Oracle监听的启动
  • ORACLE数据库常用字段数据类型介绍
  • 请问在solaris下安装ORACLE,用root用户和用oracle用户安装有什么区别么?
  • Oracle 12c的九大最新技术特性介绍
  • 网间Oracle的连接,远程连接Oracle服务器??
  • ORACLE中DBMS_RANDOM随机数生成包
  • 请教:.profile中:if [ -d /opt/oracle/db01/app/oracle/product/9.2.0 ]是什么意思?


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3