Oracle commonly uesd tables/views and processes（一）

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Oracle commonly uesd tables/views and processes（一），小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1430字，纯文字阅读大概需要3分钟。

内容图文

一、
Oracle commonly used tables
1、
DBA_USERS #DataBase users information

common column
username
user_id
account_status
lock_date
expiry_date
default_tablespace
temporary_tablespace
2、
DBA_SEGMENTS #describe the storage allocated for all segments in the database.

common column
owner
segment_name
segment_type
partition_name
tablespace_name
bytes
二、
Oracle commonly used processes
1、instance background processes

PMON :periodically check the status of the server process and restore abnormal processes 。
LGWR: to write the log  buffer contents to the redo log file,oracle writes the user chenges to the redo log file and then writes the data files.
CKPT:A checkpoint is an event that triggers DBWR to require dirty data to be written to a data file when a checkpoint occurs .LGWR writes to the log .
SMON:mandatory to perform  a recovery when the database is started . reclaim space to merge free and adjacent extents in the tablespace .clean up temporary tablespace/temporary segmentes.
ARCH:only started in archive mode .when the online redo logs  is full ,copy the log the spectfied location.
DBWR:writes the database buffer cache to the data files.

Oracle commonly uesd tables/views and processes（一）

标签：oca   trigger   byte   process   hat   rest   users   status   roc   

本文系统来源：https://blog.51cto.com/11298469/2450506

内容总结

以上是互联网集市为您收集整理的Oracle commonly uesd tables/views and processes（一）全部内容，希望文章能够帮你解决Oracle commonly uesd tables/views and processes（一）所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---