1/* 2** Zabbix 3** Copyright (C) 2001-2021 Zabbix SIA 4** 5** This program is free software; you can redistribute it and/or modify 6** it under the terms of the GNU General Public License as published by 7** the Free Software Foundation; either version 2 of the License, or 8** (at your option) any later version. 9** 10** This program is distributed in the hope that it will be useful, 11** but WITHOUT ANY WARRANTY; without even the implied warranty of 12** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13** GNU General Public License for more details. 14** 15** You should have received a copy of the GNU General Public License 16** along with this program; if not, write to the Free Software 17** Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. 18**/ 19 20package oracle 21 22import ( 23 "context" 24 25 "zabbix.com/pkg/zbxerr" 26) 27 28func sysParamsHandler(ctx context.Context, conn OraClient, params map[string]string, _ ...string) (interface{}, error) { 29 var sysparams string 30 31 row, err := conn.QueryRow(ctx, ` 32 SELECT 33 JSON_OBJECTAGG(v.NAME VALUE v.VALUE) 34 FROM 35 V$SYSTEM_PARAMETER v 36 WHERE 37 NAME IN ('sessions', 'processes', 'db_files') 38 `) 39 if err != nil { 40 return nil, zbxerr.ErrorCannotFetchData.Wrap(err) 41 } 42 43 err = row.Scan(&sysparams) 44 if err != nil { 45 return nil, zbxerr.ErrorCannotFetchData.Wrap(err) 46 } 47 48 return sysparams, nil 49} 50