Filter
Top Products
select * from v$loghist order by first_time desc
Following is an example of the output:
THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME SWITCH_CHANGE#
1 97 7132082 10/20/2008 11:47:53 PM 7155874
1 96 7086715 10/20/2008 11:32:04 PM 7132082
1 95 7043684 10/20/2008 11:15:07 PM 7086715
1 94 6998984 10/20/2008 11:00:57 PM 7043684
1 93 6950799 10/20/2008 10:48:03 PM 6998984
In this example, the logs are switched every 15 minutes.
Rollback Transaction Errors
If Sterling B2B Integrator is running with Oracle and is under load, the snap shot
too old SQL error may be found in the wf.log file. The SQL error can be resolved
with the following:
v Tune the Oracle database by increasing undo_retention and redo table space.
v If the SQL error is from WFReportService (from the stack trace in wf.log),
change the useNewStateAndStatusLogic property in jdbc.properties and
jdbc.properties.in to false. This will prevent the snap shot too old SQL error, but
it might cause the Recover process to run longer.
Database Storage
This topic provides information about database storage.
ASM
It is recommended that you use Oracle Automatic Storage Management (ASM) to
manage database storage. The benefits of using ASM include:
v Improved I/O performance and scalability
v Simplified database administration
v Automatic I/O tuning
v Reduction in number of objects to manage
For more information, consult these sources:
v ASM documents available on the Oracle Web site.
v Storage vendor best practice papers about how to configure ASM for their
storage products.
Raw Disks
For performance-critical systems, importing only raw devices into ASM is
recommended. For high-volume processing environments, ensure that ASM is
configured with disk devices from high-performance disk storage arrays. Some
characteristics that you should look for include large NVRAM caches in order to
buffer the disk reads and writes, and for efficient RAID implementation.
26 Sterling B2B Integrator: Performance Management