Skip to Main Content

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!

SQL Performance Analyzer and Database Links

User_PVGP0Jul 28 2020

Hi

We are planning to use SQL Performance Analyzer.  The question I have is , how does SQL analyzer work on queries associated with DB links?

Oracle 12.1 and 19c

Rhel 7.

Thanks in advance

Comments

sb92075

How do I ask a question on the forums?

https://forums.oracle.com/message/9362002#9362002

unknown-7404
Installation is successful, but https://localhost:5500/em/ doesn't work. What is wrong?

Use google and search for "oracle 12c doesn't work" and see if you get any relevant hits.

If none of the search results seems relevant you might want to use a better term than "doesn't work"; there is NO such Oracle exception.

Installations also create an install log that you can review for issues/problems that occured during the install.

Zoltan Kecskemethy

I suggest to issue

emctl status dbconsole

in a terminal/command prompt to get your EM url.

  1. emctl status dbconsole 

emctl status dbconsole

in a terminal/command prompt to get your EM url.

Have you tried that with EM Express 12c?

C:\Oracle\product\12.1.0\dbhome_1>dir /s /b emctl*

File Not Found

The following might be better:

How can I find the port on which EM Express is configured?

Regards,

Mark

sqlplus sys as sysdba

SQL> select dbms_xdb_config.gethttpsport() from dual;

Should return something like:

DBMS_XDB_CONFIG.GETHTTPSPORT()

------------------------------

                          5500

1 - 5

Post Details

Added on Jul 28 2020
0 comments
100 views