오라클 버전 및 인스톨 정보

1. V$VERSION : 오라클 버전에 대한 정보를 볼수 있습니다.   SQL>COL banner  FORMAT A70 HEADING "Oracle Versions" SQL>SELECT banner FROM  V$VERSION;   Oracle Versions ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE    8.1.6.0.0       Production TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production    2. PRODUCT_COMPONENT_VERSION : 제품 인스톨에 대한 정보를 볼 수 있습니다.    SQL>COL PRODUCT FORMAT A30 HEADING "Products Installed"  SQL>COL VERSION FORMAT A15  SQL>COL STATUS  FORMAT A15    SQL>SELECT product, version, status FROM  PRODUCT_COMPONENT_VERSION;  Products Installed                    VERSION           STATUS ------------------------------ --------------- --------------- NLSRTL                                      3.4.1.0.0         Production Oracle8i Enterprise Edition            8.1.6.0.0         Production PL/SQL                                      8.1.6.0.0         Production TNS for 32-bit Windows:               8.1.6.0.0         Production  3. V$OPTION : 옵션 인스톨에 대한 정보를 볼 수 있습니다. SQL>COL PARAMETER   FORMAT A50 HEADING "Options Installed"      SQL>COL VALUE       FORMAT A10 HEADING "True/False"             SQL>SELECT parameter, value FROM   V$OPTION;     Options Installed                                  ---------------------------------------------- Partitioning                                       Objects                                            Parallel Server                                    Advanced replication                               Bit-mapped indexes                                 Connection multiplexing                            Connection pooling                                 Database queuing                                   Incremental backup and recovery                    Instead-of triggers                                Parallel backup and recovery                       Parallel execution                                 Parallel load                                      Point-in-time tablespace recovery                  Fine-grained access control                        N-Tier authentication/authorization                Function-based indexes                             Plan Stability                                     Online Index Build                                 Coalesce Index                                     Managed Standby                                    Materialized view rewrite                          Materialized view warehouse refresh                Database resource manager                          Spatial                                            Visual Information Retrieval!                       Export transportable tablespaces                   Transparent Application Failover                   Fast-Start Fault Recovery                          Sample Scan                                        Duplexed backups                                   Java                                               OLAP Window Functions                              True/False ---------- TRUE        FALSE       TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        TRUE        FALSE       TRUE

================================================     * 오라클 정보공유 커뮤니티 oracleclub.com     * http://www.oracleclub.com     * http://www.oramaster.net     * 운영자 : 김정식 (oramaster _at_ naver.com)   ================================================

※ oracleclub 강좌를 다른 홈페이지에 퍼가실 경우에는 출처를 꼭 밝혀 주시면 고맙겠습니다.~^^