Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Change Sessions, Transaction And Processes Parameters In Oracle 10g

01.10.2007
| 58890 views |
  • submit to reddit 
        
alter system set PROCESSES=100 scope=SPFILE;
alter system set TRANSACTIONS=126 scope=SPFILE;
alter system set SESSIONS=115 scope=SPFILE;
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers