select * from v$sgainfo;
desc v$sgainfo;
select name, bytes/1024/1024 as Mbyte
from v$sgainfo;
show parameter sga_target;
show parameter log_buffer;
desc x$ksmfsv
col ksmfsnam for a20
col ksmfstyp for a20
select ksmfsnam, ksmfstyp, ksmfssiz, ksmfsadr
from x$ksmfsv
where ksmfsnam LIKE 'kcrf%';
select * from hr.employees;
col sql for a60
SELECT SUBSTR(sql_text, 1, 60) sql,
count(*) copies
FROM v$sqlarea
GROUP BY substr(sql_text, 1, 60)
HAVING count(*) > 3
ORDER BY count(*)
;
col name for a20
SELECT * FROM v$sysstat
WHERE name like 'parse count%';
show parameter DB_BLOCK_LRU_LATCHES
show parameter DB_BLOCK_HASH_BUCKET
S
select *
from v$latchname
where latch# IN (1,2,3);
col name for a30
select * from v$latchname
where latch# < 10;
column name format a30
select name, gets, misses, wait_time from v$latch
where name like '%redo%';
create tablespace para
datafile '/u01/app/oracle/oradata/orcl/para.dbf' size 10M;
create user para identified by para account unlock;
grant connect,resource to para;
conn sys/oracle@orcl as sysdba
create table para.sales
tablespce para
as
select * from sh.sales
;