SQL info; Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 using D:\oracleinstantclient_11_2\oci.dll (OCI version 11.1) Connected as SYS SQL select * from v$log; /////此视图包含需要归档的重做日志文件的信息 GROUP# THRE
SQL> info;
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
using D:\oracleinstantclient_11_2\oci.dll (OCI version 11.1)
Connected as SYS
SQL> select * from v$log; /////此视图包含需要归档的重做日志文件的信息
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
1 1 25 52428800 512 1 NO INACTIVE 1649914 2012-10-22 1666515 2012-10-22
2 1 26 52428800 512 1 NO CURRENT 1666515 2012-10-22 281474976710
3 1 24 52428800 512 1 NO INACTIVE 1611653 2012-10-21 1649914 2012-10-22
SQL> select * from V$BACKUP; ////此视图显示所有联机数据文件的备份状态。
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- -----------
1 NOT ACTIVE 0
2 NOT ACTIVE 0
3 NOT ACTIVE 0
4 NOT ACTIVE 0
5 NOT ACTIVE 0
6 NOT ACTIVE 0
6 rows selected
SQL> select * from V$BACKUP_ASYNC_IO; ///此视图显示控制文件中的备份集信息。在成功地完成备份集时，插入一个备份集记录。
SID SERIAL USE_COUNT RMAN_STATUS_RECID RMAN_STATUS_STAMP DEVICE_TYPE TYPE STATUS FILENAME SET_COUNT SET_STAMP BUFFER_SIZE BUFFER_COUNT TOTAL_BYTES OPEN_TIME
CLOSE_TIME ELAPSED_TIME MAXOPENFILES BYTES EFFECTIVE_BYTES_PER_SECOND IO_COUNT READY SHORT_WAITS SHORT_WAIT_TIME_TOTAL SHORT_WAIT_TIME_MAX LONG_WAITS LONG_WAIT_TIME_TOTAL LONG_WAIT_TIME_MAX
---------- ---------- ---------- ----------------- ----------------- ----------------- --------- ----------- -------------------------------------------------------------------------------- ---------- ---------- ----------- ------------ ----------- -----------
----------- ------------ ------------ ---------- -------------------------- ---------- ---------- ----------- --------------------- ------------------- ---------- -------------------- ------------------
SQL> select * from V$BACKUP_CORRUPTION; ///此视图显示来自控制文件的数据文件备份中出错的相关信息。注意，在控制文件和归
////档日志备份中是不容许出错的。
RECID STAMP SET_STAMP SET_COUNT PIECE# FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# MARKED_CORRUPT CORRUPTION_TYPE
---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------------ -------------- ---------------
SQL> select * from V$BACKUP_DATAFILE; ////此视图显示来自控制文件的备份数据文件和备份控制文件。
RECID STAMP SET_STAMP SET_COUNT FILE# CREATION_CHANGE# CREATION_TIME RESETLOGS_CHANGE# RESETLOGS_TIME INCREMENTAL_LEVEL INCREMENTAL_CHANGE# CHECKPOINT_CHANGE# CHECKPOINT_TIME ABSOLUTE_FUZZY_CHANGE# MARKED_CORRUPT MEDIA_CORRUPT LOGICALLY_CORRUPT
DATAFILE_BLOCKS BLOCKS BLOCK_SIZE OLDEST_OFFLINE_RANGE COMPLETION_TIME CONTROLFILE_TYPE USED_CHANGE_TRACKING BLOCKS_READ USED_OPTIMIZATION FOREIGN_DBID PLUGGED_READONLY PLUGIN_CHANGE# PLUGIN_RESETLOGS_CHANGE# PLUGIN_RESETLOGS_TIME div_SIZE UNDO_OPTIMIZED
BLOCKS_SKIPPED_IN_CELL
---------- ---------- ---------- ---------- ---------- ---------------- ------------- ----------------- -------------- ----------------- ------------------- ------------------ --------------- ---------------------- -------------- ------------- -----------------
--------------- ---------- ---------- -------------------- --------------- ---------------- -------------------- ----------- ----------------- ------------ ---------------- -------------- ------------------------ --------------------- ------------ --------------
----------------------
SQL>
SQL> select * from V$BACKUP_DEVICE; (注释：这个视图显示支持设备的设备的有关信息。如果某种设备类型不支持指定的设备，则返
回该设备的一个带设备类型和空设备的行。如果某种设备类型支持指定的设备，则为该类型
的每个可用设备返回一行。这个视图不返回特殊的设备类型DISK，因为它总是可用的。)
DEVICE_TYPE DEVICE_NAME
----------------- --------------------------------------------------------------------------------
SBT_TAPE
SQL>
SQL> select * from V$INSTANCE; ////这个视图显示当前实例的状态。
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS PARALLEL THREAD# ARCHIVER LOG_SWITCH_WAIT LOGINS SHUTDOWN_PENDING DATABASE_STATUS INSTANCE_ROLE ACTIVE_STATE
BLOCKED
--------------- ---------------- ---------------------------------------------------------------- ----------------- ------------ ------------ -------- ---------- -------- --------------- ---------- ---------------- ----------------- ------------------ ------------
-------
1 orcl zhangshibo 11.2.0.1.0 2012-10-17 1 OPEN NO 1 STOPPED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
NO
SQL>
SQL> select * from V$LOCK; ////这个视图列出Oracle 服务器当前拥有的锁以及未完成的锁或栓锁请求。
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ---------- ---- ---------- ---------- ---------- ---------- ---------- ----------
00000000C6C891A8 00000000C6C89200 209 XR 4 0 1 0 443625 0
00000000C6C89278 00000000C6C892D0 209 RD 1 0 1 0 443625 0
00000000C6C89348 00000000C6C893A0 209 CF 0 0 2 0 443625 0
00000000C6C894E8 00000000C6C89540 209 RS 25 1 2 0 443621 0
00000000C6C895B8 00000000C6C89610 99 AE 100 0 4 0 3425 0
00000000C6C89688 00000000C6C896E0 193 RT 1 0 6 0 443621 0
00000000C6C89758 00000000C6C897B0 161 PW 1 0 3 0 443301 0
00000000C6C89828 00000000C6C89880 225 TS 3 1 3 0 443304 0
00000000C6C898F8 00000000C6C89950 1 AE 100 0 4 0 443303 0
00000000C6C899C8 00000000C6C89A20 161 MR 1 0 4 0 443304 0
00000000C6C89A98 00000000C6C89AF0 161 MR 2 0 4 0 443304 0
00000000C6C89B68 00000000C6C89BC0 161 MR 3 0 4 0 443304 0
00000000C6C89C38 00000000C6C89C90 161 MR 4 0 4 0 443304 0
00000000C6C89D08 00000000C6C89D60 161 MR 5 0 4 0 443304 0
00000000C6C89DD8 00000000C6C89E30 161 MR 6 0 4 0 443304 0
00000000C6C89EC0 00000000C6C89F18 161 MR 201 0 4 0 443304 0
00000000C6C89F90 00000000C6C89FE8 114 AE 100 0 4 0 3507 0
00000000C6C8A060 00000000C6C8A0B8 130 AE 100 0 4 0 408 0
00000000C6C8A130 00000000C6C8A188 146 AE 100 0 4 0 3409 0
00000000C6C8A200 00000000C6C8A258 162 AE 100 0 4 0 3367 0
ADDR KADDR SID TYPE ID1 ID2 LMODE REQUEST CTIME BLOCK
---------------- ---------------- ---------- ---- ---------- ---------- ---------- ---------- ---------- ----------
00000000C6C8A2D0 00000000C6C8A328 178 AE 100 0 4 0 1067 0
21 rows selected
SQL>
SQL> select * from V$OPTION; ////这个视图列出与 Oracle 一道安装的选项。
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Partitioning TRUE
Objects TRUE
Real Application Clusters FALSE
Advanced replication TRUE
Bit-mapped indexes TRUE
Connection multiplexing TRUE
Connection pooling TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
Proxy authentication/authorization TRUE
Change Data Capture TRUE
Plan Stability TRUE
Online Index Build TRUE
Coalesce Index TRUE
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Managed Standby TRUE
Materialized view rewrite TRUE
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial TRUE
Automatic Storage Management FALSE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE
Java TRUE
OLAP Window Functions TRUE
Block Media Recovery TRUE
Fine-grained Auditing TRUE
Application Role TRUE
Enterprise User Security TRUE
Oracle Data Guard TRUE
Oracle Label Security FALSE
OLAP TRUE
Basic Compression TRUE
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Join index TRUE
Trial Recovery TRUE
Data Mining TRUE
Online Redefinition TRUE
Streams Capture TRUE
File Mapping TRUE
Block Change Tracking TRUE
Flashback Table TRUE
Flashback Database TRUE
Transparent Data Encryption TRUE
Backup Encryption TRUE
Unused Block Compression TRUE
Oracle Database Vault FALSE
Result Cache TRUE
SQL Plan Management TRUE
SecureFiles Encryption TRUE
Real Application Testing TRUE
Flashback Data Archive TRUE
DICOM TRUE
Active Data Guard TRUE
Server Flash Cache TRUE
PARAMETER VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Advanced Compression TRUE
XStream TRUE
Deferred Segment Creation TRUE
65 rows selected
SQL>
SQL> select * from V$ROLLNAME; ///这个视图列出所有联机回退段的名称。它只有在数据库打开时访问。
USN NAME
---------- ------------------------------
0 SYSTEM
1 _SYSSMU1_3780397527$
2 _SYSSMU2_2232571081$
3 _SYSSMU3_2097677531$
4 _SYSSMU4_1152005954$
5 _SYSSMU5_1527469038$
6 _SYSSMU6_2443381498$
7 _SYSSMU7_3286610060$
8 _SYSSMU8_2012382730$
9 _SYSSMU9_1424341975$
10 _SYSSMU10_3550978943$
11 rows selected
SQL>
SQL> select * from V$RSRC_CONSUMER_GROUP_CPU_MTH; ////这个视图显示资源使用者组的所有可用资源分配方法。
NAME
----------------------------------------
ROUND-ROBIN
RUN-TO-COMPLETION
SQL>
SQL> select * from V$RSRC_PLAN; ////这个视图显示所有当前活动资源计划的名称。
ID NAME IS_TOP_PLAN CPU_MANAGED
---------- -------------------------------- ----------- -----------
SQL>
SQL> select * from V$SESSION_CONNECT_INFO; ///这个视图显示当前会话的网络连接的有关信息。
SID SERIAL# AUTHENTICATION_TYPE OSUSER NETWORK_SERVICE_BANNER CLIENT_CHARSET CLIENT_CONNECTION CLIENT_OCI_LIBRARY CLIENT_VERSION
CLIENT_DRIVER CLIENT_LOBATTR CLIENT_REGID
---------- ---------- -------------------------- ------------------------------ -------------------------------------------------------------------------------- ---------------------------------------- ----------------- --------------------------- ----------------------------------------
------------- ----------------------- ------------
99 2486 INTERNAL 马明 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
99 2486 INTERNAL 马明 Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
99 2486 INTERNAL 马明 Oracle Advanced Security: crypto-checksumming service for Linux: Version 11.2.0. UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
114 2040 DATABASE lxm TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production US7ASCII Homogeneous Home-based 11.2.0.2.0
Client Temp Lob Rfc On 0
114 2040 DATABASE lxm Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro US7ASCII Homogeneous Home-based 11.2.0.2.0
Client Temp Lob Rfc On 0
114 2040 DATABASE lxm Oracle Advanced Security: crypto-checksumming service for Linux: Version 11.2.0. US7ASCII Homogeneous Home-based 11.2.0.2.0
Client Temp Lob Rfc On 0
130 163 DATABASE Administrator TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
130 163 DATABASE Administrator Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
130 163 DATABASE Administrator Oracle Advanced Security: crypto-checksumming service for Linux: Version 11.2.0. UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
146 77 INTERNAL 马明 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
146 77 INTERNAL 马明 Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
146 77 INTERNAL 马明 Oracle Advanced Security: crypto-checksumming service for Linux: Version 11.2.0. UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
162 89 INTERNAL 马明 TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
162 89 INTERNAL 马明 Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
162 89 INTERNAL 马明 Oracle Advanced Security: crypto-checksumming service for Linux: Version 11.2.0. UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
178 65 DATABASE Administrator TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
Client Temp Lob Rfc On 0
178 65 DATABASE Administrator Oracle Advanced Security: encryption service for Linux: Version 11.2.0.1.0 - Pro UTF8 Heterogeneous Full Instant Client 11.2.0.2.0
MySQL's Role: Databases in Web ApplicationsApr 17, 2025 am 12:23 AMThe main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.
MySQL: Building Your First DatabaseApr 17, 2025 am 12:22 AMThe steps to build a MySQL database include: 1. Create a database and table, 2. Insert data, and 3. Conduct queries. First, use the CREATEDATABASE and CREATETABLE statements to create the database and table, then use the INSERTINTO statement to insert the data, and finally use the SELECT statement to query the data.
MySQL: A Beginner-Friendly Approach to Data StorageApr 17, 2025 am 12:21 AMMySQL is suitable for beginners because it is easy to use and powerful. 1.MySQL is a relational database, and uses SQL for CRUD operations. 2. It is simple to install and requires the root user password to be configured. 3. Use INSERT, UPDATE, DELETE, and SELECT to perform data operations. 4. ORDERBY, WHERE and JOIN can be used for complex queries. 5. Debugging requires checking the syntax and use EXPLAIN to analyze the query. 6. Optimization suggestions include using indexes, choosing the right data type and good programming habits.
Is MySQL Beginner-Friendly? Assessing the Learning CurveApr 17, 2025 am 12:19 AMMySQL is suitable for beginners because: 1) easy to install and configure, 2) rich learning resources, 3) intuitive SQL syntax, 4) powerful tool support. Nevertheless, beginners need to overcome challenges such as database design, query optimization, security management, and data backup.
Is SQL a Programming Language? Clarifying the TerminologyApr 17, 2025 am 12:17 AMYes,SQLisaprogramminglanguagespecializedfordatamanagement.1)It'sdeclarative,focusingonwhattoachieveratherthanhow.2)SQLisessentialforquerying,inserting,updating,anddeletingdatainrelationaldatabases.3)Whileuser-friendly,itrequiresoptimizationtoavoidper
Explain the ACID properties (Atomicity, Consistency, Isolation, Durability).Apr 16, 2025 am 12:20 AMACID attributes include atomicity, consistency, isolation and durability, and are the cornerstone of database design. 1. Atomicity ensures that the transaction is either completely successful or completely failed. 2. Consistency ensures that the database remains consistent before and after a transaction. 3. Isolation ensures that transactions do not interfere with each other. 4. Persistence ensures that data is permanently saved after transaction submission.
MySQL: Database Management System vs. Programming LanguageApr 16, 2025 am 12:19 AMMySQL is not only a database management system (DBMS) but also closely related to programming languages. 1) As a DBMS, MySQL is used to store, organize and retrieve data, and optimizing indexes can improve query performance. 2) Combining SQL with programming languages, embedded in Python, using ORM tools such as SQLAlchemy can simplify operations. 3) Performance optimization includes indexing, querying, caching, library and table division and transaction management.
MySQL: Managing Data with SQL CommandsApr 16, 2025 am 12:19 AMMySQL uses SQL commands to manage data. 1. Basic commands include SELECT, INSERT, UPDATE and DELETE. 2. Advanced usage involves JOIN, subquery and aggregate functions. 3. Common errors include syntax, logic and performance issues. 4. Optimization tips include using indexes, avoiding SELECT* and using LIMIT.
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool
Safe Exam Browser
Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.
SublimeText3 Linux new version
SublimeText3 Linux latest version
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
