Home » RDBMS Server » Server Administration » Datafile Size (Solaris , 9i R2)
Datafile Size [message #308455] Mon, 24 March 2008 07:10 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

I have one question...

I fired one query as below :-

sql> select bytes, maxbytes,autoextensible,tablespace_name from dba_data_files;

The result showing as:-
bytes=55296000
Maxbytes=24576000
Autoextensible=yes

As per the description of dba_data_files the
1. bytes column means: Size of the file in bytes
2. Maxbytes column means: Maximum file size in bytes


My question is why "The bytes is greater than Maxbytes?"

Pokhraj

[Updated on: Mon, 24 March 2008 07:33] by Moderator

Report message to a moderator

Re: Datafile Size [message #308466 is a reply to message #308455] Mon, 24 March 2008 07:42 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because MAXSIZE has been set to a limit lower than current size:
SQL> select bytes, maxbytes,autoextensible,tablespace_name from dba_data_files
  2  where tablespace_name='TS_D01';
     BYTES   MAXBYTES AUT TABLESPACE_NAME
---------- ---------- --- ------------------------------
1468006400 2147483648 YES TS_D01

1 row selected.

SQL> alter database datafile 'D:\ORACLE\BASES\MIKA\TS_D0101.DBF'
  2  autoextend on maxsize 1000000000;

Database altered.

SQL> select bytes, maxbytes,autoextensible,tablespace_name from dba_data_files
  2  where tablespace_name='TS_D01';
     BYTES   MAXBYTES AUT TABLESPACE_NAME
---------- ---------- --- ------------------------------
1468006400 1000005632 YES TS_D01

1 row selected.

Regards
Michel
Previous Topic: Missing of data
Next Topic: Taking datafile offline instead of the tablespace
Goto Forum:
  


Current Time: Tue Dec 06 11:52:40 CST 2016

Total time taken to generate the page: 0.05220 seconds