When try to start up an Oracle database, the below errors occur: ORA-27125: unable to create shared memory segment Linux-x86_64 Error: 28: No space left on device Additional information: 3773…
Read Moreset trimspool on wrap off set heading off set verify off set pages 1000 lines 1000 spool rename.sql select ‘alter database rename file ”’ || name ||…
Read Moreselect n.name, s.value from v$statname n, v$sysstat s where n.statistic# = s.statistic# order by n.class,n.name /
Read MoreDatabase Security Assessment Tool. The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations, users, their entitlements, security policies and identifies where sensitive data resides to uncover security risks and…
Read MoreAPEX IMAGE ISSUE (503 Unavailable Error raising while access or load the images through Apex user). Requirements: ————– Apex 5.1.3 ORDS 3.0.9 Glassfish 3.0 Error: ====== 1.It will raised in…
Read MoreWhen i am trying to export table i am facing below error. Error ==== ORA-39166: Object APEX_050100.xxxxxx was not found or could not be exported or imported. ORA-31655: no data…
Read MoreQuery to find the concurrent programs completed in specific day. ===================================================== select f.request_id , pt.user_concurrent_program_name user_conc_program_name, to_char(f.actual_start_date,’DD-MON-YY HH24:MI:SS’) start_on, to_char(f.actual_completion_date,’DD-MON-YY HH24:MI:SS’) end_on, floor(((f.actual_completion_date-f.actual_start_date) *24*60*60)/3600) || ‘ HOURS ‘ || floor((((f.actual_completion_date-f.actual_start_date)…
Read MoreError ==== ORA-39166: Object APEX_050100.APEX was not found or could not be exported or imported. ORA-31655: no data or metadata objects selected for job Job “ROOT”.”SYS_EXPORT_TABLE_01″ completed with 2 error(s)…
Read MoreTotal number of attachments per program —————————————– select distinct program_name, count(*) from fnd_lobs group by program_name order by 2 desc; Total number of program with Expiration Date ——————————————— select program_name,count(*)…
Read MoreImportant queries related to workflow 1.Check the status of Notifications: ==================================== col RECIPIENT_ROLE format a20 col FROM_USER format a20 col TO_USER format a20 set lines 170 select NOTIFICATION_ID,MESSAGE_TYPE,MESSAGE_NAME,RECIPIENT_ROLE,STATUS,FROM_USER,TO_USER from wf_notifications…
Read More