Re: RE: 8.1.7 slow on AIX 4.3.3

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 18 Jan 2001 19:26:07 -0000
Message-Id: <10745.127058@fatcity.com>

Hi!

I agree with Gogala!

From 7.3.4 to 8i is an absolute

In 7.3.4 we did with 10-15M SGA
in 8i we had to 'maintain' minimum of 50M SGA (the shared_pool_size was increased
other things kept same)
to get 'back' 7.3.4 performance!!!!

I am very curious to know if
u r also moving from RULE based optimiser (in 7.3.4) to cost based optimiser (in 8.1.7)..

Please let me know how u 'finally' solved it Thanks
------------- Original Message -------------- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:"Gogala, Mladen" <MGogala_at_oxhp.com> Date:Thu, 18 Jan 2001 07:56:46 -0800
Subject:RE: 8.1.7 slow on AIX 4.3.3

See if you have oracle_trace parameter enabled.
Check your network setup.
See whether the machine is thrashing or not.
Enlist a good SA to help you out.

-----Original Message-----
Sent: Thursday, January 18, 2001 9:47 AM To: Multiple recipients of list ORACLE-L

I am currently testing an 8.1.7 database(enterprise edition) on AIX 4.3.3. It's really slow (it can take up to 15 seconds to connect) compared to the same 7.3.4.5 database. Do you have any ideas about what could be the cause of it ? Any new init parameter that I should have specified ? Any old init parameter that I should have modified ?

Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: Louis_Brouillette_at_uqtr.uquebec.ca
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Louis BROUILLETTE
INET: Louis_Brouillette_at_UQTR.UQuebec.CA

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Gogala, Mladen
INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

From: "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> Date: Thu, 18 Jan 2001 11:47:31 -0800
Subject: RE: Moving table to different tablespace

alter table <table_name> move tablespace <tablespace_name>;

Beware all indexes on the table will be marked as unusable and will need to be rebuilt. I don't belive it will work with tables that contain longs or long raws, but I haven't tested that assertion.

Ian

-----Original Message-----
From: Rahul Dandekar [mailto:orcldba_at_hotmail.com] Sent: Thursday, January 18, 2001 9:50 AM To: L; L
Subject: Moving table to different tablespace

Can I do it without export import?
Think there is a 8i feature or something?

Need to move replication table out of system tablespace. But don't want to do
export/import.....

Thanks

-Rahul

Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

From: Alex Hillman <alex_hillman_at_physia.com> Date: Thu, 18 Jan 2001 14:43:47 -0500
Subject: RE: A 50 MB System Tablespace !? Ruminations on System Tablespac

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C08186.F92ADD60
Content-Type: text/plain;

charset="iso-8859-1"

View definitions, stored procedures, packages, etc. are stored in the system tablespace so when one create them a lot it will require a lot of space and if they are dropped this space is not freed. Received on Thu Jan 18 2001 - 13:26:07 CST