2014年06月_历史五千年

11月 10月 07月 06月 05月

原创 ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], []

2014-06-24 22:14:51 451

转载 -bash: /home/oracle: is a directory

分类： oracle杂记 2013-07-18 16:17 730人阅读评论(0) 收藏举报安装oracle 11g过程中，创建oracle用户以及配置了.bash_profile文件后，退出oracle用户，然后重新su - oracle后出现：-bash: /home/oracle:

2014-06-24 21:50:14 4083 1

转载 win7下jdk安装环境变量配置

新本本，新系统，还是得把武器给装配好。下面图文记录win7系统下的jdk的安装和配置。1、下载jdk 地址：http://java.sun.com/javase/downloads/index.jsp 作为开发者，下载JDK，点击；选择windows平台，点击下载，需要登录一下，就可以下载了。（没有用户名的，注册下就行，免费的，而且以后经常用得到）。

2014-06-23 20:49:09 565

原创 oracle job的管理

oracle job是通过pl/sql DBMS_JOB包来创建和管理的。

2014-06-21 12:30:07 809

原创关于sqlplus的show parameter问题

这里先描述几个视图：v$parameter

2014-06-15 20:49:14 8556

原创 sqlplus help system 的创建

sqlplus的命令很多，我们不可能全部都记住

2014-06-14 20:50:09 603

原创将单个数据文件offline或online

语法：ALTER DATABASE DATAFILE

2014-06-08 19:09:08 648

原创 oracle lock 08 - 关于锁的解决方案

v$lockV$LOCK lists the locks currently held by the Oracle Database and outstanding requests for a lock or latch.

2014-06-08 16:06:56 580

原创 oracle lock 07 - DDL Locks

DDL LocksA data dictionary (DDL) lock protects the definition of aschema object while an ongoing DDL operation acts on or refers to the object. Only individual schema objects that are modified or

2014-06-08 11:03:45 516

原创 oracle lock 06 - dml locks

DML LocksA DML lock, also called a data lock, guarantees the integrity of data accessed concurrently by multiple users. For example, a DML lock prevents two customers from buying the last copy of a

2014-06-07 21:18:35 671

原创 oracle lock 05 - overview of Automatic Locks

Oracle Database automatically locks a resource on behalf of a transaction to prevent other transactions from doing something that requires exclusive access to the same resource. The database automatic

2014-06-07 16:55:13 424

原创 oracle lock 04 - Locks and Deadlocks

A deadlock is a situation in which two or more users are waiting for data locked by each other. Deadlocks prevent some transactions from continuing to work.

2014-06-07 16:34:01 552

原创 oracle lock 03 - lock mode and conversion and escalation and duration

Lock ModesOracle Database automatically uses the lowest applicable level of restrictiveness to provide the highest degree of data concurrency yet also provide fail-safe data integrity. The less re

2014-06-07 10:11:03 520

原创 oracle lock 01 - summary of lock

Summary of Locking BehaviorA lock is a mechanism that prevents destructive interactions, which are interactions that incorrectly update data or incorrectly alter underlying data structures, betwee

2014-06-06 18:23:20 437

原创 select 语句for update作用

The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock or update the rows until you end your transaction. You can specify this clause only in a top-levelSELECT stateme

2014-06-06 15:52:49 13659

原创 oracle数据文件的管理

数据文件的管理：1.

2014-06-04 19:55:22 548

原创 chapter03 管理oracle实例

ObjectivesAfter completing this lesson, you should beable to do the following:a. Create and manageinitialization parameter fileb. Startup and shutdown aninstancec. Monitor and u

2014-06-03 20:36:25 568