Oracle 9i Admin
Computer
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
Oracle Concepts
Database design
Querying
PL/SQL tables
Dynamic SQL in PL/SQL
Nested blocks in PL/SQL
Triggers in PL/SQL
Tunning
|
|
||||||||||||
Oracle 9i Admin
Oracle Concepts
Database design
Querying
PL/SQL tables
Defining PL/SQL tables
Reasons to use PL/SQL tables
Populating a PL/SQL table
Retrieving from a PL/SQL table
Dynamic SQL in PL/SQL
Introduction to the dbms_sql package
Creating a dynamic SQL statement
Nested blocks in PL/SQL
Creating nested blocks
Understanding scope in nested blocks
Triggers in PL/SQL
Triggers and database events
Defining a trigger
Timing a trigger
Enabling and disabling a trigger
Tunning
Overview Of Oracle 9i Performance Tuning, Diagnostic and Tuning Tools,
System Statistics, Event Statistics
Tuning the Shared Pool, Tuning The Buffer Cache
Sizing The Other SGA Structures, Database Configuration and I/O Issues
Using Oracle Blocks efficiently, Optimizing Sort Operations
Tuning Undo Segments, Monitoring and Detecting Lock Contention
Tuning The Oracle Shared Server, Using Resource Manager for Mixed Workload
SQL Statement and Application Tuning
Using Other Schema Objects for Performance
Performance Monitor, SQL Analyze, Tablespace Manager, Top Sessions,
Database design
Querying
PL/SQL tables
Defining PL/SQL tables
Reasons to use PL/SQL tables
Populating a PL/SQL table
Retrieving from a PL/SQL table
Dynamic SQL in PL/SQL
Introduction to the dbms_sql package
Creating a dynamic SQL statement
Nested blocks in PL/SQL
Creating nested blocks
Understanding scope in nested blocks
Triggers in PL/SQL
Triggers and database events
Defining a trigger
Timing a trigger
Enabling and disabling a trigger
Tunning
Overview Of Oracle 9i Performance Tuning, Diagnostic and Tuning Tools,
System Statistics, Event Statistics
Tuning the Shared Pool, Tuning The Buffer Cache
Sizing The Other SGA Structures, Database Configuration and I/O Issues
Using Oracle Blocks efficiently, Optimizing Sort Operations
Tuning Undo Segments, Monitoring and Detecting Lock Contention
Tuning The Oracle Shared Server, Using Resource Manager for Mixed Workload
SQL Statement and Application Tuning
Using Other Schema Objects for Performance
Performance Monitor, SQL Analyze, Tablespace Manager, Top Sessions,
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
