Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Physical File Layout / Tablespace control
AcCeSsDeNiEd wrote:
> 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_"
Then be really lazy like I am. Use DBMS_JOB to execute a job once each week that uses the UTL_SMTP built-in package to send you an email telling you how things are progressing.
Daniel Morgan Received on Mon Dec 16 2002 - 23:07:34 CST