oracle database performance monitoring scripts

In Oracle 10.2.0.4 database, there is a slow SQL execution, more than a few minutes without results, waiting for the event is idle Sql*net message events, and finally forced to break. This SQL is an ordinary UPDATE statement that has multiple tables associated in the WHERE clause and the associated tables are temporary tables. Update T_fund_product_info Set is_valid = ' N ' where prdt_id not in

In the development of SQL, filter date is often encountered in the situation, how to efficiently filter out the date period? This article is validated by experiments:Method One, compare dates into strings by To_charTo_char (cr.contractenddate, ' yyyy-mm-dd ') >= ' 2014-11-13 'and To_char (cr.contractenddate, ' yyyy-mm-dd ') Time: 0.171sMethod Two, by To_date to convert the string to a date for comparisonCr.contractenddate >= to_date (' 2014-11-13 ', ' yyyy-mm-dd ')and Cr.contractenddate Time: 0.

oracle| Data | database | performance Author: Brent Oracle database is favored by more and more enterprises because of its high reliability, security and compatibility. How to keep Oracle databases in good

1. Types of SQL parse SQL parse is usually divided into hard parsing and soft parsing. When SQL is executed for the first time, hard parsing will occur, and subsequent execution will be soft parsing if it can be found in the shared pool. Therefore, to improve data performance, try to find the SQL statement executed each time in the shared pool. 2. Under what circumstances does SQL send hard parsing?  1) Change the  Information 2) ddl operations are

"V$sqlarea" and "v$sql" are very useful views in which you can find the SQL statements that you find to be optimized for the least efficient execution. The value of the "disk_reads" column represents the amount of disk read by the statement in the system. This, combined with execution (disk_reads/executions), returns the SQL statement that each statement performs to achieve the optimal disk hit ratio. Any statements at the top of this list are most likely to be problematic queries that need to

Absrtact: Oracle database is one of the most widely used large-scale databases, and its optimization is directly related to the operation efficiency of the system. Based on the basic principle of database performance optimization, this paper expounds how to avoid competition and how to optimize data access in the

In the past few days, a project using nhib.pdf has been transplanted from SQL Server to Oracle (using odp.net). After transplantation, it is found that the unit test is much slower, determine whether it is related to nhib.pdf and odp.net. In the previous project, we found that odp.net had a low efficiency in establishing a connection, so we used the active connection method. However, when nhibsion is used, the system encapsulates NH In the DaO layer

1,sql Types of ParseSQL Parse is usually divided into hard parsing and soft parsing, and when SQL is executed for the first time, hard parsing occurs, and then execution is performed if the shared pool Can be found in the soft analysis. Therefore, to improve the performance of the data, it is possible to have SQL executed every time found in the shared pool .Under what circumstances will the 2,sql send hard parsing?  1   ) Statistics Informa

The Uniqueness index of the Oracle database is represented in the unique index created in the database table test. The EO generated by the test table does not have specific rules corresponding to the unqiue index; when you create a unique key in the database table test, the databas