Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!193.141.40.65.MISMATCH!npeer.de.kpn-eurorings.net!npeer-ng0.de.kpn-eurorings.net!eweka.nl!lightspeed.eweka.nl!postnews.google.com!m20g2000vbp.googlegroups.com!not-for-mail
From: John Hurley <johnbhurley@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Do you use ASSM (Automatic Segment Space Management)?
Date: Sat, 8 Aug 2009 07:40:19 -0700 (PDT)
Organization: http://groups.google.com
Lines: 21
Message-ID: <4dc56d12-8b8c-4cf8-aeff-4badaae81c40@m20g2000vbp.googlegroups.com>
References: <2d23edca-320a-4ace-9c8e-d20a5fdaf4ec@y28g2000prd.googlegroups.com> 
 <f6378e1e-007d-4a27-8d08-7b702a7cfe34@a39g2000pre.googlegroups.com> 
 <6185984b-6119-4b58-8e43-8c019c3fefd2@2g2000prl.googlegroups.com> 
 <f57e0831-0b4f-4708-872e-9db2360053d2@d4g2000prc.googlegroups.com> 
 <465abce5-4332-4256-a45f-d5228e225d28@v20g2000yqm.googlegroups.com> 
 <52181ba5-306f-4d77-9c21-1e562ef117b0@v15g2000prn.googlegroups.com> 
 <689647c9-64a4-4d16-80af-da08aa6b1d29@c34g2000yqi.googlegroups.com> 
 <365a4a4f-c196-41ef-b8ba-f00b81b4a42d@y28g2000prd.googlegroups.com> 
 <2482e081-c247-4fcb-8708-88d388dd5be7@o13g2000vbl.googlegroups.com> 
 <2d24dd67-a2ef-49c2-88d0-63cb83e06843@d4g2000vbm.googlegroups.com>
NNTP-Posting-Host: 75.10.157.214
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1249742419 23138 127.0.0.1 (8 Aug 2009 14:40:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 8 Aug 2009 14:40:19 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m20g2000vbp.googlegroups.com; posting-host=75.10.157.214; 
 posting-account=_6ry2goAAAB8CmCVzS5u_8_rocyBncPn
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.2) 
 Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Aug 8, 9:57=A0am, dbaboy <jojojtho...@gmail.com> wrote:

snip

> > I tried your test case. =A0My system is an 11.1.0.7 Enterprise Edition
> > 64 bit system on OEL 5.2 64 bit. =A0It has 32 gig of RAM and a very nic=
e
> > IO subsystem. =A0Using ASM for storage.
>
> > My times to complete steps 4 and 6 ( yes from different sessions )
> > were the same basically ... not different times as you reported.
>
> There is a difference between ASM (automatic storage mgmt) and ASSM
> (automatica segment space mgmt). Are you also on ASSM ?

If you look at the test script that was supplied it included a create
tablespace statement.  That was the ASSM part ... already included
baked in as part of the test script.

I added the details about the system I ran the test script(s) for
completeness.  It uses ASM and EMC based storage.