22 lines
609 B
SQL
22 lines
609 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 cont_open_time HEAD OPEN_TIME FOR A35
|
|
|
|
SELECT
|
|
con_id
|
|
, dbid
|
|
-- , con_uid
|
|
-- , guid
|
|
, name
|
|
, open_mode
|
|
, restricted
|
|
, open_time cont_open_time
|
|
, create_scn
|
|
, total_size
|
|
, block_size
|
|
, recovery_status
|
|
, snapshot_parent_con_id
|
|
FROM v$containers;
|
|
|