Guys,
Installed a database - currently doing an upgrade to 9.0.2.2 following instructs in README that says to open "migrate" then run catpatch.sql. The database is using excessive amounts of memory for process global area. I reduced pga_aggregate_target from Oracle's default setting to 10M - read something about using this stops the use of sort_area_size. Any pro/cons on using pga_aggregate_target, experiences with sizing of it.....
Thanks,
Paula