management information

Oracle data dictionary and dynamic performance views

Common data dictionary: dba_data_files: usually used to query the information on the database file dba_db_links: in all databases including database links, which is databaselinks. dba_extents: a database of information on all partitions dba_free_spac ...

Sys and system users. Sysdba and sysoper system privileges. Dba role in the difference between

In this paper, carried over the Internet, I would like to thank the author! the difference between sys and system users 1) The most important difference between the importance of data stored in different Sys] [all oracle data dictionary base tables a ...

dump the memory management information syntax

heapdump: dump PGA UGA SGA Immediately dump syntax: alter session set events 'immediate trace name heapdump level <level>'; With regard to the syntax error dump alter session set events '<error#> trace name heapdump level < ...
Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments