`
wwwxxx286
  • 浏览: 50309 次
  • 性别: Icon_minigender_1
  • 来自: 苏州
社区版块
存档分类
最新评论
文章列表
SELECT A.OWNER,        A.OBJECT_NAME,        B.XIDUSN,        B.XIDSLOT,        B.XIDSQN,        B.SESSION_ID,        B.ORACLE_USERNAME,        B.OS_USER_NAME,        B.PROCESS,        B.LOCKED_MODE,        C.MACHINE,        C.STATUS,        C.SERVER,        C.SID,        C.SERIAL#,        C.PROGRAM ...
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 3 14:51:26 2011 Copyright (c) 1982, 2008, Oracle.  All rights reserved. Enter user-name: *** Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and ...
Oracle 悲观锁 VS 乐观锁 悲观锁:悲观地认为从取出数据到提交修改的过程中,别的线程已经把该数据修改了,会引发更新丢失,所以需要在取数据的时候锁定该行。 select ... for update nowait; update ...; commit; 乐观锁:乐观地认为从取出数据到提交修改的过程中,别的线程不会修改这条数据,不需要在取出数据时就加锁。 需要做一些额外的处理,如多加一个字段(Number or Timestamp) select ...; update ... where number = old_number; update ... where timestamp = ...
Apache Active MQ 之Queue Pre-Condition: 安装Apache ActiveMQ并启动服务 消费者: package com.wx.jms.queue; import javax.jms.Connection; import javax.jms.JMSException; import javax.jms.Message; import javax.jms.MessageConsumer; import javax.jms.MessageListener; import javax.jms.Queue; import javax.jms. ...
Apache Active MQ 之Topic: Pre-Condition:安装好Apache ActiveMQ并启动服务 消费者: package com.wx.jms.topic; import javax.jms.Connection; import javax.jms.JMSException; import javax.jms.Message; import javax.jms.MessageConsumer; import javax.jms.MessageListener; import javax.jms.Session; import javax.j ...
Java 定时器之Spring Quartz: Spring Configuration: <!-- Spring Quartz Configuration --> <bean id="jobtask" class="org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean"> <property name="targetObject"> <ref bean="mail ...
Java 定时器之 Quartz: package com.wx.email.cronjob; import org.quartz.CronTrigger; import org.quartz.JobDetail; import org.quartz.Scheduler; import org.quartz.SchedulerException; import org.quartz.impl.StdSchedulerFactory; import com.wx.email.smtp.EmailNewsBiz; /** * @Class name: Cron ...
Java 定时器之 JDK Timer: package com.wx.jdktimer; import java.rmi.RemoteException; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.Timer; import java.util.TimerTask; import javax.ejb.CreateException; ...
Java 定时器之commonj timer,jms & mdb驱动,servlet 初始化: Business: package com.wxs.simple.ejb; import javax.annotation.PostConstruct; import javax.annotation.PreDestroy; import javax.ejb.Remote; import javax.ejb.Stateless; import javax.naming.InitialContext; import com.wx.simple.listener.Schedu ...
Java 定时器之EJB Timer: Interface: package test.timersession; import javax.ejb.Remote; import javax.ejb.Timer; @Remote public interface TimerSession { public void setTimer(long intervalDuration, String timerName); public void timeout(Timer timer); } EJB: package test.timersessi ...
在Solaris10 X86上安装Weblogic10.3详细过程 Weblogic Cluster配置过程
root: #groupadd oinstall #groupadd dba #useradd -g oinstall -G dba –d /export/home/oracle -m oracle #passwd oracle set password #mkdir /opt/oracle #mkdir /opt/oracle/oradata #chown -R oracle:oinstall /opt/oracle #chown -R oracle:oinstall /opt/oracle/oradata #chmod -R 775 /opt/oracle #chmod -R 775 ...
基于Solaris10: prstat –a : 任务管理器 top ifconfig –a :IP管理 ifconfig hm0 down ifconfig hmo 192.168..... netmask 255..... up df –h 磁盘空间 服务管理 svcadm enable –rt ssh svcadm restart ssh svcadm clear system/boot-archive 删除文件/目录 rm filename rm –r directoryname oracle: 授权Debug: grant debug any procedure, debug ...
SELECT UPPER(F.TABLESPACE_NAME) "表空间名",        D.TOT_GROOTTE_MB "表空间大小(M)",        D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)",        TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,                      2),                '990.99') "使用比&q ...

ORA-00600 解决方案

ORA-00600: 数据库突然断电会导致不能正常启动,解决方法如下: shutdown immediate; >connect sys as sysdba > startup mount > alter database recover until cancel using backup controlfile; (ignored promtings). > alter database recover continue default; (until it says “no such file or directory” or there are no more ...
Global site tag (gtag.js) - Google Analytics