The Oracle tutorial you are looking at is the development of high-performance, dynamic SQL programs based on Oracle.
Absrtact: The development of dynamic SQL program is summarized, and some development techniques are given according to the author's actual development experience.Key words: Dynamic Sql,pl/sql, high performance1. static sqlsql and dynamic SQLOracle
In Oracle databases, the Import utility restores the data that Export is detached to the database and recovers the database from faults. This requires a high time. Now we can make some improvements to reduce the Import performance time.
I. System-level changes
1. Increase the DB_BLOCK_SIZ parameter whenever possible during database reconstruction. The larger the block size, the less I/O cycles are required
The time spent preparing new SQL statements is the most important part of the execution time of Oracle SQL statements. However, by understanding the internal execution plan generation mechanism of Oracle, you can control the number of times that Oracle spends evaluating the connection sequence and improve query performance
Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. How to keep the Oracle database excellent performance is a lot of database management
Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. How
1. Avoid Dynamic Allocation DefectsCreate a local table space;Set the segment size properly;Monitor the segment to be extended:Select owner, table_name, blocks, empty_blocks from dba_tables where empty_blocks/(blocks + empty_blocks)
2. high water markThe records are recorded in the segment header block. When the segment is created, it is set to the starting position of the segment. When the record is inserted, it is added in increments of five blocks, truncate can reset the location of the hi
Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see!
Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle index optimization, refer!
Chapter 4 t
user trace file records the statistics that are executed by a user's SQL statement. Start user tracking can be at the instance level and session level.
Instance level: Sets the Sql_trace initialization parameter to TRUE and generally does not advocate tracking user actions at the instance level
Session level: Executes the dbms_system.set_sql_trace_in_session function, as follows
EXECUTE dbms_system.set_sql_trace_in_session (8,12,true); The Dbms_system package is created using Catproc.sql. You c
Authoritative Test organization TPC United States December 3 confirmed that Oracle company submitted the previous day SPARC T3-4 supercluster to TMPC (the number of transactions per minute) 30 249 688 created a new record of tpc-c performance testing. The original record was created by IBM Power 780 Server Model 9179-MHB in August this year. And Oracle's new machines are far more cost-effective than IBM.
I
Oracle performance optimization operation 8: Use HINT to forcibly specify an index
When the ORACLE optimizer cannot use a reasonable index, the HINT is used to forcibly specify the index.
In the example of "oracle Performance Optimization Operation 7",
optimizes full table scan by reading multiple data blocks at a time.B. Access the table through rowidYou can use rowid-based access to improve table access efficiency ,,Rowid contains the physical location information recorded in the Table. Oracle uses indexes to establish a connection between the physical location (rowid) of the data and the physical location (rowid) of the data.Generally, indexes provide a quick way to access rowid, so those querie
oracle| Performance | optimization
25. Use Index to improve efficiency
An index is a conceptual part of a table that is used to improve the efficiency of retrieving data. In fact, Oracle uses a complex, b-tree, self-balanced structure. In general, querying data through an index is faster than full table scans. The Oracle
for a50sql> set Linesize 200SQLG T Select Name,asynch_io from V$datafile f,v$iostat_file I where f.file#=i.file_no and (filetype_name= ' Data file ' or FIletype_name= ' Temp File '); -------------(view file information with async enabled) NAME asynch_io------------------------------- ----------------------------+datadg/rac/datafile/system.262.839537769 async_on+datadg/rac/datafile/system.262.8 39537769 async_on+datadg/rac/datafile/sysaux.263.839537911 async_on+datadg/rac/datafile/undotbs1.264.8
Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance of Oracle databases. Based on my experience, we suggest you consider the following aspects.
I. Partitioning
Based on actual experience, the vast majority of data s
Nowadays, Oracle databases are favored by more and more enterprises for their high reliability, security, and compatibility. Many database administrators are concerned about how to maintain excellent performance for Oracle databases. I suggest you consider the following aspects.
Partition
Based on actual experience, in a large database, the vast majority of datab
Oracle performance adjustment:
1. data access mechanisms, such as table full scan, index range scan, index full scan, and fast index scan. These contents allow me to understand how SQL statements interact with Oracle, how data is returned to the interface from a physical data file is required to adjust SQL statements.
2. The connection modes between tables are ne
Database performance exception and slowness caused by full archiving of Oracle logs
When the database performance is abnormal and slow due to full archiving of Oracle logs, I did not view the alarm log and thought it was because the lock blocking of the database affected the perfor
This article introduces how to use ODLA in oracle to diagnose the performance bottleneck of the ADF application. For more information, see.
Set the log level of the local WebLogic Server
Choose Configure Oracle Diagnostic Logging for "IntegratedWebLogicServer"
Set Log Level
Root Logger: CONFIG
Oracle: CONF
The ORACLE tutorial is: Oracle acquires TimesTen to improve database software performance. Oracle announced in June 9 that it had agreed to acquire TimesTen, a private software company whose products can improve the performance of database applications that require rapid res
1. The question
The system has a module that needs to query the data in the Oracle database. It is now implemented by establishing a linked server.
SQL Server access Oracle implementation can refer to this article http://www.cnblogs.com/gnielee/archive/2010/09/07/access-oracle-from-sqlserver.html
The current query statement is a simple query with a where condi
I have not picked up Java for several years (N> 3 ), the reason why I wrote this article is purely for developers to use jdbc to reduce interaction and improve batch update Performance in batches. If you are a DBA, after work, you can recommend this article to developers. Maybe he knows these examples. If he does not know, it is also a kind of welfare. Considering that the interaction time can be reduced between the application client and the database
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.