oracle 临时表空间学习笔记

最新推荐文章于 2024-10-12 17:19:59 发布

cuixiao8282

最新推荐文章于 2024-10-12 17:19:59 发布

阅读量80

点赞数

文章标签：数据库

1.select * from dba_temp_files;

2.select * from v$process;

3.select * from v$sql_workarea_active;

4.select * from dba_tables where table_name in ('GT1','GT2','GT3','GT4','GT5');

5.SELECT * FROM V$TEMP_EXTENT_MAP;

6.SELECT * FROM V$TEMP_EXTENT_POOL;

7.SELECT * FROM V$TEMP_SPACE_HEADER;

8.SELECT * FROM V$TEMPSEG_USAGE;

9.SELECT * FROM V$LOCK WHERE SID=256;

10.select * from DBA_TABLESPACE_GROUPS;

11.create global temporary table gt1 tablespace temp1 as select * from dba_objects where 1=2;

12.show parameter db_files;

13.create global temporary table gt4 on commit preserve rows as select * from dba_objects where 1=2;

14.alter database tempfile 2 resize 10m;

15.select * from dba_tablespace_groups;

16.drop tablespace test including contents;

17.alter tablespace temp1 tablespace group tbsg;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29622945/viewspace-1371269/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29622945/viewspace-1371269/