23 lines
503 B
SQL
23 lines
503 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
col sgares_parameter head PARAMETER for a30
|
|
col sgares_component head COMPONENT for a30
|
|
|
|
SELECT
|
|
component sgares_component
|
|
, oper_type
|
|
, oper_mode
|
|
, parameter sgares_parameter
|
|
, initial_size
|
|
, target_size
|
|
, final_size
|
|
, status
|
|
, start_time
|
|
, end_time
|
|
FROM
|
|
v$memory_resize_ops
|
|
ORDER BY
|
|
start_time
|
|
/
|