tmuth / awr-miner Goto Github PK
View Code? Open in Web Editor NEWA tool to mine and graph the AWR Repository of an Oracle 10.1+ database for performance data
A tool to mine and graph the AWR Repository of an Oracle 10.1+ database for performance data
Including memory, free mem, cpu run queue, cpu wait, etc
[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",/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("
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)
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
Probably want an array of stats, loop over that array, then plot for each metric. Finally, do a combined dashboard plot.
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.