| 1 | // SPDX-License-Identifier: GPL-3.0-or-later |
| 2 | |
| 3 | package oracledb |
| 4 | |
| 5 | import ( |
| 6 | "context" |
| 7 | "database/sql" |
| 8 | "fmt" |
| 9 | "time" |
| 10 | ) |
| 11 | |
| 12 | const precision = 1000 |
| 13 | |
| 14 | func (c *Collector) collect() (map[string]int64, error) { |
| 15 | if c.db == nil { |
| 16 | if err := c.openConnection(); err != nil { |
| 17 | return nil, fmt.Errorf("failed to open connection: %v", err) |
| 18 | } |
| 19 | } |
| 20 | |
| 21 | mx := make(map[string]int64) |
| 22 | |
| 23 | // TODO: https://www.oracle.com/technical-resources/articles/schumacher-analysis.html |
| 24 | |
| 25 | if err := c.collectSysMetrics(mx); err != nil { |
| 26 | return nil, fmt.Errorf("failed to collect system metrics: %v", err) |
| 27 | } |
| 28 | if err := c.collectSysStat(mx); err != nil { |
| 29 | return nil, fmt.Errorf("failed to collect activities: %v", err) |
| 30 | } |
| 31 | if err := c.collectWaitClass(mx); err != nil { |
| 32 | return nil, fmt.Errorf("failed to collect wait time: %v", err) |
| 33 | } |
| 34 | if err := c.collectTablespace(mx); err != nil { |
| 35 | return nil, fmt.Errorf("failed to collect tablespace: %v", err) |
| 36 | } |
| 37 | |
| 38 | return mx, nil |
| 39 | } |
| 40 | |
| 41 | func (c *Collector) doQuery(query string, assign func(column, value string, lineEnd bool) error) error { |
| 42 | ctx, cancel := context.WithTimeout(context.Background(), c.Timeout.Duration()) |
| 43 | defer cancel() |
| 44 | |
| 45 | rows, err := c.db.QueryContext(ctx, query) |
| 46 | if err != nil { |
| 47 | return err |
| 48 | } |
| 49 | defer func() { _ = rows.Close() }() |
| 50 | |
| 51 | columns, err := rows.Columns() |
| 52 | if err != nil { |
| 53 | return err |
| 54 | } |
| 55 | |
| 56 | vs := makeValues(len(columns)) |
| 57 | |
| 58 | for rows.Next() { |
| 59 | if err := rows.Scan(vs...); err != nil { |
| 60 | return err |
| 61 | } |
| 62 | for i, l := 0, len(vs); i < l; i++ { |
| 63 | if err := assign(columns[i], valueToString(vs[i]), i == l-1); err != nil { |
| 64 | return err |
| 65 | } |
| 66 | } |
| 67 | } |
| 68 | |
| 69 | return rows.Err() |
| 70 | } |
| 71 | |
| 72 | func (c *Collector) openConnection() error { |
| 73 | db, err := sql.Open("oracle", c.DSN) |
| 74 | if err != nil { |
| 75 | return fmt.Errorf("error on sql open: %v", err) |
| 76 | } |
| 77 | |
| 78 | db.SetConnMaxLifetime(10 * time.Minute) |
| 79 | |
| 80 | ctx, cancel := context.WithTimeout(context.Background(), c.Timeout.Duration()) |
| 81 | defer cancel() |
| 82 | |
| 83 | if err := db.PingContext(ctx); err != nil { |
| 84 | _ = db.Close() |
| 85 | return fmt.Errorf("error on pinging: %v", err) |
| 86 | } |
| 87 | |
| 88 | c.db = db |
| 89 | |
| 90 | return nil |
| 91 | } |
| 92 | |
| 93 | func makeValues(size int) []any { |
| 94 | vs := make([]any, size) |
| 95 | for i := range vs { |
| 96 | vs[i] = &sql.NullString{} |
| 97 | } |
| 98 | return vs |
| 99 | } |
| 100 | |
| 101 | func valueToString(value any) string { |
| 102 | v, ok := value.(*sql.NullString) |
| 103 | if !ok || !v.Valid { |
| 104 | return "" |
| 105 | } |
| 106 | return v.String |
| 107 | } |