To find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreWe can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreRMAN Issues and Solutions – (ORA-00020) and (ORA-00245) Error-1: RMAN failed to connect target database with ORA-00020: maximum number of processes (150) exceeded Solution: Here, we can see…
Read MoreError in `FNDLIBR’: double free or corruption (out) In some concurrent programs, I was seeing the error as FNDLIBR corrupted. Other programs were working fine. This was observed in EBS…
Read MoreSQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreWe are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read MoreWe got a request to do a schema refresh, We prepared the parfile as below $cat DEV_SCHEMA.par directory=MY_DIR dumpfile=DEV_SCHEMA_%u.dmp logfile=DEV_SCHEMA.log SCHEMAS=DEV_SCHEMA1,DECSCHEMA01 estimate=statistics parallel=8 filesize=2G and ran in background as $ nohup…
Read MorePatch for JSON_TABLE Query Fails with ORA-7445 [__intel_ssse3_rep_memcpy] (Doc ID 2311377.1) Prerequisite : Install OCT Patch : Patch 28662603 – Database Oct 2018 Release Update 12.2.0.1.181016 Make sure Database and listener are…
Read More