> 文章列表 / Page 318

Script set echo off set feedback off column timecol new_value timestamp column spool_extension new_value suffix select to_char(sysdate,'Mondd_hh24mi') timecol, '.out' spool_extension from sys.dual; co...

通过下图定义的规则，可确定分区索引类型: Hash Global分区索引介绍 HASH-Partitioned Global索引是Oracle 10g开始提供的新特性。而在以前的版本中 ，Oracle只支持Range-Partitioned Global索引。HASH-Partitioned Global索引的好处如下： 比Range-Partitioned Global索引易于实施。HASH-P...

以下脚本用于列出Oracle Buffer Cache的详细信息: REM List Buffer Cache Details SET LINESIZE 200 PAGESIZE 1400 SELECT /*+ ORDERED USE_HASH(o u) MERGE */ DECODE(obj#, NULL, to_char(bh.obj), u.name || '.' || o.name) na...

以下脚本用以列出Database-instance-session的NLS参数和所在时区: REM List NLS Parameters set linesize 90 pagesize 1400 col Parameter for a40 col Value for a40 SELECT Parameter, Value FROM NLS_DATABASE_PARAMETERS / SELEC...

以下脚本可以用于列出数据库内的排序活跃性能信息并监控临时空间的使用: REM SORT ACTIVITY set linesize 150 pagesize 1400; SELECT d.tablespace_name "Name", TO_CHAR(NVL(a.bytes / 1024 / 1024, 0),'99,999,990.900') "Size (M)", TO_CHAR(NVL(t....

以下脚本用以列出数据库中对象的依赖性: REM OBJECT DEPENDENT select D_OBJ#, do.object_name, do.object_type dtyp, do.status dsta, D_TIMESTAMP, ORDER#, P_OBJ#, po.object_name, po.object_type ptyp, po.status psta, P_TIMESTA...

Below lists Oracle SQL Function , and which version introduce this: SQL> SELECT NAME,VERSION,DATATYPE,DESCR FROM v$sqlfn_metadata order by 2; NAME VERSION DATATYPE DESCR ------------------------------...

Below lists Oracle SQL hints: Sql hints View more documents from Maclean Liu

该脚本可以用于列出Oracle日志文件切换的频率图: REM Log Switch Frequency Map col Day for a10 col Date for a10 set linesize 80 SELECT trunc(first_time) "Date", to_char(first_time, 'Dy') "Day", count(1) "Total", SUM(decode(...

该脚本用以汇总表空间使用情况报告: REM tablespace report set linesize 200 select a.tablespace_name, round(a.bytes_alloc / 1024 / 1024) megs_alloc, round(nvl(b.bytes_free, 0) / 1024 / 1024) megs_free, round((a.bytes_al...