oracle -sqlplus设置显示格式使用sqlplus查询显示结果,显示很乱,下面有种方法可以让她显示的更好看些。1.设置显示的宽度:设置前可以先查看当前宽度: SQL> show linesize;linesize 100SQL> set linesize 1000;SQL> sh...【阅读全文】
今天又学会一招,查看Oracle数据库中由于会话非正常退出而导致的事务锁:cuug每周五晚8点都有免费网络课程,详情可点击cuug官网。1.查看锁住的表SELECT b.owner,b.object_name,a.session_id,a.locked_mode FROM v$locked_object a ,dba_objects b WHERE b.object_id = a.o...【阅读全文】
一、创建测试表SQL> Create Table Testsample As Select Object_Id, Object_Name From Dba_Objects Where 1=2; Table created 二、创建索引SQL> Create Index i_Idx_Testsample On Testsample(Object_Id); Index created 三、插入数据SQL> Insert Into Testsample Select Object_Id, Ob...【阅读全文】
一、创建测试表SQL> Create Table T As Select * From Dba_Objects; Table created二、创建索引SQL> Create Index t_Ind On t (Object_Id); Index created三、收集统计信息 SQL> exec dbms_stats.gather_table_stats(user,'T',cascade=>true); PL/SQL procedure successfully complet...【阅读全文】
Linux环境下Oracle的scott演示模式所在目录:$ORACLE_HOME/rdbms/admin/utlsampl.sql,添加步骤:在sql*plus执行(注意在sys用户下)@$ORACLE_HOME/rdbms/admin/utlsampl.sql(@表示在sql*plus执行脚本)完成后自动断开连接,然后用scott进入,密码默认为tiger。以下是实际执行结果:SQL> show userUSER is "SYS...【阅读全文】
数据库报错GATHER_STATS_JOB encountered errors. Check the trace file.Errors in file /opt/Oracle/diag/rdbms/dbserver1/dbserver1/trace/dbserver1_j003_10544.trc:ORA-20011: Approximate NDV failed: ORA-01476: divisor is equal to zero环境ORACLE 11G R2RedHat 5.3 FOR 64 BIT解决网上给出的结论是...【阅读全文】