Oracle: is there a tool to trace queries, like Profiler for sql server? [closed]

by

I found an easy solution

Step1. connect to DB with an admin user using PLSQL or sqldeveloper or any other query interface

Step2. run the script bellow; in the S.SQL_TEXT column, you will see the executed queries

SELECT            
 S.LAST_ACTIVE_TIME,     
 S.MODULE,
 S.SQL_FULLTEXT, 
 S.SQL_PROFILE,
 S.EXECUTIONS,
 S.LAST_LOAD_TIME,
 S.PARSING_USER_ID,
 S.SERVICE                                                                       
FROM
 SYS.V_$SQL S, 
 SYS.ALL_USERS U
WHERE
 S.PARSING_USER_ID=U.USER_ID 
 AND UPPER(U.USERNAME) IN ('oracle user name here')   
ORDER BY TO_DATE(S.LAST_LOAD_TIME, 'YYYY-MM-DD/HH24:MI:SS') desc;

The only issue with this is that I can’t find a way to show the input parameters values(for function calls), but at least we can see what is ran in Oracle and the order of it without using a specific tool.

More Related Contents:

  1. The order of a SQL Select statement without Order By clause
  2. What is the Oracle equivalent of SQL Server’s IsNull() function?
  3. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  4. Oracle sequence but then in MS SQL Server
  5. Updating image in VB and SQL Server not working [closed]
  6. Compare the values of column in SQL Server
  7. T-SQL stored procedure that accepts multiple Id values
  8. When/Why to use Cascading in SQL Server?
  9. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  10. Is it possible to force row level locking in SQL Server?
  11. Preserving ORDER BY in SELECT INTO
  12. Is a single SQL Server statement atomic and consistent?
  13. SQL Server file names vs versions [closed]
  14. How to add xml encoding to xml Output in SQL Server
  15. What are the differences between a clustered and a non-clustered index?
  16. Unable to begin a distributed transaction
  17. Difference between #temptable and ##TempTable?
  18. How to add custom attributes to SQL connection string?
  19. Compute MD5 hash of a UTF8 string
  20. Sort Bullets in Database
  21. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  22. How do I remove non-breaking spaces from a column in SQL server?
  23. Why is casting from float to varchar being rounded in SQL Server?
  24. SQL SERVER PIVOT table with joins and dynamic columns
  25. “Prevent saving changes that require the table to be re-created” negative effects
  26. How to change column datatype in SQL Server database without losing data?
  27. Convert UTC Milliseconds to DATETIME in SQL server
  28. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  29. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  30. Tool for Scripting Table Data

Leave a Comment