[root@zza-server: /u01/apex/utilities]# sqlplus /nolog SQL*Plus: Release 11.2.0.2.0 Production on Sun May 27 19:00:36 2018 Copyright (c) 1982, 2011, Oracle. All rights reserved. SQL> connect sys as sysdba Enter password: Connected. SQL> @report_instance_configuration.sql ================================================================================ Oracle Application Express Instance Configuration 2018-05-27 19:00 ================================================================================ Database Information ==================== Parameter Value -------------------- ----------------------------------------------------------- Server Host zza-server Database Name XE Instance Name XE Version Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production AQ TM Processes 0 Dispatchers (PROTOCOL=TCP) (SERVICE=XEXDB) Job Queue Processes 100 Shared Servers 4 DB Character Set AL32UTF8 Server Time Zone +06:00 XDB HTTP Port 0 XDB HTTPS Port XDB Anonymous Access false Registry Information ==================== Instance Schema Version Status --------------------- ----------- -------- APEX_180100 18.1.0.00.4 VALID 5 All Application Express Schemas =============================== Schema Account Status Type Info ------------------------ ---------------- --------------------------- --------------- FLOWS_FILES EXPIRED & LOCKED APEX File Repository APEX_180100 EXPIRED & LOCKED APEX Instance (Development) Current - en APEX_INSTANCE_ADMIN_USER EXPIRED APEX Instance Admin User ANONYMOUS LOCKED APEX Run User (EPG) APEX_PUBLIC_USER OPEN APEX Run User (ORDS, OHS) APEX_LISTENER OPEN ORDS REST Admin User APEX_REST_PUBLIC_USER OPEN ORDS REST Run User ORDS_PUBLIC_USER OPEN ORDS REST Run User ORDS_METADATA EXPIRED & LOCKED ORDS Repository User Objects in APEX_180100 ====================== Status Type Count Last DDL ---------- ------------------------------ ------ ---------- VALID FUNCTION 8 2018-05-26 VALID INDEX 1450 2018-05-26 VALID JOB 4 2018-05-27 VALID LOB 217 2018-05-26 VALID PACKAGE 322 2018-05-26 VALID PACKAGE BODY 316 2018-05-26 VALID PROCEDURE 13 2018-05-26 VALID SEQUENCE 5 2018-05-26 VALID SYNONYM 3 2018-05-26 VALID TABLE 470 2018-05-27 VALID TRIGGER 538 2018-05-26 VALID TYPE 20 2018-05-26 VALID TYPE BODY 5 2018-05-26 VALID VIEW 310 2018-05-27 Constraints in APEX_180100 ========================== Owner Type Status Count ----------- ---- ---------- ------ APEX_180100 C ENABLED 2789 APEX_180100 P ENABLED 452 APEX_180100 R ENABLED 744 APEX_180100 U ENABLED 111 APEX_180100 V ENABLED 1 FLOWS_FILES C ENABLED 3 FLOWS_FILES P ENABLED 1 FLOWS_FILES R ENABLED 1 FLOWS_FILES U ENABLED 1 Constraints in other schemas referencing APEX ============================================= Versioned APIs ============== Owner Object Name Version Identifier ----------- ------------------------------ ------------------------------------- APEX_180100 WWV_FLOW_API 75110 2018-05-08 16:39:56 APEX_180100 WWV_FLOW_INTERACTIVE_GRID 74501 2018-04-05 19:21:37 APEX_180100 WWV_FLOW_IR_RENDER SYS WWV_FLOW_VAL 74620 2018-04-11 14:44:45 Single Sign-On (OSSO) ===================== - WWV_FLOW_CUSTOM_AUTH_SSO is not installed - Synonym WWSEC_ENABLER_CONFIG_INFO$ does not exist - Synonym WWSEC_SSO_ENABLER_PRIVATE does not exist - SELECT on WWSEC_ENABLER_CONFIG_INFO$ has NOT been granted - EXECUTE on WWSEC_SSO_ENABLER_PRIVATE has NOT been granted Network ACLs for APEX_180100 ============================ Authorized URLs =============== Workspace Schema Restrictions And Exceptions ============================================ Restricted Schema Exception for Workspace ------------------------------ ------------------------------------------------- ANONYMOUS APEX_180100 APEX_INSTANCE_ADMIN_USER APEX_LISTENER APEX_PUBLIC_USER APEX_REST_PUBLIC_USER APPQOSSYS AUDSYS AURORA$JIS$UTILITY$ AURORA$ORB$UNAUTHENTICATED AVSYS CTXSYS DBSFWUSER DBSNMP DIP DMSYS DVF DVSYS EXFSYS FLOWS_FILES GGSYS GSMADMIN_INTERNAL GSMCATUSER GSMUSER HTMLDB_PUBLIC_USER LBACSYS MDDATA MDSYS MGMT_VIEW ODM ODM_MTR OE OJVMSYS OLAPSYS ORACLE_OCM ORDDATA ORDPLUGINS ORDSYS ORDS_METADATA ORDS_PUBLIC_USER OSE$HTTP$ADMIN OUTLN PERFSTAT PM QS QS_ADM QS_CB Restricted Schema Exception for Workspace ------------------------------ ------------------------------------------------- QS_CBADM QS_CS QS_ES QS_OS QS_WS REMOTE_SCHEDULER_AGENT RMAN SCOTT SH SI_INFORMTN_SCHEMA SPATIAL_CSW_ADMIN_USR SPATIAL_WFS_ADMIN_USR SYS SYS$UMF SYSBACKUP SYSDG SYSKM SYSMAN SYSRAC SYSTEM TSMSYS WKPROXY WKSYS WK_TEST WMSYS XDB XS$NULL Instance Parameters =================== Name Value Updated On --------------------------------------- ---------------------------------------- ---------- ALLOW_DB_MONITOR N 2018-05-26 ALLOW_PUBLIC_FILE_UPLOAD N 2018-05-26 ALLOW_RAS N 2018-05-26 APEX_BUILDER_AUTHENTICATION APEX 2018-05-26 APEX_LISTENER_FOP_PATH _/fop2pdf 2018-05-26 APEX_PATCH_STATUS APPLIED 2018-05-26 APEX_REST_PATH_PREFIX r 2018-05-26 APPLICATION_ACTIVITY_LOGGING U 2018-05-26 APP_EXPORT_TO_DB_ENABLED Y 2018-05-26 AUDIT_LOG_RETENTION 90 2018-05-26 AUTOEXTEND_TABLESPACES Y 2018-05-26 AUTO_SCHEMA_NAME N 2018-05-26 AUTO_WORKSPACE_NAME N 2018-05-26 BIGFILE_TABLESPACES_ENABLED N 2018-05-26 CHECK_FOR_UPDATES Y 2018-05-26 CLONE_SESSION_ENABLED Y 2018-05-26 CONTENT_CACHE_MAX_FILE_SIZE 1048576 2018-05-26 CONTENT_CACHE_SIZE_TARGET 104857600 2018-05-26 DEBUG_MESSAGE_PAGE_VIEW_LIMIT 50000 2018-05-26 DEFAULT_THEMES 42,51 2018-05-26 DELETE_UPLOADED_FILES_AFTER_DAYS 14 2018-05-26 DISABLE_ADMIN_LOGIN N 2018-05-26 DISABLE_WORKSPACE_LOGIN N 2018-05-26 DISABLE_WS_PROV N 2018-05-26 ENABLE_TRANSACTIONAL_SQL N 2018-05-26 ENCRYPTED_TABLESPACES_ENABLED N 2018-05-26 EXPIRE_FND_USER_ACCOUNTS Y 2018-05-26 HPROF_DIRECTORY - 2018-05-26 INSTANCE_ID 227369841019675 2018-05-26 KEEP_SESSIONS_ON_UPGRADE N 2018-05-26 LOGIN_THROTTLE_DELAY 5 2018-05-26 LOGIN_THROTTLE_METHODS USERNAME_IP 2018-05-26 MAX_SCRIPT_SIZE 500000 2018-05-26 MAX_SESSION_IDLE_SEC 3600 2018-05-26 MAX_SESSION_LENGTH_SEC 28800 2018-05-26 MAX_WEBSERVICE_REQUESTS 1000 2018-05-26 MOBILE_DEVELOPMENT_ENABLED N 2018-05-26 PASSWORD_ALPHA_CHARACTERS abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMN 2018-05-26 OPQRSTUVWXYZ PASSWORD_PUNCTUATION_CHARACTERS !"#$%&()``*+,-/:;<=>?_ 2018-05-26 PKG_APP_AUTH_ALLOW_HHEAD N 2018-05-26 PKG_APP_AUTH_ALLOW_LDAP N 2018-05-26 PKG_APP_AUTH_ALLOW_SSO N 2018-05-26 PKG_APP_ENABLED Y 2018-05-26 PLSQL_EDITING Y 2018-05-26 PRINT_BIB_LICENSED APEX_LISTENER 2018-05-26 Name Value Updated On --------------------------------------- ---------------------------------------- ---------- REJOIN_EXISTING_SESSIONS P 2018-05-26 REQUIRE_HTTPS N 2018-05-26 REQUIRE_VERIFICATION_CODE N 2018-05-26 REQ_NEW_SCHEMA N 2018-05-26 RESTFUL_SERVICES_ENABLED Y 2018-05-26 SERVICE_REQUESTS_ENABLED Y 2018-05-26 SERVICE_REQUEST_FLOW MANUAL 2018-05-26 SMTP_HOST_ADDRESS localhost 2018-05-26 SMTP_HOST_PORT 25 2018-05-26 SMTP_TLS_MODE N 2018-05-26 SQL_SCRIPT_MAX_OUTPUT_SIZE 200000 2018-05-26 STRONG_SITE_ADMIN_PASSWORD Y 2018-05-26 SYSTEM_HELP_URL http://apex.oracle.com/doc181 2018-05-26 TOP_THEMES 42,51 2018-05-26 TRACING_ENABLED Y 2018-05-26 USERNAME_VALIDATION * 2018-05-26 WEBSERVICE_LOGGING U 2018-05-26 WEBSHEET_SQL_ACCESS N 2018-05-26 WORKSPACE_EMAIL_MAXIMUM 1000 2018-05-26 WORKSPACE_MAX_OUTPUT_SIZE 2000000 2018-05-26 WORKSPACE_PROVISION_DEMO_OBJECTS N 2018-05-26 WORKSPACE_TEAM_DEV_FILES_YN N 2018-05-26 WORKSPACE_TEAM_DEV_FS_LIMIT 15728640 2018-05-26 WORKSPACE_WEBSERVICE_REQUEST_MAX 1000 2018-05-26 WORKSPACE_WEBSHEET_OBJECTS N 2018-05-26 Instance Administrators ======================= User Name Email Address Last Login Locked? ------------------------------ ---------------------------------------- ---------- ------- ADMIN savenko.denis@blabla.com No ================================================================================