oracle数据文件的存放位置（oracle常用命令）
前言：
?在生产环境中，当运行中的Oracle数据库出现性能问题的时候，DBA通常都需要我们生成Oracle数据库出现性能问题时间段的AWR或者ASH等报告来判断原因，所以维护人员学会收集AWR、ADDM、ASH报告是必须的。
环境：
?CentOS 7.5
?Docker 20.10.2
?Oracle_11g
AWR报告收集：
?AWR(Automatic Workload Repository)自动工作负载库是Oracle公司提供的一个工具。AWR来可以自动收集、处理、并保存性能统计结果，这种统计数据存放在内存中并随后存储在数据库中，这些数据既能在报告中显示也可以通过视图查询。可以协助我们找出Oracle的性能瓶颈。
?@?/rdbms/admin/awrrpt
[root@localhost ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES3edfba76f476 registry.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 6 months ago Up 2 seconds 0.0.0.0:1521->1521/tcp oracle_11g[root@localhost ~]# docker exec -it oracle_11g /bin/bash[oracle@3edfba76f476 /]$ su - root //切换为root用户Password: # 密码默认为 helowin[oracle@3edfba76f476 /]$ su - oracle //再切换oracle用户，并且以SYS登录数据库[oracle@3edfba76f476 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 20 16:13:26 2021Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> @?/rdbms/admin/awrrpt //执行这个SQL就可以开始AWR报告收集Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------ 1384114315 HELOWIN 1 helowinSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'Enter value for report_type: //提示你输入生成报告类型，默认为HTML，回车即可Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 1384114315 1 ORCL orcl 32e47e645a97 1384114315 1 ORCL helowin a444e690ce3e 1384114315 1 ORCL orcl a444e690ce3e 1384114315 1 ORCL helowin 85e4a929d0f8* 1384114315 1 HELOWIN helowin 3edfba76f476 1384114315 1 HELOWIN helowin 85e4a929d0f8Using 1384114315 for database IdUsing 1 for instance numberSpecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Entering the number of days (n) will result in the most recent(n) days of snapshots being listed. Pressing <return> withoutspecifying a number lists all completed snapshots.Enter value for num_days: 1 //输入快照查看的间隔，一般一天的就行，实际根据DBA的要求来做Listing the last day's Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----helowin HELOWIN 253 21 Apr 2021 18:12 1 254 21 Apr 2021 19:00 1 255 21 Apr 2021 20:00 1Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 253 //首先输入开始的快照ID，此处为253Begin Snapshot Id specified: 253Enter value for end_snap: 255 //输入快照结束ID，可以根据要求的时间确定，此处为255End Snapshot Id specified: 255Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_1_253_255.html. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name: //输入报告的名字，默认的就可以，例如：awrrpt_1_167_169.html. 实例1 快照167-169的AWR报告，此处回车就行，报告生成在当前目录下Using the report name awrrpt_1_253_255.html<html><head><title>AWR Report for DB: HELOWIN, Inst: helowin, Snaps: 253-255</title><style type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}pre.awr {font:8pt Courier;color:black; background:White;}h1.awr {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}h2.awr {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}td.awrc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;}td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;}......<p />End of Report</body></html>Report written to awrrpt_1_253_255.htmlSQL> !pwd/home/oracle1.1 查看oracle容器内生成的AWR报告
[root@test ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES3edfba76f476 registry.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 2 months ago Up 3 hours 0.0.0.0:1521->1521/tcp oracle_11g[root@test ~]# docker exec -it oracle_11g bash[oracle@3edfba76f476 /]$ su - rootPassword: helowin[root@3edfba76f476 ~]# su - oracle[oracle@3edfba76f476 ~]$ ls /home/oracle/app awrrpt_1_253_255.html1.2 导出oracle容器内部的AWR报告至之宿主机
—》docker cp 容器ID:容器内文件路径 ./（宿主机路径）
[root@test ~]# docker cp 3edfba76f476:/home/oracle/awrrpt_1_253_255.html ./其他（RAC）：
?因为有的系统一般都是RAC，所以需要在各个节点下的AWR报告，如果你愿意登录各个节点，可以使用一下SQL
SQL> @?/rdbms/admin/awrrpti.sql //和上边的区别就在这于，输入报告类型后的部分Instances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 3704746844 2 HS08 HS082 hp102* 3704746844 1 HS08 HS081 hp101Enter value for dbid: 3704746844 （会要求你输入数据库的DBID）Using 3704746844 for database IdEnter value for inst_num: 1 （输入数据库实例NUM，一般就是2节点，所以一般就是输入1 或者2）剩下的部分没啥区别Using 1 for instance numberADDM报告收集：
?ADDM(Automatic Database Diagnostic Monitor) 是植入Oracle数据库的一个自诊断引擎.ADDM 通过检查和分析AWR获取的数据来判断Oracle数据库中可能的问题.
?@?/rdbms/admin/addmrpt
...SQL> @?/rdbms/admin/addmrpt //执行这个SQL就可以开始AWR报告收集Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------ 1384114315 HELOWIN 1 helowinInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 1384114315 1 ORCL orcl 32e47e645a97 1384114315 1 ORCL helowin a444e690ce3e 1384114315 1 ORCL orcl a444e690ce3e 1384114315 1 ORCL helowin 85e4a929d0f8* 1384114315 1 HELOWIN helowin 3edfba76f476 1384114315 1 HELOWIN helowin 85e4a929d0f8Using 1384114315 for database IdUsing 1 for instance numberSpecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Entering the number of days (n) will result in the most recent(n) days of snapshots being listed. Pressing <return> withoutspecifying a number lists all completed snapshots.Listing the last 3 days of Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----helowin HELOWIN 253 21 Apr 2021 18:12 1 254 21 Apr 2021 19:00 1 255 21 Apr 2021 20:00 1 256 21 Apr 2021 21:00 1Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 254Begin Snapshot Id specified: 254Enter value for end_snap: 256End Snapshot Id specified: 256Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is addmrpt_1_254_256.txt. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name:Using the report name addmrpt_1_254_256.txtRunning the ADDM analysis on the specified pair of snapshots ...Generating the ADDM report for this analysis ... ADDM Report for Task 'TASK_295' -------------------------------Analysis Period---------------AWR snapshot range from 254 to 256.Time period starts at 21-APR-21 07.00.07 PMTime period ends at 21-APR-21 09.00.21 PMAnalysis Target---------------Database 'HELOWIN' with DB ID 1384114315.Database version 11.2.0.1.0.ADDM performed an analysis of instance helowin, numbered 1 and hosted at3edfba76f476.Activity During the Analysis Period-----------------------------------Total database time was 263 seconds.The average number of active sessions was .04.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~There are no findings to report.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Additional Information ----------------------Miscellaneous Information-------------------------There was no significant database activity to run the ADDM.End of ReportReport written to addmrpt_1_254_256.txt
2.1 查看oracle容器内生成的ADDM报告
[root@test ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES3edfba76f476 registry.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 2 months ago Up 3 hours 0.0.0.0:1521->1521/tcp oracle_11g[root@test ~]# docker exec -it oracle_11g bash[oracle@3edfba76f476 /]$ su - rootPassword: helowin[root@3edfba76f476 ~]# su - oracle[oracle@3edfba76f476 ~]$ pwd/home/oracle[oracle@3edfba76f476 ~]$ lsaddmrpt_1_254_256.txt app awrrpt_1_253_255.html2.2 导出oracle容器内部的ADDM报告至之宿主机
—》docker cp 容器ID:容器内文件路径 ./（宿主机路径）
[root@test ~]# docker cp 3edfba76f476:/home/oracle/addmrpt_1_254_256.txt ./其他（RAC）：
?因为有的系统一般都是RAC，所以需要在各个节点下的AWR报告，如果你愿意登录各个节点，可以使用一下SQL
?使用addmrpti.sql脚本：@?/rdbms/admin/addmrpt.sql
ASH报告收集：
?ASH即活动会话历史，Active Session History，ASH以VSESSION为基础，每秒采样一次，记录活动会话等待的事件。不活动的会话不会采样， 采样工作由新引入的后台进程MMNL完成。
?Oracle v$active_session_history视图提供了实例中的活动会话采样。通过该视图提供的最详细最完整性能数据，可作为定位性能故障的一手证据。任一连接到数据库时，那些不属于空闲等待类的事件的会话被认为是活动会话。这包括在采样时在CPU上的任何会话。
?@?/rdbms/admin/ashrpt
...SQL> @?/rdbms/admin/ashrpt //执行这个SQL就可以开始ASH报告收集Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------ 1384114315 HELOWIN 1 helowinSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'Enter value for report_type: //提示你输入生成报告类型，默认为HTML，回车即可Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 1384114315 1 ORCL orcl 32e47e645a97 1384114315 1 ORCL helowin a444e690ce3e 1384114315 1 ORCL orcl a444e690ce3e 1384114315 1 ORCL helowin 85e4a929d0f8* 1384114315 1 HELOWIN helowin 85e4a929d0f8* 1384114315 1 HELOWIN helowin 3edfba76f476Defaults to current databaseUsing database id: 1384114315Enter instance numbers. Enter 'ALL' for all instances in aRAC cluster or explicitly specify list of instances (e.g., 1,2,3).Defaults to current instance.Using instance number(s): 1ASH Samples in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Oldest ASH sample available: 21-Apr-21 18:00:56 [ 236 mins in the past]Latest ASH sample available: 21-Apr-21 21:57:14 [ 0 mins in the past]Specify the timeframe to generate the ASH report~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter begin time for report: -- Valid input formats:-- To specify absolute begin time:-- [MM/DD[/YY]] HH24:MI[:SS]-- Examples: 02/23/03 14:30:15-- 02/23 14:30:15-- 14:30:15-- 14:30-- To specify relative begin time: (start with '-' sign)-- -[HH24:]MI-- Examples: -1:15 (SYSDATE - 1 Hr 15 Mins)-- -25 (SYSDATE - 25 Mins)Defaults to -15 minsEnter value for begin_time: 18:00 //输入开始的时间，格式为： 年/月/日 小时/分钟/秒Report begin time specified: 18:00 Enter duration in minutes starting from begin time:Defaults to SYSDATE - begin_timePress Enter to analyze till current timeEnter value for duration: 60Report duration specified: 60Using 21-Apr-21 18:00:00 as report begin timeUsing 21-Apr-21 19:00:00 as report end timeSpecify Slot Width (using ashrpti.sql) for 'Activity Over Time' section~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-- Explanation:-- In the 'Activity Over Time' section of the ASH report,-- the analysis period is divided into smaller slots-- and top wait events are reported in each of those slots.-- Default:-- The analysis period will be automatically split upto 10 slots-- complying to a minimum slot width of-- 1 minute, if the source is V$ACTIVE_SESSION_HISTORY or-- 5 minutes, if the source is DBA_HIST_ACTIVE_SESS_HISTORY.Specify Slot Width in seconds to use in the 'Activity Over Time' section:Defaults to a value as explained above:Slot Width specified:Specify Report Targets (using ashrpti.sql) to generate the ASH report~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-- Explanation:-- ASH Report can accept "Report Targets",-- like a particular SQL statement, or a particular SESSION,-- to generate the report on. If one or more report targets are-- specified, then the data used to generate the report will only be-- the ASH samples that pertain to ALL the specified report targets.-- Default:-- If none of the report targets are specified,-- then the target defaults to all activity in the database instance.Specify SESSION_ID (eg: from V$SESSION.SID) report target:Defaults to NULL:SESSION report target specified:Specify SQL_ID (eg: from V$SQL.SQL_ID) report target:Defaults to NULL: (% and _ wildcards allowed)SQL report target specified:Specify WAIT_CLASS name (eg: from V$EVENT_NAME.WAIT_CLASS) report target:[Enter 'CPU' to investigate CPU usage]Defaults to NULL: (% and _ wildcards allowed)WAIT_CLASS report target specified:Specify SERVICE_HASH (eg: from V$ACTIVE_SERVICES.NAME_HASH) report target:Defaults to NULL:SERVICE report target specified:Specify MODULE name (eg: from V$SESSION.MODULE) report target:Defaults to NULL: (% and _ wildcards allowed)MODULE report target specified:Specify ACTION name (eg: from V$SESSION.ACTION) report target:Defaults to NULL: (% and _ wildcards allowed)ACTION report target specified:Specify CLIENT_ID (eg: from V$SESSION.CLIENT_IDENTIFIER) report target:Defaults to NULL: (% and _ wildcards allowed)CLIENT_ID report target specified:Specify PLSQL_ENTRY name (eg: "SYS.DBMS_LOB.*") report target:Defaults to NULL: (% and _ wildcards allowed)PLSQL_ENTRY report target specified:Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is ashrpt_1_0421_1900.html. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name:Using the report name ashrpt_1_0421_1900.htmlSummary of All User Input-------------------------Format : HTMLDB Id : 1384114315Inst num : 1Begin time : 21-Apr-21 18:00:00End time : 21-Apr-21 19:00:00Slot width : DefaultReport targets : 0Report name : ashrpt_1_0421_1900.html<html><head><title>ASH Report - From 21-Apr-21 18:00:00 To 21-Apr-21 19:00:00</title><style type="text/css">body.awr {font:bold 10pt Arial,Helvetica,Geneva,sans-serif;color:black; background:White;}pre.awr {font:8pt Courier;color:black; background:White;}h1.awr {font:bold 20pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;border-bottom:1px solid #cccc99;margin-top:0pt; margin-bottom:0pt;padding:0px 0px 0px 0px;}h2.awr {font:bold 18pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}h3.awr {font:bold 16pt Arial,Helvetica,Geneva,sans-serif;color:#336699;background-color:White;margin-top:4pt; margin-bottom:0pt;}li.awr {font: 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;}th.awrnobg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:black; background:White;padding-left:4px; padding-right:4px;padding-bottom:2px}th.awrbg {font:bold 8pt Arial,Helvetica,Geneva,sans-serif; color:White; background:#0066CC;padding-left:4px; padding-right:4px;padding-bottom:2px}td.awrnc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;}td.awrc {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;}td.awrnclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;}td.awrncbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;}td.awrncrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-right: thin solid black;}td.awrcrb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-right: thin solid black;}td.awrclb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;}td.awrcbb {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-left: thin solid black;border-right: thin solid black;}a.awr {font:bold 8pt Arial,Helvetica,sans-serif;color:#663300; vertical-align:top;margin-top:0pt; margin-bottom:0pt;}td.awrnct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:White;vertical-align:top;}td.awrct {font:8pt Arial,Helvetica,Geneva,sans-serif;border-top: thin solid black;color:black;background:#FFFFCC; vertical-align:top;}td.awrnclbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-left: thin solid black;}td.awrncbbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-left: thin solid black;border-right: thin solid black;border-top: thin solid black;}td.awrncrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:White;vertical-align:top;border-top: thin solid black;border-right: thin solid black;}td.awrcrbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-right: thin solid black;}td.awrclbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;}td.awrcbbt {font:8pt Arial,Helvetica,Geneva,sans-serif;color:black;background:#FFFFCC; vertical-align:top;border-top: thin solid black;border-left: thin solid black;border-right: thin solid black;}table.tdiff { border_collapse: collapse; }</style></head><body class="awr"><h1 class="awr">ASH Report For HELOWIN/helowin</h1><p /><table border="1" width="500"><tr><th class="awrbg">DB Name</th><th class="awrbg">DB Id</th><th class="awrbg">Instance</th><th class="awrbg">Inst num</th><th class="awrbg">Release</th><th class="awrbg">RAC</th><th class="awrbg">Host</th></tr><tr><td class='awrnc'>HELOWIN</td><td align="right" class='awrnc'>1384114315</td><td class='awrnc'>helowin</td><td align="right" class='awrnc'>1</td><td class='awrnc'>11.2.0.1.0</td><td ......class='awrc'> </td><td class='awrc'>db file sequential read</td><td align="right" class='awrc'>1</td><td align="right" class='awrc'>2.17</td></tr></table><p /><br /><a class="awr" href="#top">Back to Top</a><p /><p />End of Report</body></html>Report written to ashrpt_1_0421_1900.html //输入报告的名字，默认回车即可3.1 查看oracle容器内生成的ADDM报告
[root@test ~]# docker psCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES3edfba76f476 registry.aliyuncs.com/helowin/oracle_11g "/bin/sh -c '/home/o…" 2 months ago Up 3 hours 0.0.0.0:1521->1521/tcp oracle_11g[root@test ~]# docker exec -it oracle_11g bash[oracle@3edfba76f476 /]$ su - rootPassword: helowin[root@3edfba76f476 ~]# su - oracle[oracle@3edfba76f476 ~]$ pwd/home/oracle[oracle@3edfba76f476 ~]$ lsaddmrpt_1_254_256.txt app ashrpt_1_0421_1900.html awrrpt_1_253_255.html3.2 导出oracle容器内部的ADDM报告至之宿主机
—》docker cp 容器ID:容器内文件路径 ./（宿主机路径）
[root@test ~]# docker cp 3edfba76f476:/home/oracle/ashrpt_1_0421_1900.html ./其他（RAC）：
?因为有的系统一般都是RAC，所以需要在各个节点下的AWR报告，如果你愿意登录各个节点，可以使用一下SQL
@?/rdbms/admin/ashrpti.sql与上边的不同也就是需要输入DBID和实例NUMBER，明白提示的意思就行。
—注意— ：
?在生成报告期间，不能有数据库重启的操作，如果有会有报错。
查看生成的各项报告：
AWR报告
ADDM报告
ASH报告
原创文章，作者：admin，如若转载，请注明出处：https://www.qq65hfghe5.com/tg/6732.html
赞 (0)
microsoftoffice激活工具（office2016永久激活工具）
上一篇
2024年11月1日 16:06:31
产品运营总监主要做什么（32点概括运营总监职责）
下一篇
2024年11月1日 16:07:31
相关推荐
-
小米金属鼠标垫怎么样（深度评测其材质及功能特点）
小米，总有很多产品让人无比欣喜。因为他会用心去感受每一款产品在用户日常使用过程中的点滴，如何做到更加的贴心，如何做到让用户无可挑剔，如何精益求精、专心致志做好自己的产品，这都在米文…
-
excel记账凭证制作（在电脑上制作表格做账方法）
我们公司的财务主管有着10年的财务工作经验，这次国庆假期回来后，看见会计小王在某宝买了一个Excel财务记账管理系统，看完之后主管竖起了大拇指，这19元花的太值了！ 主管给我们讲解…
-
平台推广有哪些好的方法（效果最好的3种推广）
越来越多的发展呈“互联网+”，教育行业也不例外，线上教育平台如雨后春笋一般。据数据统计，2014年线上教育突破了千亿元，再加上受新型冠状肺炎疫情的影响，线上教育预计在2020年教育…
-
佳雪芦荟保湿霜好用吗（盘点好用国货护肤品排行榜）
仙女们晚上好~~前段时间给大家写了一波难用的护肤品吐槽，仙女们的反响简直是超乎我的想象，并且还强烈要求我继续写一波难用的国货产品~~避免踩雷！！ 相信大家在国货热中败过很多国货化妆…
-
excel表格里面的数据怎么自动求和（求和函数的3种快捷键）
Excel可算是办公用具中非常强大的了，我们可以利用Excel完成各种公式的预算，比如求和，求积，求差，求平均值等等，我们最常用的就是求和了，今天小编做了一个简单的表格，教大家使用…
-
大数据审计案例分析（运用审计大数据的典型案例）
大数据时代的政府审计，不仅需要创新审计模式和审计方法，应对审计对象的海量数据，更需要将大数据技术手段和思维方式应用于审计流程，提供认识问题和解决问题的新思路，提升审计质量和效率。基…
-
3d画图软件哪个好用（3d绘图软件免费）
你们肯定想问，我要学习什么软件呢？什么软件好学易上手？什么软件应用面广？这都是新手所要面临的一些问题。今天这期我给大家介绍3款常用的建模软件。想要学习软件的你千万不能错过！ 一、3…
-
世界手机排行榜10强（全球手机销量排名）
现在各国都在铺建5G网络，5G网络的各种应用也在加快落地。就手机市场而言，从第一款5G手机正式量产发布以来已经过去两年多的时间里，现在很多厂商都已经相继推出自家的5G手机。近日，S…
-
windows远程连接工具有哪些（内网远程桌面控制软件使用方法）
远程控制能帮我们解决很多工作上的事务，与之相关的远程控制软件也有很多，今天小编就给大家介绍5款免费的远程控制软件，小伙伴们可以各取所需哈。 1、微软远程桌面 微软自带的远程桌面最大…
-
名片设计制作软件（名片设计免费模板分享）
名片是现今社交圈中一个不可或缺的重要工具，也是名片持有人对自我的一种宣传渠道。与其他平面类设计品相比，名片的规格不大，设计过程也相对简单。但却很难将其做好、做精。 挑战名片的不同材…