随便把控制文件也贴出来
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\sample\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\oradata\sample\CONTROL01.CTL','D:\oracle\oradata\sample\CONTROL02.CTL'
*.core_dump_dest='D:\oracle\admin\sample\cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='sample'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sampleXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=1048576
*.hash_join_enabled=TRUE
*.instance_name='sample'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=33554432
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=1048576
*.star_transformation_enabled='TRUE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\admin\sample\udump'
*.aq_tm_processes=1
*.background_dump_dest='D:\oracle\admin\sample\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\oradata\sample\CONTROL01.CTL','D:\oracle\oradata\sample\CONTROL02.CTL'
*.core_dump_dest='D:\oracle\admin\sample\cdump'
*.db_block_size=8192
*.db_cache_size=16777216
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='sample'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sampleXDB)'
*.fast_start_mttr_target=300
*.hash_area_size=1048576
*.hash_join_enabled=TRUE
*.instance_name='sample'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=33554432
*.processes=150
*.query_rewrite_enabled='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=1048576
*.star_transformation_enabled='TRUE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='D:\oracle\admin\sample\udump'
解决方案 »
- plsql developer连接oracle出现ORA-12520错误
- help!!!!!!
- 帮帮忙,请把下面的代码解释下。越详细越好,这是那方面的知识点
- proc只能去数据库以前的数据,不能取新建表中数据
- 音乐文件,存放在数据库里面,用blob字段,还是放在某文件夹,在数据库里面放地址,请赐教!
- 如何分析toad的explain plan?
- 如何在创建ORACLE数据库时指定db_block_size?急!!!
- 请问:如何才能pl/sql删除服务器端的文件
- 请问如何在日常最快的发现数据被锁,如何避免数据被锁,UP有分
- 已设置Session和Process为480,300 实际连接30个Process就满了,如何查找哪里设置有问题?
- 加急电报(巨难)!
- 关于pl/sql和t-sql的区别。。。
If the DB_CREATE_FILE_DEST initialization parameter is not set, Oracle creates one datafile whose name and size depend on your operating system.
创建数据库时连数据文件都还没有,怎么会有表空间?!,我觉得应该是在创建数据库后再
在具体的数据文件上分配表空间吧