Stack Overflow
Stack Overflow

Questions tagged [awr]

42 questions
1
vote
1 answer

Oracle "direct path read" Average wait time in AWR

I have a top wait event of "direct path read", which shows Average Wait time (Avg wait (ms)) of 96ms (in the top 5 events section). However, in the "Tablespace IO Stats" section, the only active tablespace (USERS) shows that "Av Rd(ms)" is at 2ms.…
user5372615
  • 35
  • 6
1
vote
1 answer

How to get archivelog generated based on AWR reports/repository?

We have an application that gets busy during a month in a year. We have enabled awr repository period to 360 days to make sure we store the performance statistic information for analyzing later. Recently, we have an requirement to plan for standby…
user1595858
  • 3,700
  • 15
  • 66
  • 109
1
vote
2 answers

DBA_HIST_ACTIVE_SESS_HISTORY get sql by user and object schema

Hi I am learning ASH and AWR tables but any ideas as to how i can get list of sql, objects and schema owner accessed by a give user in last 30 days ? Basically get all SQL text, and then search within this SQL to see if a given object (table,…
user2755905
  • 21
  • 1
  • 1
  • 3
1
vote
0 answers

DBA_HIST_SNAPSHOT vs. DBA_HIST_ACTIVE_SESS_HISTORY retention period

On an 11.2.0.3.0 instance the AWR retention period is 8 days. Data in DBA_HIST_ACTIVE_SESS_HISTORY starts from 2014-04-30 but the corresponding SNAP_ID is not available in DBA_HIST_SNAPSHOT. DBA_HIST_SNAPSHOT only has data starting from…
user3560812
  • 55
  • 2
  • 7
1
vote
1 answer

How to find logical reads per second in oracle database

I want to fetch the logical reads per second directly from database table. I want the same value as shown in AWR report. Seems like dba_hist_seg_stat table has logical read count, but I still can't relate it to time. Can anyone please let me know…
pseudocode
  • 341
  • 1
  • 6
  • 15
1
vote
0 answers

Java KeyListener in Ubuntu VM firing all Events at ones

I got a problem with my java program, working in a ubuntu virtual machine, using vmware fusion on macosx mountain lion. in my java program i implemented a keylistener, for control a car with W A S D by remote. The problem with it is, that it fires…
tellob
  • 1,220
  • 3
  • 16
  • 32
1
vote
1 answer

ruby oci8 generate oracle AWR report

Thanks for your time! I want to use ruby oci8 to connect to oracle database to generate AWR report. When I do this through command line, the code is like this: sqlplus sys/a@10.69.152.97/load as sysdba SQL> define num_days = '' SQL> define…
mCY
  • 2,731
  • 7
  • 25
  • 43
0
votes
0 answers

Oracle AWR text or html extraction to csv

I received an Oracle AWR Report, statistics fold under text and lst extensions. Is there a way I can read or parse these into a csv ? read them in Python? I asked for an another HTML extraction. Could you please share a snippet to read html AWR? I…
OumniaSdn
  • 1
0
votes
0 answers

ORACLE Flash Cache Hit % negative value in version 19C

I have an AWR report covering an issue of decreasing performance oracle 19C in the section of Instance Efficiency Percentages (Target 100%) I notice a negative value of Flash Cache Hit % comparing with other clients the normal value it is 100 or…
Ora_en
  • 25
  • 1
  • 7
0
votes
1 answer

AWR Report for execution of PL/SQL with multiple queries

How does a PLSQL script execute? Currently, I am confused with the AWR report analysis of a PLSQL script. I see two different SQLIDs, one for the PLSQL SQL script and another for a query executed by the PLSQL. Is it expected to have two different…
Ramesh Kumar
  • 1
0
votes
0 answers

Non responsive 2D scatter plot in Python 3.0.9

I'm trying to run a python code for an awr1642BOOST board to make a short range radar. since i dont have an dca1000 evm data capture board I'm trying to obtain the detected data points using the detObj dictionary of the provided python code. On…
Saad Hasan
  • 1
  • 1
0
votes
1 answer

oracle Unable to create AWR report

oracle version: 11.2.0.1.0 When I try to generate an AWR Report in Oracle use sysdba, exec dbms_workload_repository.create_snapshot(); I keep getting this error: ORA-00600: [kewrose_1], [600], [ORA-00600: [13013], [5001], [6213], [8465936], [5],…
benq
  • 1
  • 1
0
votes
1 answer

Oracle AWR units of db time per sec (WORKLOAD REPOSITORY COMPARE PERIOD REPORT)

I'm getting WORKLOAD REPOSITORY COMPARE PERIOD REPORT that says Load Profile 1st per sec DB time: 1.3 I'm confused, Db time should be in time units, doesn't it? BELOW are context and history of what's I've researched about AWRs and how I…
Alex Martian
  • 3,423
  • 7
  • 36
  • 71
0
votes
2 answers

Oracle AWR Report file can not be written to the disk (using Oracle Database Server Docker Image)

I am trying to generate an AWR report in Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production (using Oracle Database Server Docker Image). I am connected to the DB as sysdba. In sqlplus I run:…
Jack
  • 19
  • 4
0
votes
1 answer

Create sequence of sqlplus commands in Java

How can I create a Java code to connect to SQLPlus and execute a sequence of commands? I need to execute the commands below to generate a Oracle AWR. //Connect to DB thru SQLPlus sqlplus…
acg
  • 503
  • 3
  • 11
  • 27
1
2
3