PMON的一个关键功能就是在进程失败的时候清理死进程及其相关的资源。我们来观看一下PMON清理死进程的过程,100246事件可以跟踪PMON的行为。Event 10246 - Trace PMON ProcessThis event can be used to trace the actions of the PMON background processThis event can only be enabled in the init.ora fil...【阅读全文】
CentOS5.8,root用户登录,vi编辑/etc/gdm/custom.conf文件,注意不是/usr/share/gdm/defaults.conf文件,已经不推荐使用该文件来配置gdm了。1)编辑/etc/gdm/custom.conf,内容如下:[daemon][security]AllowRemoteRoot=true[xdmcp]Port=177Enable=1[gui][greeter][chooser][debug][servers]只需要加入上面三句就可以了。然后重启桌面:gdm-restart。注意关闭防火墙: service iptables stop; --关闭ip【阅读全文】
create or replace procedure sp_pro6(spname char) is --创建一个过程附带一个输入形参v_price goods.unitprice%type;--变量类型begin--执行部分select unitprice into v_price from goods where goodsname=spname;if v_price<5 then--条件语句update goods set unitprice=unitprice*1.1 where goodsname=spname;end if;end;
exec sp_pro【阅读全文】
Beginning
with Oracle10G, when statistics are gathered for a table, the old statistics are
retained so should there be any problem with performance of queries dependent
on those statistics, the old ones can be restored.How
long does Oracle retain the statistics for ?
The
default peri【阅读全文】
unix培训http://www.cuug.com/根据Metalink Note<Database Shutdown Immediate Takes Forever, Can Only
Do Shutdown Abort [ID 332177.1]>:
Database Shutdown Immediate Takes Forever, Can Only Do Shutdown Abort [ID
332177.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.4.0
【阅读全文】