NISCHAL's DBA WORLD

Wednesday, July 21, 2010

Startup Upgrade/Migrate/Downgrade

ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET "_SYSTEM_TRIG_ENABLED"=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0 SCOPE=MEMORY;
ALTER SYSTEM SET AQ_TM_PROCESSES=0 SCOPE=MEMORY;
ALTER SESSION SET NLS_LENGTH_SEMANTICS=BYTE;
Posted by PVS VAMSI at 9:36 PM
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2008 (23)
    • ►  April (4)
    • ►  May (4)
    • ►  June (12)
    • ►  July (1)
    • ►  August (2)
  • ►  2009 (52)
    • ►  January (9)
    • ►  February (1)
    • ►  March (12)
    • ►  April (1)
    • ►  May (6)
    • ►  June (3)
    • ►  July (4)
    • ►  August (3)
    • ►  September (6)
    • ►  October (1)
    • ►  November (4)
    • ►  December (2)
  • ▼  2010 (4)
    • ►  January (1)
    • ►  March (1)
    • ▼  July (1)
      • Startup Upgrade/Migrate/Downgrade
    • ►  December (1)
  • ►  2011 (2)
    • ►  January (1)
    • ►  February (1)
  • ►  2012 (3)
    • ►  May (2)
    • ►  November (1)
  • ►  2014 (1)
    • ►  November (1)
Picture Window theme. Powered by Blogger.