Skip to Main Content

Database Software

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!

Predicate information in SQL Monitor(Text) report

Rajeshwaran JeyabalApr 22 2020 — edited Apr 22 2020

The output produced by SQL Monitor report is really helpful.

current we use this dbms_sqltune.report_sql_monitor(type=>'text') - to get the Textual version of sqlmonitor report, very light weight when compared to "active" format. - How the predicate information section is missing in the Textual version, but the same is available in the "active" format

It would be very helpful, if the textual version supports the predicate information, that would help us to isolate what part of the predicates were access and filters, while we navigate through the execution plan details.

Comments

862536
Hi,

I too would be interested to know the answer to this, as I have a request to provide a POC for a system which will service both internal and external customers logging into an APEX application, or possibly two separate APEX applications.

I do know of a number of successful installations which service both internal and external customers, but I'm not aware of the licensing considerations involved.

Thanks,
Graham
Udo
Hi Graham,

there had been another thread were Kris posted a clarification of the license terms for the APEX Listener. See {message:id=9714073}.

-Udo
862536
Thanks Udo - so the database license covers it. Problem solved!
mark.lancaster
Hi Udo

I don't think Kris's response addressed the issue of "internal business operations" at all.

You can use the APEX listener if you have a licensed database; this is the same as using Oracle Application Server for zero cost provided it physically resides on the same server as the database.

However the APEX listener license specifies you can use it for "internal business operations". This restriction does not exist for Oracle AS.

This is the part that needs clarification.

Regards

Mark
Udo
Hi Mark,

I think this is a misunderstanding. What you are referring to is the OTN license. When I use the one linked at the APEX Listener OTN home page, I get the same agreement as I get for APEX ([url http://www.oracle.com/technetwork/licenses/app-express-lic-152009.html]ORACLE TECHNOLOGY NETWORK DEVELOPMENT AND DISTRIBUTION LICENSE AGREEMENT TERMS FOR ORACLE APPLICATION EXPRESS). This is the only licensing documentation I could find at all.
I don't think Kris' response was in respect to the APEX OTN License, but a general answer, as the question was aimed at a "production site" - which can't be used with any OTN License I know of, including Oracle AS.

Perhaps I oversaw or misunderstood something here. If you have any hint on what other terms you've based your judgement on, please let me know.

Thanks,

Udo

P.S.: The Licensing Information in the downloaded package actually includes a slightly different version, but still OTN license information only. I think this document is outdated, as it also still contains the EA-license, which shouldn't apply to the current release anymore.
Thinking of that, there seems to be a need to update the downloadable package...

Edited by: Udo on 29.11.2011 08:31
1 - 5

Post Details

Added on Apr 22 2020
0 comments
273 views