Skip to content
David Buzinkai

zavisko.com

  • Curriculum Vitae
  • Oracle WIKI
  • SAP WIKI
zavisko.com

Category: Administration

Moving database files

zaviskoSeptember 18, 2015March 25, 2017Leave a comment
Move control files Find current location Currently used control files can be found in view v$controlfile. To check, execute following...
Read More

Object compilation

zaviskoSeptember 14, 2015March 25, 2017Leave a comment
Check for uncompiled or wrongly compiled objects Execute this SQL command: COLUMN object_name FORMAT A30 SELECT owner, object_type, object_name, status...
Read More

Add new redolog group

zaviskoSeptember 14, 2015March 25, 2017Leave a comment
Check for existing redolog groups On UNIX filesystem redologs are stored in folder /oracle/<SID>/origlog<X> and mirrored in folder /oracle/<SID>/mirrlog<X> You...
Read More
zavisko.com
Proudly powered by WordPress | Theme: refur by teFox.