226.html

Jsp精华文章合集,JSP方面各种知识介绍

--收款、库存、订货、远程通信<br>
create tablespace USER_DATA1 datafile <br>
'd:\oradata\user1_1.ora' size 512M, <br>
'd:\oradata\user1_2.ora' size 512M, <br>
'd:\oradata\user1_3.ora' size 512M, <br>
'd:\oradata\user1_4.ora' size 512M, <br>
'd:\oradata\user1_5.ora' size 512M, <br>
'd:\oradata\user1_6.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 128K next 2M pctincrease 0);<br>
--initial 128K，因为，用户建在表空间上，而表建在用户里，为用户所拥有，<br>
--用户继承数据表空间的存储参数，表继承用户的存储参数<br>
--如果initial设的过大，如：5M，则每建一个空表就要占用5M的空间，即使一条记录也没有<br>
--AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED，设置数据文件自动扩展，每一次扩展增加5M，最大空间不受限<br>
<br>
--建数据表空间2<br>
--物价、人事、结算、财务、总经理、合同、统计<br>
create tablespace USER_DATA2 datafile <br>
'e:\oradata\user2_1.ora' size 512M,<br>
'e:\oradata\user2_2.ora' size 512M,<br>
'e:\oradata\user2_3.ora' size 512M,<br>
'e:\oradata\user2_4.ora' size 512M,<br>
'e:\oradata\user2_5.ora' size 512M,<br>
'e:\oradata\user2_6.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 128K next 2M pctincrease 0);<br>
<br>
--建索引表空间1<br>
create tablespace INDEX_DATA1 datafile <br>
'f:\oradata\index1_1.ora' size 512M,<br>
'f:\oradata\index1_2.ora' size 512M,<br>
'f:\oradata\index1_3.ora' size 512M,<br>
'f:\oradata\index1_4.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 128K next 2M pctincrease 0);<br>
<br>
--建索引表空间2<br>
create tablespace INDEX_DATA2 datafile <br>
'g:\oradata\index2_1.ora' size 512M,<br>
'g:\oradata\index2_2.ora' size 512M,<br>
'g:\oradata\index2_3.ora' size 512M,<br>
'g:\oradata\index2_4.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 128K next 2M pctincrease 0);<br>
<br>
--建回滚表空间1<br>
--设置初始值40M（initial 40M），则每在这个表空间中建一个回滚段，<br>
--此回滚段自动继承此回滚表空间的存储参数，也即默认文件为40M<br>
create tablespace ROLLBACK_DATA1 datafile <br>
'd:\oradata\roll1_1.ora' size 512M，<br>
'd:\oradata\roll1_2.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 40M next 5M pctincrease 0);<br>
<br>
--建回滚表空间2<br>
create tablespace ROLLBACK_DATA2 datafile <br>
'e:\oradata\roll2_1.ora' size 512M,<br>
'e:\oradata\roll2_2.ora' size 512M <br>
AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED<br>
default storage (initial 40M next 5M pctincrease 0);<br>
<br>
--建临时表空间1<br>
create tablespace TEMPORARY_DATA1 datafile <br>
'f:\oradata\temp1_1.ora' size 512M <br>
default storage (initial 10M next 3M pctincrease 0);<br>
<br>
--建临时表空间2<br>
create tablespace TEMPORARY_DATA2 datafile <br>
'g:\oradata\temp2_1.ora' size 512M <br>
default storage (initial 10M next 3M pctincrease 0);<br>
<br>
--使其真正成为临时的<br>
alter tablespace TEMPORARY_DATA1 temporary;<br>
alter tablespace TEMPORARY_DATA2 temporary;<br>
<br>
--建立新的回滚段，每个都一样大，不同大小的回滚段没有什么意义，系统是随机选择的。<br>
--建多少个，根据并发访问用户的多少，<br>
--如果你们公司每天有50-100个人员使用Oracle系统开发的管理软件，应该20个以上<br>
<br>
create public rollback segment rb01 tablespace rollback_data1;<br>
create public rollback segment rb02 tablespace rollback_data1;<br>
create public rollback segment rb03 tablespace rollback_data1;<br>
create public rollback segment rb04 tablespace rollback_data1;<br>
create public rollback segment rb05 tablespace rollback_data1;<br>
create public rollback segment rb06 tablespace rollback_data1;<br>
create public rollback segment rb07 tablespace rollback_data1;<br>
create public rollback segment rb08 tablespace rollback_data1;<br>
create public rollback segment rb09 tablespace rollback_data2;<br>
create public rollback segment rb10 tablespace rollback_data2;<br>
--前8个建在回滚表空间1中，后8个在回滚表空间2<br>
create public rollback segment rb11 tablespace rollback_data2;<br>
create public rollback segment rb12 tablespace rollback_data2;<br>
create public rollback segment rb13 tablespace rollback_data2;<br>
create public rollback segment rb14 tablespace rollback_data2;<br>
create public rollback segment rb15 tablespace rollback_data2;<br>
create public rollback segment rb16 tablespace rollback_data2;<br>
create public rollback segment rb17 tablespace rollback_data2;<br>
create public rollback segment rb18 tablespace rollback_data2;<br>
create public rollback segment rb19 tablespace rollback_data2;<br>
create public rollback segment rb20 tablespace rollback_data2;<br>
<br>
--使回滚段online，即有效<br>
alter rollback segment rb01 online;<br>
alter rollback segment rb02 online;<br>
alter rollback segment rb03 online;<br>
alter rollback segment rb04 online;<br>
alter rollback segment rb05 online;<br>
alter rollback segment rb06 online;<br>
alter rollback segment rb07 online;<br>
alter rollback segment rb08 online;<br>
alter rollback segment rb09 online;<br>
alter rollback segment rb10 online;<br>
alter rollback segment rb11 online;<br>
alter rollback segment rb12 online;<br>
alter rollback segment rb13 online;<br>
alter rollback segment rb14 online;<br>
alter rollback segment rb15 online;<br>
alter rollback segment rb16 online;<br>
alter rollback segment rb17 online;<br>
alter rollback segment rb18 online;<br>
alter rollback segment rb19 online;<br>
alter rollback segment rb20 online;<br>
<br>
--查看现有回滚段及其状态<br>
col segment format a30<br>
SELECT SEGMENT_NAME,OWNER,TABLESPACE_NAME,SEGMENT_ID,FILE_ID,STATUS FROM DBA_ROLLBACK_SEGS;<br>
<br>
--查看数据文件及其所在表空间、大小、状态<br>
col file_name format a40<br>
col tablespace_name format a20<br>
select file_name,file_id,tablespace_name,bytes,status from dba_data_files;<br>
<br>
<br>
至此，表空间重新规划完毕，这里讲的比较通俗，还有好多参数值得设置，能够把Oracle设置到最优的境界，<br>
表空间设置完了，下面，就该好好的整理一下Oracle的内存区了，<br>
Oracle很有意思，内存越大，效果越明显，所以有必要好好调整一下SGA区，也就是主要配置ininorcl.ora参数文件。<br>
<br>
 <br>
</p>
</td>
  </tr>
</table>

<p>
<CENTER><a href="http://www.jsp001.com/forum/newreply.php?action=newreply&threadid=226">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分，你认为它对你有帮助吗？
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=226&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>0</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=226&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>0</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=226&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>0</font>) 
				[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=226&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>0</font>) </p>
<script language="javascript" src="http://www.jsp001.com/include/read_thread_script.php?threadid=226"></script>
<p><CENTER>
Copyright &copy; 2001 - 2009 JSP001.com . All Rights Reserved <P>

<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>

</body>
</html>