| 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 | 1 | maybe slow |
| ALTER SESSION SET NLS_NUMERIC_CHARACTERS='.,' | 0 | 0 | 0 | |
| begin dbms_application_info.set_client_info('3.145.42.140'); end; | 1 | 1 | 3 | maybe slow |
| begin dbms_application_info.set_module(module_name => 'desenv.cronotacografo.inmetro.rs.gov.br', action_name => '/portaria_aprovacao_modelos'); end; | 1 | 1 | 1 | |
| SELECT view_name AS name FROM all_views UNION SELECT table_name AS name FROM all_tables | 9707 | 9707 | 192 | |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'USERS' | 39 | 39 | 7 | maybe slow |
| 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 = 'CG_REF_CODES' | 11 | 11 | 2 | maybe slow |
| SELECT CgRefCode.rv_domain, CgRefCode.rv_low_value, CgRefCode.rv_high_value, CgRefCode.rv_abbreviation, CgRefCode.rv_meaning, CgRefCode.stamp, CgRefCode.crc_user, CgRefCode.dt_insert, CgRefCode.no_user_insert, CgRefCode.crc_id, CgRefCode.dt_vigencia FROM cg_ref_codes CgRefCode WHERE CgRefCode.rv_domain = 'PERFIL_PORTARIA_APR_MODELO' AND (CgRefCode.dt_vigencia IS NULL OR SYSDATE < CgRefCode.dt_vigencia) | 3 | 3 | 43 | maybe slow |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'CR_PORTARIA_APR_MODELOS' | 13 | 13 | 72 | maybe slow |
| SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH FROM all_tab_columns WHERE table_name = 'CR_PORTARIA_MODELOS' | 11 | 11 | 79 | maybe slow |
| SELECT CrPortariaAprModelo.pam_id, CrPortariaAprModelo.arq_id, CrPortariaAprModelo.ds_marca, CrPortariaAprModelo.ds_modelo, CrPortariaAprModelo.ds_pam, CrPortariaAprModelo.ds_observacao, CrPortariaAprModelo.created, CrPortariaAprModelo.created_by, CrPortariaAprModelo.created_ip, CrPortariaAprModelo.modified, CrPortariaAprModelo.modified_by, CrPortariaAprModelo.modified_ip, CrPortariaAprModelo.ao_status FROM cr_portaria_apr_modelos CrPortariaAprModelo WHERE CrPortariaAprModelo.ao_status = 1 ORDER BY CrPortariaAprModelo.ds_marca ASC | 27 | 27 | 81 | maybe slow |
| SELECT CrPortariaModelo.pom_id, CrPortariaModelo.pam_id, CrPortariaModelo.arq_id, CrPortariaModelo.ds_portaria, CrPortariaModelo.created, CrPortariaModelo.created_by, CrPortariaModelo.created_ip, CrPortariaModelo.modified, CrPortariaModelo.modified_by, CrPortariaModelo.modified_ip, CrPortariaModelo.ao_status FROM cr_portaria_modelos CrPortariaModelo WHERE CrPortariaModelo.pam_id IN (21, 23, 22, 101, 24, 25, 27, 26, 2, 28, 29, 81, 50, 55, 54, 53, 52, 51, 44, 45, 46, 47, 48, 49, 41, 42, 43) | 37 | 37 | 51 | maybe slow |
