自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(40)
  • 收藏
  • 关注

转载 Instance Recovery Phases

http://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89050Instance Recovery Phases The first pha...

2016-01-12 10:31:00 109

转载 SEC_PROTOCAL_PARAMETERS

https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams213.htm SEC_PROTOCOL_ERROR_FURTHER_ACTIO...

2016-01-11 10:28:01 125

转载 PCTFREE, PCTUSED and Row Chaining

http://docs.oracle.com/cd/B19306_01/server.102/b14220/logical.htmPCTFREE, PCTUSED, and Row Chaining For ma...

2016-01-06 09:13:29 120

转载 PASSWORD_GRACE_TIME

http://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310Specify the number of days after the g...

2016-01-05 08:56:28 3830

转载 PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

http://docs.oracle.com/database/121/SQLRF/statements_6012.htm#SQLRF01310 PASSWORD_REUSE_TIME and PASSWORD_RE...

2016-01-05 08:47:21 301

转载 Overview of the Program Global Area (PGA)

https://docs.oracle.com/database/121/CNCPT/memory.htm#CNCPT7777The PGA is memory specific to an operating p...

2015-12-31 16:56:42 98

转载 Setting SGA Target Size

You enable the automatic shared memory management feature by setting the SGA_TARGET parameter to a nonzero valu...

2015-12-31 13:10:25 99

转载 Setting Maximum SGA Size

The SGA_MAX_SIZE initialization parameter specifies the maximum size of the System Global Area for the lifetime...

2015-12-31 11:23:42 160

转载 Components and Granules in the SGA

The SGA comprises several memory components, which are pools of memory used to satisfy a particular class of me...

2015-12-31 11:12:49 98

转载 About Automatic Shared Memory Management

Automatic Shared Memory Management simplifies SGA memory management. You specify the total amount of SGA memory...

2015-12-31 10:47:50 97

转载 How to Enable Automatic Memory Management in 12c

http://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11200If you did not enable automatic memory manag...

2015-12-31 10:39:10 115

转载 Configuring the Large Pool

link:http://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm#TGDBA609 Unlike the shared pool, the la...

2015-12-29 14:20:08 66

转载 Memory Architecture Overview

link:http://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11198The basic memory structures associated wit...

2015-12-29 11:05:26 122

转载 Background Process Introduction

Original link:https://docs.oracle.com/cloud/latest/db121/REFRN/bgprocesses.htm#REFRN104ARBn:ASM Rebalance Pr...

2015-12-29 10:38:34 120

转载 什么是Granule

Original Link:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9847我在很多地方看到过这个词,也查过字典,但是真的明白是什么意思,这次...

2015-12-28 16:30:13 115

转载 Mandatory Background Processes

Mandatory background processes are present in all typical database configurations. These processes run by defau...

2015-12-28 15:35:40 97

转载 Overview of Background Processes

Background processes are additional processes used by a multiprocess Oracle database. The background processes ...

2015-12-28 13:47:29 71

转载 Overview of Server Processes

原始链接:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9838 Oracle Database creates server processes ...

2015-12-28 13:21:53 101

转载 Database Operationgs 数据库运营

In the context of database monitoring, a database operation is a logical entity that includes a SQL statement, ...

2015-12-28 11:01:46 186

转载 Oracle 12c 连接和进程 Connections and Sessions

原始链接:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1247A database connection is a physical commun...

2015-12-28 10:45:36 160

转载 Oracle 12c 数据库系统中的多进程和多线程

原文来自:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1245 Multiprocess and Multithreaded Oracle D...

2015-12-24 23:26:11 644

转载 Oracle 12c进程结构 01

原文来自http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008 Introduction to Processes进程介绍...

2015-12-24 09:31:29 77

转载 INSTR的用法

我只是一个小小的翻译人员,以下内容来自Oracle 12c的官方文档,具体链接为:http://docs.oracle.com/database/121/SQLRF/functions089.htm#SQLRF00651...

2015-12-17 10:55:48 438

转载 ANY ALL SOME的区别

干了这么长时间的ORACLE,但是真正用到ANY ALL还有SOME的并不多,而且还真的不知道有SOME这个东西,这次补一下知识首先看一下官方文档中给的解释 ...

2015-12-17 10:29:31 190

转载 SQL Server Database 增加 Comment

在还原SQLSERVER的需要单独记录该数据库内的数据的日期,这个比较麻烦,需要 通过单独的文档记录为了便于方便,可以使用下面的 PROCEUDRE将还原的信息加入数据库的扩展属性里面EXEC [DATABAS...

2015-12-15 11:20:16 617

转载 转义字符Escape Character

在使用LIKE的时候下划线_表示只有一个字符,%表示所有字符,如果搜索条件中也包含了_,就可以使用ESCAPE关键字来标明什么是转义字符举例来说SELECT EMPLOY_NAME,JOB_IDFROM EM...

2015-12-12 16:29:24 209

转载 TABLE NAME的命名规则

其实这个也是OCA当中的一道题,Oracle规定创建表名和列名的时候只能包含如下字符1).A-Z2).a-z3).0-94)._5).#6).$最后Oracle两个不推荐,并且不能是保留字...

2015-12-11 10:27:36 1346

转载 Inventory.xml的作用

从来都不知道这个文件的作用,现在要好好学习, 天天向上了,所以特意查了一下这个文件中有安装在节点上的ORACLE的HOME路径,如果是多个ORACLEHOME,在文件中也列出了多个ORACLEHOME的名称,index名称,...

2015-12-10 16:11:46 524

转载 DEFAULT在DML语句中的用法

在UPDATE或者INSERT的时候,如果改列本身有设置过默认值,则使用DEFAULT就可以调用这个默认值,如如果改列没有默认值,则使用DEFAULT的时候改列就为空SQL> UPDATE HR.EMPLOYEES...

2015-12-10 13:57:29 82

转载 RAC to Single Instance

http://www.luocs.com/archives/592.html ...

2014-07-07 10:06:18 59

转载 Change Hostname

http://soft.chinabyte.com/os/281/11563281.shtml ...

2014-06-23 17:16:19 133

转载 RPM

http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/08/2203153.html ...

2014-06-23 16:35:16 45

转载 VotingDisk and OCR

http://tech.diannaodian.com/dw/data/oracle/2011/1112/142760.html ...

2014-06-23 14:10:49 61

转载 Restore RAC to Single Instance

http://www.luocs.com/archives/592.html ...

2014-06-16 14:34:12 61

转载 CRS-2501

CRS-2501: Resource 'ora.orcl.db' is disabled [root@rac0 bin]# ./srvctl start database -d ORCL PRCR-1079 : F...

2014-06-09 16:15:52 287

转载 how to configure yum source

Disabled other repo file in /etc/yum.repos.d/*.repo create new repo file. e.g. media.repo , and typing belo...

2014-06-01 13:51:48 61

转载 Linux Command 20140530

Change IP /etc/sysconfig/network-scripts/ifcfg-* Restart network /etc/init.d/network restart Check Firew...

2014-05-30 17:47:12 62

转载 在Openfiler里面建立PV没有响应

点击Create但是系统没有响应,直接刷新然后没有变更 然后我开始尝试修改Starting Cylinder, 1980 , 1990 , 2000 直到2100的时候成功了 …. 但是最终显示的 Sta...

2014-05-30 15:11:36 146

转载 4 Nodes RAC Deploy in minutes

Oracle http://www.oracle.com/technetwork/systems/hands-on-labs/deploy-rac-ovm-cluster-2101019.html#6 ...

2014-05-28 11:31:38 59

转载 VirtualBox ExtensionPack Error on Win7

VirtualBox的扩展包安装在win7专业版64位上出错的解决办法 来自CSDN http://blog.csdn.net/ken2002/article/details/17891013 ...

2014-05-28 11:30:39 40

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除