加入收藏 | 设为首页 | 会员中心 | 我要投稿 核心网 (https://www.hxwgxz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 站长百科 > 正文

oracle 10g 生成awr报告过程

发布时间:2021-01-25 12:35:22 所属栏目:站长百科 来源:网络整理
导读:SQL exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning,OLAP and Data Mining options [ [email?protected]_maridb ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Pr

<P>
No data exists for this section of the report.
<P>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<A class=‘awr‘ NAME=‘6800‘></A>
<H3 class=‘awr‘>init.ora Parameters</H3>
<UL>
</UL>
<TABLE BORDER=1><TR><TH class=‘awrbg‘>Parameter Name</TH><TH class=‘awrbg‘>Begin value</TH><TH class=‘awrbg‘>End value (if different)</TH></TR>
<TR><TD class=‘awrc‘>_allow_resetlogs_corruption</TD> <TD class=‘awrc‘>TRUE</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>audit_file_dest</TD> <TD class=‘awrnc‘>/u01/oracle/admin/skodacom/adump</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>audit_sys_operations</TD> <TD class=‘awrc‘>TRUE</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>audit_trail</TD> <TD class=‘awrnc‘>DB,EXTENDED</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>background_dump_dest</TD> <TD class=‘awrc‘>/u01/oracle/admin/skodacom/bdump</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>control_files</TD> <TD class=‘awrnc‘>/u01/oradata/skodacom/control1.ctl,/u01/oradata/skodacom/control2.ctl,/u01/oradata/skodacom/control3.,/u01/app/oracle/product/10.2.0/db_1/dbs/ctl</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>core_dump_dest</TD> <TD class=‘awrc‘>/u01/oracle/admin/skodacom/cdump</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>db_block_size</TD> <TD class=‘awrnc‘>8192</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>db_create_file_dest</TD> <TD class=‘awrc‘>/u01/oradata</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>db_create_online_log_dest_1</TD> <TD class=‘awrnc‘>/u01/oradata</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>db_domain</TD> <TD class=‘awrc‘>skodacom</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>db_name</TD> <TD class=‘awrnc‘>skodacom</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>db_recovery_file_dest</TD> <TD class=‘awrc‘>/u01/arch/flashbakdb</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>db_recovery_file_dest_size</TD> <TD class=‘awrnc‘>21474836480</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>db_unique_name</TD> <TD class=‘awrc‘>skodacom</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>job_queue_processes</TD> <TD class=‘awrnc‘>10</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>log_archive_dest_1</TD> <TD class=‘awrc‘>LOCATION=/u01/arch/skodacom</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>log_archiveformat</TD> <TD class=‘awrnc‘>log%t%s%r.arc</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>open_cursors</TD> <TD class=‘awrc‘>1500</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>processes</TD> <TD class=‘awrnc‘>400</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>sga_target</TD> <TD class=‘awrc‘>1224736768</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>undo_management</TD> <TD class=‘awrnc‘>AUTO</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>undo_retention</TD> <TD class=‘awrc‘>10800</TD> <TD class=‘awrc‘>??</TD></TR>
<TR><TD class=‘awrnc‘>undo_tablespace</TD> <TD class=‘awrnc‘>UNDOTBS1</TD> <TD class=‘awrnc‘>??</TD></TR>
<TR><TD class=‘awrc‘>user_dump_dest</TD> <TD class=‘awrc‘>/u01/oracle/admin/skodacom/udump</TD> <TD class=‘awrc‘>??</TD></TR>
</TABLE><P>
<BR><A class=‘awr‘ HREF=‘#top‘>Back to Top</A><P>
<P>
<P>
<P>
<P>
<P>
End of Report
</BODY></HTML>
Report written to awrrpt_1_52416_52434.html
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning,OLAP and Data Mining options
[[email?protected]_maridb ~]$ ll总用量 19080-rw-r--r-- 1 oracle oinstall 252239 7月 1 16:09 awrrpt_1_52416_52434.html-rw-r--r-- 1 oracle oinstall 249247 7月 1 15:22 awrrpt_1_52431_52432.html-rw-r--r-- 1 oracle oinstall 16444 4月 16 11:45 dbca.rsp-rw-r--r-- 1 oracle oinstall 920 4月 16 11:24 enterprise01.rsp-rw-r--r-- 1 oracle oinstall 457 4月 22 16:04 export.log-rw-r----- 1 oracle oinstall 18321408 4月 19 10:54 full.dmp-rw-r----- 1 oracle oinstall 1167 4月 19 11:39 impdp.log-rw-r----- 1 oracle oinstall 291067 4月 19 11:36 import.log-rw-r--r-- 1 oracle oinstall 5742 4月 16 11:49 netca.rsp-rw-rw-r-- 1 oracle oinstall 65 4月 16 11:13 oraInst.loc-rw-r--r-- 1 root root 121910 5月 14 14:19 rlwrap-0.43-2.el7.x86_64.rpm-rw-r--r-- 1 oracle oinstall 65638 5月 14 11:48 rman_11.logdrwxr-xr-x 2 oracle oinstall 4096 5月 23 10:55 scripts-rw-r----- 1 oracle oinstall 172032 4月 19 11:36 testexpdp.dmp

(编辑:核心网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

热点阅读