Spotlight on Oracle Professional

What is Spotlight on Oracle Professional?

The fastest way to find and fix Oracle performance compressions.

Spotlight on Oracle Professional is a database diagnostic tool that lets you quickly discover performance issues in your Oracle database. By providing a real-time dashboard of all your critical database processes, Spotlight reveals the performance status of your Oracle components, locating areas of inefficiency for rapid diagnostics.

Spotlight on Oracle Professional does this by automatically setting a baseline of normal activity for each instance and then setting limits. This can also be customized to meet the requirements of your environment. Then, based on these thresholds, Spotlight on Oracle provides alerts because it detects performance issues of any kind. And using a recording and playback function, you can also see historical activity.

Spotlight on Oracle Professional (incluído com Toad DBA Suite para Oracle)

• Identify and diagnose performance issues – whether related to a specific user, SQL transaction, I/O issues, lock wait, or other exact source
• Automatic definition of baselines, thresholds, and display alerts
• Diagnose operating system inefficiencies by fixing performance issues in Linux, UNIX, and Windows
• Predictive Diagnostics anticipates future performance issues before impacting the database
• Detect and diagnose problems in Oracle RAC (Real Application Cluster) environments in node, cluster, and interconnection (Spotlight on Oracle RAC)

Benefits:

• Minimize the time it takes to identify Oracle performance issues
• Diagnose the source of database inefficiencies in just a few clicks
• Visualize database process flows through an intuitive GUI for instant visual understanding, helping in quick time for resolution
• Reduce the risk of deceleration of unplanned database performance and downtime

System requirements:

Windows Vista Business

Windows Server 2003, 2008,

2012

Windows 7, 8, 10

SQL * Net 2.3.4 or later

Oracle 9.2 a 12c

Operating system:

Windows Server 2008, 2012

Oracle Solaris 9, 10, 11

Windows 7, 8, 10

HP-UX 11i, 11i v2, 11i v3

IBM AIX 5.2, 5.3, 6.1, 7.1

Red Hat e SUSE (Linux kernel 2.4, 3.0, 3.1)

Oracle Enterprise Linux (OEL) com base em kernels Linux 2.4, 2.6 e 3.8

Cloud services:

Oracle databases running on Amazon EC2 and Amazon RDS

Serviços Oracle Rac

Spotlight on Oracle RAC supports up to 16 instances in a cluster, with a limit content of 36 instances.