| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| ALTER SESSION SET CURRENT_SCHEMA=crono | 0 | 0 | 1 | maybe slow |
| ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' | 0 | 0 | 0 | |
| ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.,' | 0 | 0 | 0 | |
| begin dbms_application_info.set_client_info('3.140.188.195'); end; | 1 | 1 | 3 | maybe slow |
| begin dbms_application_info.set_module(module_name => 'desenv.cronotacografo.inmetro.rs.gov.br', action_name => '/informativos/consultar'); end; | 1 | 1 | 0 | |
| SELECT view_name AS name FROM all_views UNION SELECT table_name AS name FROM all_tables | 9707 | 9707 | 198 | |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'LOGS' | 10 | 10 | 2 | maybe slow |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'USERS' | 39 | 39 | 5 | maybe slow |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'CR_PERMISSOES' | 12 | 12 | 2 | maybe slow |
| SELECT PEM.DS_MODULO
, PEA.DS_ACAO
, LISTAGG(NVL(PER.GRO_ID, '0'), ',') WITHIN GROUP (ORDER BY PEM.DS_MODULO ASC, PEA.DS_ACAO ASC) "GRO_ID"
FROM CRONO.CR_PERMISSOES PER
, CRONO.CR_PERMISSAO_MODULOS PEM
, CRONO.CR_PERMISSAO_ACOES PEA
WHERE PER.PEM_ID = PEM.PEM_ID
AND PER.PEA_ID = PEA.PEA_ID
AND PER.AO_STATUS = 1
AND PEM.AO_STATUS = 1
AND PEA.AO_STATUS = 1
GROUP BY PEM.DS_MODULO, PEA.DS_ACAO | 330 | 330 | 6 | |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'CR_PARAMETROS' | 13 | 13 | 2 | maybe slow |
| SELECT CrParametro.group_id, CrParametro.ds_observacao, CrParametro.par_id, CrParametro.no_parametro, CrParametro.vl_parametro, CrParametro.ds_descricao, CrParametro.created, CrParametro.created_by, CrParametro.created_ip, CrParametro.modified, CrParametro.modified_by, CrParametro.modified_ip, CrParametro.ao_status FROM cr_parametros CrParametro WHERE CrParametro.ao_status = 1 | 223 | 223 | 137 | maybe slow |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'GROUPS' | 2 | 2 | 2 | |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'CR_ENSAIO_LOTE_DEVOLVIDOS' | 15 | 15 | 76 | maybe slow |
