[go: up one dir, main page]
Scribd
Upload
91 views2 pages

PL/SQL Native Compilation Guide

1. Stop the BI application to avoid data source disconnections during the database restart. 2. Change the Oracle Database parameter PL/SQL_CODE_TYPE to NATIVE, restart the database, and validate that PL/SQL objects are now compiled natively. 3. Restart the database listener and BI application, and validate the system is working correctly.

Uploaded by

babitae
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
91 views2 pages

PL/SQL Native Compilation Guide

1. Stop the BI application to avoid data source disconnections during the database restart. 2. Change the Oracle Database parameter PL/SQL_CODE_TYPE to NATIVE, restart the database, and validate that PL/SQL objects are now compiled natively. 3. Restart the database listener and BI application, and validate the system is working correctly.

Uploaded by

babitae
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Activity

Enable Native PL/SQL Compilation for Data Warehouse

MOS Reference
How To Convert the Entire DB From INTERPRETED Mode to NATIVE or Vice Versa for PL/SQL (Doc ID
1340441.1)

Action Plan
1. Stop BI Application (to avoid data source disconnection after DB restart)

2. Database server activity

Stop database listener

lsnrctl stop LISTEN_POBI

Compile invalids and take plsql settings count before activity

$ cd /home/sdbisdba/SBI-4774

$ sqlplus / as sysdba

SQL> @?/rdbms/admin/utlrp

SQL> spool list_invalid_b4.txt

SQL> @list_invalid_objects.sql

SQL> spool off

SQL> spool verify_plsql_settings_b4.txt

SQL> @verify_plsql_settings.sql

SQL> spool off

Backup initialization file (optional)

SQL> create pfile='/tmp/pfileSBIDWPR.ora' from spfile;

Alter DB parameter and restart DB

SQL> alter system set plsql_code_type='NATIVE' scope=spfile;

SQL> shutdown immediate

SQL> startup upgrade

SQL> @?/rdbms/admin/dbmsupgnv.sql TRUE

SQL> shutdown;

SQL> startup

SQL> alter system enable restricted session;


Take invalids count and plsql settings count after activity

SQL> spool list_invalid_after.txt

SQL> @list_invalid_objects.sql

SQL> spool off

SQL> spool verify_plsql_settings_after.txt

SQL> @verify_plsql_settings.sql

SQL> spool off

SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;

Stop database listener

lsnrctl start LISTEN_POBI

3. Start BI Application and validate

Known issue
In Dev and QA “sysman.MGMT_STARTUP” got invalid after activity. This can be compiled manually.

SQL> alter trigger sysman.MGMT_STARTUP compile;

Trigger altered.

You might also like