Home » RDBMS Server » Server Administration » Why size od sysaux datafile is limited to 16383MB (10.2.0.3.0 on linux 64 bit)
Why size od sysaux datafile is limited to 16383MB [message #358290] Mon, 10 November 2008 10:04 Go to next message
MIFI
Messages: 256
Registered: February 2008
Location: U.K.
Senior Member
Hi,

I want to find out that why size of sysaux table space is limited to 16383MB as shown in Enterprose manager, i am using 64 bit linux

sysaux tablespace

File Size (KB) 716800
AutoExtend Yes
Increment 10240KB
Maximum File Size 16383MB
Maximum File Size 16383MB

Report message to a moderator

Re: Why size od sysaux datafile is limited to 16383MB [message #358304 is a reply to message #358290] Mon, 10 November 2008 11:17 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Durely it is because it is the maximum size you can have with your block size which seems to be 4K.
4K block size * 4M blocks = 16G

Regards
Michel

[Updated on: Mon, 10 November 2008 11:20]

Report message to a moderator

Previous Topic: Monitor during statistics
Next Topic: Undo retention value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 18:34:23 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.