oracle

type OracleQueryLogSchema struct {
	SqlId             string     `db:"SQL_ID"`
	SqlFulltext       *string    `db:"SQL_FULLTEXT"`
	ParsingSchemaName *string    `db:"PARSING_SCHEMA_NAME"`
	LastActiveTime    *time.Time `db:"LAST_ACTIVE_TIME"`
	IntervalStart     *time.Time `db:"INTERVAL_START"`
	Executions        *int64     `db:"EXECUTIONS"`
	ElapsedTime       *int64     `db:"ELAPSED_TIME"`
	CpuTime           *int64     `db:"CPU_TIME"`
	DiskReads         *int64     `db:"DISK_READS"`
	BufferGets        *int64     `db:"BUFFER_GETS"`
	RowsProcessed     *int64     `db:"ROWS_PROCESSED"`
	CommandType       *int64     `db:"COMMAND_TYPE"`
	Module            *string    `db:"MODULE"`
	Action            *string    `db:"ACTION"`
	OptimizerCost     *int64     `db:"OPTIMIZER_COST"`
	Fetches           *int64     `db:"FETCHES"`
	Sorts             *int64     `db:"SORTS"`
}

type OracleScrapper struct {
	// contains filtered or unexported fields
}

type OracleScrapperConf struct {
	dwhexecoracle.OracleConf

	// UseDiagnosticsPack enables use of AWR (Automatic Workload Repository) views
	// for query log collection. AWR is part of the Oracle Diagnostics Pack, which
	// requires a separate license for Oracle Database Enterprise Edition.
	// When false (default), query logs come from V$SQL (no additional license needed).
	// V$SQL provides in-memory cached SQL statements that age out under memory pressure.
	// When true, query logs come from DBA_HIST_SQLSTAT + DBA_HIST_SQLTEXT which
	// provides persistent AWR snapshots (typically hourly, retained for days/weeks).
	// Requires Diagnostics Pack license and SELECT ANY DICTIONARY or SELECT_CATALOG_ROLE grant.
	UseDiagnosticsPack bool
}