Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Within the first afternoon I found 2 of the 3 needed solutions, and the 3rd came to me over the weekend!..."

Geography

Where in the world do Tek-Tips members come from?
bcbcheng (Programmer)
31 May 00 21:17
When I did some bulk insert SQL statement, sometimes later the Oracle server is hang, and the following message appear on the console:

Warning - The following error occured during ORACLE redo log archival :
Oracle Instance hhcl - Can not allocate log, archival required.
Press to acknowledge message.

I have started the auto archive, and the Oracle is running on the NT server. Could anyone tell me what is thge problem ?
carp (MIS)
1 Jun 00 0:54
I believe what is happening is that during your bulk load, LGWR is writing redo information faster than ARCH can copy the redo log files.  This message is not so dire as it appears.  If you are going to be doing this often, you probably should (a) increase the number of redo log groups, (b) increase the size of your redo log files, or (c) both.

Issue the command ARCHIVE LOG LIST to verify that you are indeed archiving.
bcbcheng (Programmer)
1 Jun 00 11:44
I am new to Oracle, and have very limited concept on it.
I have created 2 Rollback Segnment for my Oracle DB, and each of the segment is associated with individual tablespace.
After that, I observed that these tablespace grows and increase in size every day.

My questions is :
1. Is it possible that as times go by, the tablespace will grow up until it reach the file system limited.
2. Should I limit the size of the tablespaces for Rollback Segment ?
carp (MIS)
1 Jun 00 15:11
By "associated with individual tablespace", I assume you mean each rollback segment is stored in a separate tablespace.  Normally, you would create a separate tablespace and put all of your rollback segments in that tablespace.  
Tablespace size is dictated by the size of the datafiles assigned to the tablespaces.  If the tablespace is growing, it is because you have autoextend turned on for one or more of the datafiles.  If growth is required, the files will keep increasing in size until (a) no more growth is required, (b) the maximum supported file size is reached,  or (c) your drive space is depleted.

You can either limit the size of the rollback segments or the tablespaces if you desire.  However, if more space is required for your data, you will have to accomodate that need somehow!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close