Re: Noarchivelog ==> archivelog

2003-10-28 Thread Zhai Jingmin
102400 bytes Redo Buffers 10502144 bytes Database mounted. SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-01126: database must be mounted EXCLUSIVE and not open for this operation Thanks Sami -- Please see the official ORACLE-L FA

Re: where can I find sample db creation script (9.2.0.1.0 installation)?

2003-10-08 Thread Zhai Jingmin
mail client: http://www.opera.com/m2/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhai Jingmin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- M

Re: Re: RE: SHMMAX setting on Sun 4800 box

2003-06-26 Thread Zhai Jingmin
4800? I doubt it), you'll want to turn on >>priority_paging in /etc/system to keep your sga from getting paged out >>in favor of filesystem buffers. >> >>Thanks, >>Matt >> >>-- >>Matthew Zito >>GridApp Systems >>Email: [EMAIL PROTECTED

Re: how to find folder size in unix

2003-06-26 Thread Zhai Jingmin
Best regards. Zhai Jingmin [EMAIL PROTECTED] 2003-06-26 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhai Jingmin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

SHMMAX setting on Sun 4800 box

2003-06-26 Thread Zhai Jingmin
racle's SGA may exceed 4G,can I set this parameter to 8G,10G? Any suggestion is appreciated. Thanks, Zhai Jingmin [EMAIL PROTECTED] 2003-06-26 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zhai Jingmin INET: [EMAIL PROTECTED] Fat City Network Services

Re: Session, connections, circuits

2003-06-16 Thread Zhai Jingmin
) 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). = = = = = = = = = = = = = = = = = = = = Best regards.

Re: Re: Undo Analyze Table

2003-06-16 Thread Zhai Jingmin
ote 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). > >. = = = = = = = = = = = = = =