select
cr_requests, -- CR_REQUESTS NUMBER
current_requests, -- CURRENT_REQUESTS NUMBER
data_requests, -- DATA_REQUESTS NUMBER
undo_requests, -- UNDO_REQUESTS NUMBER
tx_requests, -- TX_REQUESTS NUMBER
current_results, -- CURRENT_RESULTS NUMBER
private_results, -- PRIVATE_RESULTS NUMBER
zero_results, -- ZERO_RESULTS NUMBER
disk_read_results, -- DISK_READ_RESULTS NUMBER
fail_results, -- FAIL_RESULTS NUMBER
fairness_down_converts, -- FAIRNESS_DOWN_CONVERTS NUMBER
fairness_clears, -- FAIRNESS_CLEARS NUMBER
free_lock_elements, -- FREE_LOCK_ELEMENTS NUMBER
flushes, -- FLUSHES NUMBER
flushes_queued, -- FLUSHES_QUEUED NUMBER
flush_queue_full, -- FLUSH_QUEUE_FULL NUMBER
flush_max_time, -- FLUSH_MAX_TIME NUMBER
light_works, -- LIGHT_WORKS NUMBER
errors -- ERRORS NUMBER
from
gv$bsp
where
inst_id = USERENV('Instance')