- 博客(5)
- 资源 (2)
- 收藏
- 关注
原创 explain plan
explain plan for SQL STATEMENT;SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
2012-04-30 15:47:35 476
原创 Oracle table size
I SELECT segment_name, BYTES FROM user_segments WHERE segment_type = &1;SELECT segment_name, SUM (BYTES) / 1024 / 1024 FROM user_extentsGROUP BY segment_name;II Actual Size:ANALY
2012-04-27 15:08:24 783
原创 temporary tablespace usage
SELECT * FROM dba_temp_free_space; (Oracle11g) select * from v$tempseg_usage; SELECT sess.SID, segtype, blocks * 8 / 1000 "MB", sql_text FROM v$sort_usage sort, v$session sess, v$sql
2012-04-27 14:39:28 530
原创 利用光盘搭建Yum源
1. Mount 光盘及ISO image# mount /dev/cdrom /media mount: block device /dev/cdrom is write-protected, mounting read-only # mount -o loop rhel-server-5.4-i386-dvd.iso /media/2.编辑yum repos文件 cat
2012-04-26 13:08:07 537
原创 ORA-14452: attempt to create, alter or drop an index on temporary table already in use
ORA-14452: attempt to create, alter or drop an index on temporary table already in useStep:1>select object_id from user_objects where object_name=&object_name;2>select * from v$lock where id1=
2012-04-18 18:25:17 1675
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人