Re: Change parameter without restart db

You must check in V$PARAMETER if that parameter you want modified it's possible. In that view you have two columns ISSES_MODIFIABLE and ISSYS_MODIFIABLE, and they say toy you if you can modify that parameter to session or system level. If both are false only it's possible modifing

Re: Automatic database start in sun solaris

Saroj, you must create two files, SXXXOracle and KXXXOracle, in /etc/rc2.d, for example, where XXX are numbers. So when your machine reboots that files starts Oracle Database and listeners. Well, first, because second is to stop database and listener. This is a question of Unix start. Due to

Re: index status

In what view do you see that information?. - Mensaje original - De: orclbabu [EMAIL PROTECTED] Fecha: Miércoles, Agosto 8, 2001 7:09 pm Asunto: index status All What does index status = ' I have a bunch of Indexes that have a index_status of Babu -- Please see the official

List errors of Microsoft ODBC for Oracle

Hi folks. Anybody knows where can I get information about list of error codes of Microsoft ODBC for Oracle. We are working with Visual Basic 6.0 with Oracle8 and name of dinamic library is MSORCL32.DLL. Thank you very much in advance. Regards. Miguel Urosa.

Re: Table Fragmentation - Please Help - Urgent

SELECT SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024 Kbytes, EXTENTS FROM DBA_SEGMENTS / - Mensaje original - De: Viraj Luthra [EMAIL PROTECTED] Fecha: Miércoles, Agosto 8, 2001 11:21 am Asunto: Table Fragmentation - Please Help - Urgent Hello All,

Database in archivelog mode

Hi folks. I have a very strange behavour in a database. I want to put database inarchivelogmode, I've changed log_archive_start to true, log_archive_dest_1 to a location where I can write and log_archive_start to true. Then I follow next sequence:

Database in archivelog mode THANX

I've got solution from 1062786.6 note of Metalink. Thank you very much to all who reply to me. Best regards. Miguel Urosa. Este mensaje y los documentos que, en su caso, lleve anexos, pueden contener

Latchs

Hi folks. I'd like to know about different latchs, wait events and locks. Meaning of willing to wait and immediate ratio and all anothers things in relation with that. Anybody knows about documents, books, notes in Metalink, etc about that?. Thank you very

RE: Oracle 8i database ER diagram

What about to use Oracle Designer?. Regards. Miguel Urosa. 12/06/2001 11.00 magesh [EMAIL PROTECTED] 12/06/2001 11.01 Por favor, responda a [EMAIL PROTECTED]

GV$ views

Hi folks. We have installed four OPS on a Solaris 2.6 cluster. In one of that instances we have problems with GV$ views because it returns same results than V$ views. Anybody knows what nappens?. We have Oracle 8.1.6.3 over Solaris 2.6 and all instances are working well.

Re: GV$ views

08/06/2001 13.16 Stephane Faroult [EMAIL PROTECTED] 08/06/2001 13.11 Por favor, responda a [EMAIL PROTECTED]

Re: SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Thank you very much, Ruth, but it doesn't our problem. We have same tnsnames in our server and client machines. Best regards. Miguel. 01/06/2001 20.51 Ruth Gramolini [EMAIL PROTECTED] 01/06/2001 20.06

RE: Database writer

You can see that at operating system level using next sentence: ps -ef | grep dbwr 04/06/2001 17.55 Kevin Kostyszyn [EMAIL PROTECTED] 04/06/2001 18.10 Por favor, responda a [EMAIL

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Hi folks, again. I was subscribed two years ago and I'm stay here again. I'm facing to a curious problem with Oracle 8.1.6.3 over Solaris 2.6. When I connect to sqlplus via tnsnames.ora I'm getting following errors: SQL*Plus: Release 8.1.6.0.0 - Production on Fri Jun 1 10:08:58 2001