




版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
1、Static Data Dictionary ViewsIn Trusted Oracle Server, each of the dictionary tables and views contains a column that indicates the label of each row in the table or view. Trusted Oracle also provides some additional dictionary tables and views, and some Oracle8 dictionary tables and views contain co
2、lumns that support compatibility with Trusted Oracle applications. See your Trusted Oracle documentation for more information about Trusted Oracle dictionary tables and views. Data Dictionary ViewsThe following is an alphabetical reference of the data dictionary views accessible to all users of an O
3、racle Server. Most views can be accessed by any user with the CREATE_SESSION privilege. The data dictionary views that begin with DBA_ are restricted. These views can be accessed only by users with the SELECT_ANY_TABLE privilege. This privilege is assigned to the DBA role when the system is initiall
4、y installed. ALL_ALL_TABLESThis view describes all of the tables (object tables and relational tables) accessible to the user. ALL_INDEXESThis view contains descriptions of indexes on tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE. This view supports p
5、arallel partitioned index scans. ALL_SEQUENCESThis view lists descriptions of sequences accessible to the user. ALL_TABLESThis view contains descriptions of relational tables accessible to the user. To gather statistics for this view, use the SQL command ANALYZE. ALL_TRIGGERSThis view lists trigger
6、information for triggers owned by the user, triggers on tables owned by the user, or all triggers if the user has the CREATE ANY TRIGGER privilege. ALL_USERSThis view contains information about all users of the database. ALL_VIEWSThis view lists the text of views accessible to the user. DBA_ALL_TABL
7、ESThis view displays descriptions of all tables (object tables and relational tables) in the database.DBA_CONSTRAINTSThis view contains constraint definitions on all tables.DBA_DATA_FILESThis view contains information about database files. DBA_EXTENTSThis view lists the extents comprising all segmen
8、ts in the database. DBA_FREE_SPACEThis view lists the free extents in all tablespaces. DBA_INDEXESThis view contains descriptions for all indexes in the database. To gather statistics for this view, use the SQL command ANALYZE. This view supports parallel partitioned index scans. DBA_JOBSThis view l
9、ists all jobs in the database. DBA_ROLESThis view lists all roles that exist in the database. DBA_ROLE_PRIVSThis view lists roles granted to users and roles. DBA_ROLLBACK_SEGSThis view contains descriptions of rollback segments. DBA_SEGMENTSThis view contains information about storage allocated for
10、all database segments. DBA_TABLESPACESThis view contains descriptions of all tablespaces. DBA_TRIGGERSThis view lists all triggers in the database. DBA_TS_QUOTASThis view lists tablespace quotas for all users. DBA_VIEWSThis view contains the text of all views in the database. DICTIONARYThis view con
11、tains descriptions of data dictionary tables and views.USER_TABLES This view contains a description of the user's own relational tables. To gather statistics for this view, use the SQL command ANALYZE. USER_TABLESPACES This view contains descriptions of accessible tablespaces. USER_TRIGGERS This
12、 view contains descriptions of the user's triggers. Dynamic Performance ViewsThe Oracle Server contains a set of underlying views that are maintained by the server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuousl
13、y updated while a database is open and in use, and their contents relate primarily to performance. Although these views appear to be regular database tables, they are not. These views provide data on internal disk structures and memory structures. These views can be selected from, but never updated
14、or altered by the user. The file CATALOG.SQL contains definitions of the views and public synonyms for the dynamic performance views. You must run CATALOG.SQL to create these views and synonyms. V$ ViewsDynamic performance views are identified by the prefix V_$. Public synonyms for these views have
15、the prefix V$. Database administrators or users should only access the V$ objects, not the V_$ objects. The dynamic performance views are used by Enterprise Manager and Oracle Trace, which is the primary interface for accessing information about system performance. Suggestion: Once the instance is s
16、tarted, the V$ views that read from memory are accessible. Views that read data from disk require that the database be mounted. Warning: Information about the dynamic performance views is presented for completeness only; this information does not imply a commitment to support these views in the futu
17、re. GV$ ViewsIn Oracle, there is an additional class of fixed views, the GV$ (Global V$) fixed views. For each of the V$ views described in this chapter (with the exception of V$CACHE_LOCK, V$LOCK_ACTIVITY, V$LOCKS_WITH_COLLISIONS, and V$ROLLNAME), there is a GV$ view. In a parallel server environme
18、nt, querying a GV$ view retrieves the V$ view information from all qualified instances. In addition to the V$ information, each GV$ view possesses an additional column named INST_ID with type integer. The INST_ID column displays the instance number from which the associated V$ view information was o
19、btained. The INST_ID column can be used as a filter to retrieve V$ information from a subset of available instances. For example, the query: SELECT * FROM GV$LOCK WHERE INST_ID = 2 OR INST_ID = 5 retrieves the information from the V$ views on instances 2 and 5. The GV$ views can be used to return in
20、formation on groups of instances defined with the OPS_ADMIN_GROUP parameter. Restrictions on GV$ Views GV$ views have the following restrictions: · The value of the PARALLEL_MAX_SERVERS parameter must be greater than zero on all instances mounting the database. · The OPS_ADMIN_GROUP parame
21、ter must be defined with at least one member for a query to successfully complete. V$BGPROCESS This view describes the background processes. V$BUFFER_POOLThis view displays information about all buffer pools available for the instance. The "sets" pertain to the number of LRU latch sets.V$C
22、ONTROLFILE This view lists the names of the control files. V$DATABASE This view contains database information from the control file. V$DATAFILE This view contains datafile information from the control file.V$DATAFILE_HEADER This view displays datafile information from the datafile headers. V$DBFILE This view lists all datafiles making up the database. This view is retained for historical compatibility. Use of V$DATAFILE is recommended instead.V$FILESTAT This view contains information about file read/write statistics. V$INSTANCEThis view displays the state of the c
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025河北雄安新区新建片区学校引进应届毕业生99人笔试模拟试题及答案解析
- 建设工程各方责任主体管理人员履职情况检查表
- 2025年学校控辍保学工作方案:夯实教育根基守护求学梦想
- 二年级数学有余数的除法(2位数除以1位数)竞赛试题练习题
- 诚信倡议书范文
- 进步之星先进事迹
- 部门内勤年终总结
- Unit 4 School Life 第3-4课时Reading and Rriting 课件 -【中职专用】高一学年英语(高教版2023修订版基础模块1)
- 设备维修人员年终总结
- 湖南省郴州市2024-2025学年高一上学期期末考试生物试题 含解析
- 教师个人嘉奖主要事迹材料500字(31篇)
- 基金基础知识考试题库100道及答案
- 高一下学期统编版历史必修中外历史纲要下第6课《全球航路的开辟》课件(共38张)
- 人教版(2024新版)九年级上册化学:第四单元 跨学科实践活动3《水质检测及自制净水器》教案教学设计
- 《跨文化传播教程》全套教学课件
- AQ 1119-2023 煤矿井下人员定位系统技术条件
- JGJ33-2012 建筑机械使用安全技术规程
- 收割机收割协议合同
- GB/T 10781.4-2024白酒质量要求第4部分:酱香型白酒
- 上海市文来中学2024届毕业升学考试模拟卷数学卷含解析
- 六年级奥数典型题-冲刺100测评卷10《工程问题》(原卷版)
评论
0/150
提交评论