为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
[root@localhost ~]# su - dmdba
Last login: Wed Oct 18 08:12:51 CST 2023 on pts/1
Last failed login: Wed Oct 18 08:13:26 CST 2023 on pts/0
There was 1 failed login attempt since the last successful login.
[dmdba@localhost ~]$ source .bash_profile
[dmdba@localhost ~]$ disql sysdba:5237
password:
Server[LOCALHOST:5237]:mode is normal, state is open
login used time : 2.983(ms)
disql V8
SQL> select tablespace_name,file_name from dba_data_files;
LINEID tablespace_name file_name
---------- --------------- -----------------------------
1 fuwa /dmdb8/dmdata/fuwa/fuwa01.dbf
2 SYSTEM /dmdb8/dmdata/fuwa/SYSTEM.DBF
3 TEMP /dmdb8/dmdata/fuwa/TEMP.DBF
4 ROLL /dmdb8/dmdata/fuwa/ROLL.DBF
5 MAIN /dmdb8/dmdata/fuwa/MAIN.DBF
used time: 6.629(ms). Execute id is 700.
SQL> select count(*) from fuwa.test_insert;
LINEID COUNT(*)
---------- --------------------
1 1000000
used time: 0.479(ms). Execute id is 701.
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf to 2048;
2 /
3 ;
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 2048;
alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 2048;
[-2410]:Error in line: 1
Data file [/dmdb8/dmdata/fuwa/fuwa01.dbf] size is invalid.
used time: 0.315(ms). Execute id is 0.
SQL> alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 4096;
alter tablespace fuwa resize datafile '/dmdb8/dmdata/fuwa/fuwa01.dbf' to 4096;
[-2410]:Error in line: 1
Data file [/dmdb8/dmdata/fuwa/fuwa01.dbf] size is invalid.
used time: 0.305(ms). Execute id is 0.
SQL> SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name =FUWA;
SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name =FUWA;
[-2111]:Error in line: 1
Invalid column name [FUWA].
used time: 1.180(ms). Execute id is 0.
SQL> SELECT tablespace_name,file_name,bytes/1024 total_space,user_bytes/1024 user_space FROM dba_data_files where tablespace_name ='FUWA';
LINEID tablespace_name file_name total_space user_space
---------- --------------- ----------------------------- -------------------- --------------------
1 fuwa /dmdb8/dmdata/fuwa/fuwa01.dbf 131072 86528
used time: 10.170(ms). Execute id is 702.
SQL> SELECT tablespace_name,file_name,bytes/1024/1024 total_space,user_bytes/1024/1024 user_space FROM dba_data_files where tablespace_name ='FUWA';
LINEID tablespace_name file_name total_space user_space
---------- --------------- ----------------------------- -------------------- --------------------
1 fuwa /dmdb8/dmdata/fuwa/fuwa01.dbf 128 84
used time: 8.280(ms). Execute id is 703.
达梦数据库表空间的单个数据文件的最小与最大大小依赖于数据库初始化时页的大小,单个文件的最小值为页大小乘以4096,最大值为页大小乘以2147483647
select para_name,para_value from v$dm_ini where para_name = 'GLOBAL_PAGE_SIZE';