1.同一个用户的数据可以分布在多个表空间中么?
2.修改表的表空间需要在脱机模式下么?
3.oracle数据库执行sql语句的硬分析与软分析是什么?
2.修改表的表空间需要在脱机模式下么?
3.oracle数据库执行sql语句的硬分析与软分析是什么?
解决方案 »
- 关于oracle恢复区奇怪的问题
- 如何简便地将一台机器上的oracle数据库迁移到另一台机器上
- oracle 表因为update 大长度字段,导致表空间增长过快问题,高手请进
- user undo sh odm 等表空是否可以删除
- sql语句转换成oracle
- 有什么好工具,能方便可视化,查询、增加、删除Oracle 数据、并能方便地生成Oracle 存储过程、函数、sql语句???
- 表编辑器中如果输入日期 在线等待
- 请帮忙看以下我的建库脚本,为何总是出错
- 怎么快速在表中建立测试数据(必须百万级记录)???
- Oracle 存储过程 多个临时表使用
- ●█〓oracle里写个存储过程报“创建的过程带有编译错误”〓█●
- 关于字符集问题
问题2:不需要,直接修改(前提要有这个表空间)ALTER TABLE tablename MOVE TABLESPACE newTABLESPACE
问题3:需要研究~~~
We must parse it, hash it, look in the shared pool for it, don't find it,
security check it, optimize it, etc (lots of work).o SOFT parse -- the query has been seen before, is in the shared poo. We have
to parse it, hash it, look in the shared pool for it and find it (less work then
a hard parse but work none the less)o a kinder, softer SOFT parse -- you are using session_cached_cursors (search
this site for that word for info). We take your query, look in the sessions
cursor cache -- find the cursor and reuse it. Very very little work.So, after "startup", you go into sqlplus and do this:SQL> alter session set session_cached_cursors=0; -- just making sure this is off
SQL> select * from emp; -- hard parse
SQL> select * from emp; -- soft parse
SQL> select * from emp; -- soft parse
SQL> alter session set session_cached_cursors=100; -- enable this feature
SQL> select * from emp; -- soft parse
SQL> select * from emp; -- kinder, gentler, soft parseFrom:http://asktom.oracle.com/pls/ask/f?=4950:8:::::F4950_P8_DISPLAYID:801662252143