| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Test
Just testing,
Disregards.
Larry
From: "kang wen wong" <kangwen_at_mailcity.com>
Date: Thu, 18 May 2000 18:43:42 -0700
Subject: Re: Two (newbie) questions
Eric,
Q1: I think u were using direct path, use conventional path may avoid it or set env parameter NLS_LANG to AMERICAN_AMERICA.US7ASCII etc
-- On Wed, 17 May 2000 20:22:00 Eric Fang wrote:Received on Thu May 18 2000 - 20:35:55 CDT
>I just installed oracle8.1.5 on Sun Solaris. I loaded
>9m rows in a table. When I tried to do an export, I
>got the dollowing error:
>EXP-00041: Export done in server's WE8ISO8859P1,
>different from user's character set US7ASCII.
>
>Q: How can I set the character set to WE8ISO8859P1 on
>the unix box?
>
>Also I accidently drop a datafile for one of the
>rollback segment(I want to resize the rbs):
>I drop the rollback segment,tablespace(forgot to
>delete the o/s file), then when I created the
>tablespace, I got the error of the file already
>existed. Then I deleted the o/s file, tried to create
>ts again, I got the error of TS already existed but
>the datafile cannot found.
>
>Q: the database in in noarchive log mode, how can I
>drop the tablespace(which doesn't have datafile), I am
>still able to use the database though and the database
>is just created but I don't want to load the 9m rows
>again.
>
>Thanks in advace.
>
>Eric Fang
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Eric Fang
> INET: eric_fang_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get your FREE Email at http://mailcity.lycos.com Get your PERSONALIZED START PAGE at http://my.lycos.com ------------------------------ From: LBhat_at_LEVI.com Date: Thu, 18 May 2000 18:55:57 -0700 Subject: RE: Transactions waiting for Lock on Rollback Segments Cut-Paste from Orace 7 Server Tuning Manual. ------------------------------------------------------------------- <<To reduce contention for the free lists of a table, re-create the table with a larger value for the FREELISTS storage parameter. Increasing the value of this parameter to the number of Oracle processes that concurrently insert data into the table may benefit performance for the INSERT statements>> wrt to your problem, I would advice to check the following 1. Increase total no. of rollback segments upto 50 (not more than that, oracle advice) 2. Increase transactions_per_rollback_segments parameter. You may be able to balance between (1) and (2). 3. Increase the freelists on the tables participating in the process to have sufficient no. of freelists for the no. of concurrent transactions. BTW, is there any overhead/drawback if the table is having more than enough freelists? List, your suggestions pls. Regards. -----Original Message----- From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com] Sent: Thursday, May 18, 2000 5:06 PM To: Multiple recipients of list ORACLE-L Subject: RE: Transactions waiting for Lock on Rollback Segments What ADVISABLE value , Heuristic for Calculation of the same ?
> -----Original Message-----
> From: LBhat_at_LEVI.com [SMTP:LBhat_at_LEVI.com]
> Sent: Wednesday, May 17, 2000 1:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Transactions waiting for Lock on Rollback Segments
>
> Freelists are meant to be created for the tables, hence you should
> not try to create it on rollback segments. Instead try to increase
> the freelists on the tables which participate in online transactions.
>
> Regards.
>
> Bhat
>
> -----Original Message-----
> Sent: Wednesday, May 17, 2000 2:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> Banking product Application - Bancs2000
>
> On Oracle 7.3.4.5.0 FREELISTS for ROLLBACK segments NOT allowed .
> Allowed only for Tables & indexes
>
> SQL> create public rollback segment bm1_temp_test1
> 2 tablespace tba_roll
> 3 storage (initial 512K next 512K maxextents 121 freelists 50);
> storage (initial 512K next 512K maxextents 121 freelists 50)
> *
> ERROR at line 3:
> ORA-02169: FREELISTS storage option not allowed
>
> ADVICE PLEASE
>
> -----Original Message-----
> From: Gogala, Mladen [SMTP:MGogala_at_oxhp.com]
 |
 |