apple_7898的专栏

1、数据库参数alter system set audit_trail=db scope=spfile sid=*;shutdown immediate;startup2、设置审计内容audit select table, update table, insert table, delete table by audit_test by access;

在AIX5.3平台中，Oracle10gR2的版本Oracle10.2.0.1，在关闭shutdown immediate数据库时，报错ORA-24323，alert文件出现错误PMON failed to acquire latch, see PMON dump。1、关闭数据库报错[iapbill]$sqlplus /nologSQL*Plus: Release 10.2

Connected to Oracle9i Enterprise Edition Release 9.2.0.6.0 Connected as system SQL> select count(*) from boss_wnx.ts_b_detailbill_chk1;select count(*) from boss_wnx.ts_b_detailbill_chk1ORA-0

存储过程执行后手工停止后，发现存储过程无法编译，报ora-04021错误。1、查找正在执行的存储过程select distinct s1.*,oc.* from V$DB_OBJECT_CACHE   oc,　　v$object_dependency od,　　dba_kgllock         w,　　v$session           s1　　where oc.

测试数据库的NLS_NCHAR_CHARACTERSET和正式环境不一致，需要由UTF8修改为AL16UTF16。1、停数据库SQL> alter system checkpoint;System altered.SQL> alter system checkpoint;System altered.SQL> alter system switch logfile;Sy

一、4月5日更换了风扇后，应用程序又出现ORA-04030的错误：错误号:-4030  错误信息:ORA-04030: out of process memory when trying to allocate 16776728 bytes (QERHJ hash-joi,QERHJ Hash Table Entries)select * from etl.t_sys_total_exec

grant select 遇到的问题，长时间hang住了：1、SQL> grant select on szgrp.td_m_depart_all to szhrms;grant select on szgrp.td_m_depart_all to szhrmsORA-01013: user requested cancel of current operation2、分析原因：

oracle报4030错误，开了SR，oracle回复测试主机的内存分配情况，经测试内存分配没有问题。 1. Detect whether 3.5GB memory can be allocated by oracle account1)Save the program as mem.c+++++++++++++/* mem.c */#include #include

在oracle10g数据库建dblink到11g数据库，完成后访问远端11g表报ora-01017错误，其实输入的用户名和密码正确。 原因dblink从低版本到高版本需要修改一个参数，在11g中将认证的case sensitive关闭，才可以通过database link访问11g中的表。 修改后正常访问远端数据库。 SQL> alter system set sec_ca