Vi ste ovdje
Overview/Description
Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting the output of the tkprof command. Tuning statements automatically eases the entire SQL tuning process and replaces manual SQL tuning. Statement profiling, and using the SQL Tuning Advisor, the SQL Access Advisor, and Automatic SQL Tuning are...
Overview/Description
The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical...
Overview/Description
An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command and the PLAN_TABLE, using AUTOTRACE, dynamic performance views that contain execution plan information, the Automatic Workload Repository (AWR), and SQL monitoring. The star schema is the simplest data...
Overview/Description
Access paths are the ways in which data is retrieved from the database, and there are a number of different access paths which can be used for tables and indexes. This course explores the access paths used for tables, such as full table, rowid, and sample table scan. It also examines the access paths used for indexes, such as unique, range, full, fast full, skip, and index join index scans, as well as bitmap indexes and combining bitmap indexes. Additionally, this course discusses B*-tree, bitmap, composite, and invisible indexes and nullable columns when using indexes....
Overview/Description
Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics. if you use SQL statements where literal values are provided for the WHERE clause conditions, you get results in many versions of almost identical SQL to be stored in the library cache. If, instead of issuing different statements for each...
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
