Oracle System Architecture - 随笔分类 - Coldest Winter

摘要：Oracle内存全面分析(1)网址：http://www.hellodba.com/reader.php?ID=100&lang=CN 阅读全文

posted @ 2012-12-13 07:27 Coldest Winter 阅读(139) 评论(0) 推荐(0)

摘要：网址:http://cuddletech.com/articles/oracle/node58.html http://cuddletech.com/articles/index.shtml参考网址:http://blog.csdn.net/tianlesoftware/article/details/4693470 http://blog.csdn.net/tianlesoftware/article/details/5674309 启用归档日至模式Enabling ARCHIVELOG Mode Most of the High Availability features... 阅读全文

posted @ 2012-07-30 19:10 Coldest Winter 阅读(462) 评论(0) 推荐(0)

Oracle Concept

摘要：checkpoint A data structure that defines an SCN in the redo thread of a database. Checkpoints arerecorded in the control file and each datafile header, and are a crucial element ofrecovery.（检查点记录在控制文件和每个数据文件的头部，对于恢复他是至关重要的）(参考:Oracle® Database Concepts 11g Release 1 (11.1).pdf Oracle Database B 阅读全文

posted @ 2012-07-25 05:47 Coldest Winter 阅读(349) 评论(0) 推荐(0)

为数据库的可恢复性作准备

摘要：参考：http://blog.csdn.net/robinson_0612/article/details/5784713 http://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_2013.htm http://storage.chinaunix.net/stor/g/2008/07/21/1223005.shtml为了保证数据库的最大可恢复性， 1、必须多路复用控制文件； 2、必须多路复用联机重做日志； 3、必须以归档日志模式运行数据库，并多路复用归档日志文件；最后必须做常规备份。一、保护控制... 阅读全文

posted @ 2012-07-22 11:00 Coldest Winter 阅读(522) 评论(0) 推荐(0)

Oracle中数据库的连接-监听配置文件的介绍

摘要：参考网址:http://blog.csdn.net/pan_tian/article/details/7611179TNSNAMES.ORA - This file contains a list of service names, which translate into the instances the client can connect to. It (tnsnames.ora) is used on outgoing requests.SQLNET.ORA - this file is used to configure Oracle Net on the client. For 阅读全文

posted @ 2012-07-06 07:11 Coldest Winter 阅读(389) 评论(0) 推荐(0)

Oracle parameter中常用参数收集:

摘要：1、DB_FILE_MULTIBLOCK_READ_COUNT这个参数可以控制同时被读取的块的数目。主要是应用于快速全表扫描的时候使用。请参阅:http://blog.csdn.net/tianlesoftware/article/details/5347098#comments 阅读全文

posted @ 2012-07-03 06:37 Coldest Winter 阅读(291) 评论(0) 推荐(0)

Oracle Database Startup and Shutdown Procedure

摘要：参考网址:http://www.thegeekstuff.com/2009/01/oracle-database-startup-and-shutdown-procedure/http://docs.oracle.com/cd/E11882_01/server.112/e10713/startup.htmhttp://onlineappsdba.com/所有的操作需要在DOS下的SQLPLUS来完成:在任意一个时刻，Oracle将处于以下几个状态之一:SHUTDOWNNOMOUNTMOUNTOPENMOUNT:安装1、启动OracleThe default SPFILE (server par 阅读全文

posted @ 2012-06-26 07:32 Coldest Winter 阅读(181) 评论(0) 推荐(0)

Initialization Parameter files: PFILEs vs. SPFILEs

摘要：本文为转载:网址:http://www.orafaq.com/node/5 http://www.cnblogs.com/jacktu/archive/2008/02/27/1083232.html声明:如果本文侵犯了您的权益，请及时告知，本人将即刻停止侵权行为.针对Oracle数据库熊，分为单实例体系结构:关系型数据库管理系统-RDBMS(relational database management system)分布式系统体系结构:具有代表性的是实时应用集群-RAC(Real Application Cluster) ，多个实例打开一个数据库.名词解释:OEM-Oracle Enterp. 阅读全文

posted @ 2012-06-14 07:44 Coldest Winter 阅读(271) 评论(0) 推荐(0)

DBconsole 和listener的启动,数据库启动的环境变量的变量，数据库启动故障排除

摘要：如果要将OEM的显示方式，由英文改为中文，则只需将IE浏览器进行设置即可：如下所示:IE8>工具>Internet选项>语言>添加英语(美国)>上移英语(美国) 本文部分内容系转载，如果有侵犯您的权益，请及时通知本人，本人将即刻停止侵权行为。系统环境变量的优先级高于注册表，如果设置了环境变量，那么就会忽略注册表的值。Oracle_home和Oracle_path的说明:Oracle_Home要启动DBconsole，请使用EMCTL使用程序，该程序位于Oracle_home/bin目录下：下面的三个命令用于DBconsole的启动、停止和状态检测，可以使用它阅读全文

posted @ 2012-06-12 07:24 Coldest Winter 阅读(750) 评论(0) 推荐(0)

Oracle体系结构

摘要：Oracle体系结构概览:参考资料:http://docs.oracle.com/cd/E11882_01/server.112/e25789/process.htmOracle Database 10g SQL Tuning Workshop性能优化.pdf第一章节:Oracle Database Architecture: OverviewOracle课件:02_的体系结构.ppt1、共享池中内存按照LRU(最近最少使用算法)来分配。2、DBWn(数据库写入器)根据极懒算法写入:尽可能少，再尽可能少(但出现检查点的情况例外,将所有脏缓存区尽快写入磁盘)。在以下四种情况下，DBWn将执行写操阅读全文

posted @ 2012-06-06 06:40 Coldest Winter 阅读(1010) 评论(0) 推荐(0)

pl/sql functions and cbo costing

摘要：参考网址:http://blog.csdn.net/suncrafted/article/details/4239237 http://www.oracle-base.com/articles/misc/cost-based-optimizer-and-database-statistics.phpCBO-Cost-Based Optimizer 阅读全文

posted @ 2012-06-03 19:35 Coldest Winter 阅读(148) 评论(0) 推荐(0)

Session and Lock

摘要：Lock:参考如下网址:http://broadh2o.net/docs/database/oracle/oracleLocks.html http://docs.oracle.com/cd/E11882_01/server.112/e10592/ap_locks001.htm#SQLRF55502 (Automatic Locks in DML Operations) http://docs.oracle.com/cd/E11882_01/server.112/e25789/consist.htm#CNCPT1339(数据库的事务和读一致性和O... 阅读全文

posted @ 2012-04-18 22:54 Coldest Winter 阅读(257) 评论(0) 推荐(0)

PL/SQL User's Guide and Reference:PL/SQL Architecture

摘要：Block StructureThe basic units (procedures, functions, and anonymous blocks) that make up aPL/SQL program are logical blocks, which can be nested inside one another.A block groups related declarations and statements. You can place declarations close towhere they are used, even inside a large subprog 阅读全文

posted @ 2012-03-18 20:27 Coldest Winter 阅读(496) 评论(0) 推荐(0)

Oracle altet table Rules

摘要：Oracle 修改表的限制 To make a NOT NULL column nullable, use the alter table command with the NULL clause,as follows:alter table TROUBLE modify(Condition NULL);The Rules for Adding or Modifying a ColumnThese are the rules for modifying a column: (在任何情况下) 1、You can increase a character column’s wi... 阅读全文

posted @ 2012-03-10 14:18 Coldest Winter 阅读(293) 评论(0) 推荐(0)

Oracle Lock and Hibernage Lock

摘要：http://orafaq.com/node/854ORACLE锁: Oracle uses locks to control concurrent access to data. A lock gives you temporary ownership of a database resource such as a table or row of data. Thus, data cannot be changed by other users until you finish with it. You need never explicitly lock a resource becau 阅读全文

posted @ 2012-03-10 12:06 Coldest Winter 阅读(300) 评论(0) 推荐(0)

Flashback—Tables and Databases

摘要：As of Oracle Database 10g, you can use the flashback table and flashback databasecommands to simplify your data-recovery efforts. The flashback table commandautomates the process of restoring a full table to its prior state. The flashbackdatabase command flashes back an entire database, and it req.. 阅读全文

posted @ 2012-03-07 22:38 Coldest Winter 阅读(367) 评论(0) 推荐(0)

Working with Tablespaces

摘要：Tablespaces and the Structure of the Database People who have worked with computers for any period of time are familiar with the concept of afile; it’s a place on disk where information is stored, and it has a name. Its size is usually not fixed: Ifyou add information to the file, it can grow larg.. 阅读全文

posted @ 2012-03-07 07:07 Coldest Winter 阅读(388) 评论(0) 推荐(1)

转:Oracle数据库一致性读的原理(Consistent Read)

摘要：申明:此文为转载，如果发生版权问题，本人将立即删除相关内容:http://blog.csdn.net/wh62592855/article/details/6151482在Oracle数据库中，undo主要有三大作用：提供一致性读（Consistent Read）、回滚事务（Rollback Transaction）以及实例恢复（Instance Recovery）。一致性读是相对于脏读（Dirty Read）而言的。假设某个表T中有10000条记录，获取所有记录需要15分钟时间。当前时间为9点整，某用户A发出一条查询语句：select * from T，该语句在9点15分时执行完毕。当用户A 阅读全文

posted @ 2012-01-13 23:18 Coldest Winter 阅读(1220) 评论(0) 推荐(0)

Using Flashback Queries(使用闪回操作)

摘要：SCN的概念:http://www.itpub.net/thread-1601493-1-1.html查询当前的系统的时间戳:1 select SysTimeStamp from DUAL;NOTE--Oracle uses undo to roll back transactions and support flashbackqueries. Oracle uses redo (captured in the online redo log files) toapply transactions during database recoveries.NOTE--To use some fea 阅读全文

posted @ 2012-01-11 16:25 Coldest Winter 阅读(617) 评论(0) 推荐(0)

Schema and Difference between user and schema oracle

摘要：参考网址:http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_6013.htm Use theCREATESCHEMAstatement to create multiple tables and views and perform multiple grants in your own schema in a single transaction. To execute aCREATESCHEMAstatement, then Oracle Database executes e... 阅读全文

posted @ 2012-01-05 22:58 Coldest Winter 阅读(253) 评论(0) 推荐(0)

随笔分类 - Oracle System Architecture