DBMS
文章平均质量分 53
数据我最大
这个作者很懒,什么都没留下…
展开
-
Some Commands
1. Show dabase name $ sqlplus / as sysdba sql>select name from v$database; 2. On linux prompt check the listener is up and running or not. The command to check for the listener is as follows原创 2013-12-30 23:51:30 · 483 阅读 · 0 评论 -
一些概念
数据库是数据的集合;数据库系统是是由数据库及其管理软件组成的系统。数据库系统的主要目的是给用户提供数据的抽象视图。特定时刻存储在数据库中的信息的集合称为数据库的一个实例(instance)。而数据库的总体设计称为数据库模式(schema). 一个数据库系统可以有多个数据库实例。文本数据: 非结构化数据,和关系数据库中严格的结构化数据不同,查询非结构化的文本数据被称为信息检索(informa原创 2013-12-31 15:10:06 · 752 阅读 · 0 评论 -
Linux下SQL Developer 4.0 安装
一、Oracle SQL Developer 3.2.2 选择Linux RPM版本下载 http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html1、安装sqldeveloper, rpm -ivh sqldeveloper-3.2.20.09.87-1.noarch原创 2014-01-02 10:46:00 · 1667 阅读 · 0 评论 -
索引
Suppose you want to locate a particular book in a library. Does it make sense to look through every book in the library until you find the one you want? Of course not; you use the library’s catalo转载 2014-01-05 22:18:13 · 627 阅读 · 0 评论 -
Understanding Row Identifiers(ROWID)
Each row in an Oracle database has a unique row identifier, or rowid.A ROWID is an 18-digit number that is represented as a base-64 number.ROWID is used internally by the Oracle database to access the转载 2014-01-16 17:26:15 · 611 阅读 · 0 评论 -
100 Things You Probably Didn't Know About Oracle Database
100 Things You Probably Didn't Know About Oracle DatabaseRecently, while delivering a presentation on Cache Fusion at New York Oracle Users Group (www.nyoug.org), the regional user group where I h转载 2014-01-16 17:34:21 · 891 阅读 · 0 评论 -
How Oracle Locking Works - First
When a transaction updates a row, it puts a lock so that no one can update the same row until it commits. When another transaction issues an update to the same row, it waits until the first one eith转载 2014-01-16 17:36:39 · 769 阅读 · 0 评论 -
How Oracle Locking Works - Second
How Oracle Locking WorksWhen a Lock is NOT a Lock!In the last installment of this series "100 Thing you Probably Didn't Know About Oracle" you learned how Oracle locks the rows of a table.转载 2014-01-16 18:41:16 · 879 阅读 · 0 评论