Deploy the SQL profiles

SQL profiles can be used to improve performance.

To create a SQL Profile, a user must have the following privileges:

To deploy SQL profiles:

Unzip InForm_SQLProfiles.zip.(located in the <Installation_Directory>\InForm\Bin\DBOra\ReviewSchema folder).
Connect to SQLPlus as a user with the proper privileges (for example, system user).
Create a staging table in the destination database.
EXEC DBMS_SQLTUNE.CREATE_STGTAB_SQLPROF (table_name => 'STGTAB_SQLPROF_DB006');
Import the data to the destination database.
imp <user>/<pwd>@<instance> tables=('STGTAB_SQLPROF_DB006') file= InForm_SQLProfiles.dmp log=imp.log ignore=y
Make sure that you're logged in as the same user as in Step 2, and create SQL Profiles in the destination database using the data stored in the staging table.
EXEC DBMS_SQLTUNE.UNPACK_STGTAB_SQLPROF(replace => TRUE, staging_table_name => 'STGTAB_SQLPROF_DB006');
Verify that the profiles imported correctly.
Select name, created from dba_sql_profiles;