How to find sql text from a sid
col sql_text form a80
set lines 120
select sql_text from gv$sqltext where hash_value=
(select sql_hash_value from gv$session where sid=&1)
order by piece
/
Format Date in Oracle Database - NLS_DATE_FORMAT
When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of DD-MON-YY, and no time component. There are multiple ways to see the time component of a DATE column, in sqlplus. You can either alter your session to set the date format, or you can use a function in your select statement to alter the format of the column. alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS' ; select sysdate from dual; SYSDATE ------------------- 12/01/2022 20:19:06 select to_char(sysdate, 'DD-MON-YY HH24:MI:SS' ) from dual; TO_CHAR(SYSDATE,'D ------------------ 12-JAN-22 20:19:50 How about RMAN? How can you see the date and time a backup completed or started? By default you only see the same format as in sqlplus: DD-MON-YY. This format is not always enough. You try an alter session command in RMAN (same as above), and it doesn’t work. Instead, what is the solution? You must set the NLS_DA...
Comments
Post a Comment