Spotlight on Unix connections do not display all data in the metrics in the Activity Summary window.
User received the following error while trying to access the parallel queries graph, the second time after restarting Spotlight, and the third time after opening the metrics window for block changes/sec.
tns entry for ASM instance does not exist in tnsnames.ora file ... add tns entry for ASM instance in tnsnames.ora file (see sample tns entry attached)
When logging into database with Spotlight the following error comes up. ... An error has occurred in table InitializeFast in connection <connection> with the following error: ORA-06550:line 2, column 18: PLS-00302: component 'INITIALIZE_FAST' must be declared
Spotlight displays wrong value for optimizer_mode. ... Spotlight shows value as CHOOSE, while db shows a value of ALL ROWS.(see atachments). ... Customer is looking for the explanation since they don't know if all the information they are getting from spotlight are correct.
While creating Spotlight user, insufficient privileges in table BuildXview message is displayed ... The Oracle account being used to install the read-only views into the SYS schema to configure the Spotlight user does not have sysdba privilege
Target PGA showing 0 in Spoptlight on Oracle, wherePGA target is 10GB.
Where the system that you are diagnosing has two or more CPUs, this control may show a total CPU usage greater than 100%. ... This value represents the addition of usage percentages across the CPUs, rather than an overall percentage use of CPU resources.
What is new in Spotlight on Oracle 10.8? ... Spotlight on Oracle 10.8 now supports monitoring Oracle 19c databases and connecting to the Oracle 19c client. ... Windows 2019 is a supported platform for the installation of Spotlight on Oracle and for monitoring.
When trying to connect in Spotlight on RAC, the user gets the error message: "This TNS entry is a duplicate of another" ... 2) If TNS entry is correct, please delete and re-create the connection profile.
Where do I download Spotlight on Oracle 7.1? ... To download Spotlight on Oracle v7.1: ... 1) Go to http://support.quest.com and login ... 2) Under "Go to Product Information Page" enter "Spotlight on Oracle" for the product and click "Go".
Spotlight on Oracle 7.1.0.1481 - The following internalerror occurred: Access violation at address 0048E7C8 in module'Spotlight.exe'. ... The following internal error occurred: ... Access violation at address 0048E7C8 in module 'Spotlight.exe'.
Does Spotlight support jump servers to monitor the OS? ... Spotlight needs to be able to directly log into the database server via ssh or rexec in order to monitor the OS. ... Jump servers are not supported.
Why spotlight does not have this same history browser views as PA allowing to view recent SQL statements that were run. ... Performance Analysis is the Quest product for doing this. ... Spotlight doesnnâ€t have this facility, we donnâ€t have agent-style Spotlight facility.
There is a problem whereby an object is blocking sid 106 from sid 79. ... It reports that KCRT_FLS_VISIBILITY is wanted by SID 106 but for SID 79, it has that as status ... "Not Blocking", although it is holding a lock on it, so it could be blocking.
After right-clicking the instance box in my RAC overview I selected metrics. ... My wish is to see and edit the metric settings for reported alarms. ... The instance metrics page comes up but there doesnnâ€t seem to be much I can do there except reorder things and the information in the Metric Help box is empty and so is the alarm help.
1) It seems like Spotlight generated too many files within 1 hour. ... How can I setup so it will generate 1 file per hour? ... 2) How can I view the XML file? ... I tried Internet Explorier (IE) but it showed the code instead of graphic.
Do we need to install both? ... What are the different components or products that come with them? ... The Toad for Oracle product that comes in the Toad for Oracle DBA Suite and the Toad for Oracle DBA Suite - RAC Edition is actually the same.
I am unable to apply my license key to Spotlight on Oracle versions prior to 7.1. ... If you were recently issued a license key, the format for license keys has changed for Spotlight on Oracle 7.1.
An error occurred while refreshing the table "LogicalDisks" in connection "SIEC PrrÃ-Production sql-a". ... †Click OK to continue, †Click Ignore to ignore any further errors related to this table, or †Click Disconnect to close this connection.
ASM menu is grayed out ... First verify that the password entered in the Connection profile is for the â€syss†user on this ASM instance plus try connecting remotely through SQLplus preferably from the machine Spotlight is installed on.
How long does Spotlight on Oracle keep history data? ... Spotlight on Oracle does not keep any history unless you launch the History Browser (under View | History Browser), then it takes snapshots every 5 minutes.
 ... From the man page for â€/etc/usr/attrrâ€, it looks like it should work but it doesn't
What are the requirements for EM in Spotlight Oracle? <div><p>Regarding the EM Agent, the OS user should have permission to access the Oracle home and can run emctl, plus all the permissions listed in Release Notes under "Monitored Operating system requirements."</p><p>However, the Database control for 12C and later version is not supported because the “emctl” command is no longer use in this version.
Email notifications don´t work when there is a condition for Description value for Spotlight on Unix. ... Any of the values in the list does not trigger the rule. ... Use condition "Where the control is..." if you want to limit the rule for a specific metric/control.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center