tmuth/awr-miner

A tool to mine and graph the AWR Repository of an Oracle 10.1+ database for performance data

awr-miner's Issues

Add OSSTAT plots

Including memory, free mem, cpu run queue, cpu wait, etc

<simpleError in perl("\nERROR at line .+\n"): could not find function "perl">

[1] INFO [2020-08-16 21:06:57] \n\n--------------------------------------------------\n
[1] INFO [2020-08-16 21:06:57] ** Starting AWR-Miner **
[1] INFO [2020-08-16 21:06:57] Looking in this directory:
[1] INFO [2020-08-16 21:06:57] /Users/naveen/OneDrive/Work/OUTFILES
[1] INFO [2020-08-16 21:06:57] for files that match the pattern: ^awr-hist*.*(\.out|\.gz)$
[1] INFO [2020-08-16 21:06:59] Files found (1): \nawr-hist-1288227953-ORCL-14815-14820.out
INFO [2020-08-16 21:07:00] Starting DB: ORCL
[1] INFO [2020-08-16 21:07:00] -
INFO [2020-08-16 21:07:00] dbname-dbid: ORCL-1288227953
[1] INFO [2020-08-16 21:07:00] dbname-dbid: ORCL-1288227953
[1] INFO [2020-08-16 21:07:00] awr-hist-1288227953-ORCL-14815-14820.out
[1] INFO [2020-08-16 21:07:00] File size (kb): 72
[1] INFO [2020-08-16 21:07:00] Number of sections: 17
6: order(SUMMARY_DF_TMP$aas, decreasing = TRUE) at R-AWR-Mining.R#4252
5: main$mainLoop() at R-AWR-Mining.R#4326
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("/OneDrive/Work/WorkArea/AWRMiner/AWR-Miner-master/release/5.0.8/R-AWR-Mining.R",
echo = TRUE)
<simpleError in perl("\nERROR at line .+\n"): could not find function "perl">
6: order(SUMMARY_DF_TMP$aas, decreasing = TRUE) at R-AWR-Mining.R#4252
5: main$mainLoop() at R-AWR-Mining.R#4326
4: eval(ei, envir)
3: eval(ei, envir)
2: withVisible(eval(ei, envir))
1: source("/OneDrive/Work/WorkArea/AWRMiner/AWR-Miner-master/release/5.0.8/R-AWR-Mining.R",
echo = TRUE)
Error in order(SUMMARY_DF_TMP$aas, decreasing = TRUE) :
argument 1 is not a vector
In addition: Warning message:
panel.margin is deprecated. Please use panel.spacing property instead

RStudio Version 1.3.1073

R version 4.0.2 (2020-06-22)

When sourcing R-AWR-Mining.R file, it prompts Error in order(SUMMARY_DF_TMP$aas, decreasing = TRUE) : argument 1 is not a vector

R version 4.3.1 (2023-06-16) -- "Beagle Scouts"
Copyright (C) 2023 The R Foundation for Statistical Computing
Platform: aarch64-apple-darwin20 (64-bit)

source("~/Documents/Learning/AWR/AWR-Miner/source/R-AWR-Mining.R")
Using checkpoint directory /Users/mliang/.checkpoint/2015-05-01/lib/aarch64-apple-darwin20/4.3.1
[1] INFO [2023-09-20 18:29:13] \n\n--------------------------------------------------\n
[1] INFO [2023-09-20 18:29:13] ** Starting AWR-Miner **
[1] INFO [2023-09-20 18:29:13] Looking in this directory:
[1] INFO [2023-09-20 18:29:13] /xxx/awr_out
[1] INFO [2023-09-20 18:29:13] for files that match the pattern: ^awr-hist*.*(\.out|\.gz)$
[1] INFO [2023-09-20 18:29:15] Files found (0): \n
Error in order(SUMMARY_DF_TMP$aas, decreasing = TRUE) :
argument 1 is not a vector

Document the combined-stat process

Paramaterize the combined stats code

Probably want an array of stats, loop over that array, then plot for each metric. Finally, do a combined dashboard plot.

Error on Last Version for Source Version

During the execution of R-AWR-Mining.R (Source Version), I had a error message !

"Error in order(SUMMARY_DF_TMP$aas, decreasing = TRUE) : argument 1 it´s not a vector."

I used Rstudio : Version 1.2.5033 and R version 3.6.3 (2020-02-29), both in Windows

Could you help me !
Thks,

Rubens Oliveira