以v$开头的数据字典与以dba_开头的数据字典主要区别是什么
v$开头的数据字典 叫动态视图，其数据存放在内存中，动态变化，一旦关闭实例，里面的数据就会被清空，启动实例后被重新设置。dba_开头的数据字典是静态视图，是数据存放在表中的，关闭实例后，数据不会被清空 Data dictionary views are static views that answer questions such as:
• Was the object ever created?
• What is the object a part of?
• Who owns the object?
• What privileges do users have?
• What restrictions are on the object?
The dynamic tables answer questions such as:
• Is the object online and available?
• Is the object open?
• What locks are being held?
• Is the session active?
页:
[1]