[Oracle]데이터베이스 정보 NLS_Session_parameter

Oracle

SELECT parameter AS "Parameter",
       VALUE AS "Value"
  FROM nls_session_parameters
ORDER BY parameter

<결과>

[SQL-Server]데이터 베이스 백업 디렉토리 보기 쿼리

SQL-Server

declare
@BackupDirectory nvarchar(512)
exec
    master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',
    N'Software\Microsoft\MSSQLServer\MSSQLServer',
    N'BackupDirectory',
    @BackupDirectory OUTPUT

    SELECT @BackupDirectory as [BackupDirectory]

<결과>

[DB2]Procedure Grant 보기 쿼리

DB2

SELECT DISTINCT a.Grantee AS Grantee,
       (
           CASE (a.GranteeType)
               WHEN 'U'
               THEN 'User'
               WHEN 'G'
               THEN 'Group'
           END
       ) AS Type,
       a.Grantor,
       (
           CASE (a.ExecuteAuth)
               WHEN 'Y'
               THEN 'Yes'
               WHEN 'N'
               THEN 'No'
               WHEN 'G'
               THEN 'Yes,Grantable'
           END
       ) AS EXECUTE
  FROM syscat.routineAuth a,
       syscat.routines r
 WHERE r.RoutineSchema = a.Schema
       AND r.SPECIFICNAME = a.SPECIFICNAME
       AND r.RoutineSchema = 'ADMINISTRATOR'
ORDER BY a.Grantee FOR
FETCH ONLY
WITH UR

<결과>

[Oracle]데이터베이스 NLS_Instance_Parameter 보기 쿼리

Oracle

SELECT parameter AS "Parameter",
       VALUE AS "Value"
  FROM nls_instance_parameters
ORDER BY parameter

<결과>

[SQL-Server]DB 사용 공간 보기 쿼리

SQL-Server

exec sp_spaceused

<결과>

[DB2]Package 권한 보기 쿼리

DB2

SELECT DISTINCT a.Grantee AS Grantee,
       (
           CASE (a.GranteeType)
               WHEN 'U'
               THEN 'User'
               WHEN 'G'
               THEN 'Group'
               WHEN 'R'
               THEN 'Role'
           END
       ) AS Type,
       a.GRANTOR,
       (
           CASE (a.BINDAUTH)
               WHEN 'G'
               THEN 'Yes,Grantable'
               WHEN 'N'
               THEN 'No'
               WHEN 'Y'
               THEN 'Yes'
           END
       ) AS Bind,
       (
           CASE (a.EXECUTEAUTH)
               WHEN 'G'
               THEN 'Yes,Grantable'
               WHEN 'N'
               THEN 'No'
               WHEN 'Y'
               THEN 'Yes'
           END
       ) AS Execute,
       (
           CASE (a.CONTROLAUTH)
               WHEN 'N'
               THEN 'No'
               WHEN 'Y'
               THEN 'Yes'
           END
       ) AS CONTROL
  FROM SYSCAT.PACKAGEAUTH a,
       syscat.PACKAGES p
 WHERE p.PKGSCHEMA = a.PKGSCHEMA
       AND p.PKGSCHEMA = 'ADMINISTRATOR'
ORDER BY a.Grantee FOR
FETCH ONLY
WITH UR

<결과>

[Oracle]데이터베이스 NLS_Database_Parameter 보기 쿼리

Oracle

<br />
SELECT parameter AS &quot;Parameter&quot;,<br />
       VALUE AS &quot;Value&quot;<br />
  FROM nls_database_parameters<br />
ORDER BY parameter<br />

<결과>

[SQL-Server]DB속성 옵션 정보 보기 쿼리

SQL-Server

SELECT CAST(DATABASEPROPERTYEX(dtb.name, 'Collation') AS sysname) AS [Collation],
       CASE DATABASEPROPERTYEX(dtb.name, 'Recovery')
           WHEN 'SIMPLE'
           THEN 3
           WHEN 'BULK_LOGGED'
           THEN 2
           ELSE
               /*FULL*/
               1
       END AS [Recovery],
       dtb.cmptlevel AS [CompatibilityLevel],
       DATABASEPROPERTYEX(dtb.name, 'Status') AS [state_desc],
       CAST(DATABASEPROPERTY(dtb.name, 'IsReadOnly') AS bit) AS [Read_Only],
       CASE CONVERT(sysname,DATABASEPROPERTYEX(dtb.name, 'UserAccess'))
           WHEN 'SINGLE_USER'
           THEN 1
           WHEN 'RESTRICTED_USER'
           THEN 2
           ELSE
               /*MULTI_USER*/
               0
       END AS [UserAccess],
       CAST(dtb.status & 1 AS bit) AS [AutoClose],
       CAST(dtb.status & 4194304 AS bit) AS [AutoShrink],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAutoUpdateStatistics') AS bit) AS [AutoUpdateStatistics],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAutoCreateStatistics') AS bit) AS [AutoCreateStatistics],
       '' AS [AutoUpdateStatisticsAsync],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsLocalCursorsDefault') AS bit) AS [LocalCursorsDefault],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsCloseCursorsOnCommitEnabled') AS bit) AS [CloseCursorsOnCommitEnabled],
       CASE
           WHEN 1=DATABASEPROPERTYEX(dtb.name, 'IsTornPageDetectionEnabled')
           THEN 1
           ELSE 0
       END AS [PageVerify],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAnsiNullDefault') AS bit) AS [AnsiNullDefault],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAnsiNullsEnabled') AS bit) AS [AnsiNullsEnabled],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAnsiWarningsEnabled') AS bit) AS [AnsiWarningsEnabled],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsAnsiPaddingEnabled') AS bit) AS [AnsiPaddingEnabled],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsNullConcat') AS bit) AS [ConcatenateNullYieldsNull],
       '' AS [DateCorrelationOptimization],
       CAST
       (
           CASE
               WHEN
                   (
                       dtb.status2 & v.number != 0
                   )
               THEN 1
               ELSE 0
           END AS bit
       ) AS [DatabaseOwnershipChaining],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsQuotedIdentifiersEnabled') AS bit) AS [QuotedIdentifiersEnabled],
       '' AS [IsParameterizationForced],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsArithmeticAbortEnabled') AS bit) AS [ArithmeticAbortEnabled],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsNumericRoundAbortEnabled') AS bit) AS [NumericRoundAbortEnabled],
       '' AS [Trustworthy],
       CAST(DATABASEPROPERTYEX(dtb.name, 'IsRecursiveTriggersEnabled') AS bit) AS [RecursiveTriggersEnabled],
       '' AS [SnapshotIsolationState],
       '' AS [BrokerEnabled]
  FROM master.dbo.sysdatabases AS dtb
   INNER JOIN master.dbo.spt_values AS v
       ON v.name = 'db chaining'

<결과>

[DB2]인덱스 권한 보기 쿼리

DB2

SELECT DISTINCT a.Grantee AS Grantee,
       (
           CASE (a.GranteeType)
               WHEN 'U'
               THEN 'User'
               WHEN 'G'
               THEN 'Group'
               WHEN 'R'
               THEN 'Role'
           END
       ) AS Type,
       (
           CASE(a.CONTROLAUTH)
               WHEN 'Y'
               THEN 'Yes'
               WHEN 'N'
               THEN 'No'
           END
       ) AS CONTROL,
       a.Grantor
  FROM syscat.indexAuth a,
       syscat.indexes i
 WHERE i.INDSCHEMA = a.INDSCHEMA
       AND i.INDSCHEMA = 'ADMINISTRATOR'
ORDER BY a.Grantee FOR
FETCH ONLY
WITH UR

<결과>

[Oracle]데이터베이스 인스턴스 보기 쿼리

Oracle

SELECT instance_number AS "Instance Number",
       instance_name AS "Instance Name",
       host_name AS "Host Name",
       version AS "Version",
       startup_time AS "Startup Time",
       status AS "Status",
       PARALLEL AS "Parallel",
       thread# AS "Thread#",
       archiver AS "Archiver",
       log_switch_wait AS "Log Switch Wait",
       logins AS "Logins",
       shutdown_pending AS "Shutdown Pending",
       database_status AS "Database Status",
       instance_role AS "Instance Role"
FROM   v$instance

<결과>