2013年10月_czmmiao

Oracle 11g Locking Enhancement(原创)

Locking EnhancementsOracle Database 11g provides more efficient capabilities relating to the implementation of object locking. These new capabilities include allowing a DDL lock to wait for a DML lo...

2013-10-31 20:41:36 124

Oracle 11g Create Parameter file from memory and Hot Patch(原创)

Creating a Parameter File from MemoryYou can now create a text initialization parameter file (PFILE) or a server parameter file (SPFILE) from the system-wide parameters currently in use by the insta...

2013-10-31 20:40:19 126

Oracle 11g Invisible Index(原创)

Invisible IndexesIn Oracle Database 11g, you can create invisible indexes. An invisible index is similar to regular indexes in most respects. However, you can hide the index from the optimizer, thus ...

2013-10-30 20:44:56 158

Oracle User和Schema的区别(原创)

概述Schema和User的定义如下A schema is a collection of database objects (used by a user.).Schema objects are the logical structures that directly refer to the database’s data.A user is a name defined in t...

2013-10-30 20:44:15 260

Oracle 11g Shrink Temporary Tablespace and Temporary Table Enhancement(原创)

Shrinking Temporary TablespacesWhen a large job that uses a temporary tablespace finishes executing, the database doesn’t immediately release the space used by the job in the temporary tablespace, e...

2013-10-29 13:22:09 141

Oracle 11g PL/SQL and Java Automatic Native Compilation(原创)

PL/SQL and Java Automatic Native CompilationUp until the Oracle Database 11g release, the database always transformed PL/SQL code to C code first before executing it. This meant you needed a third-p...

2013-10-29 13:21:04 146

原创 oracle XML的使用

XML DB简介Oracle XML DB 是一组专门为 XML 开发的内置高性能存储和检索技术，首次随 Oracle9i 数据库第 2 版推出。OracleXML DB 将 World Wide Web Consortium (W3C) XML 数据模型完全吸收到 Oracle9i 数据库中，并为导航和查询 XML 提供了新的标准访问方法。可以同时获得关系数据库技术和 XML 技术的所有优势...

2013-10-29 13:20:30 257

原创 Binary XML Data Storage in 11g

Oracle 11g New Features TipsIn previous versions of Oracle, two Extensible Markup Language (XML) storage options were available: unstructured, or CLOB, and storage and structured, or schema-based. ...

2013-10-29 13:06:38 198

Oracle 11g Compress Enhancement(原创)

OLTP Table CompressionIn earlier releases, you could compress data only during bulk load operations such as during a direct load or a create table as select operation. You couldn’t, however, compres...

2013-10-28 22:12:49 210

Oracle 11g Direct NFS(原创)

Direct NFS ClientNAS storage devices use the Network File System (NFS) to access data. In Oracle Database 10g, NAS devices were accessed using operating system–specific kernel NFS drivers. This requ...

2013-10-28 22:10:44 357

Oracle 11g Fine-grained Dependency Management(原创)

Minimal Invalidation of Dependent ObjectsIn the previous release, Oracle automatically invalidated all dependent views and PL/SQL packages during an online redefinition, even if those objects weren’t...

2013-10-27 14:25:42 111

Oracle 11g Securefile(原创)

Overview Oracle SecureFilesContemporary organizations deal with data that includes traditional data stored in relational tables, semi-structured data such as XML and word processing documents, and u...

2013-10-27 11:19:23 285

Oracle 11g PL/SQL Function Result Cache(原创)

The PL/SQL Function Result CacheThe PL/SQL function result cache uses the same infrastructure as the SQL query result cache, and caches the results of the PL/SQL functions in the result cache compon...

2013-10-26 16:10:02 225

Oracle 11g Result Cache(原创)

Result CacheThe shared pool component of the SGA, as you are aware, stores the parsed and compiled versions of SQL queries, which lets the database quickly execute frequently run SQL statements and ...

2013-10-26 09:36:05 253

Oracle 11g Extension Statistics and Expression Statistics(原创)

Overview Extended StatisticsIn this release, Oracle has introduced major new capabilities in statistics gathering, which are referred to as extended statistics, to make the optimizer statistics refl...

2013-10-24 17:45:41 122

Oracle 11g Optimizer Statistics Enhancement(原创)

OverviewThere are two major innovations in optimizer statistic collection in the Oracle Database 11g release: pending statistics and extended statistics. In addition, the Statistics Preferences fe...

2013-10-24 17:13:01 272

ORACLE 11g 自动内存管理(原创)

Overview在oracle 11g中，使用一个参数memory_target就能够实现SGA和PGA组件依据工作负荷进行自动内存分配。oracle推荐使用自动内存管理简化内存分配。oracle 11g依然支持手工内存分配：1：oracle 11g使用memory_target来支持内存自动分配。2：使用sga_target和pga_target参数来设置SGA和PGA，数据库会在这两个...

2013-10-23 08:13:58 559

原创自定义sublime text 2 build system

IntroductionSublime Text build systems can be considered simplistic, but highly customizable. The basic idea is that each type of Build profile is powered by a “.sublime-build” file – a JSON repre...

2013-10-21 14:07:35 396

批处理for命令详解

批处理for命令详解FOR这条命令基本上都被用来处理文本,但还有其他一些好用的功能! 看看他的基本格式(这里我引用的是批处理中的格式,直接在命令行只需要一个%号) FOR 参数 %%变量名 IN (相关文件或命令) DO 执行的命令参数:FOR有4个参数 /d /l /r /f 他们的作用我在下面用例子解释 %%变量名 :这个变量名可以是小写a-z或者大写A-Z,他们区分大小写,...

2013-10-21 13:49:33 221

Oracle 11g ADDM Enhancements(原创)

Overview ADDM Enhancements The Automatic Database Diagnostic Monitor, which Oracle introduced in Oracle Database 10g, analyzes the AWR data, diagnoses the root causes for performance problems, and...

2013-10-21 13:24:23 176

Oracle 11g SQL Access Advisor Enhancements(原创)

Overview SQL Access AdvisorOracle introduced the SQL Access Advisor in the Oracle database 10g Release to help you create efficient access structures to optimize SQL queries. The advisor accepted ei...

2013-10-15 15:19:08 153

Oracle 11g SQL Plan Management(原创)

SQL Plan ManagementOnce the cost optimizer provides an efficient execution plan for a SQL statement, you can’t assume that the optimizer will always use that execution plan. There may be any numbe...

2013-10-13 22:59:49 233

Oracle 11g Automatic SQL Tuning Advisor(原创)

Introduce of SQL Tuning AdvisorIn Oracle Database 10g, Oracle introduced the Automatic Tuning Optimizer, which is the name given to the optimizer when it is running in the tuning mode instead of i...

2013-10-12 13:30:40 409

Tablespace Encryption in Oracle 11g R1(原创)

OverviewIn Oracle Database 10g, Oracle introduced the new Transparent Data Encryption (TDE) feature, which let you easily encrypt a column’s data in a table. The encryption is called transparent b...

2013-10-10 09:46:29 303

Oracle 11g Security Enhancement(原创)

Secure Password SupportOracle Database 11g provides several new ways to make database passwords more secure. Among these are the following new password-related features:Case-sensitive passwords ...

2013-10-09 17:42:31 129

Fine-Grained Access to Network Services in Oracle Database 11g R1(原创)

OverviewOracle allows access to external network services using several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP and UTL_INADDR), all of which are implemented using the TCP protocol. In pr...

2013-10-09 16:27:11 113

原创停止Oracle Job

ORACLE如何停止一个JOB相关表、视图dba_jobs：包含登录用户所有的JOB信息dba_jobs_running：包含正在运行job相关信息注意:须使用oracle的sys用户登录到数据库，才能查看dba_jobs_running, v$process, v$session表的信息。同时，登录操作系统时，要用oracle用户。问题描述为同事解决一个因为网络连接情况不佳时，执行一个超长时间...

2013-10-08 21:47:41 264

Oracle 11g Lightweight Jobs(原创)

Overview Lightweight JobIn Oracle Database 10g, there was only a single type of Scheduler job. In Oracle Database 11g, you can also create what’s called a lightweight job (also referred to as a pe...

2013-10-08 21:17:54 478

Database Resource Manager New Features(原创)

You’re familiar with the Database Resource Manager (Resource Manager) from the earlier release. You use the Database Resource Manager to efficiently allocate resources among competing database sessi...

2013-10-08 15:05:09 124

原创 Oracle的sys_context函数

概述sys_context函数是Oracle提供的一个获取环境上下文信息的预定义函数。该函数用来返回一个指定namespace下的parameter值。该函数可以在SQL和PL/SQL语言中使用。sys_context实际上就是一个Oracle存储和传递参数的容器访问函数。我们登入Oracle服务器，是带有会话信息session_info和其他一些属性信息。其中，有一些是Oracle预定义的...

2013-10-07 21:04:52 336

Oracle Database 11g I/O Calibration(原创)

Overview I/O Calibration Oracle Database 11g introduces an I/O Calibration mechanism, whereby you can run I/O calibration tests either through the Enterprise Manager Performance page or a PL/SQL p...

2013-10-06 20:58:18 167

Oracle 11g Automated Maintenance Tasks(原创)

OverviewYou’re familiar with the concept of automated maintenance tasks from the Oracle Database 10g release. These are jobs that are run automatically by the database to perform maintenance operati...

2013-10-06 17:42:36 705

Oracle 11g Enhancements in AWR Baselines(原创)

Enhancements in AWR Baselines A baseline is any set of snapshots taken over a period of time. The snapshots are selected such that they yield a set of baselines that change during the period of ti...

2013-10-05 21:42:01 150

原创 ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr]

ORA-00600: 内部错误代码, 参数: [kcratr_nab_less_than_odr], [1], [3313], [2328320], [2334233], [], [], [], [], [], [], []，这里面的最后两个参数的含义是什么？这里的nab就是Next Available Block number in the Online Redo Log，也就是上述倒数第二个...

2013-10-05 12:00:12 885

Oracle 11g Database Recover Adviser(原创)

Data Recovery AdvisorThe Data Recovery Advisor (DRA) is a new tool that automatically diagnoses failures in the database, determines the repair options and, optionally, executes the repairs if you w...

2013-10-05 10:06:12 217

czmmiao的专栏