Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REDO LOG and ARCHIVE LOG size

user13026028Apr 22 2010 — edited Apr 22 2010
Please take this as very theoretical question, there is no actual server in place yet ...

I have mid-size solaris 10 server with Oracle 10.2, the main tablespace (or better say few tablespaces) will have 3TB. This will be data warehouse server (smaller instance with maybe 20-30 users), and daily loads which will not exceed 50GB (50gb is really overstated number). There will be archive log with daily backups.

1. What is the rule of thumb as a decent size initial REDO and ARCHIVE LOG size? I know there is no way to give me exact number, I am talking high level ballpark here.


2. We will have 6 SAN filesystems attached to the server, would you recommend to use one for data, one for archive log and 2 for redo or would you rather use all 6 evenly for all data files (redo, archive, data, index, temp, ...).

Comments

djz

lb diff -url host2:1521:my.service.de -user username -pass "xxxxxxxxxxxxxxx"
does the trick ( colon instead of slash ), would it be gettint now the error
class oracle.jdbc.driver.T4CConnection cannot be cast to class liquibase.database.jvm.JdbcConnection

djz

Perhaps notewothy: I am using GraalVM

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 20 2010
Added on Apr 22 2010
#database-installation
2 comments
1,559 views