Oracle Database Concepts includes an introduction to Oracle SQL and PL/SQL. However, it is impossible to tune applications or a database without knowing SQL. Oracle Database Concepts explains the basic relational data structures, transaction management, storage structures, and instance architecture of Oracle Database.īecause of the existence of GUI-based tools, it is possible to create applications and administer a database without knowing SQL. For example, not understanding Oracle Database concurrency controls and multiversioning read consistency may make an application corrupt the integrity of the data, run slowly, and decrease scalability. As a developer, you want to develop applications in the least amount of time against an Oracle database, which requires exploiting the database architecture and features. Table 1-1 Required Knowledge Required Knowledgeĭatabase architecture is not the domain of administrators alone. To disable the use of existing SQL Quarantine configurations, set OPTIMIZER_USE_SQL_QUARANTINE to FALSE (the default is TRUE). To enable SQL Quarantine to create configurations automatically after the Resource Manager terminates a query, set the OPTIMIZER_CAPTURE_SQL_QUARANTINE initialization parameter to TRUE (the default is FALSE). The default setting is false, which means real-time statistics Initialization parameter is set to true, Oracle DatabaseĪutomatically gathers real-time statistics during conventional DML operations. This control may be useful for ad hoc queries or testing new functionality.Ĭontrols for enabling or disabling the gathering of real-time statistics. The automatic indexing process does not identify index candidates, or create and verify indexes. Session-level controls for automatic indexingīy setting the OPTIMIZER_SESSION_TYPE initialization parameter to ADHOC in a session, you can suspend automatic indexing for queries in this session. The following features are new in this release:
0 Comments
Leave a Reply. |