The Spring Framework is a popular open source application development framework for building lightweight enterprise applications. It makes Java development more ...
PL/SQL Oracle optimization
Approximately 80% of all Oracle performance problems are resolved by coding optimal PL/SQL.
Learn Oracle tuning techniques in 2 hours. Explore real-world advice and techniques from practitioners.
Oracle optimization and performance tuning begins with design. In many cases, the core performance problem in a Oracle application has been designed into the system. There is a lot you can do to increase the performance of Oracle databases significantly. You may be able to identify the most resource-intensive parts of the application, focusing future tuning efforts on specific database parameters or PL/SQL statements. Database tuning is crucial in any modern database systems.
Learn Oracle optimization video tutorial: 10 lessons, 2 hours 2 minutes.
- Import data into the database (03:30)
- Indexes (10:21)
Using a table without indexes, Create a index by creating a primary key constraint, Creating an Index, Creating a Bitmap Index, Placing an Index in the Database, Rebuilding an Index, Function-Based Indexes
- Partitioning and Creating an Index-Organized Table (15:06)
Creating an Index-Organized Table, Creating a Partitioned Table, Creating a hash partition, List Partitioning, Creating Subpartitions, Indexing Partitions
- Generating and Reading Explain Plans (06:01)
Display the reading explain plan
- Joins (11:22)
Operations That Perform Joins, Merge Join, Nested Loops and Hash Join
- Parallelism and Implementing Stored Outlines (07:38)
Implementing Stored Outlines, Parallelism
- Using Oracle Text for Text Searches (29:42)
Adding Text to the Database, Text Queries and Text Indexes, Text Queries, Searching for an Exact Match of a Word, Searching for an Exact Match of Multiple Words, Searching for an Exact Match of a Phrase, Searches for Words That Are Near Each Other, Using Wildcards During Searches, Searching for Words That Share the Same Stem and Searching for Fuzzy Matches, Searches for Words That Sound Like Other Words, Using the ABOUT Operator, Index Synchronization
- Tuning - Best Practices (20:33)
Do as Little as Possible, Do It as Simply as Possible, Tell the Database What It Needs to Know, Maximize the Throughput in the Environment, Test Correctly
- REF Cursors and SYS RefCursors (08:55)
Cursor type as function/procedure result, ref cursor, sys_refcursor
- Materialized views refresh fast on commit (08:45)
Materialized view log with rowid, fast-refreshable materialized views, refresh fast on commit, refreshing view
- save your time
- learn Oracle optimization in the fastest and most effective way
- get instant access and download your video tutorial