Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 50)

8-4

Creating Indexes

First, you create indexes as follow:

1. Connect to the source database as glogowner and run the following:

<OTM_INSTALL_HOME>/script8/fti_indexes.sql

2. Connect to the source database using a sys user and run following commands:

alter system set optimizer_index_caching=0 scope=BOTH;

alter system set optimizer_index_cost_adj=100 scope=BOTH;

3. Install and configure the ODI Agent in the target (hdowner) database instance machine.

Changing the ODI Agent’s Heap Size

Next, you change the heap size of the ODI agent as follows:

1. Open one of the following files depending on the operating system:

a. Windows: <ODI_HOME>/oracledi/agent/bin/odiparams.bat

b. Linux: /oracledi/agent/bin/odiparams.sh.

2. Change following parameters values based on available RAM.

set ODI_INIT_HEAP=512m

set ODI_MAX_HEAP=1024m

3. Go to Topology Manager > Physical Architecture > Oracle >

ORACLE_OTM/ORACLE_FTI.

4. Increase Array Fetch Size/Batch Update Size based on the environment. You can increase the

sizes to 100 and check the performance.

5. If you observe no improvement in performance, then increase to some other numbers and try

again.

6. Continue to increase these numbers until you see performance improvement. Eventually the

performance increase will level off.

Configuring OBI EE

Setting up an OBI EE Agent

To set up an OBI EE Delivers Agent, complete the following:

Note: In Fusion Transportation Intelligence, these are called Alerts.

1. In OBI EE enterprise manager, set up the SMTP server. Refer to the OBI EE documentation for

details.

2. All Business Intelligence Roles that ship with Oracle Transportation Intelligence have the

correct privileges to access Oracle Delivers and create agents (alerts). However, if an Oracle

Transportation Management user cannot access the Alerts page, you need to enable alerts as

follows:

a. Log into Oracle Transportation Management as DBA.ADMIN.

b. Click Transportation Intelligence > Alerts.

c. Click the Administration link in the upper right corner of the Oracle Business

Intelligence page.

d. Under Security, click Manage Privileges.

e. Under Access, make sure the Business Intelligence Role specified on your Oracle

Transportation Management user is listed next to Access to Delivers.

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 105 106

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 50