leandrolbs
felipeg muitíssimo obrigado pela atenção.
1º
GROUP# ROUND(BYTES/1024/1024,2)
1 50
3 50
2 50
2º
SQL> Show parameter sga
NAME TYPE VALUE
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 584M
sga_target big integer 584M
SQL>
3º
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
1 processes 34 38 300 300
2 sessions 37 42 335 335
3 enqueue_locks 19 41 4170 4170
4 enqueue_resources 19 19 1692 UNLIMITED
5 ges_procs 0 0 0 0
6 ges_ress 0 0 0 UNLIMITED
7 ges_locks 0 0 0 UNLIMITED
8 ges_cache_ress 0 0 0 UNLIMITED
9 ges_reg_msgs 0 0 0 UNLIMITED
10 ges_big_msgs 0 0 0 UNLIMITED
11 ges_rsv_msgs 0 0 0 0
12 gcs_resources 0 0 0 0
13 gcs_shadows 0 0 0 0
14 dml_locks 0 37 1472 UNLIMITED
15 temporary_table_locks 0 0 UNLIMITED UNLIMITED
16 transactions 1 10 368 UNLIMITED
17 branches 0 0 368 UNLIMITED
18 cmtcallbk 0 1 368 UNLIMITED
19 sort_segment_locks 0 1 UNLIMITED UNLIMITED
20 max_rollback_segments 17 17 368 65535
21 max_shared_servers 1 1 UNLIMITED UNLIMITED
22 parallel_max_servers 0 0 0 3600
Print do 3º select.
