Stack Overflow
Stack Overflow

Questions tagged [awr]

42 questions
0
votes
1 answer

Opening a csv file from an API with python

So I am trying to download a file from and API which will be in csv format I generate a link with user inputs and store it in a variable exportLink import requests #getProjectName projectName = raw_input('ProjectName') #getApiToken apiToken =…
Harrada
  • 83
  • 2
  • 8
0
votes
1 answer

Listing strings from file using awr Linux Red Hat

I have a file "salida_test" containing (in repetitive way): Point ID 1.750251 Point Name >BRI_4L_SA2__INT Interruptor 33kV Parque Industrial < value 2 Time of last value update (ascii): >03/07/17 11:11:14.596 ART< TLQ …
carlos
  • 3
  • 1
0
votes
1 answer

Elapsed Time Interpretation in Oracle AWR Report

In my AWR (automated workload repository) report, I see the following Free Buffer Waits : 24,000 seconds I have a 4 CPU machine. Does this means there was 24,000/4 = 6,000 seconds of "clock time" or "real time" wait ?
oradbanj
  • 551
  • 7
  • 23
0
votes
1 answer

What does "rows processed" in Oracle AWR report mean?

I have an application which uses Oracle Database. I have several sql updates and selects in the application. I gathered an AWR report on Oracle Database to diagnose some performance charasteristics of my application. When I analyze the report by…
Ugur KAYA
  • 167
  • 3
  • 14
0
votes
2 answers

SQL's performance based on other query's performance executed at same time - AWR

In Oracle 10g, I have a SQL which executes reasonably faster(around 30-40 mins approx) today. When the same SQL was executed two days back, it took around 2.5 hours for the SQL to get completed. I thought the query's execution plan might have…
toddlermenot
  • 1,588
  • 2
  • 17
  • 33
0
votes
1 answer

oracle - Session execute a specified query

Today, someone in my system has updated unexpected statement. So that makes my system run incorrect. Now, I would like to see log who (or which session) did it. May I find it in AWR report ? And if I can find it in AWR report, where is it…
Leo Le
  • 815
  • 3
  • 13
  • 33
0
votes
2 answers

how to change JLabel color

i have problem to change JLabel color. i am using three JLabel variables . i am putting mouse event on this JLabel variables. i run the and both are changes color when i am entring mouse on JLabels. i whis is that, at the time one JLabel change the…
kusama
  • 389
  • 3
  • 13
0
votes
0 answers

Extract multiple binds at once

I just found i can use extract_binds to get binds-info from raw bind data (like the one in v$sql, dba_hist_sqlstat etc) select listagg(value_string, ',') within group (order by position) from …
trinity
  • 10,394
  • 15
  • 49
  • 67
0
votes
1 answer

How to get the start time and duration of the SQL-queries to the specified tables in the database (Oracle 10g)?

How to get the start time and duration of the SQL-queries to the specified tables in the database (Oracle 10g)? I need information even about very short queries, which can be many, and which AWR not shows.
Alex
  • 12,578
  • 15
  • 99
  • 195
0
votes
1 answer

Oracle10g AWR How to measure improvement after splitting tablespaces into multiple disk volumes?

I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re-writing many of the SQLs in the application for better performance we are also on a…
user1710196
-1
votes
2 answers

Oracle AWR to CSV converter?

Is there any converter available that help me convert all tables in my AWR report into CSV?
SachinJadhav
  • 291
  • 4
  • 11
-1
votes
2 answers

Get first two values from an array and run foreach

I've json data in the format shown below I'm trying to build urls using foreach for API that requires start and finish date as parameters. Here's the example of url ->…
shutupchigo
  • 703
  • 1
  • 7
  • 19
1 2
3