-
编辑 删除
sql 执行过程
1.创建游标2.分析语句 把SQL从用户进程载入到oracle‘s shared pool if( hash_value(Sql_Statement) in hash_table == true ) &nb...
-
编辑 删除
DUAL 表
接触数据库过程中会遇见select sysdate from dual 这样的情况然后去 desc dual 表会SQL> desc dual Name &n...
-
编辑 删除
AIX 修改时区
IBM AIX 6.1 时间和时区错误。需修改date 看当前时间******# dateFri Mar 15 09:53:03 GMT+08:00 2013smit -> System Environments -> Change / Show Date and Time -> Change Time Zone Using System D...
-
编辑 删除
忠孝东路走九边
这城市满地的纸屑 风一刮像你的妩媚 我经过的那一间鞋店 却买不到你爱的那双鞋 黄灯了人被赶过街 我累的摊坐在路边 看著一份爱有头无尾 你有什么感觉 耳听见的每首歌曲都有我的悲 眼看见的每个昨天都有你的美 哦...
-
编辑 删除
AWR 报告修改moving window 出错分析
背景：测试库 11G r2 +IBM AIX 6.0在运行AWR 收集数据库的snapshot 的频率和保留策略是出现如下错误。SQL> exec dbms_workload_repository.modify_snapshot_settings(interval=>30,retention=>1*24*60);BEGIN dbms_...
-
编辑 删除
expdp 备份
export DUMPFILE=`date +%Y%m%d`.dmpexport ORACLE_HOME=$ORACLE_BASE/oracle---这里最好设置一下 如果root用户运行脚本会去找其它目录下的expdp命令export LOGFILE=`date +%Y%m%d`.logexport &nb...
-
编辑 删除
Flashback Data Archive Requirements
Flashback Data Archive Requirements 1. Flashback Data Archive tablespaces must be managed with automatic segment space management&...
-
编辑 删除
SQL Management Base Architecture
SQL Management Base ArchitectureWithin the SYSAUX data dictionary tablespace one can find a SQL Management Base entry for a one or more SQL statements when this feature is enabled.The SQL Ma...
-
编辑 删除
Automatic Diagnostic Repository (ADR)
The ADR is a file-based repository for database diagnostic data such as traces, dumps, the alert log, health m...
-
编辑 删除
BLOCK CHANGE TRACKING
About Block Change TrackingIf block change tracking is enabled on a primary or standby database, then RMAN uses a block change tracking file to identify changed blocks for incremental backup...
-
编辑 删除
SESSIONS, PROCESSES, TRANSACTIONS
1. SESSIONS, PROCESSES, TRANSACTIONSSESSIONSDefault value : (1.5 * PROCESSES) + 22 (ORACLE 11G) / (1.1 * PROCESSES) + 5 (ORACLE 10G)Range of values: 1 to231http://do...
-
编辑 删除
ORA-00258: manual archiving in NOARCHIVELOG mode must identify log
10g RAC 数据库未归档。 解释:alter system archive log current*ERROR at line 1:ORA-00258: manual archiving in NOARCHIVELOG mode must identify logOERR: ORA 258 manual archiving in...
-
编辑 删除
归档区别
alter system s swotch logfile : 仅对当前节点的对应redo thread 进行日志切换并归档。alter system archive log current 对集群内所有节点 的redo thread 进行日志切换并归档...
-
编辑 删除
IMP 错误
IMP 导入错误IMP-00019: row rejected due toORACLE error 1IMP-00003: ORACLE error 1encounteredORA-00001: unique constraint(SYSMAN.MGMT_PRIV_INCLUDES_PK) violated查到MGMT_PRIV_INCLUDES_P...
-
编辑 删除
RAC 用户权限错误
错误代码ORA-01565: error in identifying file '+DATA/ruirui/spfileruirui.ora'ORA-17503: ksfdopn:2 Failed to open file +DATA/ruirui/spfileruirui.oraORA-01031: insufficient privileges描述：RAC 用户id需要...
-
编辑 删除
统计用户表对应字段
select TABLE_NAME,COLUMN_NAME,DATA_TYPE from user_tab_columns;
-
编辑 删除
About Static Data Dictionary Views
1.静态数据字典视图：Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to...
-
编辑 删除
rman 备份 全库
run{allocate channel d1 type disk maxpiecesize=50G;allocate channel d2 type disk maxpiecesize=50G;backup full database filesperset 10 include current controlfile format '/backup/fullbak_%d_%T_%s_%...
-
编辑 删除
给自己的歌
想得却不可得你奈人生何该舍的舍不得只顾著跟往事瞎扯等你发现时间是贼了它早已偷光你的选择爱恋不过是一场高烧思念是紧跟著的好不了的咳是不能原谅却无法阻挡恨意在夜里翻墙是空空荡荡却嗡嗡作响谁在你心里放冷枪旧...
-
编辑 删除
TEMPORARY Tablespaces and TEMPFILES 详细解释
What are Temporary Tablespaces:Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracl...
