For Q No. 1, this is the quickest method I have used
in the past (works only if you can afford shutting
down the database)
o Create controlfile trace
o Edit the trace file and change the RedoLog Path.
Save it as an SQL script
o Shutdown database
o Use svrmgrl, connect internal and run the script
- Deepak
- aheda_at_cdotd.ernet.in wrote:
>
> I am facin certain problems while tuning the
> performance of oracle .It
> would be of great help if somebody can give
> suggestions over:
> 1).how can we change the redolog files path on a
> running system.
> 2). If we are havinfg two datafiles under one
> tablespace how can we move
> one move certain tables to one file completely
>
>
>
> Arvind
>
>
>
> --
> Author:
> INET: aheda_at_cdotd.ernet.in
>
> 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).
Oracle DBA,
Minneapolis, MN
USA
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Sat Jul 08 2000 - 10:04:51 CDT
