Voltar
-
Título
How to see the SQL statement from Browse History? -
Descrição
Spotlight for Sybase takes a snapshot when alarm occurs. When examining the Browse History to look at past history, how can the SQL statements for specific times be pulled up?
-
Resolução
SQL statements are only available in live connection. Collecting SQL statement data is very resource intensive and only performed when you focus on the drill down in real time. Data saved for History does "not" include SQL statements.To see SQL Statements in real time do this:1. Connect to Sybase database.2. Right-click on Problem Users and go to "Show Details | User Activity General."3. In User Activity tab, applications which are connected to database are listed. Click on an application and check the SQL statement in SQL Detail below.