[Oracle integration]: Oracle Observability Metrics enhancement

### Integration Name

Oracle [oracle]

### Dataset Name

_No response_

### Integration Version

1.30.0

### Agent Version

8.17.3

### OS Version and Architecture

RHEL 9.6 x64

### User Goal

We are requesting the ability to collect additional Oracle metrics that are not currently supported by the Elastic integration. These metrics include, and not limited to:

gv$instance
gv$database
gv$dataguard_stats
v$asm_diskgroup
sys.v_$asm_disk
v$database
v$sort_usage
v$session
v$parameter
v$sql
gv$session
gv$sql_monitor
dba_data_files
gv$parameter
dba_segments
v$archived_log
dba_users
sys.v_$TEMP_SPACE_HEADER
sys.v_$Temp_extent_pool
dba_temp_files
v$BACKUP
V$DATAFILE
dba_tablespaces
dba_segments
v$controlfile
dual
gv$spparameter
v$instance
gv$parameter
dba_tables
dba_indexes
dba_tablespaces
gv$resource
dba_2pc_pending
dba_2pc_neighbors
dba_objects
dba_registry
dba_hist_sqlstat
v$sqlarea
samples
plan_stats
elapsed_time_diffs
impacted_sql_ids
all_info
V$RMAN_BACKUP_JOB_DETAILS
dba_datapump_jobs
temp
GV$LOCK
dba_registry_sqlpatch
gv$resource_limit
dba_audit_session
dba_tab_statistics
dba_indexes
dba_jobs
dba_data_files

A table

### Existing Features

The current feature set does not extract the above metrics and does not provide a customisation to extract them.

### What did you see?

The above metrics are not present.

An Excel with the queries and the visibility provided is located in a comment in this ER #24839 (Direct link not provided as the source is a private repo).

### Anything else?

_No response_