- 博客(40)
- 收藏
- 关注
RSS订阅转载 Instance Recovery Phases
http://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT89050Instance Recovery Phases The first pha...
2016-01-12 10:31:00
147
转载 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
151
转载 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
143
转载 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
4112
转载 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
361
转载 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
127
转载 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
116
转载 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
181
转载 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
130
转载 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
128
转载 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
148
转载 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
93
转载 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
153
转载 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
147
转载 什么是Granule
Original Link:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT9847我在很多地方看到过这个词,也查过字典，但是真的明白是什么意思,这次...
2015-12-28 16:30:13
144
转载 Mandatory Background Processes
Mandatory background processes are present in all typical database configurations. These processes run by defau...
2015-12-28 15:35:40
127
转载 Overview of Background Processes
Background processes are additional processes used by a multiprocess Oracle database. The background processes ...
2015-12-28 13:47:29
96
转载 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
130
转载 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
220
转载 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
194
转载 Oracle 12c 数据库系统中的多进程和多线程
原文来自:http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT1245 Multiprocess and Multithreaded Oracle D...
2015-12-24 23:26:11
742
转载 Oracle 12c进程结构 01
原文来自http://docs.oracle.com/database/121/CNCPT/process.htm#CNCPT008 Introduction to Processes进程介绍...
2015-12-24 09:31:29
91
转载 INSTR的用法
我只是一个小小的翻译人员，以下内容来自Oracle 12c的官方文档，具体链接为:http://docs.oracle.com/database/121/SQLRF/functions089.htm#SQLRF00651...
2015-12-17 10:55:48
474
转载 ANY ALL SOME的区别
干了这么长时间的ORACLE,但是真正用到ANY ALL还有SOME的并不多，而且还真的不知道有SOME这个东西，这次补一下知识首先看一下官方文档中给的解释 ...
2015-12-17 10:29:31
247
转载 SQL Server Database 增加 Comment
在还原SQLSERVER的需要单独记录该数据库内的数据的日期，这个比较麻烦，需要 通过单独的文档记录为了便于方便，可以使用下面的 PROCEUDRE将还原的信息加入数据库的扩展属性里面EXEC [DATABAS...
2015-12-15 11:20:16
663
转载 转义字符Escape Character
在使用LIKE的时候下划线_表示只有一个字符,%表示所有字符,如果搜索条件中也包含了_,就可以使用ESCAPE关键字来标明什么是转义字符举例来说SELECT EMPLOY_NAME,JOB_IDFROM EM...
2015-12-12 16:29:24
238
转载 TABLE NAME的命名规则
其实这个也是OCA当中的一道题,Oracle规定创建表名和列名的时候只能包含如下字符1).A-Z2).a-z3).0-94)._5).#6).$最后Oracle两个不推荐，并且不能是保留字...
2015-12-11 10:27:36
1483
转载 Inventory.xml的作用
从来都不知道这个文件的作用，现在要好好学习， 天天向上了，所以特意查了一下这个文件中有安装在节点上的ORACLE的HOME路径，如果是多个ORACLEHOME，在文件中也列出了多个ORACLEHOME的名称，index名称，...
2015-12-10 16:11:46
574
转载 DEFAULT在DML语句中的用法
在UPDATE或者INSERT的时候，如果改列本身有设置过默认值，则使用DEFAULT就可以调用这个默认值，如如果改列没有默认值，则使用DEFAULT的时候改列就为空SQL> UPDATE HR.EMPLOYEES...
2015-12-10 13:57:29
98
转载 RPM
http://www.cnblogs.com/xiaochaohuashengmi/archive/2011/10/08/2203153.html ...
2014-06-23 16:35:16
55
转载 VotingDisk and OCR
http://tech.diannaodian.com/dw/data/oracle/2011/1112/142760.html ...
2014-06-23 14:10:49
77
转载 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
339
转载 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
82
转载 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
80
转载 在Openfiler里面建立PV没有响应
点击Create但是系统没有响应,直接刷新然后没有变更 然后我开始尝试修改Starting Cylinder, 1980 , 1990 , 2000 直到2100的时候成功了 …. 但是最终显示的 Sta...
2014-05-30 15:11:36
165
转载 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
70
转载 VirtualBox ExtensionPack Error on Win7
VirtualBox的扩展包安装在win7专业版64位上出错的解决办法 来自优快云 http://blog.youkuaiyun.com/ken2002/article/details/17891013 ...
2014-05-28 11:30:39
51
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人