set pages 50000 lines 32767 select * from ( select SQL_ID, sum(CPU_TIME_DELTA),sum(DISK_READS_DELTA),count(*) from DBA_HIST_SQLSTAT a, dba_hist_snapshot s where s.snap_id = a.snap_id and s.begin_interval_time > sysdate -1 group by SQL_ID order…
Read More**ORA-19566: Exceeded limit of 0 corrupt blocks for file: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571:…
Read MoreError: ORA-02374: conversion error loading table “SCHEMA”.”TABLENAME” ORA-12899: value too large for column ENAME (actual: 66, maximum: 64) ORA-02372: data for row: ENAME : 0X’45737061C3B16F6C2020202020202020202020202020202020′ More About the Error: 1. …
Read MoreWhen 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 More