Home » RDBMS Server » Server Administration » size
size [message #339357] Thu, 07 August 2008 06:14 Go to next message
acronis.84
Messages: 9
Registered: July 2008
Junior Member
Hi i am newbie to oracle. In lab scenarios we use small database and small tablespace,shared pool, buffer pool. However in real time scenario what will be the approximate size of database, tables and other memory structures.......
Re: size [message #339360 is a reply to message #339357] Thu, 07 August 2008 06:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
what will be the approximate size of database,

I work with databases from 2GB to 10TB.

Regards
Michel
Re: size [message #339361 is a reply to message #339360] Thu, 07 August 2008 06:25 Go to previous messageGo to next message
acronis.84
Messages: 9
Registered: July 2008
Junior Member
Then how long will it take to take a full backup of 2gb database and what will be the size of tables. Thanks a lot for your immediate reply
Re: size [message #339362 is a reply to message #339361] Thu, 07 August 2008 06:30 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends on the disk speed, the network speed, the backup medium, the actual mode of the backup (cold backup, RMAN backup, etc .....)

One one of our machines a OS level flashcopy cold backup of a 300 GB database takes about a minute, the same backup we did of basically the same database on a development system with a normal copy over the network did take 5 hours.
Re: size [message #339364 is a reply to message #339362] Thu, 07 August 2008 06:33 Go to previous messageGo to next message
acronis.84
Messages: 9
Registered: July 2008
Junior Member
Thanks a lot. Is user managed backups better or rman. Does Rman has any disadvantages compared to user managed backups....
Re: size [message #339366 is a reply to message #339364] Thu, 07 August 2008 06:38 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
it's all in the Concept Guide
Re: size [message #339372 is a reply to message #339366] Thu, 07 August 2008 06:50 Go to previous message
acronis.84
Messages: 9
Registered: July 2008
Junior Member
THANK YOU
Previous Topic: DBMS
Next Topic: PGA_TARGET
Goto Forum:
  


Current Time: Thu Nov 07 17:37:48 CST 2024