![blog-post](/images/blog/vendor-logos/oracle_hu0e51f16f299b901974dc8c7c559a4bb9_49102_8460b6f757e49ad48b7f047327e591f9.webp)
Query to find service name
This article explains the steps to find the service name of a database running on your local windows machine. Open …
Query to find the queries executed by an user in Oracle
SELECT VS.USERNAME
, VS.MACHINE
, VS.PROGRAM
, VS.STATUS
, VST.SQL_ID
, VST.PIECE
, VST.SQL_TEXT
FROM V$SESSION VS
,V$SQLTEXT VST WHERE VS.SQL_ID = VST.SQL_ID AND VS.USERNAME = 'USER' ORDER BY VST.SQL_ID
,VST.PIECE;
This article explains the steps to find the service name of a database running on your local windows machine. Open …
Overview Transferring data between Amazon S3 buckets is a common requirement for many AWS users. This guide will walk …