Oracle announced the availability of its Cloud Data Science Platform, which has new seven services, with OCI Data Science at the core that delivers a robust, scalable, and collaborative tool…
Read MoreAmidst the current scenario of COVID-19 pandemic, we would like to assure you that Doyensys is trying to do everything possible to continue to provide our services. Overall situation in…
Read Moreset serveroutput on declare v_diskgroup_name varchar2(50); v_total_space number(12); v_free_space number(12); v_pct_free number(6,3); begin for diskgroup_rec in (select name from v$asm_diskgroup) loop — — Get the total space for the current…
Read MoreMVIEW LOG =========== col log_owner for a30 col master for a40 col log_table for a40 col last_purge_date for a30 col last_purge_status for 9999999 select log_owner,master,log_table,last_purge_date,last_purge_status from dba_mview_logs; MVIEW LOG SIZE…
Read MoreGATHER STATS FOR TABLE exec dbms_stats.gather_table_stats (ownname=>’&Owner’,tabname=>’&Table_name’,estimate_percent=>100,block_sample=>true,method_opt=>’FOR ALL COLUMNS size 254′); ESTIMATE INDEX SIZE set serveroutput on declare l_used_bytes number; l_alloc_bytes number; begin dbms_space.create_index_cost ( ddl => ‘create index test_indx…
Read MoreBEGIN DBMS_AUDIT_MGMT.init_cleanup( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, default_cleanup_interval => 12 /* hours */); END; / ERROR at line 1: ORA-46267: Insufficient space in 'SYSAUX' tablespace, cannot complete operation ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line…
Read MoreError ======= Errors IN EBS POST INSTALL:RW 50015 : HTTP SERVER NOT RESPONDING 19/09/22 22:21:26 Start process ————————— /u01/oracle/VIS/inst/apps/VIS_ebs/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd /u01/oracle/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot…
Read MoreUnknown fonts while installing oracle database Cause ===== Missing dejavu-lgc-sans-fonts or dejavu rpm Solution ======== Install dejavu-lgc-sans-fonts and then invoke the OUI. The below rpm’s helps the OUI to be…
Read MoreError ===== BEGIN * ERROR at line 1: ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [], [], [], [], [], [], [], [], [], [], [] ORA-06512: at “SYS.DBMS_STATS”,…
Read MoreCOL TABLESPACE_NAME FOR A30 COL FILE_NAME FOR A70 COL SIZE_GB FOR 99999 COL USED_GB FOR 99999 COL FREE_GB FOR 99999 COL %_Used FOR A15 SELECT Substr(df.tablespace_name,1,25) “Tablespace_Name”, Substr(df.file_name,1,70) “File_Name”, Round(df.bytes/1024/1024/1024,2)…
Read More