Performance Analysis for Oracle - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
Product Enhancements (Ideas)
Contact Us
Technical Support
View All

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 1130
How to uninstall a corrupted Performance Analysis Agent installation for Oracle or SQL Server? (44712)

The user tried to uninstall Performance Analysis for Oracle and Performance Analysis for SQL Server. The user got a message saying: "The agent installation specified to be uninstalled is corrupted. Please use the brute Uninstall ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 4/17/2018
(0 Ratings) 11304 views
Checking for blocked ports from a remote computer when TELNET is not available (238273)

Blocked ports often contribute to product connection issues. Typically, Support requests to use TELNET or even run a “portable” version of PuTTY to test the connection. Increasingly customers are reluctant to install Telnet on their servers for security reasons. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 2/22/2018
(0 Ratings) 410 views
Error in Oracle Alert log: "ORA-07445: exception encountered: core dump" (43510)

Oracle Alert log shows core dumpt: ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [lmebco()+577] [SIGSEGV] [Address not mapped to object] [0xC0 00000163B2F5E0] [] [] Current SQL statement for this session: INSERT INTO ...

Product(s): Performance Analysis for Oracle
Last Updated On: 1/11/2018
(0 Ratings) 4981 views
Meltdown (CVE-2017-5715) and Spectre (CVE-2017-5753 & CVE-2017-5754) CPU Vulnerability (237415)

Meltdown (CVE-2017-5715) and Spectre (CVE-2017-5753 & CVE-2017-5754) exploit critical vulnerabilities in modern processors. These hardware bugs allow programs to steal data which is currently processed on the computer. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle...
Last Updated On: 1/8/2018
(0 Ratings) 22 views
Find block data showing in CBC Latch report (78502)

Performance Analysis (PA) is reporting contention on a cache buffer latch (hot data blocks). We're trying to understand the contents of the blocks to help determine why they're being so frequently accessed. Specifically, in the ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1499 views
An internal issue has occurred while installing agent on Active/Passive Oracle cluster (46377)

Installing PAO6.3 agent on active/passive cluster. We have failed over to the former passive node, now active. When running the installer, we get the following error: Middle-tier Host (DEFAULT: holland.ric.qimonda.com): holland ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1460 views
What are the Performance Analysis Scenarios? (49949)

What are the Performance Analysis Scenarios? and what is the correlation with the Repsository? PA uses three scenarios: StealthCollect scenario (SC), which is responsible to pass data from MW to the Repository database. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1681 views
Need to determine start/stop times of session (22983)

Is there an easy way to determine that actual start/stop time of the session ? If the time range you have selected includes the entire time that the offending statement was running, you can click on the SQL statement in the tree view, then click on the "Time Breakdown" tab. ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1415 views
Setting StealthCollect in SSH environment (20457)

You will receive a variation of unable to connect to port errors like "Could nor connect to the agent on the specified port .." meaning the ssh environment is unavailable through the normal out-of-the-box install process. Refer to ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1431 views
Sizing Documents for Performance Analysis for SQL Server (PASS) and Oracle (PAO) 7.0.4 and later (206900)

Sizing Document information for PASS and PAO 7.0.4 and later. In order to aquire the correct hardware for the MiddleWare machine, it is a prerequisite to use this document correctly. There is a specific sizing document for each database application. SQL Server Sizing Doc. ...

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1963 views
How to understand the Locking Behavior in Performance Analysis for Oracle (22098)

How to understand the Locking Behavior in Performance Analysis for Oracle. Attached is the document explaining the locking behavior in performance analysis for oracle.

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1505 views
The tns entry I added is not refreshing from the database pulldown menu (22061)

After adding a tns entry in the tnsnames.ora file, it is not viewable through the database pull-down menu in the Performance Analysis Profile screen. The refresh list button needs to be clicked to re-read the tnsnames.ora file. Click ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1474 views
How to determine which is the existing monitored and repository schemas and its respective dat (70859)

How to determine which is the existing monitored and repository schemas and its respective data and index tablespaces? To determine which is the monitored and repository schemas. Open this file (on the middleware). <installation ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1672 views
In Performance Analysis, how to compare the nodes in Cluster RAC? (32843)

How to compare the nodes in Cluster RAC? Go to History view, on the left hand panel, go to Cluster View | Instances, right click and select Compare.

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1550 views
PAO GUI client shown no data collection, only O/S data (see attachment) (116480)

PAO GUI client started up without issue, however, real time of Home tab still shows no data collection from database. PA Dev team encountered a strange problem when attempting to install the same exact OPatch that customer ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1319 views
Not getting shown active users and other data metrics (106463)

Only seeing memory% and slight disk %busy on the overview screen. All other metrics show 0. Session Logons show 0, despite many being defined in v$instance as running. See error screenshot. PAO 7.0.429 does not support Oracle v11.2.0.3 - Linux 32-bit STATUS: ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 78 views
What are the requirements for the Unix userid for installing Stealth Collector/middleware softwar (21295)

What are the requirements for the Unix userid for installing Stealth Collector/middleware software? In Unix, installation OS user account must have the following access rights - Oracle owner. - WRITE privileges to the installation directory. ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 33 views
Experiencing performance problems with repository/middleware databases on VMware (40493)

Can you please let me know if you have any recommendations around VMware and holding repository data on them. Please reviewed the PAO_Hardwar e_Considerations PDF available for download on Support Link? We do ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1409 views
Oracle error “ORA-6502 and ORA-06512” when installing Repository on Oracle Standard Edition (89444)

Error received when running the script quest_pa_internal_grant_rep_user. sql. ORA-6502 PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 29. (Example attached). We believe the error is happening ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 12 views
Collector does not start when database is failed over to passive unix node (86530)

Collector does not start when database is failed over to the passive unix node (active/passive unix cluster). Post install steps not completed. Please see the "Additional Unix/Linux Configuration" section of the Agent Installation ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1542 views
Startup parameters for Performance Analysis for Oracle console (25770)

What are the PARunner startup parameters and values? Right click on Performance Analysis for Oracle icon, and click on Properties This is the default value in shortcut's target " :\Performance Analysis\Common\PARunner.exe ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1568 views
Is there an option to show more than 25 number for each dimension in History? (64654)

Is there an option to show more than 25 number for each dimension in History? You can adjust the Performance Analysis (PA) Display Options to show more than 25 for each dimension in the History. Please take a look at the attached screenshot.

Product(s): Performance Analysis for SQL Server, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1502 views
Performance Analysis for Oracle creates explain plan for core Oracle code, causing "ORA-00600" er (45198)

Performance Analysis for Oracle (PAO) change management is generating explain plans for all core oracle codes causing "ORA-00600" errors. this is a default process by PA client. The appropriate solution to this problem is not to submit the SQL statements for Explain Plan. ...

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1523 views
How to connect to OracleXE database (74631)

How to connect to OracleXE database. OracleXE database is an unsupported platform - Please try a supported version from release notes attached.

Product(s): Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1441 views
MISC REDO waits (31249)

Ive been using Performance Analysis to monitor the redo waits. When I click on Real-Time| Wait Events and select the Redo resource, I see MISC REDO waits. I am trying to understand what does that mean? In some cases ...

Product(s): QCO Performance Analysis, Performance Analysis for Oracle
Last Updated On: 12/26/2017
(0 Ratings) 1773 views