Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Switch log file

jairamMar 7 2013 — edited Mar 8 2013
Hi Everyone,

We are using the 9i database and during the import, we have temporarily added 2 new log groups (Each 2 gb in size) to improve the import performance. After the completion of the import we have a plan to drop those newly added log groups. In order to do that we have issue the command "Alter system switch logfile".,
but it is running more than 8 hrs., We have increased the Log_archive_max_processes value also but still it is running.,

Could anyone please suggest about how to improve the speed of switch log file operation?

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production


Regards,
Jai
This post has been answered by unknown-7404 on Mar 8 2013
Jump to Answer

Comments

1062147

Can anybody please answer my query.

Thanks

Alok Bakshi-Oracle

you can use throttling in OSB refer http://docs.oracle.com/middleware/1213/osb/administer/osb-message-throttling.htm

1 person found this helpful
Vasim Patel-Oracle

hi

12.1.3, EDN supports only  Oracle AQ JMS and Oracle WebLogic Server JMS providers. MQ is not supported

by default the JMS type is WLJMS, to see the JMS type: goto EM-> right click soa-infra->Administration->System MBean Browser->search for EDNConfig mbean ->JmsType

You can define the event(.edl) from the schema(xsd) in JDeveloper for the soa server.

43 Using Business Events and the Event Delivery Network (12g Release 1 (12.1.3.0.0))

1 person found this helpful
Vasim Patel-Oracle

Refer the following in the above link

http://docs.oracle.com/middleware/1213/soasuite/administer/business-events-manage.htm#SOAAG98178

Support for both the Oracle AQ JMS and Oracle WebLogic Server JMS providers. An Oracle WebLogic Server JMS topic (default) and an AQ JMS topic are automatically configured for EDN use after installation. The default JMS type can be switched from Oracle WebLogic Server JMS (default) to AQ JMS in Oracle Enterprise Manager Fusion Middleware Control. For more information, see "Mapping Business Events to JMS Topic Destinations on the Business Events Page" of Administering Oracle SOA Suite and Oracle Business Process Management Suite.

1 person found this helpful
1062147

Hi,


How to achieve Throttling in SOA Suite or this is archive in WebLogic and OSB only ?

or SOA Suite dose does not provide any option to achieve Message Throttling form its GUI/JDeveloper or EM but through WebLogic or OSB it can be achieve ?


Thanks

1062147

If Event Driving Network is using Oracle AQ JMS and Oracle WebLogic Server JMS then why don’t we use JMS or AQ using Adapters. Then what is the benefits of using Even instated of using JMS because internally it is using JMS only ?

Vasim Patel-Oracle

Hi

EDN is a lightweight manager above JMS. By default SOA comes with OOTB EDN JMS topic.

EDN users don't need to directly handle underlying JMS destinations. They publish and subscribe events to EDN

Basic XPath filters supported by EDN.

Plus there is JMS API and EDN API available for non-SOA clients to pub/sub with SOA EDN.

Refer: 43 Using Business Events and the Event Delivery Network (12g Release 1 (12.1.3.0.0))

1 person found this helpful
Vasim Patel-Oracle
Answer

Further main benefits of using EDN instead of JMS messaging are:

To interact with SOA components via EDN events

Strong typing with inherent XML support.

Easy to use: simple event type definition, pub/sub configuration (design-time), and you are ready to deploy/run.

No need to manage JMS administered objects, e.g. queue, connection factories, etc. - This is true in 11g. This is also true in 12c unless scalability becomes a concern where additional JMS topic is needed with event-to-JMS mapping change.

PL/SQL (database) publishers supported (if based on AQ).

Marked as Answer by 1062147 · Sep 27 2020
1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 5 2013
Added on Mar 7 2013
#general-database-discussions
16 comments
385 views