start调用图形界面,报错。
<br />xstart连接linux5,不能弹出图形界面。<br />提示错误:Can't open display: localhost:10.0<div style="line-height:21px;white-space:normal;"> <wbr>_X11TransSocketINETConnec<wbr>t() can't get address for localhost:6010: Name or service not known<div>/usr/bin/xterm Xt error: Can't open...
oracle11g flashback技术
http://blog.itpub.net/500314/viewspace-1067247/
oracle 10g statspack学习
<h3 class="title pre fs1" style="margin:0px;padding:0px;color:#000000;font-family:Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;"><span class="tcnt"><strong>oracle 10g statspack学习</strong></span><strong> </strong><br /></h3><span style="font-family:Arial;font-si...
ORA-01152: file 1 was not restored from a sufficiently old backup
<span style="color:#555555;font-family:宋体, 'Arial Narrow', arial, serif;font-size:14px;line-height:28px;white-space:normal;background-color:#FFFFFF;">在一次恢复过程中,restore过后,在open时遇到报错:</span><br style="padding:0px;margin:0px;color:#555555;font-family:宋体, 'Arial Narrow', arial, seri...
ORA-29857 ORA-23515 ORA-02449
SYS@ PROD1>drop tablespace example including contents and datafiles;<br />drop tablespace example including contents and datafiles<br />*<br />ERROR at line 1:<br />ORA-29857: domain indexes and/or secondary objects exist in the tablespace<br /><br />SYS@ PROD1>select index_name, table_o...
oracle的shared server模式和dedicated server模式2
<p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;">1、shared server和dedicated server连接方式比较</p><p style="color:#333333;font-family:Arial;font-size:14px;line-height:26px;white-space:normal;background-color:#FFFFFF;"><img...
Oracle Shared 连接和Oracle Dedicated 连接
<p style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;">共享与专用服务器的区别:</p><p style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;">专用服务器(DEDICATED):一个客户端连接对应...
Oracle 11g AMM与ASMM切换
<p class="MsoNormal" style="margin:0cm 0cm 0pt;color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;"><span style="font-size:small;"><span style="font-family:宋体;">现在的</span><span lang="EN-US"><span style="font-family:Calibri;">Oracle</span></span...
SCOPE 中 SPFILE、MEMORY、BOTH 的区别
<span style="font-family:Arial;line-height:26px;white-space:normal;font-size:16px;background-color:#FFFFFF;">ALTER SYSTEM 中 SCOPE=SPFILE/MEMORY/BOTH 的区别:<br />SCOPE = SPFILE<br /> <wbr>The change is applied in the<a target="_self"></a></span><span style="font-family:Arial;line-height:26p...
Oracle分区表技术 (Partitioned Tables)
摘自:http://blog.csdn.net/pan_tian/article/details/42556909<br /><br /><div style="font-size:14px;white-space:normal;font-family:Tahoma;line-height:normal;orphans:2;text-align:-webkit-auto;widows:2;background-color:#FFFFFF;">自Oracle 8(1997年左右)就引入了<a target="_blank" href="http://www.or...
深入学习Oracle分区表及分区索引
摘自:http://www.blogjava.net/rabbit/archive/2013/01/08/393955.html<br /><br /><p style="line-height:25px;margin-top:10px;margin-bottom:10px;font-size:14.3999996185303px;white-space:normal;font-family:Verdana, Arial, Helvetica, sans-serif;background-color:#FFFFFF;">深入学习Oracle分区表及分区索引...
使用oradebug dump processstate 来诊断enq: TX - row lock contention
来自:http://blog.itpub.net/26015009/viewspace-1074535/<br /><br /><span style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;">朋友的应用程序在年度结转时调用存储过程时hang住了.经过调试存储过程发现执行到下面的语句时被hang住.</span><br style="colo...
oracle 优化统计数据之直方图(histograms)
<p style="margin-bottom:1.3em;white-space:normal;color:#333333;font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:14px;line-height:21px;background-color:#FFFFFF;">来自:http://blog.itpub.net/26015009/viewspace-1072732/<br /><br />直方图是一种按数据出现的频率来进...
基于CBO优化器谓词选择率的计算方法
来自:http://blog.itpub.net/26015009/viewspace-1071186/<br /><br /><p style="margin-bottom:1.3em;white-space:normal;color:#333333;font-family:Georgia, 'Times New Roman', 'Bitstream Charter', Times, serif;font-size:14px;line-height:21px;background-color:#FFFFFF;">选择率selectivity是Oracle的CBO中...
收集优化统计数据(Optimizer Statistics)的最佳实践方法
介绍
深入理解oracle优化器统计数据(Optimizer Statistics)
来自:http://blog.itpub.net/26015009/viewspace-1068582/<br /><br /><p style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;">理解oracle优化器统计数据</p><p style="color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;backg...
oracle11g multi column statistics
来源:http://blog.itpub.net/17203031/viewspace-710894/<br /><br /><p class="MsoNormal" style="margin:0cm 0cm 0pt;color:#666666;font-family:宋体, Arial;line-height:26px;white-space:normal;background-color:#FFFFFF;"><span style="font-size:small;"><span style="font-family:宋体;">目前,<span lang="E...
Oracle Resource Manager
来源:http://blog.chinaunix.net/uid-21267615-id-2406084.html<br /><br /><div style="color:#666666;font-family:宋体, Arial;font-size:16px;line-height:26px;white-space:normal;background-color:#FFFFFF;">Oracle Resource Manager是Oracle8i开始提供的数据库组件,目的是可以让Oracle定义数据库资源的利用,通...
ORACLE优化器RBO与CBO介绍总结
来自:http://www.cnblogs.com/kerrycode/p/3842215.html<br /><br /><br /><div id="cnblogs_post_body" style="margin-bottom:20px;word-break:break-word;color:#333333;font-family:Georgia, 'Times New Roman', Times, sans-serif;font-size:14px;line-height:25.2000007629395px;white-space:normal;background-co...
hint
<br />来自:http://www.cnblogs.com/ebs-blog/archive/2011/09/05/2167730.html<br /><br /><p style="margin:10px auto;color:#666666;font-family:verdana, 'ms song', 宋体, Arial, 微软雅黑, Helvetica, sans-serif;white-space:normal;background-color:#DDDDDD;">Hint 是Oracle 提供的一种SQL语法,它允许用户...