Tuesday, September 18, 2012

db migrations

checklist for database migrations:

  • check roles and permissions to roles
  • check TEMP
  • check UNDO (on RAC check UNDO for each instance)
  • check SGA
  • check optimizer parameters
  • check all possible accounts (personal and app)