Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 88)

13-12

7. Also query data dictionary to ensure that hash partitoned indexes are created, and all primary

key and foreign key constraints are valid.

SELECT table_name, index_name FROM dba_part_indexes WHERE owner IN

('GLOGOWNER','REPORTOWNER');

SELECT owner, status, constraint_type, COUNT(*) FROM

dba_constraints WHERE owner IN ('GLOGOWNER','REPORTOWNER') GROUP BY

owner, status, constraint_type;

8. Restart all web and application servers.

Changing Database Pool Size

As your server load varies, you may need to change the number of connections in the database pool.

This may increase the performance of your Oracle Transportation Management instance. To determine

if you have a database connection bottleneck, follow the instructions provided under the Microsoft

Windows section in the Operating System Monitoring Tools section.

After making any database pool changes, you may need to stop and restart Oracle Transportation

Management, as described in the chapter Starting and Stopping the Oracle Transportation

Management Servers. Also, before you change your pool size, consult a qualified Oracle DBA and

ensure that your database can handle the new number of connections. If you set your pool

connections higher than your database can support, Oracle Transportation Management will not be

able to startup and function correctly. The instructions below describe how to make these changes.

1. Log into your Oracle Transportation Management system (http://<otm_webserver_name>) as

the user DBA.ADMIN.

2. In the left frame expand Configuration and Administration > System Administration > Data

Source Manager.

3. Select search.

4. Select the desired database pool.

5. You can now edit the initial capacity, maximum capacity, and capacity increment. If resources

permit, you should set the initial and maximum capacity to the same value and save some

overhead involved with expanding and shrinking the database pool.

Purging Excess Reports from the REPORT_LOG Table

Purge Process for UNIX

1. Log into the UNIX machine on which the report server is installed.

2. Run the shell script

purgeRepLog.sh

The script prompts for the nine parameters that are listed later in this section. Based on the

parameters passed, the script deletes the records from the database and deletes the PDF files.

Note: The USERID used to logon to the UNIX machine should have delete permissions on

the PDF files created by the report server.

Purge Process for Windows

1. Log into the Windows machine on which the Report server is installed.

2. Run the batch file purgeRepLog.bat with the parameters that are list later in this section (in

the order specified).

Based on the parameters passed, the script deletes the records from the database and deletes the

PDF files.

1 2 ... 83 84 85 86 87 88 89 90 91 92 93 ... 105 106

Kommentare zu diesen Handbüchern

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 88

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software Axis RightFax 8.5