查询数据库主要参数列表sql

------**************Datafile Disk Allocation Parameter************
SELECT *
  FROM (SELECT T.FILE_NAME,
               T.AUTOEXTENSIBLE,
               T.INCREMENT_BY *
               (SELECT TT.VALUE
                  FROM V$PARAMETER TT
                 WHERE LOWER(TT.NAME) = 'db_block_size') / 1024 / 1024 || 'M' AS NEXT_AUTOEXTEND_DELTA
          FROM DBA_DATA_FILES T
        UNION ALL
        SELECT '**************Datafile Disk Allocation Parameter Above************',
               '',
               ''
          FROM DUAL)
 ORDER BY 1;

------**************Extent Allocation Parameter************
SELECT *
  FROM (SELECT T.TABLESPACE_NAME,
               T.BLOCK_SIZE,
               NVL(T.INITIAL_EXTENT, 0) / 1024 || 'K' AS INITIAL_EXTENT,
               NVL(T.NEXT_EXTENT, 0) / 1024 || 'K' AS NEXT_EXTENT,
               T.PCT_INCREASE,
               T.LOGGING,
               T.EXTENT_MANAGEMENT,
               T.ALLOCATION_TYPE,
               T.SEGMENT_SPACE_MANAGEMENT
          FROM DBA_TABLESPACES T
        UNION ALL
        SELECT '**************Extent Allocation Parameter Above************',
               NULL,
               NULL,
               NULL,
               NULL,
               NULL,
               NULL,
               NULL,
               NULL
          FROM DUAL)
 ORDER BY 1;

------**************Instance Parameter************
SELECT *
  FROM (SELECT T.NAME, T.VALUE
          FROM V$PARAMETER T
         WHERE T.VALUE IS NOT NULL
           AND T.VALUE NOT LIKE '%/%'
           AND T.VALUE NOT LIKE '%:%'
        UNION ALL
        SELECT '**************Instance Parameter Above************', NULL
          FROM DUAL)
 ORDER BY 1;