Chapter 05–Using Data Dictionary and Dynamic Performance.txt
来源:互联网 发布:starry night软件下载 编辑:程序博客网 时间:2024/06/06 18:55
data dictionary
stored in the system tablespace
owned by the user sys
read-only
when DDL statement is executed
由base tables(sql.bsq)和data dictionary views(catalog.sql)构成
静态:
USER_XXX
ALL_XXX
DBA_XXX
预览表 desc dictionary
dynamic performance tables (虚表,存在内存与控制文件里的信息以表的形式
表现出来)
动态:
V$XXX
预览表 desc V$FIXED_TABLE
一般普通用户查询不了这种表,性能调优查看
查看数据字典通常是你要先知道想查看的表名,然后desc一下,有必要col 字段名
format a50,再select查看想要的字段,具体字段参数的含义就要查联机文档了(
reference)
- Chapter 05–Using Data Dictionary and Dynamic Performance.txt
- Using Data Dictionary and Dynamic Performance Views
- Fundamental I 05 Using Data Dictionary and Dynamic Performance Views
- data dictionary and dynamic performance view
- 128.Note the points about data dictionary views and dynamic performance views:
- Using the V$SEGMENT_STATISTICS Dynamic Performance View
- Matlab read data from txt file and then cluster data using K-means
- Collecting performance counters and using SQL Server to analyze the data
- Using inheritance and dynamic binding
- Chapter 2 Computer Evolution And Performance
- Chapter 11: Using Menu-Based Controls--Defining menu structure and data
- Chapter 11: Using Menu-Based Controls Defining menu structure and data
- Data Structures and Other Objects Using C++ (Chapter 1) 学习笔记一
- Data Structures and Other Objects Using C++ (Chapter 1) 学习笔记二
- Data Structures and Other Objects Using C++ (Chapter 1) 学习笔记三
- Data Structures and Other Objects Using C++ (Chapter 2) 学习笔记四
- Data Structures and Other Objects Using C++ (Chapter 2) 学习笔记五
- Building Data Dictionary using SQL Server 2005
- Windows 命名管道2
- Oracle 常见错误码整理
- C语言100个经典的算法
- Chapter 06–Maintaining the Control File
- C算法
- Chapter 05–Using Data Dictionary and Dynamic Performance.txt
- ctypes文章收集
- Chapter 04–Creating a Database
- Reading notes of Dynamic Ticks
- 关于IoGetTopLevelIrp()
- 开启关闭、操作日志文件alter.LOG trace.LOG
- ListView的Item中有CheckBox,导致OnItemClick不响应的解决办法
- 枚举的使用
- 反编译APK文件的三种方法