Re: Re[2]: SAP R3 and Locally Managed Tablespaces

Doug,

Here is my favorite "We're a 3rd Party Product, and We Won't Support You" story:

I was supporting a fairly large Siebel Call Center database at my previous employer. There is a process called Territory Assignment that basically works its way through your company's list of contacts, and assigns them to a sales rep for your company's defined sales regions. We had over 2 million to assign. Basically, there are flags set, and fields updated in batch. The problem was it was taking days, no weeks. The base table for contacts had 32 indexes on it! This was a first for me and my boss, and my boss' boss. We suggested that we drop the indexes, run the assignment, then recreate the indexes. Siebel had a hissy-fit, and threatened to end our support. They then agreed to send in a team of "experts" to look at the situation (for a nice fee, of course). They found nothing wrong with our configuration, set-up, platform, etc. Their answer? Let's run this during times of low database use. I'm still laughing...I guess times of low use can span weeks in a large corporation!

Jim

> Jim,
>
> I don't know about the others on the list, but I for one appreciate
hearing
> about personal experiences of others with these crappy packaged packages.
$
> years ago we decided against SAP mostly due to the experiences of a local
firm
> that had decided to implement it. At the time they were 2 months into the
> implementation when the German consultants "had enough" with their local
IT
> folks, took the install disks/manuals, etc... & went home. Sounded like a
bunch
> of control-freaks. That was further added to by a friend at the NOUG who
added
> a tablespace to the database for index re-organization only to have the
SAP
> software throw a hissy fit & drop the tablespace! Not sure what version
of SAP
> that was, but WOW!! Anyway we're on PeopleSoft right now & although they
do not
> support LMT's they don't care either.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Jim Hawkins" <jhawkins_at_primary.net>
> Date: 7/6/2001 12:09 PM
>
> Jared,
>
> I can't say that I have used LMT's with our SAP installation, however, I
> constantly modify storage parameters, and I really don't see a difference.
> That being said, I know how much of a control-freak SAP is. The problem
is
> that SAP puts tables/indexes in certain tablespaces based on
functionality.
> For example, the BTABD tablespace contains all transaction, heavy I/O
> tables, while the STABD tablespace contains all master data and
transparent
> tables, etc. So if you organize LMT's based on size/storage
> characteristics, you would have to have multiple BTABD, STABD, etc.
> tablespaces. That would be the only thing I can see SAP being nervous
> about. In order to do table reorgs, I do this in the sense that I have a
> BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if
you
> already knew all this, but maybe others would benefit.
>
> Jim
>
> >
> > In working with our SAP consultant, I've discovered that SAP may not
> > yet support the use of LMT's on Oracle. Yes I know that SAP should
> > not really care about this, but SAP seems to care about a number of
> > things that would be best left to the DBA.
> >
> > Does anyone have experience with SAP and LMT's?
> >
> > TIA
> >
> > Jared
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.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).
> >
> >
>
>
> --
> Jim Hawkins
> Lead SAPR/3 Oracle Database Administrator
> MEMC Electronic Materials, Inc.
> 600 Pearl Drive
> St. Louis, MO 633376
> 9636) 474-7832
> jhawkins_at_memc.com (work)
> jhawkins_at_primary.net (home)
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jim Hawkins
> INET: jhawkins_at_primary.net
>
> 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:
> INET: dgoulet_at_vicr.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).
>
>

-- 
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
St. Louis, MO  633376
9636) 474-7832
jhawkins_at_memc.com (work)
jhawkins_at_primary.net (home)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jim Hawkins
  INET: jhawkins_at_primary.net

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