- 诊断基础文件夹(内存)设置为c:\oracle\T647001\diag,
- 诊断基础文件夹(spfile)设置为c:\ora19c\T647001\diag,
- 关闭自动内存管理(内存)
- 自动内存管理当前值(spfile)设置为3216MB
- 关闭自动共享内存管理(内存)
- 自动共享内存当前值(spfile)设置为0MB
- 不淘汰的缓存区大小(内存)设置为240MB
- 不淘汰的缓存区大小(spfile)设置为96MB
- 立即淘汰的缓存区大小(内存)设置为96MB
- 立即淘汰的缓存区大小(内存)设置为96MB
- alter system set diagnostic_dest='c:\oracle\T647001\diag' scope=memory;
- alter system set diagnostic_det='c:\ora19c\T647001diag' scope=spfile;
- alter system set memory_target=0 scope=memory;
- alter system set memory_target=3216m scope=spfile;
- alter system set sga_target=0 scope=memory;
- alter system set sga_target=0 scope=spfile;
- alter system set db_keep_cache_size=240m scope=memory;
- alter system set db_keep_cache_size=96m scope=spfile;
- alter system set db_recycle_cache_size=96m scope=memory;
- alter system set db_recycle_cache_size=96m scope=spfile;