Test the tablespace available space of LinuxLVM + RAW Devices

This article mainly verifies the maximum available space size of the lvm + raw device tablespace-1. Preparations before creating the tablespace, the size of devrawraw14 is 8 Mb [Oracle @ master ~] $ Ln-s

This article mainly verifies the maximum available space size of the lvm + raw device tablespace-1. Preparations before creating the tablespace, the/dev/raw/raw14 size is 8 M [Oracle @ master ~] $ Ln-s

This article mainly verifies the maximum available space size of the lvm + raw device tablespace.

-- 1. Prepare the tablespace before it is created. The size of/dev/raw/raw14 is 8 Mb.
[Oracle @ master ~] $ Ln-s/dev/raw/raw14/oracle/oradata/rawt/test01.dbf

-- 2. Create a tablespace
SQL> create tablespace test
Datafile '/oracle/oradata/rawt/test01.dbf' size 2 M
Autoextend on;

-- 3. Check the file size and insert data until the space is insufficient.
SQL> select bytes/1024/1024, maxbytes/1024/1024 from dba_data_files where file_id = 5;

BYTES/1024/1024 MAXBYTES/1024/1024
---------------------------------
2 32767.9844 -- when creating a tablespace, the maximum value is not specified, which is about 32 GB.

SQL>
SQL>
SQL>
SQL>
SQL> select count (*) from dba_objects;

COUNT (*)
----------
50032

SQL> create table t (id int, name varchar2 (20) tablespace test;

Table created.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;

49999 rows created.

SQL> commit;

Commit complete.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;

49999 rows created.

SQL> commit;

Commit complete.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;

49999 rows created.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;

49999 rows created.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;

49999 rows created.

SQL> insert into t select rownum, '000000' from dba_objects where rownum <1111111111;
Insert into t select rownum, '000000' from dba_objects where rownum <1111111111
*
ERROR at line 1:
ORA-01653: unable to extend table SYS. T by 128 in tablespace TEST

SQL> commit;

Commit complete.