OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Datafile Size (Solaris , 9i R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Datafile Size [message #308455]

Mon, 24 March 2008 07:10

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Missing of data
Next Topic:	Taking datafile offline instead of the tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:41:40 CST 2024