Open DB Links

ORA-02049: timeout: distributed transaction waiting for lock .Non dynamic/Statis

·         alter system set open_links=12 scope=spfile;

·         alter system set open_links_per_instance=12 scope=spfile;

PGA usage 

ORA-04030: out of process memory when trying to allocate 8216 bytes (PLS PGA hp,PL/SQL STACK)

select s.sid,p.pid,p.spid,p.pga_used_mem, p.pga_alloc_mem  from gv$session s, gv$process p where s.paddr=p.addr

   and  p.pga_alloc_mem >= 10000000

  and s.username like 'PA%'

   order by p.pga_alloc_mem

   

DB%File

Show parameter pfile

  To check if DB is running from pfile or spfile

Show parameter  db_create_file_dest  

   Db_create_file_dest  is used for table space monitor, if we are doing daily clone to Test  then we don’t need to worry since table space are fixed in Production .Any new DB growth should be directed to this destination.

Show parameter   db_file_name_convert 

 It’s a strong clone parameter . Whenever cloning runs manually we have to set it up to resemble Production mount points.

*In case of snapshot clone (FS clone) both the parameters value can be left blank.