Oracle

Requirements

• Oracle Instant Client on the agent box.

• Oracle database with ORACLE_HOME configured to the correct directory for the root user.

• Oracle database user with both CONNECT and SELECT privileges on the required global views.

CREATE USER USERNAME IDENTIFIED BY "USER_PASSWORD";
GRANT CONNECT TO USERNAME;
GRANT SELECT ON GV_$PROCESS TO USERNAME;
GRANT SELECT ON gv_$sysmetric TO USERNAME;
GRANT SELECT ON sys.dba_data_files TO USERNAME;
GRANT SELECT ON sys.dba_tablespaces TO USERNAME;
GRANT SELECT ON sys.dba_tablespace_usage_metrics TO USERNAME;

Integration Installation

1. Install the Astradot Infra Agent on your server

2. Edit /etc/astradot-infra/integrations/oracle.toml

   #For every oracle instance to monitor, add an [[instance]] block
   [[instance]]
   server = "localhost:1521"
   user = "astradot"
   password = "password"
   timeout = 30
   service_name = "xe"

3. Restart astradot-infra agent

   service astradot-infra restart

Metrics

Metric	Description
In Use PGA memory	Indicates how much PGA memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).
Allocated PGA memory	Current amount of PGA memory allocated by the instance.
Freeable PGA memory	Number of bytes of PGA memory in all processes that could be freed back to the operating system.
Max PGA size	Maximum size of a work area executed in automatic mode. Extended: yes
Memory buffer cache hit ratio	Buffer cache hit ratio. Extended: yes.
Cursor cache hit ratio	Cursor cache hit ratio.
Library cursor cache hit ratio	Library cache hit ratio
Shared pool free percentage	Shared pool free percentage.
Physical reads per second	Physical reads direct per second. Extended: yes.
Physical writes per seconds	Physical writes direct per second. Extended: yes.
Enqueue timeouts per sec	Enqueue timeouts per second.
GC CR block received per second.	GC CR block received per second.
Sys Bytes	Total size of the virtual address space reserved by the Go runtime
Malloc Count	Cumulative count of heap objects allocated
Free Count	Cumulative count of heap objects freed
Total GC pause ns	Cumulative nanoseconds in GC stop-the-world pauses since Consul started
Global cache blocks corrupted.	Global cache blocks corrupted.
Global cache blocks lost	Global cache blocks lost
Logons per second.	Logons per second.
Average active sessions	Average active sessions. Extended: yes.
Table scans per second	Long table scans per second.
SQL service response time	SQL service response time.
User rollbacks per second	User rollbacks per second.
Sorts per user call	Total sorts per user call.
Rows per sort	Rows per sort.
Sort per sec	Disk sort per second.
Mem sort ratio	Memory sorts ratio.
DB wait time ratio	Database wait time ratio.
Session limit percentage	Session limit percentage.
Session count	Session count. Extended: yes.
Temp space used	Temp space used.
Tablespace used	Tablespace used
Tablespace size	Tablespace size
Tablespace InUse	Tablespace InUse
Tablespace offline	Number if offline tablespace