Performance Issues
We have increased the default sessions and process parameter in database, now its performing well.
now nobody sessions are purging automaticallly.
Delete Session on Logout
begin
apex_session.delete_session (
p_session_id => 2224940013004);
end;
---------List of NOBODY Session
SELECT
workspace_name,
apex_session_id,
user_name,
remote_addr,
TO_CHAR(session_created, 'DD-MON-YYYY HH24:MI') AS session_created,
TO_CHAR(session_idle_timeout_on, 'DD-MON-YYYY HH24:MI') AS session_idle_timeout_on,
TO_CHAR(session_idle_timeout_on-(session_max_idle_sec/24/60/60), 'DD-MON-YYYY HH24:MI') AS last_activity,
TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI') AS time_now,
round((sysdate-(session_idle_timeout_on-(session_max_idle_sec/24/60/60)))*24*60) as minutes_ago
FROM apex_workspace_sessions
WHERE user_name NOT IN ('APEX_PUBLIC_USER','nobody')
ORDER BY minutes_ago, workspace_name, session_idle_timeout_on DESC;
--------------Query to check direct database session_created
SELECT
sid,
serial#,
username,
osuser,
machine,
program,
--sql_id, sql_exec_start, event,
logon_time,
client_info AS workspace_id_auth_user,
module AS db_schema_apex_app_id_page_id,
action AS action,
client_identifier AS auth_user_apex_session,
service_name
FROM gv$session
WHERE type = 'USER'
AND service_name = 'CADB.pasi.gov.om';
-----------Check Application and page wise performance
select workspace
, application_name
, application_id, page_id
, count(*) total_page_events
, avg(elapsed_time) avg_elapsed_time
, sum(elapsed_time) elapsed_time
from apex_workspace_activity_log
where view_date between to_date('20210606','RRRRMMDD') and to_date('20210607','RRRRMMDD')
group by workspace, application_name, application_id, page_id
order by 6, 7 asc
----------lIST OF APEX VIEWS
select *
from
apex_dictionary;
-------------APEX WORKSPACE ACESS LOG
SELECT * FROM
APEX_WORKSPACE_ACCESS_LOG
Comments
Post a Comment