cneo2012-优快云博客

转载人力&人手&人才&人物

人力:只需要你在工作中肯卖力气就足够了;人手:则需要你熟悉掌握工作，能应付突发事件;人才:则需要你头脑灵活，能够在工作中提出创造性的方案;人物:就需要八面玲珑，用自己特有的方式为公司做出比较大的贡献.[@more@] ...

2008-07-17 11:24:38 336

转载 oracle树中prior的用法

1)prior放在子节点端,则表示扫描树是以start with指定的节点作为根节点从上往下扫描.可能对应一个或多个分支.start with可以省略,如果省略,表示对所有节点都当成根节点分别进行遍历.2)prior放在父节点端...

2008-07-17 11:23:56 345

转载 Using Supplied Packages to Manage Stored Outlines

The DBMS_OUTLN and DBMS_OUTLN_EDIT package provides procedures used for managing stored outlines and their outline...

2008-07-16 14:09:45 298

转载 $ORACLE_HOMERDBMSADMIN目录下各SQL的含义

catalog.sql - create data dictionary views.cataudit.sql - data dictionary views for auditing. (catnoaud.sql will r...

2008-07-15 10:40:38 780

转载 PRODUCT_USER_PROFILE Table

SQL*Plus uses the PRODUCT_USER_PROFILE (PUP) table, a table in the SYSTEM account, to provide product-level securi...

2008-07-15 10:39:16 167

转载 Backing Up Server Parameter Files with RMAN

RMAN automatically backs up the current server parameter file in certain cases. The BACKUP SPFILE command backs up...

2008-06-05 10:52:41 103

转载 Backing Up Control Files with RMAN

You can back up the control file when the database is mounted or open. RMAN uses a snapshot control file to ensure...

2008-06-05 10:51:42 109

转载 Backing Up Individual Tablespaces with RMAN

You can backup one or more individual tablespaces with the BACKUP TABLESPACE command. You can use this command whe...

2008-06-05 10:48:17 120

转载 Making Whole Database Backups with RMAN

You can perform whole database backups with the database mounted or open. To perform a whole database backup, from...

2008-06-05 10:43:23 107

转载目睹奥运火炬传递

头顶烈日 , 等了两个小时 , 目睹奥运火炬手在半分钟内被加油声及国旗奥运五环旗吞没 , 真是不容易啊.[@more@] ...

2008-06-04 16:29:32 103

转载 RMAN Backup Formats:Backup Sets

RMAN can also store backup information a logical structure called a backup set. A backup set contains the data fr...

2008-06-04 16:20:36 123

转载 RMAN Backup Formats: Image Copies

An image copy is a bit-for-bit duplicate of a database file, identical to a copy made with an operating system com...

2008-06-04 16:19:42 114

转载 Files That RMAN Can Back Up

RMAN's BACKUP command supports backing up the following types of files:■ Database files, including datafiles, cont...

2008-06-04 16:17:27 97

转载 Using Quotation Marks

Quotation marks can be nested in one of two ways. The first method is to double the quotation marks in the nested ...

2008-06-03 10:32:55 186

转载 Special Characters in Initialization Parameter Files

Character Name Description# Number sign Comment( L...

2008-06-03 10:30:49 123

转载 Using Special Characters in Parameter Values

If a parameter value contains a special character, then the special character must be preceded by a backslash or t...

2008-06-03 10:27:30 93

转载 Rules Governing Initialization Parameter Files

The following rules govern the specification of parameters in initialization parameter files:■ An initialization p...

2008-06-03 10:25:41 114

转载 Active Session History Reports

■ The ashrpt.sql SQL script generates an HTML or text report that displays ASH information for a specified duratio...

2008-06-02 10:44:36 107

转载 Running Workload Repository Reports Using SQL Scripts

You can view AWR reports by running the following SQL scripts:■ The awrrpt.sql SQL script generates an HTML or tex...

2008-06-02 10:43:55 26694

转载 Automatic Workload Repository Views

Typically, you would view the AWR data through Oracle Enterprise Manager screens or AWR reports. However, you can ...

2008-06-02 10:42:25 114

转载保护眼睛的好方法

桌面->右键->属性->外观->高级－>项目选择（窗口）、颜色1（L）选择（其它）将色调改为：85。饱和度：123。亮度：205－>添加到自定义颜色－>在自定义颜色选定点确定－>确...

2008-06-02 10:41:58 78

转载 Creating and Dropping Baselines

A baseline is created with the CREATE_BASELINE procedure. A baseline is simply performance data for a set of snaps...

2008-05-30 13:20:41 75

转载 Managing Snapshot : Modifying Snapshot Settings

For example:BEGIN DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( retention => 43200, inte...

2008-05-30 13:17:33 114

转载 Managing Snapshot : Dropping Snapshots

You can drop a range of snapshots using the DROP_SNAPSHOT_RANGE procedure. To view a list of the snapshot Ids alon...

2008-05-30 13:15:13 82

转载 Managing Snapshot : Creating Snapshots

You can manually create snapshots with the CREATE_SNAPSHOT procedure if you want to capture statistics at times di...

2008-05-30 13:13:57 88

转载 Interpreting Statistics

Some pitfalls are discussed in the following sections:■ Hit ratios■ Wait events with timed statistics■ Comparing O...

2008-05-30 13:10:28 135

转载 UNIX下收集操作系统统计数据

CPU : sar, vmstat, mpstat, iostatMemory : sar, vmstatDisk : sar, iostatNetwork : netstat[@more...

2008-05-29 14:51:06 101

转载 Disk Statistics

Measure the normal performance of the I/O system; typical values for a single block read range from 5 to 20 millis...

2008-05-29 14:48:04 98

转载操作系统统计数据分类

Operating system statistics include the following:■ CPU Statistics■ Virtual Memory Statistics■ Disk Statistics■ Ne...

2008-05-29 14:47:57 180

转载 CPU Statistics

On an Oracle data server system, where there is generally only one application running, the server runs database a...

2008-05-29 14:46:42 153

转载 V$STATNAME 视图中各class的含义

■ 1 - User■ 2 - Redo■ 4 - Enqueue■ 8 - Cache■ 16 - OS■ 32 - Real Application Clusters■ 64 - SQL■ 128 - Debug不明白我自己...

2008-05-29 14:38:28 156

转载 V$ACTIVE_SESSION_HISTORY 视图中包含的信息

The data present in ASH can be rolled up on various dimensions that it captures, including the following:■ SQL ide...

2008-05-29 14:37:39 123

转载奥运火炬长沙传递路线

火炬传递从长沙市岳麓区的东方红广场出发先到爱晚亭，再由爱晚亭到岳麓书院，经麓山路口向北至新民路到新民会馆，再由新民会馆到通城商业广场向东过橘子洲大桥到平和堂，再沿黄兴路向北到中山亭，再向东经蔡锷路、湘春路上沿江风光带，到开福路口...

2008-05-28 16:25:33 119

转载 DB Time小结

This statistics represents the total time spent in database calls and is a indicator of the total instance workloa...

2008-05-28 16:24:55 62

转载 Time Model Statistics

可从V$SESS_TIME_MODEL或者V$SYS_TIME_MODEL动态视图中获得时间类指标的统计数据.V$SESS_TIME_MODEL displays the session-accumulated time for...

2008-05-28 16:23:53 198

转载 Wait Events的分类及分类依据

To enable easier high-level analysis of the wait events, the events are grouped into classes. The wait event class...

2008-05-28 16:21:16 124

转载重组后三大运营商的用户数

据分析,2007年,中国移动用户数为38660万户,铁通有固定电话用户2079万户和475万互联网用户,合并后用户总数超过4.11亿.这是新移动的客户资源.2007年,中国联通CDMA用户有4192.6万户,中国电信固定电话加小...

2008-05-27 17:17:40 108

转载 Restrictions on Altering Temporary Tables

You can modify, drop columns from, or rename a temporary table. However, for a temporary table you cannot:■ Add co...

2008-05-27 17:16:47 86

转载 Building a Dynamic Oracle ETL Procedure

参阅http://www.orafaq.com/node/1902[@more@] ...

2008-05-20 15:24:30 73

转载 cache buffers chains vs cache buffers lru chain

http://luckysea.itpub.net/post/5481/323246cache buffers chains当一个数据块读入sga区，相应的buffer header会被放置到hash列表上,我们称其这hash ...

2008-05-16 15:33:03 113

空空如也

空空如也