Skip to Main Content

SQL History

Last Active TimeParsing Schema NameSql TextModuleServiceElapsed TimeRows ProcessedDisk ReadsFirst Load Time
19-03-2024 02:20:07APEX_230200TEDSTRUIK/APEX:APP 25384:1freepdb12401682886218-03-2024 01:09:05
19-03-2024 02:20:07APEX_230200TEDSTRUIK/APEX:APP 25384:1135freepdb114314144018-03-2024 22:04:37
19-03-2024 02:20:07APEX_230200TEDSTRUIK/APEX:APP 25384:1041freepdb1715111019-03-2024 01:07:10
19-03-2024 02:20:07APEX_230200TEDSTRUIK/APEX:APP 25384:1freepdb131359184019-03-2024 01:08:25
19-03-2024 02:20:07APEX_230200TEDSTRUIK/APEX:APP 25384:1102freepdb1136802019-03-2024 01:04:39
  • 1 - 5 of 134

Info

My take on a query to list historical SQL statements. Play around with the where clause to change this to your needs.

Either run this query as sys/system, or give the user this privilege: Note that you can only select from v$sql; you cannot grant to v$sql or any other fixed views. So here we need to give the grant directly to the base table v_$sql instead.

The Dynamic Action in the Code section below is included as an example of how to get Codemirror to work in reports - more info on my Codemirror page. It is not needed for the rest of this example, but it does make it look nice.

Code

Region

Identification
Sequence
Title
Type
Source
Source Type
Region Source

Dynamic Action

Identification
Name
Execution Options
Sequence
When
Event
Selection Type
Region
Advanced
Event Scope
True Action
Identification
Action
Settings
Code
Execution Options
Sequence
Fire On Initialization
Affected Elements
Selection Type
jQuery Selector