Révision 99e235ce
Fix to remove ${sqlplus_opts} to supress shellcheck warnings
| plugins/oracle/oracle_sysstat_ | ||
|---|---|---|
| 464 | 464 |
# End of Graph Settings |
| 465 | 465 |
|
| 466 | 466 |
# sqlplus options |
| 467 |
: ${sqlplus:=sqlplus}
|
|
| 468 |
: ${sqlplus_opts:=-S -L}
|
|
| 467 |
: "${sqlplus:=sqlplus -S -L}"
|
|
| 469 | 468 |
sqlplus_variables=" |
| 470 | 469 |
set pagesize 0 |
| 471 | 470 |
set feed off |
| ... | ... | |
| 531 | 530 |
[ -z "$field" ] && continue |
| 532 | 531 |
label="${t[3]}"
|
| 533 | 532 |
|
| 534 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 533 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 535 | 534 |
${sqlplus_variables}
|
| 536 | 535 |
VAR vf VARCHAR2(64) |
| 537 | 536 |
VAR vl VARCHAR2(64) |
| ... | ... | |
| 556 | 555 |
[ -z "$field" ] && continue |
| 557 | 556 |
label="${t[3]}"
|
| 558 | 557 |
|
| 559 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 558 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 560 | 559 |
${sqlplus_variables}
|
| 561 | 560 |
VAR vf VARCHAR2(64) |
| 562 | 561 |
VAR vl VARCHAR2(64) |
| ... | ... | |
| 581 | 580 |
[ -z "$field" ] && continue |
| 582 | 581 |
label="${t[3]}"
|
| 583 | 582 |
|
| 584 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 583 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 585 | 584 |
${sqlplus_variables}
|
| 586 | 585 |
VAR vf VARCHAR2(64) |
| 587 | 586 |
VAR vl VARCHAR2(64) |
| ... | ... | |
| 598 | 597 |
} |
| 599 | 598 |
|
| 600 | 599 |
getvalue_cachehit() {
|
| 601 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 600 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 602 | 601 |
${sqlplus_variables}
|
| 603 | 602 |
SELECT |
| 604 | 603 |
'buf_hitratio.value ' || ROUND( ( 1 - a.value / ( b.value + c.value ) ) * 100 ) |
| ... | ... | |
| 623 | 622 |
} |
| 624 | 623 |
|
| 625 | 624 |
getfield_sessionuser() {
|
| 626 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 625 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 627 | 626 |
${sqlplus_variables}
|
| 628 | 627 |
SELECT |
| 629 | 628 |
REGEXP_REPLACE( username, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || |
| ... | ... | |
| 639 | 638 |
} |
| 640 | 639 |
|
| 641 | 640 |
getvalue_sessionuser() {
|
| 642 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 641 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 643 | 642 |
${sqlplus_variables}
|
| 644 | 643 |
SELECT |
| 645 | 644 |
REGEXP_REPLACE( du.username, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || '.value ' || |
| ... | ... | |
| 661 | 660 |
} |
| 662 | 661 |
|
| 663 | 662 |
getfield_sessionwait() {
|
| 664 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 663 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 665 | 664 |
${sqlplus_variables}
|
| 666 | 665 |
SELECT |
| 667 | 666 |
REGEXP_REPLACE( wait_class, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || |
| ... | ... | |
| 681 | 680 |
} |
| 682 | 681 |
|
| 683 | 682 |
getvalue_sessionwait() {
|
| 684 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 683 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 685 | 684 |
${sqlplus_variables}
|
| 686 | 685 |
SELECT |
| 687 | 686 |
REGEXP_REPLACE( en.wait_class, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || '.value ' || |
| ... | ... | |
| 704 | 703 |
} |
| 705 | 704 |
|
| 706 | 705 |
getfield_eventwait() {
|
| 707 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 706 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 708 | 707 |
${sqlplus_variables}
|
| 709 | 708 |
SELECT |
| 710 | 709 |
REGEXP_REPLACE( wait_class, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || |
| ... | ... | |
| 723 | 722 |
} |
| 724 | 723 |
|
| 725 | 724 |
getvalue_eventwait() {
|
| 726 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 725 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 727 | 726 |
${sqlplus_variables}
|
| 728 | 727 |
SELECT |
| 729 | 728 |
REGEXP_REPLACE( en.wait_class, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || '.value ' || |
| ... | ... | |
| 749 | 748 |
getfield_eventwait2() {
|
| 750 | 749 |
local waitclass="$1" |
| 751 | 750 |
|
| 752 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 751 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 753 | 752 |
${sqlplus_variables}
|
| 754 | 753 |
VAR vl VARCHAR2(64) |
| 755 | 754 |
EXEC :vl := '${waitclass}'
|
| ... | ... | |
| 769 | 768 |
getvalue_eventwait2() {
|
| 770 | 769 |
local waitclass="$1" |
| 771 | 770 |
|
| 772 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 771 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 773 | 772 |
${sqlplus_variables}
|
| 774 | 773 |
VAR vl VARCHAR2(64) |
| 775 | 774 |
EXEC :vl := '${waitclass}'
|
| ... | ... | |
| 786 | 785 |
} |
| 787 | 786 |
|
| 788 | 787 |
getfield_tablespace() {
|
| 789 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 788 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 790 | 789 |
${sqlplus_variables}
|
| 791 | 790 |
SELECT |
| 792 | 791 |
REGEXP_REPLACE( tablespace_name, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || |
| ... | ... | |
| 800 | 799 |
} |
| 801 | 800 |
|
| 802 | 801 |
getvalue_tablespace() {
|
| 803 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 802 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 804 | 803 |
${sqlplus_variables}
|
| 805 | 804 |
SELECT |
| 806 | 805 |
REGEXP_REPLACE( tablespace_name, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || '.value ' || |
| ... | ... | |
| 828 | 827 |
} |
| 829 | 828 |
|
| 830 | 829 |
getfield_asmusage() {
|
| 831 |
data_attrs[$module]="$( ${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 830 |
data_attrs[$module]="$( ${sqlplus} "${oracle_auth}" <<EOF
|
|
| 832 | 831 |
${sqlplus_variables}
|
| 833 | 832 |
SELECT |
| 834 | 833 |
REGEXP_REPLACE( name, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || |
| ... | ... | |
| 842 | 841 |
} |
| 843 | 842 |
|
| 844 | 843 |
getvalue_asmusage() {
|
| 845 |
${sqlplus} ${sqlplus_opts} "${oracle_auth}" <<EOF
|
|
| 844 |
${sqlplus} "${oracle_auth}" <<EOF
|
|
| 846 | 845 |
${sqlplus_variables}
|
| 847 | 846 |
SELECT |
| 848 | 847 |
REGEXP_REPLACE( name, '^[^A-Za-z_]|[^A-Za-z0-9_]', '_' ) || '.value ' || |
Formats disponibles : Unified diff