iSelfSchooling - Manuscripts

Learn about the important notes to remember when you do Oracle installation. The Oracle database and Developer are very easy to install. The only difficulty that you may face is: How to establish connectivity between the Oracle developer tools and the Oracle database on the same machine such as windows98. - Manuscript

Hands-On 02-Basic Introduction

Understanding of the basic definition of elements, fields, and items, columns, records, and rows, tables, datatypes, primary keys and foreign keys. - Manuscript

Hands-On 03-Installation and connectivity (TEXT)

Learn how to establish a connection from Developer to Oracle Database Personal Edition. - Manuscript

Hands-On 04-Installation and connectivity

The Oracle database and Developer are very easy to install. The only difficulty that you may face is: How to establish connectivity between the Oracle developer tools and the Oracle database on the same machine such as windows98. Learn how to make this connectivity. - Manuscript

Hands-On 05-De-installation-Remove Oracle (TEXT)

How to remove all Oracle products, Oracle services, and Oracle registry entries from your computer. - Manuscript

Hands-On 06-Create "iself" user

Learn how to run the script to create a user named "iself" with password "schooling" and all its tables. - Manuscript

Manuscripts for Hands-On SQL

Hands-On 01(SQL)

Learn how to select data from Oracle - Manuscript

Hands-On 02(SQL)

Learn how to select data from Oracle using advanced data selection in Oracle - Manuscript

Hands-On 03(SQL)

Learn how to create, drop, and maintain Oracle Database objects - Manuscript

Hands-On 04(SQL)

Learn more how to create, drop, and maintain other Database Objects in Oracle - Manuscript

Hands-On 05(PL/SQL)

Learn how to use command line editor which it is native to SQL*PLUS. - Manuscript

Hands-On 06(PL/SQL)

Learn how Oracle makes provisions for you to utilize your favorite text editor to edit the statement created in "afiedt.buf," the file into which SQL*PLUS stores the most recently executed SQL statement. - Manuscript

Manuscripts for Hands-On PL/SQL I

Hands-On 01(PL/SQL)

Learn how to use command line editor which it is native to SQL*PLUS. - Manuscript

Hands-On 02(PL/SQL)

Hands-On 03(PL/SQL)

Learn the basic fundamentals of PL/SQL block. - Manuscript

Hands-On 04(PL/SQL)-Explicit Cursor Handling

Learn how to declare a cursor to list the department name (dname), total number of employees (ttemp), total salary (ttsal), and average salary (avsal) for each department from the department table and employee table. - Manuscript

Hands-On 05(PL/SQL)-Controlling Process Flow

Learn how to modify the previous PL/SQL block to use the "FOR LOOP" statement vs simple "LOOP." - Manuscript

Hands-On 06(PL/SQL)-Populating table using PL/SQL

Learn how to create a table with a primary key constraint and then populate the table. - Manuscript

Hands-On 07(PL/SQL)-Cursor Parameter

Learn how to use the “test_for_loop2” file from the previous Hands-On. Then modify the PL/SQL block that the cursor only calculate the department statistics for a specific department. For example the department number 10. - Manuscript

Hands-On 08(PL/SQL)-How to use EXECPTION

Learn how to modify the “test_for_loop3” file from previous Hands-On. You need to add exception to the PL/SQL block. - Manuscript

Manuscripts for Hands-On PL/SQL II (Program Units)

Hands-On 01 (PL/SQL)-Create PL/SQL Procedure

Learn how to create a table called "cust_stat." This table keeps the customers last name (customer_lname), the traded date (trade_date), and the total stock market value (portfolio_value) for that traded date. - Manuscript

Hands-On 02 (PL/SQL)-Creating PL/SQL Stored Procedure

Learn how to write a PL/SQL stored procedure to add a record into the department table (dept). You use three input parameters to pass the department's columns (Department number “deptno,” department name “dname,” and department location “loc”); and use one output parameter to check the status of the insert transaction. - Manuscript

Hands-On 03 (PL/SQL)-Creating PL/SQL Stored Procedure

Learn how to write a PL/SQL stored procedure to remove a record from the department table (dept). You use one input parameter to pass the department number (deptno); and use one another output parameter to check the status of the delete transaction. - Manuscript

Hands-On 04 (PL/SQL)-Creating PL/SQL Function

Learn how to write a PL/SQL Function to concatenate the customer's last name and first name to be separated by a comma. For example (lastname, firstname). - Manuscript

Hands-On 05 (PL/SQL)-Creating PL/SQL Function using parameters

Learn how to write a PL/SQL Function to return the department name (dname). You use one input parameter to pass the department number (deptno) and return its department name. - Manuscript

Hands-On 06 (PL/SQL)-Debugging a PL/SQL Stored Procedure

Learn how to debug a procedure that is supposed to calculate the factorial of a number. You should pause and playback the movie as much as it is needed. - Manuscript

Hands-On 07 (PL/SQL)-Granting Object Privileges

Learn how to create, copy, alter, and drop a table, view, synonym, and user. How to grant, revoke object and system privileges. - Manuscript

Hands-On 08 (PL/SQL)-Managing Objects Dependency

Learn how to view some of the Oracle directory views and experience the Oracle object dependencies (timestamp). - Manuscript

Hands-On 09 (PL/SQL)-Creating Package

Learn how to create a package by copy and pasting an existing PL/SQL stored procedures. Then save it in the local library or the database server. - Manuscript

Hands-On 10 (PL/SQL)-Developing and using Database triggers

Learn how to create a table and name it "audit_dept" (audit department table). The table contains only one column (audit_line) and it should be big enough to fit 80 characters. - Manuscript

Go To INDEX

Oracle9i SQL New Features

Manuscripts for Oracle9i and Developer 6i New Features

Create the ISELF schema

Learn how to run the script to create a user named "iself" with password "schooling" and all its tables. - Manuscript

Introduction 01 ("Must to know" Oracle9i: SQL New Features)

Learn the new Oracle ANSI SQL standard statement and compare it with the original non-ANSI Oracle SQL. - Manuscript

Introduction 02 ("A Must to know" Oracle9i: SQL New Features)

Learn more about some Oracle9i: SQL New Features such as the “MERGE” and “WITH summary_name AS” statements. - Manuscript

Hands-On 01 (Materialized Views – The view that stores data)

Learn how to pre-compute database information into a summary data aggregated to be easily understood. Learn how to write simple SQL statement using the “ROLLUP” operator to create salary subtotals for each type of job per year. Also, you should use the CUBE operator to enable a simple statement to calculate all possible combinations of the types of jobs and year for the research department only. - Manuscript

Hands-On 02(The break on clause)

Learn how to write a simple report to create a control break on columns. - Manuscript

Hands-On 03 (Troubleshooting – UNION, INTERSET, and MINUS statements)

Learn how to check the contents of a table with an another table. - Manuscript

Hands-On 04 (Troubleshooting Deleting duplicated records)

Learn how to eliminate records duplication from a table. - Manuscript

Hands-On 05 (Data Partitioning)

Learn how to partition a table and how to run a query against a partition segment. - Manuscript

Hands-On 06 (Data Warehousing – The ROLLUP and CUBE function)

Learn how to to write simple SQL statement using the “ROLLUP” operator to create salary subtotals for each type of job per year. Also, hot to use the CUBE operator to enable a simple statement to calculate all possible combinations of the types of jobs and year for the research department only. - Manuscript

Hands-On 07 (Using Native Dynamic SQL)

Learn how to write a stored procedure to pass the table name and get back the number of records that table contains. The SELECT statement must be created a dynamically, since you don’t know what table you are getting statistics from. You should write your function so that your client can display all of the tables’ name, plus the number of records contained each table. - Manuscript

Hands-On 08 (JAVA Stream)

Learn how to write a simple java program to identify a special problem that can be classified by iselfschooling’s problems only. - Manuscript

Hands-On 09 (Defining Objects and Collection Types)

Learn how to use the nested object tables for a table. Learn how to use the “CONSTRUCTOR” operator to refer to the nested table with the “THE” syntax. - Manuscript

Hands-On 10 (Inserting employees’ picture into the EMP table using BLOB / CLOB)

Learn how to add pictures into a table using a stored procedure - Manuscript

Hands-On 11 (Viewing a picture using BLOB datatype)

Learn how to develop an application form to display all of the employee information plus their picture. - Manuscript

Hands-On 12 (What is a REF CURSOR)

Learn how to complete the process for basing a block on a stored procedure for “single block operations and create a package called "managers_pkg.". - Manuscript

Hands-On 13 (FORM BLOCK and TRANSACTIONAL TRIGGERS)

Learn how to use the “managers_pkg” package from previous Hands-On that you created to insert, delete, update, lock, and count a record. - Manuscript

Go To INDEX

Developer

Manuscripts for Hands-On Oracle Tools

Hands-On 01 (An example of how to use Schema Builder)

Learn how to to define the tables, views, snapshots, synonyms, constraints, and table relationships that will make up your database. You can visualize your database design, including the tables, columns, data types, and relationships, and then execute that design. - Manuscript

Hands-On 02 (An example of how to use Query Builder)

Learn how to write your simple or complex query. You can save your query at your client-side. It allows you to set your table relationships and visualize your database objects that being linked, including the tables, columns, and datatypes. - Manuscript

Hands-On 03 (An example of how to use Procedure Builder)

Learn how to develop stored procedures, functions, packages, and triggers in Oracle. Many developers have found the SQL*PLUS and favorite text editor approach cumbersome. You use Procedure Builder for ease of writing program development, debugging, and version control. - Manuscript

Hands-On 04 (An example of how to use Form Builder)

Learn how to simplify for the creation of data-entry screens, also known as Forms. Forms are the applications that connect to a database, retrieve information requested by the user, present it in a layout specified by Form designer, and allow the user to modify or add information. Form Builder allows you to build forms quickly and easily. - Manuscript

Hands-On 05 (An example of how to use Report Builder)

Learn how to use report wizard, use object navigator, use report builder, save report, use “data model”, use property palette, work on query and group box, see report style, use tabular style, navigating through report’s record, change the format mask for dollar, numeric and date items. - Manuscript

Hands-On 06 (An example of how to use Graphics Builder)

Learn how to create a chart, write a query, execute a query, modify a query, and save a chart. - Manuscript

Manuscripts for Forms and Reports Case Study

Hands-On Form Builder (Internet Applications Tool)

Hands-On 01(Forms)-Tab canvas, Master-detail relationship

Learn how to use tab canvas, Master-Detail relationship. - Manuscript

Hands-On 02(Forms)-Tooltip, Hint, Format Mask, Properties

Learn how to use and change the Help, Hint, and format mask of properties. - Manuscript

Hands-On 03(Forms)-LOVs, Record Group

Learn how to use the List of Values (LOV), and group records. - Manuscript

Hands-On 04(Forms)-Radio Buttons

Learn how to add and use Radio Buttons. - Manuscript

Hands-On 05(Forms)-Display items, Summary and Function columns

Learn how to display fields, summary and formula functions. - Manuscript

Hands-On 06(Forms)-Triggers (POST-QUERY)

Learn how to use the POST-QUERY trigger. - Manuscript

Hands-On 07(Forms)-Horizontal Toolbar, Push Button, Trigger (when-button-pressed)

Learn how to create and use horizontal toolbar, create and use push button item, create "WHEN-PUTTON-PRESSED" trigger, write and compile trigger. - Manuscript

Hands-On 08(Forms)-Sizing , Layout appearances

Learn how to size your canvas, change the horizontal toolbar canvas. - Manuscript

Hands-On 09(Forms)-Trigger (PRE-QUERY), set dynamically properties

Learn how to create and use pre-query trigger, set dynamically block property on a table's data block and execute the query using trigger. - Manuscript

Hands-On 10(Forms)-Sequence object, Trigger (pre-insert)

Learn how to create sequence object, create and use "PRE-INSERT" trigger. - Manuscript

Hands-On 11(Forms)-Call form

Learn how to call another form. - Manuscript

Hands-On 12(Forms)-Global variable, trigger (when-new-form-instance)

Learn how to use and assign global variable, pass global variable from one form to another, use global variable to execute query base on that parameter, create and use "WHEN-NEW-FORM-INSTANCE" trigger. - Manuscript

Hands-On 13(Forms)-Main menu

Learn how to create or modify default main menu, use and assign global variable from one form to another, use global variable to execute query base on that parameter, create and use "WHEN-NEW-FORM-INSTANCE" trigger. - Manuscript

Hands-On 14(Forms)-Pop up menu

Learn how to create "pop-up" menu, with following functionality "CUT", "PASTE", and "COPY." - Manuscript

Hands-On 15(Forms)-Move objects, Layout appearances

Learn how to move objects around, create or copy, paste the logo. - Manuscript

Hands-On 16(Forms)-Run Application from desktop

Learn how to run your application from desktop. - Manuscript

Hands-On Report Builder (Internet Applications Tool)

Hands-On 01(Reports)-Tabular

Hands-On 02(Reports)-Group left

Learn how to use report wizard, use report style “group left”, use template, use pre-viewer, use zoom in and out, use the body section in the layout model in the object navigator, change repeating object’s property palette. - Manuscript

Hands-On 03(Reports)-Mailing Label

Learn how to use report style “mailing label,” use the “query builder,” generate three columns label, change the font and size, change it to two columns label, use handlers on the layout model. - Manuscript

Hands-On 04(Reports)-Matrix

Learn how to use query builder, set table relationship, change properties from property palette, use report style matrix, make subtotal for rows and columns, use the “select parent frame” icon, create grid, use the conditional formatting. - Manuscript

Hands-On 05(Reports)-Form Letter

Learn how to use the report style “Form Letter,” use the “query builder,” set table relationships, define column from the “query builder,” use sub-query, use of data model, layout model, use of boilerplate, write the letter and pass the column to the letter. - Manuscript

Hands-On 06(Reports)-Group above

Learn how to use a master-detail report, build a new report manually, create multiple “sql query,” create data link, use the formula column, use the summary column, use the report “group above” style, use object navigator, layout model, main section, use property palette. - Manuscript

Hands-On 07(Reports)-Template

Learn how to create or modify an existing template, save the template with new name, change the default, delete the logo, replace the new logo, save your template. - Manuscript

Hands-On 08(Reports)-Layout appearances

Learn how to use boilerplate. - Manuscript

Hands-On 09(Reports)-Parameters

Learn how to use the “group above,” use the “query builder,” set table relationship, create and use binding variable, calculate total and average shares, delete the object from layout. - Manuscript

Hands-On 10(Reports)-Drill Down or Push Button report

Learn how to use push button to execute another report, use or pass parameter, use the “select parent frame” icon, use or open objects property, compile report, use the boilerplate, write and compile PL/SQL trigger, use “runtime pre-viewer.” - Manuscript

Hands-On 11(Reports)-LOVs (List Of Values)

Learn how to use parameter, modify parameter properties using property palette, use query builder, add more parameters to existing parameter Form. - Manuscript

Go To INDEX

DBA

Manuscripts for Oracle Fundamentals I Case Study

Hands-On Oracle Fundamentals I-CD#01 (Database Administrator-DBA)

Hands-On 01 (The most important Dictionary Views)

Learn how to obtain the most important dictionary views. - Manuscript

Hands-On 02 (Startup and Shutdown the database)

Learn how to start-up and shut-down the database. - Manuscript

Hands-On 03 (Multiplexing controlfiles)

Learn how to multiplexing control files. - Manuscript

Hands-On 04 (Reading the ALERT file)

Learn how to read the ALERT file to be informed of any unknown problems with the database such as, not enough space in the rollback segment or the maximum extent reached in a table, etc. - Manuscript

Hands-On 05 (Changing the database mode)

Learn how to change the database mode for database maintenance purposes. - Manuscript

Hands-On 06 (Server Parameter File-SPFILE)

Learn how to change memory size allocations while the database is on. - Manuscript

Hands-On 07 (Configure the database to the archive mode)

Learn how to change a database mode from no archive log to archive log and how to maintain online redo-log files. - Manuscript

Hands-On 08 (Maintaining and Relocating the Redo Log files)

Learn how to maintain and relocate the Redo Log file in order to distribute data among multiple hard disks to increase I/O performance. - Manuscript

Hands-On 09 (Multiplexing and Maintaining the Online Redo Log files)

Learn how to maintain multiple Online Redo log files to protect your organization of a possible loss of data due to media failure. - Manuscript

Hands-On 10 (Maintaining Tablespace and Datafiles)

Learn how to maintain tablespaces and datafiles due to the growth of a user’s database.   - Manuscript

Hands-On 11 (Maintaining a TEMPORARY tablespace)

Learn how to maintain a TEMPORARY tablespace due to a user’s big transaction sorting.   - Manuscript

Manuscripts for Oracle Fundamentals I Case Study

Hands-On Oracle Fundamentals I-CD#02 (Database Administrator-DBA)

Hands-On 12 (Maintaining a Tablespace)

Learn how to maintain tablespaces and datafiles due to a user’s usage of the tablespace. How to change the tablespace mode to the READ ONLY mode, relocate the tablespace to a new not busy disk. - Manuscript

Hands-On 13 (Managing Storage Structures)

Learn how to manage a table storage structure due to performance problems or a spacing issue. - Manuscript

Hands-On 14 (Maintaining and Configuring UNDO tablespace)

Learn how to maintain UNDO tablespaces due to an users’ database transactions, how to use UNDO_MANAGEMENT, UNDO_TABLESPACE, UNDO_RETENTION parameters. - Manuscript

Hands-On 15 (Maintaining and Configuring an UNDO tablespace manually)

Learn how to maintain UNDO tablespaces manually due to an users’ database transactions.   - Manuscript

Hands-On 16 (Creating and Maintaining a TEMPORARY table)

Learn how to create and maintain a TEMPORARY table due to your organization’s developer requirements (transactional or session). - Manuscript

Hands-On 17 (Detecting ROW Migration and Chaining)

Learn how to detect row migration and chaining. - Manuscript

Hands-On 18 (Monitoring an object usage)

Learn how to monitor newly created indexes.   - Manuscript

Hands-On 19 (EXCEPTIONS INTO EXCEPTIONS)

Learn how to use the advantages of the EXCEPTIONS clause. - Manuscript

Hands-On 20 (Maintaining user’s account and profile)

Learn how to maintain user accounts due to the growth of the organization. Learn how to create a profile to limit a group of users from using the database resources. - Manuscript

Hands-On 21 (Auditing a database)

Learn how to audit the database due to a suspicious transaction on certain table - Manuscript

Hands-On 22 (Creating a new database)

Learn how to create a new database. - Manuscript

Manuscripts for Oracle Fundamentals II Case Study

Hands-On Oracle Fundamentals II-CD#01 (User-Managed Backup and Recovery)

Hands-On 01 (Memory Space Allocation on the Fly)

Learn how to monitor and change a memory space allocation of your organization’s database in case of performance problems. - Manuscript

Hands-On 02 (Oracle Background Processes)

Learn how to to monitor and understand the functions of the Oracle background processes. - Manuscript

Hands-On 03 (Multiplexing the Control File)

Learn how to multiplex controlfiles to protect your organization from a possible and unexpected loss of controlfiles, due to media failure. - Manuscript

Hands-On 04 (Configuring the Database Archive mode)

Learn how to change a database mode from no archive mode to archive mode to recover any failures to a point of failure and also to perform your backup while in an online status. - Manuscript

Hands-On 05 (Maintaining Redo Log files)

Learn how to maintain and relocate the Redo Log files in order to distribute data among multiple hard disks to increase I/O performance. - Manuscript

Hands-On 06 (Duplexing Archived Online Redo Log files)

Learn how to duplex archived Online Redo log files in order to protect the organization from a loss of or a case of corrupted archived files. - Manuscript

Hands-On 07 (User-Managed COLD or OFFLINE backup)

Learn how to backup the database and restore the data in case of a loss of data due to media failure. Learn how to use the COLD or OFFLINE backup process. - Manuscript

Hands-On 08 (User-Managed HOT or ONLINE backup)

Learn how to backup the database and restore the data in case of a loss of data due to media failure. Learn how to use the HOT or ONLINE backup process.   - Manuscript

Hands-On 09 (User-Managed Tablespaces and Datafiles Backup)

Learn how to backup the tablespace or datafile and restore the data to the point of failure in case of a loss of data due to a media hard disk crash. - Manuscript

Hands-On 10 (User-Managed Tablespace Recovery)

Learn how to recover the database to the point of failure due to a loss of data and media failure. - Manuscript

Hands-On 11 (User-Managed Logical Backup and recovery)

Learn how to perform a logical backup using the EXP and IMP tools. Learn also how to use the IMP tool to restore data to the same or a different destination. - Manuscript

Manuscripts for Oracle Fundamentals II Case Study

Hands-On Oracle Fundamentals II-CD#02

(RMAN-Managed Backup and Recovery along with Network Configurations)

Hands-On 01 (RMAN-Managed user and repository)

Learn how to create the RMAN repository and use the RMAN tool to perform a backup and recovery of your organization’s database. - Manuscript

Hands-On 02 (Use of the RMAN commands)

Learn how to register a database, synchronize a database, and back-up a database. - Manuscript

Hands-On 03 (Configuration of the RMAN tool)

Learn how to configure the RMAN repository, perform an image copy, connect to the target and catalog databases, etc. - Manuscript

Hands-On 04 (Using the RMAN backup utility)

Learn how to perform backups of a database, perform incremental backups, and use the formatted defined output name. - Manuscript

Hands-On 05 (RMAN-Managed Tablespace Recovery)

Learn how to recover a tablespace due to a loss of data from a media system crash. - Manuscript

Hands-On 06 (RMAN-Managed Complete Backup)

Learn how to perform a complete backup using the RMAN tool. - Manuscript

Hands-On 07 (RMAN-Managed incomplete database recovery scenario)

Learn how to recover a table to a point in time due to user failure (Scenario only). - Manuscript

Hands-On 08 (RMAN-Managed incomplete database recovery)

Learn how to recover a table to a point in time due to user failure. - Manuscript

Hands-On 09 (RMAN-Managed the LIST and REPORT commands)

Learn how to obtain backup information using the LIST and REPORT commands. - Manuscript

Hands-On 10 (Configuring a Listener using the “Net Manager” tool)

Learn how to configure a listener using the “Net Manager” tool.   - Manuscript

Hands-On 11 (Configuring a Service Name using the “Net Manager” tool)

Learn how to configure a Service Name using the “Net Manager” tool.   - Manuscript

Manuscripts for Oracle Performance Tuning Case Study

Hands-On Oracle Performance Tuning-CD#01

Hands-On 01 (Why tuning and what is Granule unit)

Learn where to start investigating a performance problem and then solve it. - Manuscript

Hands-On 02 (Memory Space Allocation on the Fly)

Learn how to monitor and change memory space allocation of your organization’s database in case of a performance problem. - Manuscript

Hands-On 03 (Sizing the Shared Pool)

Learn how to monitor and change the memory space allocation for the Shared Pool in the SGA memory in case of performance problems. - Manuscript

Hands-On 04 (Sizing the Buffer Cache)

Learn how to monitor and change the memory space allocation for the Buffer Cache in the SGA memory in case of performance problems. - Manuscript

Hands-On 05 (Measuring the Buffer Cache Hit Ratio)

Learn how to monitor and calculate the Buffer Cache Hit Ratio in the SGA memory in case of performance problems. - Manuscript

Hands-On 06 (Monitor and size the Redo Log buffer)

Learn how to monitor and resize the Redo Log buffer in the SGA memory in case of performance problems. - Manuscript

Hands-On 07 (Database I/O problem)

Learn how to monitor and detect I/O problems of your organization’s database in case of performance problems. - Manuscript

Hands-On 08 (Optimize Sort Operations)

Learn how to optimize sort operations of your organization’s database in case of performance problems. - Manuscript

Hands-On 09 (Diagnosing Contention for Latches)

Learn how to diagnose any latch contentions in the Shared Pool area in case of performance problems. - Manuscript

Hands-On 10 (Tuning rollback or undo segment)

Learn how to tune rollback or undo segments in case of performance problems. - Manuscript

Hands-On 11 (Monitoring and Detecting Lock Contention)

Learn how to monitor and detect a lock contention in case of a performance problem. - Manuscript

Hands-On 12 (Optimizing a SQL statement)

Learn how to optimize a SQL statement using the EXPLAIN PLAN statement in case of performance problems. - Manuscript

Hands-On 13 (Diagnostic and Tuning Tools)

Learn how to use and read the STATSPACK tool in a case of a performance problem. - Manuscript

Oracle Enterprise Manager Case Study

Hands-On Oracle Enterprise Manager (OEM)-CD#01

Hands-On 01 (Discovering a Server Node using OEM)

Learn how to add databases to the Oracle Enterprise Manager. Learn how to discover the node to your OEM and how to start and shut down a database. - Manuscript

Hands-On 02 (Managing Users using OEM)

Learn how to manage (create, drop, and maintain) an Oracle user account using OEM tool. - Manuscript

Hands-On 03 (Managing Roles using OEM)