⌘KCtrl+K 快速搜索

> 文章列表 / Page 262

2011-08-08

Seconds in wait

The term "seconds in wait" means the number of seconds that a SQL Statement, Database User, etc. was waiting on an event. It is possible that the total number of "seconds in wait" exceeds the total am...
#POST 2 MIN READ
2011-08-08

Round-Trip Time

Round-trip time when running "select 1 from dual" (includes network time but not connect time) on this database. Solution If this is high, contact your network administrator to un...
#POST 1 MIN READ
2011-08-08

Reduce the Number of SQL Statements

Shareable SQL uses bind variables rather than literal values. If an application makes use of literal (unshared) SQL then this can severely limit scalability and throughput. The cost of parsing a new S...
#POST 3 MIN READ
2011-08-08

PX qref latch等待事件

Contention caused by communication between parallel query processes. Solutions Decrease the degree of parallelism for the queries Tune the parallel_execution_message_size paramete...
#POST 1 MIN READ
2011-08-08

PX Deq: Table Q Normal等待事件

Occurs when a parallel slave is waiting for data from another slave. Investigate why the other slaves are not sending data fast enough. This is normally considered an idle event, but can cause excessi...
#POST 1 MIN READ
2011-08-08

PX Deq: Execution Msg等待事件

Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases. Solution Reduce the degree of ...
#POST 1 MIN READ
2011-08-08

PX Deq: Execute Reply等待事件

Occurs when the query coordinator is waiting for a response from a parallel slave. This is normally considered an idle event, but can cause excessive CPU in some cases. Solution R...
#POST 1 MIN READ
2011-08-08

Library Cache Hit Ratio

The library cache (a component of the shared pool) stores the executable (parsed or compiled) form of recently referenced SQL and PL/SQL code. Oracle tries to reuse this code. If the code has been exe...
#POST 1 MIN READ
2011-08-08

Changing an Init.ora Parameter

To change an init.ora parameter, follow these steps. Open the file called init<database_name>.ora. For example, if the database is called oraprod, then the file would be called initoraprod.ora. ...
#POST 2 MIN READ
2011-08-08

提高DBWR进程的吞吐量

Improve DBWR Throughput To improve DBWR's throughput, consider the following: Disk capabilities and setup (stripe size, speed, controllers etc...) Using raw devices instead of File System files -- dep...
#POST 2 MIN READ