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.

RULE hint and 11g

myhandleMar 29 2010 — edited Mar 29 2010
Oracle Standard Edition 11.1.0.7.0

We all know that the RULE hint is not longer supported, so in that case why would Oracle themselves want to use it ?

select parsing_schema_id,sql_Text from v$sqlarea where upper(sql_text) like '%+ RULE%' or upper(sql_text) like '%+RULE%'

I get 7 rows back from my 11gR1 database (and many more from 10gR2)

Basically, we have a bunch of issues with parsing SQL in a 10gR2 environment, upgrading from 9iR2, setting optimizer_features_enable down at lower releases, as far as the minimum 8.0.3, does provide quicker parses with still acceptable plans, but RULE hint gives the best parse, so wondering about the support situation if we deplot it tactically. Oracle can hardly object if the RDBMS itself uses the hint, surely ?

Comments

277993
See Enterprise Manager SNMP Support Reference Guide

http://download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b16244/toc.htm
637909
I can't found an Oracle SNMP configuration guide that has the specific steps for the Oracle and Linux version of my case anyway I follow general steps and I have this message in master_peer.out
snmp bind failure: Address already in use
smux bind failure: Address already in use
./master_peer: error processing configuration
and in encap_peer.out:
trap bind failure: Address already in use
./encap_peer: error opening manger-role port(s)
Finally please I need to know if It is necesary to add in /etc/services a line reference of 1161 port.
23ai
This link http://download-uk.oracle.com/docs/cd/B16240_01/doc/em.102/b16244/toc.htm is not really very useful.

It seems Oracle does not provide enough documentation on the SNMP Configuration.

I am having the same problem and no idea?

Any idea guys..
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 26 2010
Added on Mar 29 2010
#general-database-discussions
6 comments
6,063 views