环境: 服务器安装oracle 9i客户端安装的 oracle10G 客户端 配置了 net 配置 再客户端计算机用plsql 大概10分钟左右不操作 再进去操作会提示 ora-03114 未连接到oracle.用delphi ado 用oracle provider for ole db 方式开发了测试exe 如果有一段时间没操作 也会提示连接数据库失败select resource_name,profile from dba_profiles; 值都是default是oracle 版本不匹配还是服务器端需要什么设置 请指点
解决方案 »
- oracle ORA-01008: 并非所有变量都已绑定
- ORA-01427: 单行子查询返回多个行
- 好几天没有解决的问题:老是提示TNS: 没有监听器
- 日期型变量的运算
- [讨论]刚才发现like时Oracle貌似是不区分'_'和'_'
- 请问如果将sqlserver2000中的存储过程和视图转换至oracle中啊,急~!
- 判断数据是否存在时一般使用语句select 1 from .. where.. ,它比select count(*) from .. where ..的优点在哪里?
- 在oracle中如何删除作业?
- oracle中删除一个用户,用语法如何写
- 请问在oracle9i下创建表之间的约束关系是在那儿实现的?(在线等待)
- EM服务正常但启动dbconsole后firefox却显示无法打开
- ORACLE数据库迁移到MYSQL数据库
看值是不是为true,
如果打开了就增大idle_time值
alter system set db_cache_size=256M scope=spfile;alter system set sga_max_size=1536M scope=spfile; alter system set undo_management=auto scope=spfile; alter system set undo_retention=10800 scope=spfile; alter system set shared_pool_size=256M scope=spfile;alter system set workarea_size_policy=auto scope=spfile; alter system set pga_aggregate_target=200M scope=spfile;alter system set log_buffer=1024000 scope=spfile;alter system set java_pool_size=64M scope=spfile;alter system set Large_pool_size=32M scope=spfile;alter system set session_cached_cursors=50 scope=spfile;alter system set pre_page_sga=false scope=spfile;alter system set processes=400 scope=spfile;alter system set job_queue_processes=10 scope=spfile;alter system set db_file_multiblock_read_count=8 scope=spfile;alter system set open_cursors=350 scope=spfile;alter system set log_checkpoint_interval=0 scope=spfile;alter system set log_checkpoint_timeout=1800 scope=spfile;alter system set remote_login_passwordfile=exclusive scope=spfile;alter system set timed_statistics=true scope=spfile;alter system set global_names=false scope=spfile; alter system set cursor_sharing=exact scope=spfile;alter system set disk_asynch_io=FALSE scope=spfile;
SQL> drop trigger sys.cdc_alter_ctable_before;
SQL> drop trigger sys.cdc_create_ctable_after;
SQL> drop trigger sys.cdc_create_ctable_before;
SQL> drop trigger sys.cdc_drop_ctable_before;
SQL> call sys.dbms_java.dropjava('-s rdbms/jlib/cdc.jar');