Re: Physical File Layout / Tablespace control

From: Ginger Mall <bocgco_at_hongkong.com>
Date: Tue, 17 Dec 2002 13:26:50 +0800
Message-ID: <3dfeb407$1_at_shknews01>


He actually doesn't say you are lazy. He means you are looking for a time efficient way to solve the problem.
Anyway, it'll be your boss problem if he doesn't understand lots of effort is required to maintain Oracle.

"AcCeSsDeNiEd" <dillon_at_rm_accessdenied.darktech.org> wrote in message news:143tvukll1epv1mm61m9aaifc7mg6ga4ap_at_4ax.com...
> On Mon, 16 Dec 2002 18:22:07 -0800, DA Morgan <damorgan_at_exesolutions.com>
 wrote:
>
>
> >A tablespace can automatically grow but it can not automatically add
 another datafile.
> >
> >Your question reeks of lazyiness.
>
> Bah! I'm not a god damn DBA.
> I'm just an IT Exec. here and have my own duties.
> There's no DBA here and the company doesn't plan to hire one.
> I handle support, network admin, security, e-mail admin, development,
 vendor management and now DB
> management for 400+ people.
>
> I don't think I'm being "lazy".
> I'm just being more productive.
>
> >The only way to handle something such as you have described is to
> >create a tablespace large enough to handle the first year and then weekly
 or monthly monitor its
> >progress.
>
> Guess so.
> So I just add a new datafile to the tablespace when I find record
 retrival/insert slow?
>
>
> >And, in the future, please post to only a single usenet group. Thanks.
>
> Sorry my news server's crapping up.
> So I thought if it doesn't get posted to .misc then it get posted to the
 other one.
>
> .
>
> To e-mail me, remove "rm_"
Received on Tue Dec 17 2002 - 06:26:50 CET

Original text of this message