Oracle - Trace

SELECT
S.LAST_ACTIVE_TIME,
S.MODULE,
S.SQL_TEXT,
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 ('SGCORESYS')
ORDER BY S.LAST_ACTIVE_TIME desc;

ORACLE lectura de parametros de base de datos

select * from database_properties where PROPERTY_NAME in ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;


select * from v$parameter order by name