- 博客(5)
- 资源 (2)
- 收藏
- 关注
原创 explain plan
explain plan for SQL STATEMENT; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
2012-04-30 15:47:35 475
原创 Oracle table size
I SELECT segment_name, BYTES FROM user_segments WHERE segment_type = &1; SELECT segment_name, SUM (BYTES) / 1024 / 1024 FROM user_extents GROUP BY segment_name; II Actual Size: ANALY
2012-04-27 15:08:24 782
原创 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 use Step: 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关注的人