oracle常用查看命令

select sum(bytes/1024/1024/1024) from dba_segments;   #注：查看表空间大小，除以3个1024后的大小为GB

du instance_name(实例名);  查看实际数据库大小

SQL> show parameter db_recover

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +RECOC1
db_recovery_file_dest_size big integer 10T

 

SQL> select sum(bytes/1024/1024/1024/1024) from dba_segments;

SUM(BYTES/1024/1024/1024/1024)
------------------------------
            1.66453058

SQL> 
SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           +RECOC1
Oldest online log sequence     40718
Next log sequence to archive   40722
Current log sequence           40722 
SQL> 
SQL> host
[oracle@dm02dbadm01 ~]$  
[oracle@dm02dbadm01 ~]$ exit
exit

SQL>  
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@dm02dbadm01 ~]$ exit
logout
[root@dm02dbadm01 RMAN]# 
[root@dm02dbadm01 RMAN]# su - grid
Last login: Wed Oct 26 13:26:37 CST 2022
Last login: Wed Oct 26 13:41:55 CST 2022 on pts/0
[grid@dm02dbadm01 ~]$ asmcmd 
ASMCMD> 
ASMCMD> lsdg
State    Type  Rebal  Sector  Logical_Sector  Block       AU   Total_MB    Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  HIGH  N         512             512   4096  4194304  242122752  199969776         36318412        54550454              0             Y  DATAC1/
MOUNTED  HIGH  N         512             512   4096  4194304   60566688   27841164          9085003         6252053              0             N  RECOC1/
ASMCMD> cd datac1
ASMCMD> ls
ASM/
CDB1DB1/
CWDB/
CWDBEXA/
Cluster-c1/
DB_UNKNOWN/
JQDB/
orapwasm
orapwasm_backup
ASMCMD> 
ASMCMD> du CWDB
Used_MB      Mirror_used_MB
2697028             8091084
ASMCMD> exit
[grid@dm02dbadm01 ~]$ exit

 

 

select * from v$recovery_file_dest;     #查看归档日志大小及使用情况

alter system set recovery_file_dest_size=50G #设置归档日志大小

 

select instance_name from v$database;   #查看实例名 

select cdb from v$database;  #查看是否开启cdb

select tablespace_name,file_name,table_id from dba_data_files order by file_id;  #查看数据库文件

select name from v$ datafile;   #查看数据文件

 

 

create table baseinfo(
id number(22) primary key,
name varchar(16),
sex varchar(8),
class varchar(8),
phone varchar(11),
int_date varchar(19)
);
执行commit;

//批量插入100条数据或更多
begin
for i in 1..2000000 loop
insert into baseinfo values(i,to_char(10000+i),'nan','erban',to_char(15500000000+i),to_char(sysdate,'yyyy-MM-dd HH24:mi:ss'));
end loop;
commit;
end;
/




CREATE TABLE employees (
    employee_id NUMBER,
    first_name VARCHAR2(50),
    last_name VARCHAR2(50),
    hire_date DATE
);
BEGIN
    FOR i IN 1..30000000 LOOP
        INSERT INTO employees (employee_id, first_name, last_name, hire_date)
        VALUES (i, 'Employee', 'Lastname', SYSDATE - TRUNC(DBMS_RANDOM.VALUE(1, 3650)));
    END LOOP;
    COMMIT;
END;