RE: Background jobs inUnix
Hi Suhen, I guess the flwng is the syntax: $ mknod -p /mydir/pipe_file 200m $ exp user/passwd file=pipe_file tables=abc correct me if I am wrong thanq srinvias -Original Message- Sent: Tuesday, October 02, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Srinivas, Try using nohup compress /u01/dmps/zvr_dd.dmp It should not be a problem to close your Unix session. I have not had any problems with the Unix compress utility on Oracle Dump files. You could also compress while you export using names pipes. Let me know if you want the syntax. Regards Suhen Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
find out ip
Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How much data can SQL*Server hold?
Title: How much data can SQL*Server hold? Lisa, It may be a little late for your needs but I am attending a meeting in London (Oct1 5th) about this very thing. Apparently (and I was blissfully unaware of this) we run a large-ish (about 70Gb) SQL*Server database for a major communications company and where costs prohibit the use of Oracle we may see this as a strategy for the future also, not sure about the parallel server side of things but I'm sure this will come up in the debate. I can let you know on my return what the general feeling was (if its not too late) but I would also be grateful to be included on any replies to your original question. Regards Lee -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 01 October 2001 16:50To: Multiple recipients of list ORACLE-LSubject: How much data can SQL*Server hold? Hello everyone, Any of you using SQL*Server on fairly large databases? If so please email me directly. I have a consulting company telling me they can run a 500GB+ database on SQL*Server with no problems and I'm pretty skeptical. What's the largest implementation of SQL*Server you've seen? Does SQL*Server have parallel server functionality? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Re: find out ip
$ who am i root pts/12 obre 2 09:11 (192.168.11.33) Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
optimizer function based indexes
hello i've update my database from 8.1.7 release 3 to 9iand now following statement don't use my optimizer hint in 9i (in 8i itworks)upper_artikel_kurztext_idx is an function based indexselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) LIKE '%WANN%'when i change the statement it works but i need above statementselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) LIKE 'WANN%' orselect /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikelwhere upper(kurztext) = 'WANN'the following parameters are set in init.oraQUERY_REWRITE_ENABLED=TRUEQUERY_REWRITE_INTEGRITY=TRUSTEDOPTIMIZER_MODE = CHOOSEdatabase is analyzed !any ideasthanx joe
Re: find out ip
Your IP address is 127.0.0.1 :-) JP Try ifconfig On Tue 2. October 2001 09:30, you wrote: Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: find out ip
Thanks a lot -Original Message- Sent: Tuesday, October 02, 2001 5:15 AM To: Multiple recipients of list ORACLE-L $ who am i root pts/12 obre 2 09:11 (192.168.11.33) Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How much data can SQL*Server hold?
Title: How much data can SQL*Server hold? Hi Lisa, About the biggest MSSQL implementation I am aware of is this: http://terraserver.homeadvisor.msn.com/terra_tech.asp 1.5 terabytes on SQL Server 2000, Windows 2000 Datacenter and Compaq ProLiant. There's even a picture of what it looks like! :0) g -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, October 01, 2001 4:50 PMTo: Multiple recipients of list ORACLE-LSubject: How much data can SQL*Server hold? Hello everyone, Any of you using SQL*Server on fairly large databases? If so please email me directly. I have a consulting company telling me they can run a 500GB+ database on SQL*Server with no problems and I'm pretty skeptical. What's the largest implementation of SQL*Server you've seen? Does SQL*Server have parallel server functionality? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117
RE: Comparing data between two tables in two schema
If its the actual data you could look at the minus, intersect operators etc eg select * from schema1.table minus select * from schema2.table give the data in schema1 not in schema 2. Iain Nicoll -Original Message- Sent: 02 October 2001 04:15 To: Multiple recipients of list ORACLE-L I think that the Change Management Pack of the Oracle Enterprise Manager may be useful to you. From: Rao, Maheswara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Comparing data between two tables in two schema Date: Mon, 01 Oct 2001 12:29:41 -0800 List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicoll, Iain (Calanais) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: please help me to unlock a table
Try this: Alter table table_name disable table lock; --- Ha Duy Thien [EMAIL PROTECTED] wrote: Hi all Does anyone know how to unlock a locked table? Thanks in advance Ha Duy Thien __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ha Duy Thien INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
BEGIN BACKUP MODE !!
Hello All, When you take begin back up of tablespace what exactly oracle does internally. what happen the transcation in that period. Please tell me . Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: ORA-03113 when executing the initjvm script
Thanks, christoffer, finally I have solved this and it works. The parameters set I have now, is the following: shared_pool_size 68157440 (size in bytes ) shared_pool_reserved_size 3407872 large_pool_size 614400 java_pool_size 5250 java_soft_sessionspace_limit 0 java_max_sessionspace_size 0 50 mb free in the system tablespace XXX in the rollback segment. I suppose that the rollback segment space is the following: SQL select sum(rssize-writes) from v$rollstat; SUM(RSSIZE-WRITES) -- 29326204 A lot of thanks all, Christopher Spence wrote: I notice this happens when you don't have enough rollback space. You may want to go through and check back and see what the original error was. You may want to increase your SP a little and decrease your JP a little. Although it is recommended to have SP: 20M JP: 30M for the install, 90M of rollback, and if I remember 130M of System Tablespace. Also, there is a bug on metadink regarding changing call to execute, seems to cause this problem as well. Forget the bug number. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 5:35 AM To: Multiple recipients of list ORACLE-L Hello all of you, I get the ORA-03113 (end-of-file on communication channel) error when I execute the initjvm script. This script is needed to use utl_smtp package. Here is the output I get: *** ERROR: ORA-03114: not connected to ORACLE create or replace java system; * ERROR en línea 1: ORA-03113: end-of-file on communication channel * The script is composed of several calls to another scripts, and is in the second one, the initjvm2.sql where the error appears. I have checked the trace and log files, but there isn´t any one that give me a clue on the problem. I have read something about checking some parameters, here is the output showing them: ** SQL select * from v$parameter 2 where name like '%pool_size%'; NUM NAME TYPE -- -- VALUE ISDEFAULT ISSES ISSYS_MOD ISMODIFIED ISADJ - - - -- - DESCRIPTION 23 shared_pool_size 2 19643392 FALSE FALSE FALSE FALSE FALSE size in bytes of shared pool 28 large_pool_size 2 614400 FALSE FALSE FALSE FALSE FALSE size in bytes of the large allocation pool 30 java_pool_size 2 5250 FALSE FALSE FALSE FALSE FALSE size in bytes of the Java pool * I think they are setting correctly... Has anyone faced this problem? TIA, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
RE: Hot Backup Issue
Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Problem in setting PCTFREE and PCTUSED
Hello ! After having defined all the tables, now I have to parametrize each table. I have some tables that every day must be deleted and reloaded through sql loader. I think to set PCTFREE = 0, but I don't know if I have to specify a particular value for PCTUSED. Anybody can give an advice about which value set PCTUSED ? Thanks in advance, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Searching across multiple columns
HELL of a reason to learn Perl!
Nice..
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0 }
);
die connect failed\n unless $dbh;
my $sql='select * from persons;'
my $sth = dbh-prepare($sql) || die
my $rv = $sth-execute || die error in execution\n;
while ( my $arrarRef = sth-fetchrow_arrayref ) {
my @array = @{$arrayRef};
if ( grep(/\s+hoser\s+/gi, @array ) ) {
print Hey! I found a hoser!\n;
}
}
/PerlEvangelism
This connected, built a cursor, read it and searched it.
Compare to how many lines of PL/SQL this would take.
Good reason to learn Perl? :)
Jared
rick_stephenso
[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Searching across
multiple columns
om
10/01/01 11:55
AM
Please respond
to ORACLE-L
Does Oracle have a way to do a search across multiple columns/tables for
specific data? I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?
Thanks for the information,
Rick Stephenson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: Searching across multiple columns
Well, but can you put some words about performance of Perl versus PL/SQL
(where to use what)?
JP
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0 }
);
die connect failed\n unless $dbh;
my $sql='select * from persons;'
my $sth = dbh-prepare($sql) || die
my $rv = $sth-execute || die error in execution\n;
while ( my $arrarRef = sth-fetchrow_arrayref ) {
my @array = @{$arrayRef};
if ( grep(/\s+hoser\s+/gi, @array ) ) {
print Hey! I found a hoser!\n;
}
}
/PerlEvangelism
This connected, built a cursor, read it and searched it.
Compare to how many lines of PL/SQL this would take.
Good reason to learn Perl? :)
Jared
rick_stephenso
[EMAIL PROTECTED] To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Searching across
multiple columns
om
10/01/01 11:55
AM
Please respond
to ORACLE-L
Does Oracle have a way to do a search across multiple columns/tables for
specific data? I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?
Thanks for the information,
Rick Stephenson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Log Buffers
Hi list members, I'm new in the field of Oracle DBA. I'm trying to change the size of Redo Buffers by setting the log_buffer parameter in init.ora file. But its value does not mach to redo buffers when I connect to svrmgr and use show sga command to view the SGA parameters. Can anyone help me by explaining this. Thanks Naveed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Searching across multiple columns
I'm sure Perl would be more efficient especially as you don't have to name
the columns, but if you don't have to worry about the combined columns being
too large isn't it equivalent to
select col1||'|'||col2 etc
from table
having col1||'|'||col2 etc like '%value%'
Iain Nicoll
-Original Message-
Sent: 02 October 2001 13:00
To: Multiple recipients of list ORACLE-L
HELL of a reason to learn Perl!
Nice..
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0 }
);
die connect failed\n unless $dbh;
my $sql='select * from persons;'
my $sth = dbh-prepare($sql) || die
my $rv = $sth-execute || die error in execution\n;
while ( my $arrarRef = sth-fetchrow_arrayref ) {
my @array = @{$arrayRef};
if ( grep(/\s+hoser\s+/gi, @array ) ) {
print Hey! I found a hoser!\n;
}
}
/PerlEvangelism
This connected, built a cursor, read it and searched it.
Compare to how many lines of PL/SQL this would take.
Good reason to learn Perl? :)
Jared
rick_stephenso
[EMAIL PROTECTED] To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Searching across
multiple columns
om
10/01/01 11:55
AM
Please respond
to ORACLE-L
Does Oracle have a way to do a search across multiple columns/tables for
specific data? I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?
Thanks for the information,
Rick Stephenson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nicoll, Iain (Calanais)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: Hot Backup Issue
Title: RE: Hot Backup Issue Guy, I would have thought 2) was best as you are reducing the concurrency (I think that is the right word) of redo log activity. As each tablespace is in backup mode it writes the full block to the redo log when any changes are made. On the assumption that all tablespaces are being written (albeit infrequently) during the period of hot backup it is better to alter each tablespace, copy it then alter online again so that only 1 tablespace at a time is having full blocks of changed data writing to the redo logs. The overall level of redo will be the same but contention (ah ha - better word) will be reduced John -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: 02 October 01 12:15 To: Multiple recipients of list ORACLE-L Subject: RE: Hot Backup Issue Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
SANPSHOT TECHNOLGIES ON WINDIWS 2000 CLUSTER SYSTEMS
hi , We have been studiyng about a project which is include Oracle Real Application Clusters on Windows 2000 Cluster System. And Our hardware vendors present to us snapshot technology on their storage systems .We have orginized two meeting with DELL and HP vendores and they said to us that they could present to us snapshot tech. and We could usathis snapshots as consistent oracle backups. But I am not sure about this. Is there any body who has oracle or Oracle Parallel Server or 9i RAC and this kind of storage systems. I need advice and expre?nced info aabout this sunbject. Thank YOu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Problem in setting PCTFREE and PCTUSED
There are no strict rules, but its all about trying to reduce the amount of wasted space under the high water mark for the table. That wasted space is when you have free'd up some space in a block but the block is still deemed sufficiently full for it not be considered for new data. This is where PCTUSED comes in. hth connor --- Quaglio Andrea [EMAIL PROTECTED] wrote: Hello ! After having defined all the tables, now I have to parametrize each table. I have some tables that every day must be deleted and reloaded through sql loader. I think to set PCTFREE = 0, but I don't know if I have to specify a particular value for PCTUSED. Anybody can give an advice about which value set PCTUSED ? Thanks in advance, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: count rows that are being imported
srinivas, Also look at using the COMMIT=Y command line prompt. This will commit the imported records every so often which would allow you to perform your select count(*) command. Be aware that if your import plan requires a complete rollback if something bad happens, then using COMMIT=Y is probably not what you want to do, as the records are truely committed. In that case, as Bruce said, using the FEEDBACK command is probably better. For a quick reference of commands, type IMP HELP=Y at the command line. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:30 AM To: Multiple recipients of list ORACLE-L Hi, Look into imp -feedback. From the manual (816 Utilities, chapter 2): FEEDBACK Default: 0 (zero) Specifies that Import should display a progress meter in the form of a dot for n number of rows imported. For example, if you specify FEEDBACK=10, Import displays a dot each time 10 rows have been imported. The FEEDBACK value applies to all tables being imported; it cannot be set on a per-table basis. If your import has already started, you could possibly use logminer to query the redo / archive logs to count the number of inserted rows - I haven't tried this though. HTH, Bruce Reardon -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 2 October 2001 15:10 Hi lists, I have a tablespace that is 600 M size, has 4 million rows. It is taking nearly 2 hrs to finish the import. In the meantime, I tried selecting howmany rows imported(from another session), but every time I issue query,the result is zero. But after finishing the import I got the total count. Is there anyway to see how may rows imported in that table(in the middle or import process, from another session) ? thnx in adv. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Problem in setting PCTFREE and PCTUSED
Andrea, If it were me and I had tables that were reloaded every day, I would set the following: PCTFREE=5 : Since you are not doing deletes inserts, keep this small PCTUSED=95 : Since you are not doing updates, pack the data right in tight. PCTINCREASE=0 : I ALWAYS set this to 0. and, make sure that the INITIAL extent size was large enough to hold all of the data. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 02, 2001 7:40 AM To: Multiple recipients of list ORACLE-L Hello ! After having defined all the tables, now I have to parametrize each table. I have some tables that every day must be deleted and reloaded through sql loader. I think to set PCTFREE = 0, but I don't know if I have to specify a particular value for PCTUSED. Anybody can give an advice about which value set PCTUSED ? Thanks in advance, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Comparing data between two tables in two schema
This function comapres two tables. It's easy to write a cycle for tables in two schemas. Enjoy it. Jan Pruner create function compare_tables( tbl1 VARCHAR2, tbl2 VARCHAR2) return NUMBER /* Function compares content of two identical tables || tbl1, tbl2 are names of tables in format owner.table_name || 2001, Jan Pruner */ AS cnt1number; cnt2number; cnt3number; res number; sql_stmtvarchar2(100); begin -- count of tuples in 1. table sql_stmt := 'select count(*) into cnt1 from :1'; EXECUTE IMMEDIATE sql_stmt USING tbl1; -- count of tuples in 2. table sql_stmt := 'select count(*) into cnt2 from :1'; EXECUTE IMMEDIATE sql_stmt USING tbl2; -- count of tuples in union of tables sql_stmt := 'select count(*) into cnt3 from ( select * from :1 UNION select * from :2) t'; EXECUTE IMMEDIATE sql_stmt USING tbl1, tbl2; if (cnt1 = cnt2) and (cnt2 = cnt3) then res := 0 ; else res := 1 ; end if; return res; end; From: Rao, Maheswara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Comparing data between two tables in two schema Date: Mon, 01 Oct 2001 12:29:41 -0800 List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Hot Backup Issue
well 1 is simpler to code. :) However, if you put all tablespaces in backup mode at once, you will be generating a LOT of extra redo and archived logs. That's because even if you are not currently backinf up that tablespace (say you already HAVE backed it up), you will still have to write full blocks to the redo log for that tablespace. So it's extra strain on the system --- Guy Hammond [EMAIL PROTECTED] wrote: Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Hot Backup Issue
Guy, Some reasons why NOT to put all tablespaces in the backup mode at once (step 1) is that the tranactions against the database could create a lot of redo and archive logs that could fill the space, tranaction time could be longer as it now reads the redo not the tables, Snapshot to old could occur, If there is a problem and the server restarts Oracle will not start tablespaces in the backup mode you have to manually issue the tablespace normal command. Doing each tablespace individually allow you more control over the process. Just a few thoughts. ROR mª¿ªm [EMAIL PROTECTED] 10/02/01 07:15AM Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Hot Backup Issue
The main disadvantage of #1 is that lgwr will write full blocks to the redo logs for the entire database until the entire backup is finished. If that takes a while and there is significant activity, it can generate tremendous amounts of redo - and archive. Lgwr and the I/O subsystem are doing more work since they are writing more data. This is what I have do when using EMC and BCV splits for backups since it is so fast. #2 is, in my opinion, better for any normal backups - such as to tape. Since only one tablespace at a time is in backup mode, redo and archive generation is minimized. This is especially true if only a relatively small fraction of the database is undergoing significnant transactional activity. The length of time when lgwr is writing full blocks for those transactions is only as long as it takes to back up those particular tablespaces, not all tablespaces. -Don Granaman [OraSaurus - Honk if you remember UFI!] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 6:15 AM Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Background jobs inUnix
that will kill the job... if you want it to continue after you log out, you should run: nohup compress /u01/dmps/zvr_dd.dmp this will allow it to run disconnected from a terminal and will continue after you log out. You will get the message you have running jobs when you type exit, just type exit again. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Log Buffers
it can be because of log_buffer is enforced to 4 times of OS block size. -Original Message- Sent: Tuesday, October 02, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Hi list members, I'm new in the field of Oracle DBA. I'm trying to change the size of Redo Buffers by setting the log_buffer parameter in init.ora file. But its value does not mach to redo buffers when I connect to svrmgr and use show sga command to view the SGA parameters. Can anyone help me by explaining this. Thanks Naveed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: BEGIN BACKUP MODE !!
It freezes increasing the SCN of the data files associated with the tablespace. Then it writes full block data to the redo logs instead of the standard old, new, operation data. If the block has already been written out, it will use an algorithm to avoid constantly writing out the same blocks. However, in nutshell, there is an increased log on the logs and archive logs as well as their processes. Transactions go along fine with no differences. In addition, yes, data IS written to the data files while in begin backup mode and thus corrupting the data files (that is why full blocks are written out so they can be overlaid over the corrupted blocks in their entirety). It is not recommended to do more than one tablespace in backup mode at the same time on a highly transactional system. Although this is highly system dependant. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Hello All, When you take begin back up of tablespace what exactly oracle does internally. what happen the transcation in that period. Please tell me . Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re[2]: For i (Select..)
You can do all three, but if you do not declare it you can't use the 'for update of' clause. Of course the 'for i in ()loop' does replace a lot of lines of code. Dick Goulet Reply Separator Author: Steve Smith [EMAIL PROTECTED] Date: 10/1/2001 7:50 PM You can also use the for loop - end loop with explicit cursors.. You don't have to define the cursor in the loop itself.. That is my preferred method (defining the cursor in the declare section and referencing it in the for loop).. There really isn't any more work defining the cursor up front and then using the for loop as there is using the for loop and defining the cursor in the loop.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 01, 2001 6:01 PM If you only use a cursor in this manner, the only place that the cursor can be used is in the particular For Loop in which it is defined - it can't be shared by other procedures or functions. If you design and create packaged public cursors, they can be reused from other stored procedures and/or client side programs. Code reuse is just one advantage. When table structures change - as they invariably do - you have only a few cursors to change, instead of a bazillion Cursor For Loops. Also, you can more easily tune a few public cursors. I'd also recommend passing in Table%RowType arguments to your public cursors and specifying that they return Table%RowType records. That further isolates your code from table changes. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Zsolt Sent: Monday, October 01, 2001 6:15 PM To: Multiple recipients of list ORACLE-L Hi, If this code is a cursor then why doesn't everybody use it this way? For me it seems a lot simplier and easier than declaring a cursor in a normal way. At 14:50 2001.10.01. -0800, you wrote: the code IS a cursor --- Csillag Zsolt [EMAIL PROTECTED] wrote: Hi, I've read in Tom Kyte's book the following technique: For i in (Select statement ) Loop Process records here End Loop ; I have tried it and it works great. The question is that what is the difference betwen a cursor and the code above? Which is more efficient? Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re:BEGIN BACKUP MODE !!
Saroj, Oracle does two things when you issue the start backup command. 1) It freezes the SCN in the header block of all datafiles in that tablespace and 2) it begins writing full block redo, from my experience for all tablespaces in the database. Some folks, including Oracle themselves, do not recommend putting the entire database into hotbackup mode at one time. There are varying reasons for that we could probably start a 'holy war' on the subject. But I do it all the time as it does make recovery a little simpler to fathom and it makes matters on my SA's easier to manage. The scenario I follow is a) put all of the tablespaces into backup mode, b) back up all of the datafiles followed by the control file(s), c) end the backup, d) backup all of the archive redo logs. Now you've got a set of data files that can be used to restore to a replacement system, almost (but not exactly) like you had a cold backup. Dick Goulet Reply Separator Author: Dash; Saroj (CAP;CEF) [EMAIL PROTECTED] Date: 10/2/2001 2:30 AM Hello All, When you take begin back up of tablespace what exactly oracle does internally. what happen the transcation in that period. Please tell me . Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Extents size.
I did the same reorganization two weeks ago, not the same amount of data, but I used 128k for index tablespaces, 4m for the most activity TS (Sales) and 5160k for the others. I am very, very, very happy with the performance. I read two articles that some folks from the list sent me. Good luck!!! Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Thanh-truc Nguyen Enviado el: Monday, 01 October, 2001 5:35 PM Para: Multiple recipients of list ORACLE-L Asunto: Extents size. Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Database Hangs -- System shows latch contentions
Title: RE: Database Hangs -- System shows latch contentions Thanks. Yes its shared pool and Library cache. Shared pool was 4 GB initially I reduced it to 1.5 GB then we had problem and we increased it to 1.9 GB. We can't go to 8.1.6 new as it requires lot of testing and users are not ready for that. I guess I will have to live with that till they decide to go to 8.1.6. Thanks -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Subject: Re: Database Hangs -- System shows latch contentions What is in V$LATCH. If its shared pool and library cache contention I'd be tempted to: a) upgrade to 8.1.6+ where the algorithm is better b) reduce the size of your shared pool hth connor --- Gupta, Brijesh [EMAIL PROTECTED] wrote: Hi all My database almost hangs and when I query the v$session_wait I found latch contention. we are running on Oracle 8.0.5 (64bit) Oracle application 10.7 SC. Shared pool is 1.9GB and SGA 9GB. I have to flush the shared_pool to get rid of the problem. Can any one help me in finding the permanent solution of this problem. Brijesh Wait Sec in EVENT time SID Wait STATE BLOCK -- -- --- --- --- -- latch free 0 40 1 WAITING address=pp92556056 number=60 tries=25 latch free 0 43 0 WAITING address=9465536000 number=53 tries=1 latch free -1 89 0 WAITED SHORT TIME address=pp92559080 number=60 tries=0 latch free 0 47 0 WAITING address=pp92556056 number=60 tries=1 latch free -1 190 0 WAITED SHORT TIME address=9465548816 number=59 tries=0 latch free 0 281 1 WAITING address=pp92556488 number=60 tries=0 latch free 1 317 2 WAITED KNOWN TIME address=9465548816 number=59 tries=0 latch free -1 343 1 WAITED SHORT TIME address=9465548816 number=59 tries=0 latch free 0 391 2 WAITING address=pp92556200 number=60 tries=25 latch free 0 369 2 WAITING address=pp92555768 number=60 tries=26 latch free 0 631 1 WAITING address=pp92556344 number=60 tries=0 latch free -1 627 0 WAITED SHORT TIME address=pp92559080 number=60 tries=0 latch free 0 600 0 WAITING address=pp92556344 number=60 tries=0 latch free 1 577 1 WAITED KNOWN TIME address=pp92559224 number=60 tries=0 latch free -1 465 1 WAITED SHORT TIME address=9465548816 number=59 tries=1 latch free 0 448 0 WAITING address=pp92557208 number=60 tries=0 latch free 0 414 0 WAITING address=pp92556920 number=60 tries=0 latch free 0 409 2 WAITING address=pp92555912 number=60 tries=26 latch free 0 950 0 WAITING address=pp92556632 number=60 tries=2 latch free 0 949 0 WAITING address=pp92555768 number=60 tries=1 latch free 0 930 0 WAITING address=pp92556776 number=60 tries=1 latch free 0 915 0 WAITING address=pp92556920 number=60 tries=0 latch free 0 901 0 WAITING address=pp92557064 number=60 tries=0 latch free -1 889 0 WAITED SHORT TIME address=9465536000 number=53 tries=0 latch free 0 858 0 WAITING address=pp92556344 number=60 tries=1 latch free 1 832 1 WAITED KNOWN TIME address=pp92559224 number=60 tries=0 latch free 0 827 0 WAITING address=pp92556200 number=60 tries=1 latch free 0 826 0 WAITING address=pp92556344 number=60 tries=0 latch free 0 820 0 WAITING address=pp92556776 number=60 tries=0 latch free 0 805 0 WAITING address=pp92556344 number=60 tries=1 latch free 0 757 0 WAITING address=pp92555768 number=60 tries=1 latch free 0 718 1 WAITING address=pp92556632 number=60 tries=0 latch free 0 697 0 WAITING address=pp92556056 number=60 tries=1 latch free 0 666 0 WAITING address=pp92556200 number=60 tries=0 latch free 0 1154 0 WAITING address=pp92555912 number=60 tries=1 latch free 0 1138 0 WAITING address=pp92556200 number=60 tries=0 latch free 0 1132 0 WAITING address=9465536000 number=53 tries=1 latch free 0 1068 0 WAITING address=pp92556776 number=60 tries=2 latch free 0 1058 0 WAITING address=9465536000 number=53 tries=1 latch free 1 1037 0 WAITED KNOWN TIME address=pp92557064 number=60 tries=0 latch free -1 963 0 WAITED SHORT TIME address=pp92556200 number=60 tries=1 latch free 0 952 0 WAITING address=pp92556776 number=60 tries=1 latch free 1 1425 0 WAITED KNOWN TIME address=pp92556200 number=60 tries=0 latch free 0 1421 2 WAITING address=pp92555768 number=60 tries=29 latch free 0 1412 0 WAITING address=pp92556344 number=60 tries=0 latch free 0 1398 0 WAITING address=9465536000 number=53 tries=1 latch free -1 1385 1 WAITED SHORT TIME address=9465548816 number=59 tries=0 latch free 1 1357 0 WAITED KNOWN TIME address=9465536000 number=53 tries=1 latch free 0 1338 2 WAITING address=pp92555912 number=60 tries=25 latch free 0 1330 2 WAITING address=pp92556200 number=60 tries=19 latch free 0 1301 0 WAITING address=pp92556200 number=60 tries=0 latch
RE: Hot Backup Issue
Title: RE: Hot Backup Issue That makes sense, I just wanted to check :0) And of course, transactions in other tablespaces would be writing redo as normal. The overall level of redo generated would surely be less, tho'? Because say you had 5 tablespaces and put them all into hotbackup mode. Then the 5th tablespace would be writing full blocks to the redo log for all the time it took to copy the datafiles of the first 4, rather than for just the time it took to copy itself if you only put tablespaces into backup mode while they were actually having their datafiles copied? And when recovering, Oracle doesn't mind that some redo information will be full blocks, and some not, if a transaction spans multiple tablespaces, one of which was in hotbackup mode and the rest not when the transaction was committed? Thanks, g -Original Message-From: Hallas John [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 1:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hot Backup Issue Guy, I would have thought 2) was best as you are reducing the concurrency (I think that is the right word) of redo log activity. As each tablespace is in backup mode it writes the full block to the redo log when any changes are made. On the assumption that all tablespaces are being written (albeit infrequently) during the period of hot backup it is better to alter each tablespace, copy it then alter online again so that only 1 tablespace at a time is having full blocks of changed data writing to the redo logs. The overall level of redo will be the same but contention (ah ha - better word) will be reduced John -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: 02 October 01 12:15 To: Multiple recipients of list ORACLE-L Subject: RE: Hot Backup Issue Hello, Slightly unrelated question... is it better to (in pseudo code) : 1) for each tablespace loop put tablespace in backup mode end loop for each datafile in the database loop copy data file end loop for each tablespace loop put tablespace in normal mode end loop or 2) for each tablespace loop put tablespace in backup mode for each datafile in this tablespace loop copy data file end loop put tablespace in normal mode end loop What I'm doing is (2), but I notice that Rajesh is doing (1). What are the pros and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). **This email and any attachments may be confidential and the subject oflegal professional privilege. Any disclosure, use, storage or copyingof this email without the consent of the sender is strictly prohibited.Please notify the sender immediately if you are not the intendedrecipient and then delete the email from your inbox and do notdisclose the contents to another person, use, copy or store theinformation in any medium.**
control file contents
Hello, Out of curiosity just now, I ran strings on a backup of my control file. In it, there are lots of repeated references to archive log files - there are groups log file names, and the same name might appear in multiple groups. Is this a list of the redo logs that you would need to recover the database from the time of the previous backup to the time that the control file was written? Because, looking in my archive log destination, these are a lot older than the last hot backup. Cheers, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Meaning of V$WAITSTAT statistics
right...okwell. save=write ?? that's what I have always ASSumed...? hth - Ross -Original Message- Sent: Monday, October 01, 2001 11:10 PM To: Multiple recipients of list ORACLE-L ok, I know the meaning of the undo block and undo header statistics, but I don't know how to understand the save undo block and save undo header statistics. From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meaning of V$WAITSTAT statistics Date: Mon, 01 Oct 2001 13:05:51 -0800 rollback=undo -Original Message- Sent: Monday, October 01, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Hello ! I need to know what is the meaning of the save undo block and save undo header statistics in the V$WAITSTAT view. TIA. Alejandra. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Log Buffers
Did you bounce (shutdown startup) your instance? If you set an initialisation parameter, you will need to cycle your instance for these parameters to be reinforced. HTH Mark -Original Message- Bahar Sent: Tuesday, October 02, 2001 14:45 To: Multiple recipients of list ORACLE-L it can be because of log_buffer is enforced to 4 times of OS block size. -Original Message- Sent: Tuesday, October 02, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Hi list members, I'm new in the field of Oracle DBA. I'm trying to change the size of Redo Buffers by setting the log_buffer parameter in init.ora file. But its value does not mach to redo buffers when I connect to svrmgr and use show sga command to view the SGA parameters. Can anyone help me by explaining this. Thanks Naveed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveed INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Comparing data between two tables in two schema
The freware tora tool also has some compare capabilities. I've tested if with whe users scott and scott1 (both populated throuh the demobld script and, therefore containing vast masses of data) and it worked well. I haven't tested it on a real life database, mostly because the word freeware is considered rude in production environment. -Original Message- From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Comparing data between two tables in two schema I think that the Change Management Pack of the Oracle Enterprise Manager may be useful to you. From: Rao, Maheswara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Comparing data between two tables in two schema Date: Mon, 01 Oct 2001 12:29:41 -0800 List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: BEGIN BACKUP MODE !!
What happens? What happens is exactly what is described in the DBA guide and concepts manual. You can find bth of those on http://technet.oracle.com. Read the fine manual. -Original Message- From: Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Subject: BEGIN BACKUP MODE !! Hello All, When you take begin back up of tablespace what exactly oracle does internally. what happen the transcation in that period. Please tell me . Regards, saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
New disks on AIX, things to monitor/checks??
Hi Friends, We are going to add new disks other than existing disks!! My front end is baan, my system is AIX 4.1.5 with 200Gb data( I think its before AIX 4.3 version). My task is to test new disks performance like is it viable or not!! So what are the things I need to monitor?? or any checks I have to do?? I appreciate any light on this?? TIA Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Problems Installing a patch on Solaris for Intel
Apologies for asking another question on this (posted one yesterday) but I'm stuck, I am using patchadd to install 2 patches (107545-03 and 106542-17) to Solaris for Intel, these patches are required for Oracle 8.1.6. I keep getting the following message: Checking installed patches... One or more patch packages included in 107545-03 are not installed on this system. I assume that I am missing some required packages but the release notes for the patches do not mention this, how can I determine what's missing and hence what I need to do to overcome this? Many thanks for any help, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Claybrook Computing Limited is a subsidiary of Claybrook Computing (Holdings) Limited Registered Office: Abbey House. 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 1287205 A Hogg Robinson plc company ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Leach INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Migration v. Upgrade
I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re:RE: Comparing data between two tables in two schema
Why not try the time tested brute force method? Select * from owner1.table1 intersect select * from owner2.table2; If you get the same number of rows as there are in the tables individually then they are equal. BTW: it's cheap too. Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 10/2/2001 7:35 AM The freware tora tool also has some compare capabilities. I've tested if with whe users scott and scott1 (both populated throuh the demobld script and, therefore containing vast masses of data) and it worked well. I haven't tested it on a real life database, mostly because the word freeware is considered rude in production environment. -Original Message- From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Comparing data between two tables in two schema I think that the Change Management Pack of the Oracle Enterprise Manager may be useful to you. From: Rao, Maheswara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Comparing data between two tables in two schema Date: Mon, 01 Oct 2001 12:29:41 -0800 List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Meaning of V$WAITSTAT statistics
Save undo headers are made for the Billy Graham's database only. Just kidding. The save undo headers refer to the deferred rollback segment, which are created if a tablespace goes offline with uncommitted transactions. Those deferred rollback segments are created in the tablespace SYSTEM and there is no way of changing that (allegedly, some magic happens if the default tablespace is changed for the user 'SYS', but I've never tested that. It might be a rumor). From the performance perspective, you can safely ignore the save undo statistics. -Original Message- From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 11:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Meaning of V$WAITSTAT statistics ok, I know the meaning of the undo block and undo header statistics, but I don't know how to understand the save undo block and save undo header statistics. From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Meaning of V$WAITSTAT statistics Date: Mon, 01 Oct 2001 13:05:51 -0800 rollback=undo -Original Message- Sent: Monday, October 01, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Hello ! I need to know what is the meaning of the save undo block and save undo header statistics in the V$WAITSTAT view. TIA. Alejandra. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Oracle Open World
On Monday 01 October 2001 19:55, satar naghshineh wrote: Regards, Satar Groping Hands Grandma Fetish Naghshineh OK, it's already been on the list once, that's enough. Don't prolong it. Jared --- Smith, Ron L. [EMAIL PROTECTED] wrote: Just thought I would ask. How does everyone feel about Oracle Open World this year. Will attendance be down? Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Extents size.
Ramon, Why use an extent size of 5.16 meg when you are already using 4 meg? Jared On Tuesday 02 October 2001 07:40, Ramon Estevez wrote: I did the same reorganization two weeks ago, not the same amount of data, but I used 128k for index tablespaces, 4m for the most activity TS (Sales) and 5160k for the others. I am very, very, very happy with the performance. I read two articles that some folks from the list sent me. Good luck!!! Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Thanh-truc Nguyen Enviado el: Monday, 01 October, 2001 5:35 PM Para: Multiple recipients of list ORACLE-L Asunto: Extents size. Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Slightly OT
By any chance are any on this list members of TCOUG(Twin Cities Oracle Users Group)? If so are you planning on attending tomorrows conference in Bloomington on Oracle System Performance given by Cary Millsap? Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Extents size.
That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
oem job fails..
Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Problem in setting PCTFREE and PCTUSED
You can not make an intelligent guess at what these values should be without knowing: 1. Average Row Length 2. Blocks Size 3. Average Rows/Block 4. How active the table is for insert, deletes, updates. 5. Average size of updates (1,2,3 columns, 1 byte, 10 bytes) Without these pieces of information, you just as well keep the defaults, it is just mere guessing to set them to anything else. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 7:40 AM To: Multiple recipients of list ORACLE-L Hello ! After having defined all the tables, now I have to parametrize each table. I have some tables that every day must be deleted and reloaded through sql loader. I think to set PCTFREE = 0, but I don't know if I have to specify a particular value for PCTUSED. Anybody can give an advice about which value set PCTUSED ? Thanks in advance, Andrea -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quaglio Andrea INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Extents size.
well, only when you are deleting massive amounts of data or truncating with drop storage.. then there is an impact because of the hits on the dictionary tables. but basically yes... I've been told by various Oracle employees that up to 4096 extents cause no problem whatsoever. --- Christopher Spence [EMAIL PROTECTED] wrote: That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Searching across multiple columns
On a logical level perhaps.
Try coding it. It will also be slow.
Perl is *much* faster for something like this.
Jared
On Tuesday 02 October 2001 06:00, Nicoll, Iain (Calanais) wrote:
I'm sure Perl would be more efficient especially as you don't have to name
the columns, but if you don't have to worry about the combined columns
being too large isn't it equivalent to
select col1||'|'||col2 etc
from table
having col1||'|'||col2 etc like '%value%'
Iain Nicoll
-Original Message-
Sent: 02 October 2001 13:00
To: Multiple recipients of list ORACLE-L
HELL of a reason to learn Perl!
Nice..
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Monday, October 01, 2001 20:51
To: Multiple recipients of list ORACLE-L
PerlEvangelism
my $dbh = DBI-connect(
'dbi:Oracle:' . $db,
$username, $password,
{ RaiseError = 1, AutoCommit = 0 }
);
die connect failed\n unless $dbh;
my $sql='select * from persons;'
my $sth = dbh-prepare($sql) || die
my $rv = $sth-execute || die error in execution\n;
while ( my $arrarRef = sth-fetchrow_arrayref ) {
my @array = @{$arrayRef};
if ( grep(/\s+hoser\s+/gi, @array ) ) {
print Hey! I found a hoser!\n;
}
}
/PerlEvangelism
This connected, built a cursor, read it and searched it.
Compare to how many lines of PL/SQL this would take.
Good reason to learn Perl? :)
Jared
rick_stephenso
[EMAIL PROTECTED] To: Multiple recipients of
list ORACLE-L [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Searching across
multiple columns
om
10/01/01 11:55
AM
Please respond
to ORACLE-L
Does Oracle have a way to do a search across multiple columns/tables for
specific data? I know I can issue a query with a bunch of or statements,
but is there something similar to fulltext searching?
Thanks for the information,
Rick Stephenson
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: Meaning of V$WAITSTAT statistics
Save undo is when a tablespace has undo information, but is currently offline. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Hello ! I need to know what is the meaning of the save undo block and save undo header statistics in the V$WAITSTAT view. TIA. Alejandra. _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RE: Comparing data between two tables in two schema
That is not elegant and doesn't have a GOOEY interface. It also requires the knowledge of SQL, which is a lot to ask from a poor little DBA like me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:21 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: Comparing data between two tables in two schema Why not try the time tested brute force method? Select * from owner1.table1 intersect select * from owner2.table2; If you get the same number of rows as there are in the tables individually then they are equal. BTW: it's cheap too. Dick Goulet Reply Separator Author: Gogala; Mladen [EMAIL PROTECTED] Date: 10/2/2001 7:35 AM The freware tora tool also has some compare capabilities. I've tested if with whe users scott and scott1 (both populated throuh the demobld script and, therefore containing vast masses of data) and it worked well. I haven't tested it on a real life database, mostly because the word freeware is considered rude in production environment. -Original Message- From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 11:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Comparing data between two tables in two schema I think that the Change Management Pack of the Oracle Enterprise Manager may be useful to you. From: Rao, Maheswara [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Comparing data between two tables in two schema Date: Mon, 01 Oct 2001 12:29:41 -0800 List, I have two schema. The tables in both schema are having same name and structures. Is there any tool to compare the data between two schema tabels? Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). _ Descargue GRATUITAMENTE MSN Explorer en http://explorer.msn.es/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alejandra Pazos Freire INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
Re: oem job fails..
read the oracle docs om error 54. joe [EMAIL PROTECTED] 10/02/01 12:40PM Hi Guys,While running a job(with lot of updates)in oem i get this error:ORA-00054: resource busy and acquire with NOWAIT specified.data base is 8.1.7 on NT.please help me how to fix it.Sunil NookalaDell Corp.Austin, TX-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
pl/sql question
Can I somehow use a variable for the table name in a cursor select? Here is the example: --Declaration Section sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC'; --cursor for tmo daily source records CURSOR cTMODaily IS SELECT* FROM sSrcTableName; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re:oem job fails..
Sunil, Depends on what your job is doing. From the error message I would expect that it needs an exclusive lock on a database object that someone else is using. Please post the code. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/2/2001 8:40 AM Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: optimizer function based indexes
Hi, Have you checked OPTIMIZER_FEATURES_ENABLE? oli [EMAIL PROTECTED] wrote: hello i've update my database from 8.1.7 release 3 to 9i and now following statement don't use my optimizer hint in 9i (in 8i it works) upper_artikel_kurztext_idx is an function based index select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) LIKE '%WANN%' when i change the statement it works but i need above statement select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) LIKE 'WANN%' or select /*+ index_asc(artikel upper_artikel_kurztext_idx */ * from artikel where upper(kurztext) = 'WANN' the following parameters are set in init.ora QUERY_REWRITE_ENABLED=TRUE QUERY_REWRITE_INTEGRITY=TRUSTED OPTIMIZER_MODE = CHOOSE database is analyzed ! any ideas thanx joe Content-Type: text/html; charset=iso-8859-1; name=Anhang: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re:RE: Extents size.
Back in the V6 days it was a desired characteristic to have every thing in the first extent of an object for performance reasons. Thankfully those days are gone and it really does not matter how many extents there are. Rachel has a presentation on Oracle Myths where she actually portrays having multiple extents as a good thing from an IO perspective (Rachel, correct me if I got this wrong). Although I can't give you exact examples, take a look and v$filestat. I've found that tablespaces where there are more than one extent in the objects have a lower average io wait time that those where everything is in the first extent. The only real good reason I have found for re-organizing a tablespace is to get all of the used extents at one end and all of the free extents (you know those little bitty ones that individually aren't worth the trouble, but together!!) at the other end. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 10/2/2001 7:55 AM That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: pl/sql question
Use DBMS_SQL or EXECUTE IMMEDIATE Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Can I somehow use a variable for the table name in a cursor select? Here is the example: --Declaration Section sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC'; --cursor for tmo daily source records CURSOR cTMODaily IS SELECT* FROM sSrcTableName; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Migration v. Upgrade
Erik - I believe the upgrade / recovery manual will have the more concise definition you seek. Look for the Oracle version you are on and the one you want to move to and it will tell you whether you need to upgrade or migrate. With an upgrade you usually just bring up the new version and run some procedures to modify your system tables. With migrate it is much more involved. To put things concisely: upgrade - good migrate - bad upgrade - minor, easy. migrate - hard, difficult, headaches. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 02, 2001 11:00 AM To: Multiple recipients of list ORACLE-L I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: RE: Meaning of V$WAITSTAT statistics
Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ahead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Snapshots and DBlink on different version of database
Hello Everybody I am here with a question, please help. I am running 7.3.4.4 on our two different departments and sales deaprtment runs dblink and snapshots to refresh from the central department. Both department running 7.3.4.4 Core Central department upgrading the database to 8.1.7. Now, my question is Sales department database version will be 7.3.4.4 Central department database version will be 8.1.7 Will sales department's snapshots and dblink work as before, or they will not work at all; or we need to drop and recrete in order to get them work??? Please help Thank you all very much I will be waiting for the answer Thanks again Kishore __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kishore INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Extents size.
Yea - I keep hearing and seeing tests that show that the number of extents had no bearing on performance (up to a point). It just 'bothers' me to see a 500 or 1200 or 2000 extents on a table.. grin Here is a question - is there any situation that having only 1 big extent would reduce performance? Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 10:30 AM well, only when you are deleting massive amounts of data or truncating with drop storage.. then there is an impact because of the hits on the dictionary tables. but basically yes... I've been told by various Oracle employees that up to 4096 extents cause no problem whatsoever. --- Christopher Spence [EMAIL PROTECTED] wrote: That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com
Re: oem job fails..
that's not an oem problem per se... but is related to the fact that you are trying to update a row or table that is already in use review the updates and order of updates you are making. Is anything else running at that time? --- [EMAIL PROTECTED] wrote: Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: HOTBACKUP issue !!
On Mon, 1 Oct 2001, Dash, Saroj (CAP,CEF) wrote: When you take begin back up of tablespace what exactly oracle does internally. what happen the transcation in that period. Check out my hot backup article. http://www.speakeasy.net/~jwilton/hot-backup.html -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Repost: Nested loop in PL/SQL
Jun,
What exactly do you mean that it doesn't work after the first inner loop?
One thing you should do is close and open the inner cursor after the inner
loop completes.
Are you sure the outer loop returns more than one row?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, October 02, 2001 11:05 AM
To: Multiple recipients of list ORACLE-L
Sorry, I meant to say doesn't work.
-Original Message-
Sent: Monday, October 01, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Could anyone tell me why following nested loop does work? It stopped after
inner loop finished. I tried for loop, it worked ok.
Thanks,
Jun
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where CHANNEL_ID = 'GROUP19'
and promotion_cd = 'INFO'
and trunc(end_date) = trunc(sysdate)
and p_mode = 'LIVE'
group by PRICING_PLAN_ID;
cursor channel_id is
select distinct channel_id from pricing_plan
where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3')
and transaction_type = 'REGISTRATION'
order by channel_id;
begin
open plan_id;
open channel_id;
loop
fetch plan_id into v_plan_id;
exit when plan_id%NOTFOUND;
loop
fetch channel_id into v_channel_id;
exit when channel_id%NOTFOUND;
select * into v_row
from pricing_plan
where PRICING_PLAN_ID = 1;
dbms_output.put_line(v_row.price_cd);
end loop;
end loop;
close plan_id;
close channel_id;
end;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Loadjava utility
Hello all, I want to load in ther server two jar files, through the loadjava utility. But, where should be this files physically stored? Should they be in any folder under ORACLE_HOME directory? A lot of thanks in advance begin:vcard n:Jimenez;Beatriz Martinez x-mozilla-html:FALSE org:Fundación CIDAUT;Departamento de Informática adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain version:2.1 email;internet:[EMAIL PROTECTED] title:Ingeniera Informática fn:Beatriz Martínez Jiménez end:vcard
Re: Extents size.
Yes. If you need to do parallel query, multiple extents may help you out a bit. Jared Steve Smith [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Sent by: Subject: Re: Extents size. [EMAIL PROTECTED] om 10/02/01 10:37 AM Please respond to ORACLE-L Yea - I keep hearing and seeing tests that show that the number of extents had no bearing on performance (up to a point). It just 'bothers' me to see a 500 or 1200 or 2000 extents on a table.. grin Here is a question - is there any situation that having only 1 big extent would reduce performance? Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 10:30 AM well, only when you are deleting massive amounts of data or truncating with drop storage.. then there is an impact because of the hits on the dictionary tables. but basically yes... I've been told by various Oracle employees that up to 4096 extents cause no problem whatsoever. --- Christopher Spence [EMAIL PROTECTED] wrote: That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
RE: Hot Backup Issue
On Tue, 2 Oct 2001, Ron Rogers wrote: Some reasons why NOT to put all tablespaces in the backup mode at once (step 1) is that the tranactions against the database could create a lot of redo and archive logs that could fill the space, tranaction time could be longer as it now reads the redo not the tables What reads the redo? I don't think you have to read the redo during hot backup mode. You read the datafiles or buffer cache just like when you're not in backup mode. Snapshot to old could occur Why? I can think of no reason that ORA-1555 should be more likely during hot backup mode. Can you explain this? If there is a problem and the server restarts Oracle will not start tablespaces in the backup mode you have to manually issue the tablespace normal command. Do you mean 'alter database datafile n end backup?' This can and should just be integrated into the database start scripts. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
SID Environment Variable
I am trying to find an environment variable that returns the current session's SID. I see things like ora_login_user but can't find anything SID related. Basically I want to take a statspack snapshot using the SID of the current session. - E -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: pl/sql question
Yep - here's an example. There is really a whole lot more that goes with this, but I've included the pertinent portions so you can get an idea. Hope this helps. SET DEFINE OFF; CREATE OR REPLACE PROCEDURE Student_Course_Report( fromSchool varchar2, toSchoolvarchar2, fromCourse varchar2, toCoursevarchar2) AS schoolWhereClause varchar2(250); courseWhereClause varchar2(250); TYPE RefCurType IS REF CURSOR; schoolCur RefCurType; v_schoolnum varchar2(3); v_schoolnamevarchar2(35); ACRSVar varchar2(13); BEGIN IF fromSchool = 'All Schools' THEN schoolWhereClause:= ' Where schoolnum not in ( ' || || '800' || || ' , ' || || 'D01' || || ') Order by schoolnum'; END IF; OPEN schoolCur for 'Select schoolnum, name From sasi.asch ' || schoolWhereClause; LOOP Fetch schoolCur into v_schoolnum, v_schoolname; EXIT WHEN schoolCur%NOTFOUND; ACRSVar:= 'sasi.ACRS1'||v_schoolnum; OPEN courseCur for 'Select statecrs1, title, course From ' || ACRSVar || courseWhereClause; LOOP Fetch coursecur into v_statecrs1, v_title, v_course; EXIT WHEN courseCur%NOTFOUND; David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Eric.Chesebro@ chase.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: pl/sql question om 10/02/2001 11:50 AM Please respond to ORACLE-L Can I somehow use a variable for the table name in a cursor select? Here is the example: --Declaration Section sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC'; --cursor for tmo daily source records CURSOR cTMODaily IS SELECT* FROM sSrcTableName; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re[2]: For i (Select..)
Thank you very much. Your answers explained everything about explicit and implicit cursors. At 07:00 2001.10.02. -0800, you wrote: You can do all three, but if you do not declare it you can't use the 'for update of' clause. Of course the 'for i in ()loop' does replace a lot of lines of code. Dick Goulet Reply Separator Author: Steve Smith [EMAIL PROTECTED] Date: 10/1/2001 7:50 PM You can also use the for loop - end loop with explicit cursors.. You don't have to define the cursor in the loop itself.. That is my preferred method (defining the cursor in the declare section and referencing it in the for loop).. There really isn't any more work defining the cursor up front and then using the for loop as there is using the for loop and defining the cursor in the loop.. Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 01, 2001 6:01 PM If you only use a cursor in this manner, the only place that the cursor can be used is in the particular For Loop in which it is defined - it can't be shared by other procedures or functions. If you design and create packaged public cursors, they can be reused from other stored procedures and/or client side programs. Code reuse is just one advantage. When table structures change - as they invariably do - you have only a few cursors to change, instead of a bazillion Cursor For Loops. Also, you can more easily tune a few public cursors. I'd also recommend passing in Table%RowType arguments to your public cursors and specifying that they return Table%RowType records. That further isolates your code from table changes. Jack Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Slightly OT : IFS Search is Slow.
Hi
We are using IFS 1.1 version on HP UX. Large number of XMl documents are
loaded into IFS ( around 5.5 gb of table space occupied).
Our req. is , given a file name , we need to lookup for the same in IFS
repository and load it if exists. Search is based on file name ( attribute
search) not file contents ( content search) .
The following is the function we have wriiten to search
public String ifsDocSearch(String name, String path, String owner)throws
Exception
{
FolderRestrictQualification frq = new FolderRestrictQualification();
FolderPathResolver fpr = new FolderPathResolver(ifsSession);
fpr.setRootFolder();
Folder startFolder = (Folder) fpr.findPublicObjectByPath(path);
frq.setStartFolder(startFolder);
AttributeQualification aq = new AttributeQualification();
aq.setAttribute(oracle.ifs.beans.Document.CLASS_NAME,NAME);
aq.setOperatorType(aq.EQUAL);
aq.setValue(name);
AttributeQualification aq1 = new AttributeQualification();
aq1.setAttribute(oracle.ifs.beans.Document.OWNER_ATTRIBUTE,oracle.ifs.beans.
Document.OWNER_ATTRIBUTE);
aq1.setOperatorType(aq.EQUAL);
aq1.setValue(owner);
String arr[]= new String[2];
arr[0]=DOCUMENT;
arr[1]=FOLDER;
SearchClassSpecification scs=new SearchClassSpecification(arr);
AttributeSearchSpecification ass = new AttributeSearchSpecification();
ass.setSearchClassSpecification(scs);
SearchClause sc = new SearchClause(aq, frq, SearchClause.AND);
SearchClause sc1 = new SearchClause(sc, aq1, SearchClause.AND);
ass.setSearchQualification(sc);
Search s = new Search(this.ifsSession,ass);
s.setSearchSpecification(ass);
s.open();
SearchResultObject sro=s.getItems(0);
if(sro==null)
{
System.out.println(sro is null);
return null;
}
oracle.ifs.beans.Document myDoc = (oracle.ifs.beans.Document)
sro.getLibraryObject();
if(myDoc == null)
{
System.out.println(my doc is null);
return null;
}
vxweb.vxhelper.VxDebug.timer(File IO);
StringBuffer sb = new StringBuffer();
BufferedReader bufferedReader =
new BufferedReader(myDoc.getContentReader());
for (String l_nextLine = bufferedReader.readLine();
l_nextLine != null;
l_nextLine = bufferedReader.readLine()) {
sb.append(l_nextLine);
sb.append(\n);
}
vxweb.vxhelper.VxDebug.timer(File IO);
System.out.println(sb);
return sb.toString();
}
The search seems to be slower. it takes around 2-4 sec. -
Is there any way this can be tuned better for faster searching?
do we need to create any indexes file names in IFS schema ?
Other Info : processing mode :MTS
table space for ifs : localymanaged
Thanks in Advance
Raj
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raj Gopalan
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re:RE: Extents size.
something along those lines... as with everything there is no real black or white on this... but transactional systems that do a lot of small (non-sequential) reads you are better off with lots of extents while data warehouses are often better off with fewer extents as the reads tend to be sequential or full table scans so you would want more of the data together as for those little bitty extents -- you mean you aren't using tablespaces with a single extent size so you don't have to worry about them? --- [EMAIL PROTECTED] wrote: Back in the V6 days it was a desired characteristic to have every thing in the first extent of an object for performance reasons. Thankfully those days are gone and it really does not matter how many extents there are. Rachel has a presentation on Oracle Myths where she actually portrays having multiple extents as a good thing from an IO perspective (Rachel, correct me if I got this wrong). Although I can't give you exact examples, take a look and v$filestat. I've found that tablespaces where there are more than one extent in the objects have a lower average io wait time that those where everything is in the first extent. The only real good reason I have found for re-organizing a tablespace is to get all of the used extents at one end and all of the free extents (you know those little bitty ones that individually aren't worth the trouble, but together!!) at the other end. Dick Goulet Reply Separator Author: Christopher Spence [EMAIL PROTECTED] Date: 10/2/2001 7:55 AM That is completely a myth. There is no notable performance different with a table with 10,000 extents and one with 1. The only problem is when it comes to the bitmaps when dealing with LMT and cluster when dealing with dictionary managed. When you query the extent views, or do space management type processes. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, October 01, 2001 7:15 PM To: Multiple recipients of list ORACLE-L May be it is good practice to keep number of extents to be less than 50, no matter what the size of extent. -Original Message- Sent: Monday, October 01, 2001 3:35 PM To: Multiple recipients of list ORACLE-L Hello, I'll do an reorganization of a database (about 140 gigs). Some people say that it'd be good to use 128K, 4M and 128M extents. I saw somewhere it'd be 160K, 4M and 160M. Which size do you advice me ? I have also many small indexes (less than 16K). Regards, Thanh-truc Nguyen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thanh-truc Nguyen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City
Re: SANPSHOT TECHNOLGIES ON WINDIWS 2000 CLUSTER SYSTEMS
I have designed systems on Sun Solaris Cluster (1.2 and 2.2) with OPS (7.3.x and 8.1.x) that used EMC snapshots (BCVs and SRDF), but not Windows 2000 clusters, DELL, or HP. Those used BCVs for backups of OPS databases and worked well. Since the EMC snapshot was performed at a layer common to all nodes (the Symmetrix), there was no issue of synchronizing host write activity - a track modification is a track modification, no matter which host it comes from. If the snapshot mechanism is at the host level, one would need to be concerned about how writes from distinct hosts in an OPS cluster are managed/coordinated. In this context, the considerations for RAC are identical to those for OPS. -Don Granaman [Orasaurus - Honk if you remember UFI!] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 8:35 AM hi , We have been studiyng about a project which is include Oracle Real Application Clusters on Windows 2000 Cluster System. And Our hardware vendors present to us snapshot technology on their storage systems .We have orginized two meeting with DELL and HP vendores and they said to us that they could present to us snapshot tech. and We could usathis snapshots as consistent oracle backups. But I am not sure about this. Is there any body who has oracle or Oracle Parallel Server or 9i RAC and this kind of storage systems. I need advice and expre?nced info aabout this sunbject. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: find out ip
netstat -in Will also tell you if there are any other assigned ip addresses to that server, for example in a cluster configuiration. Regards, Satar --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Loadjava utility
Doesn't matter, they get loaded into the java tables as lobs. As long as the loadjava command has access to the file when you run it. You can then delete the files if you so choice. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 2:25 PM To: Multiple recipients of list ORACLE-L Hello all, I want to load in ther server two jar files, through the loadjava utility. But, where should be this files physically stored? Should they be in any folder under ORACLE_HOME directory? A lot of thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Migration v. Upgrade
Migrating is the process of transforming one database version to a later database version. Oracle 7 to Oracle 8 is migration. Upgrading is the process of transforming one database release to another database release of the same database version. Oracle 8.0.1 to 8.0.5 is upgrading database. HTH Rick -Original Message- Sent: Tuesday, October 02, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Erik - I believe the upgrade / recovery manual will have the more concise definition you seek. Look for the Oracle version you are on and the one you want to move to and it will tell you whether you need to upgrade or migrate. With an upgrade you usually just bring up the new version and run some procedures to modify your system tables. With migrate it is much more involved. To put things concisely: upgrade - good migrate - bad upgrade - minor, easy. migrate - hard, difficult, headaches. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 02, 2001 11:00 AM To: Multiple recipients of list ORACLE-L I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Problems with patchsets to 8.1.7.0.0 on Windows 2000
I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install the 8.1.7.2.1 patchset according to the readme directions (shutdown all Oracle* services first, etc.), but when I try to run setup.exe, nothing happens. The icon flashes momentarily after being double-clicked, but nothing ever actually runs. I tried it a number of times. Then I tried it with an older 8.1.7.1.1 patchset - and the exactly same thing happened. These patchsets are for Windows NT, but I assumed they would work for 2000 as well. (Am I wrong in this assumption?) Does anyone have any experience with this and/or workarounds? -Don Granaman [OraSaurus - Honk if you remember UFI!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Repost: Nested loop in PL/SQL
Jun the corrected code should be ... assuming you want to process channel_id
for each row of pla_id.
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where CHANNEL_ID = 'GROUP19'
and promotion_cd = 'INFO'
and trunc(end_date) = trunc(sysdate)
and p_mode = 'LIVE'
group by PRICING_PLAN_ID;
cursor channel_id is
select distinct channel_id from pricing_plan
where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3')
and transaction_type = 'REGISTRATION'
order by channel_id;
begin
open plan_id;
loop
fetch plan_id into v_plan_id;
exit when plan_id%NOTFOUND;
open channel_id; -- note this line
loop
fetch channel_id into v_channel_id;
exit when channel_id%NOTFOUND;
select * into v_row
from pricing_plan
where PRICING_PLAN_ID = 1;
dbms_output.put_line(v_row.price_cd);
end loop;
close channel_id;-- note this line
end loop;
close plan_id;
end;
/
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art !
*1
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000
and delete this e-mail message from your computer, Thank you.
*1
Re: Repost: Nested loop in PL/SQL
The reasons this doesn't work are fairly numerous. What is it you're
trying to accomplish here? Perhaps if you could explain your requirement,
somebody could help you out. I'm quite surprised you were able to get a
version of this to compile and run even if you did use a 'FOR' loop. Is it
possible we're not seeing all the code?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Feng, Jun
jfeng@verisig To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
n.com cc:
Sent by: Subject: Repost: Nested loop in PL/SQL
[EMAIL PROTECTED]
om
10/02/2001
10:05 AM
Please respond
to ORACLE-L
Sorry, I meant to say doesn't work.
-Original Message-
Sent: Monday, October 01, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Could anyone tell me why following nested loop does work? It stopped after
inner loop finished. I tried for loop, it worked ok.
Thanks,
Jun
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where CHANNEL_ID = 'GROUP19'
and promotion_cd = 'INFO'
and trunc(end_date) = trunc(sysdate)
and p_mode = 'LIVE'
group by PRICING_PLAN_ID;
cursor channel_id is
select distinct channel_id from pricing_plan
where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3')
and transaction_type = 'REGISTRATION'
order by channel_id;
begin
open plan_id;
open channel_id;
loop
fetch plan_id into v_plan_id;
exit when plan_id%NOTFOUND;
loop
fetch channel_id into v_channel_id;
exit when channel_id%NOTFOUND;
select * into v_row
from pricing_plan
where PRICING_PLAN_ID = 1;
dbms_output.put_line(v_row.price_cd);
end loop;
end loop;
close plan_id;
close channel_id;
end;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line
Oracle - SQL Server
Title: Oracle - SQL Server I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas on this, I searched technet (ms/oracle) and metalink, as well as some search engines without luck. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863
[no subject]
SELECT s.study_id, s.status, sp.status FROM s, sp WHERE s.study_id = 5014 AND s.study_id = sp.study_id(+) AND s.status = 'A' AND sp.status = 'A' I'm stuck trying to figure out how to make this SQL work, and am starting to wonder if it's even possible. I'm trying to get this SQL to return rows from the S table even if there are records in the SP table with status of 'D'(logically deleted). What am I missing??!?!?!? TIA Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Background jobs inUnix
That's fine, but I would look into using the nohup command to solve error issues and to report any errors. Regards, Satar --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi Lists, Shall I close the unix session after submitting my job (compressing the dmp file after importing) in the background on solaris. $ compress /u01/dmps/zvr_dd.dmp is this harmful ? (like killing the running jobs) thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satar naghshineh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Meaning of V$WAITSTAT statistics
From the performance perspective, you can safely ignore the save undo statistics. Anyone know where I can find a list of the v$sysstat, v$system_event and v$session_wait items I can safely ignore? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: RE: Meaning of V$WAITSTAT statistics
I didn't mean to offend anyone and I apologize if I did so. By the way, it's spelled unpalatable and not unplatable. -Original Message- From: Cyril Thankappan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Meaning of V$WAITSTAT statistics Hello Can you please clarify the relation between 'save undo headers' and Billy Graham. If making a joke out of what is 'unplatable' or 'inconvenient' to believe is comforting you by all means go ahead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: control file contents
Guy, I assume the database involved in 8.0 or higher :) Starting 8.0, the control files retain the list of archive logs in addition to recording both the list of database and redolog files. In fact, I found that it retains a list of backup controlfiles too... The list size for archive logs seems to be controlled by a combination of the init parameter 'control_file_record_keep_time' and the MAXLOGHISTORY. I haven't been able to test this, but if select count(*) from v$log_history is less than MAXLOGHISTORY, then I am willing to bet that you will see a list of all archive logs since database create... Nice to reply to a question from you after a long time! John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 7:50 AM To: Multiple recipients of list ORACLE-L Subject: control file contents Hello, Out of curiosity just now, I ran strings on a backup of my control file. In it, there are lots of repeated references to archive log files - there are groups log file names, and the same name might appear in multiple groups. Is this a list of the redo logs that you would need to recover the database from the time of the previous backup to the time that the control file was written? Because, looking in my archive log destination, these are a lot older than the last hot backup. Cheers, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: pl/sql question
Or use a cursor variable. Jared Christopher Spence To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cspence@FuelS cc: pot.com Subject: RE: pl/sql question Sent by: [EMAIL PROTECTED] om 10/02/01 10:30 AM Please respond to ORACLE-L Use DBMS_SQL or EXECUTE IMMEDIATE Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Can I somehow use a variable for the table name in a cursor select? Here is the example: --Declaration Section sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC'; --cursor for tmo daily source records CURSOR cTMODaily IS SELECT* FROM sSrcTableName; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Oracle - SQL Server
Title: Oracle -> SQL Server I have not used it but Oracle Transparent Gateway can query against a SQL Server database. This is a very expensive product. Rick -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle - SQL Server I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas on this, I searched technet (ms/oracle) and metalink, as well as some search engines without luck. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863
RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000
I had that same problem with it. I ended up getting it to work OK when I navigated into the directory structure that the zip file creates (or on CD, whichever you're running it from) into patch_base\install\win32\setup.exe and ran it from there. This actually runs the OUI instead of the unnecessary little autorun executable that they put in the root directory. Try that, I think that will work for you. -::YEX::- ))) -Original Message- Sent: Tuesday, October 02, 2001 2:29 PM To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install the 8.1.7.2.1 patchset according to the readme directions (shutdown all Oracle* services first, etc.), but when I try to run setup.exe, nothing happens. The icon flashes momentarily after being double-clicked, but nothing ever actually runs. I tried it a number of times. Then I tried it with an older 8.1.7.1.1 patchset - and the exactly same thing happened. These patchsets are for Windows NT, but I assumed they would work for 2000 as well. (Am I wrong in this assumption?) Does anyone have any experience with this and/or workarounds? -Don Granaman [OraSaurus - Honk if you remember UFI!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Never mind - please ignore
Never mind - please ignore. Sorry for bothering. Brain fart. -Original Message- Sent: Tuesday, October 02, 2001 2:01 PM To: Fatcity's Oracle ListServ SELECT s.study_id, s.status, sp.status FROM s, sp WHERE s.study_id = 5014 AND s.study_id = sp.study_id(+) AND s.status = 'A' AND sp.status = 'A' I'm stuck trying to figure out how to make this SQL work, and am starting to wonder if it's even possible. I'm trying to get this SQL to return rows from the S table even if there are records in the SP table with status of 'D'(logically deleted). What am I missing??!?!?!? TIA Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Repost: Nested loop in PL/SQL
Part of the code must be missing because plan_id cursor is being
open/fetched but NOTHING done with it.
Rick
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 2:29 PM
To: Multiple recipients of list ORACLE-L
The reasons this doesn't work are fairly numerous. What is it you're
trying to accomplish here? Perhaps if you could explain your requirement,
somebody could help you out. I'm quite surprised you were able to get a
version of this to compile and run even if you did use a 'FOR' loop. Is it
possible we're not seeing all the code?
David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002
Feng, Jun
jfeng@verisig To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
n.com cc:
Sent by: Subject: Repost: Nested loop in
PL/SQL
[EMAIL PROTECTED]
om
10/02/2001
10:05 AM
Please respond
to ORACLE-L
Sorry, I meant to say doesn't work.
-Original Message-
Sent: Monday, October 01, 2001 6:50 PM
To: Multiple recipients of list ORACLE-L
Could anyone tell me why following nested loop does work? It stopped after
inner loop finished. I tried for loop, it worked ok.
Thanks,
Jun
declare v_plan_id number;
v_channel_id pricing_plan.channel_id%TYPE;
v_row pricing_plan%ROWTYPE;
cursor plan_id is
select distinct pricing_Plan_id from pricing_plan
where CHANNEL_ID = 'GROUP19'
and promotion_cd = 'INFO'
and trunc(end_date) = trunc(sysdate)
and p_mode = 'LIVE'
group by PRICING_PLAN_ID;
cursor channel_id is
select distinct channel_id from pricing_plan
where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3')
and transaction_type = 'REGISTRATION'
order by channel_id;
begin
open plan_id;
open channel_id;
loop
fetch plan_id into v_plan_id;
exit when plan_id%NOTFOUND;
loop
fetch channel_id into v_channel_id;
exit when channel_id%NOTFOUND;
select * into v_row
from pricing_plan
where PRICING_PLAN_ID = 1;
dbms_output.put_line(v_row.price_cd);
end loop;
end loop;
close plan_id;
close channel_id;
end;
/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Feng, Jun
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
interesting problem with jdbc
Okay, I'll preface this by saying we did find a work around but this was strange and I wondered if any of you had run into this. Background: two 8.1.6.0 databases, one is Solaris 2.8 32 bit and the other is Solaris 2.6 the local database is on the 2.8 machine, call it users the remote database is on the 2.6 machine, call it compdata Public database link from users to compdata private synonym events for events@compdata in the users database. log into sqlplus, select * from events where id=# works fine via the java program jdbc 1.1, select * from events where id=# returns the first row you selected, no matter what id you subsequently give it. So id=4 as the first selected means that whatever id you now give it, it will return the data from id 4. drop the public synonym, create a copy of the events table on users. sqlplus AND the program run fine go back to the synonym across the link and the program blows up, sqlplus is fine (at least it's consistent) change the program code to select * from events@compdata and the program is fine so something is wrong not with the database, but with java settings, or jdbc drivers (1.1) or ? All other accesses with other links between the two databases are fine. The only other thing we could think of was that that program runs on an app server with an older version of WebSphere. Any ideas on what would cause this? As I said, we have a work around (hard-code the link) but I'd like not to have to do that Rachel __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Migration Workbench
When using the Oracle Migration Workbench in Oracle 8.1.7, the SQL Server 7 Source Model generates 6 errors. I then fix those errors and generate the model again. The problem I have is when I actually Migrate to Oracle. This procedure generates 69 errors. How can these errors be fixed? Am I doing something wrong? These errors occur on everything (indexes, procedures, tables, packages, etc.). Thanks, Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Brian King INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Slightly OT: Perl and PL/SQL Cursor Question
In PL/SQL, if I need to know if I've fetched the last
row, I can do this:
IF recCursor%NOTFOUND THEN
...
...
END IF;
How would I do this in Perl? Looking at the DBI docs,
there does not seem to be a similar method. It
suggests doing a COUNT(*) or possibly use the
following:
$hash_ref = $sth-fetchall_hashref('id');
So, any similar functionality to %NOTFOUND in Perl?
tia
mkb
__
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mohammed bhatti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE:
Ron, An outer join on sp.status will only return records from s if no records exist in the sp table. If a record exists in the sp table, it HAS to be a value of 'A'. I suggest he drop the 'and' clause altogether. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 02, 2001 3:21 PM To: Multiple recipients of list ORACLE-L You need the outer join on sp.status as well Ron Thomas Hypercom, Inc [EMAIL PROTECTED] cgrabowy@fcg. com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: com 10/02/01 12:00 PM Please respond to ORACLE-L SELECT s.study_id, s.status, sp.status FROM s, sp WHERE s.study_id = 5014 AND s.study_id = sp.study_id(+) AND s.status = 'A' AND sp.status(+) = 'A' -- outer join here as well What am I missing??!?!?!? TIA Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: oem job fails..solved
I found out the session which kept the table locked. killed it, jobs run fine now. thanks for help. Sunil Nookala -Original Message- Sent: Tuesday, October 02, 2001 12:37 PM To: Multiple recipients of list ORACLE-L that's not an oem problem per se... but is related to the fact that you are trying to update a row or table that is already in use review the updates and order of updates you are making. Is anything else running at that time? --- [EMAIL PROTECTED] wrote: Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Problems with patchsets to 8.1.7.0.0 on Windows 2000
Same problem, go into the install directory and Win32 I think it was, the install works fine from there. Just shear luck I just setup two Win2000 boxes in my lab for Replication, heh. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, October 02, 2001 2:29 PM To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install the 8.1.7.2.1 patchset according to the readme directions (shutdown all Oracle* services first, etc.), but when I try to run setup.exe, nothing happens. The icon flashes momentarily after being double-clicked, but nothing ever actually runs. I tried it a number of times. Then I tried it with an older 8.1.7.1.1 patchset - and the exactly same thing happened. These patchsets are for Windows NT, but I assumed they would work for 2000 as well. (Am I wrong in this assumption?) Does anyone have any experience with this and/or workarounds? -Don Granaman [OraSaurus - Honk if you remember UFI!] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
