Hi, Sometimes customer ask you that why spesific sql is running long time or consuming lots of resource.   Oracle DBA should find this sql’s SQL_ID in the Oracle database and monitor this SQL how it is running. To find any SQL’s SQL_ID and other SQL informations in the cache, use following SQL. Following query … Continue reading Oracle Historical SQL Search