What gets written to redo on a rollback?

Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Join Query Question

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Join vs. Subselect

ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

log_archive_max_processes

documentation I have seen says it is supposed to default to 1. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services

Can I index this query?

of a varchar2(4000) field. Understandably, their query is slow. Is there anything I can do with an index to speed this up? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS

RE: oracle 9i desupport dates

Yes. 9i Release 2 is the final version of 9i. Thats why its desupport date is so much further out. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002

sqlplus question

space 0 linesize 5000 pagesize 0 echo off recsep off feedback off heading off trimspool on colsep | Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED

RE: sqlplus question

I don't want just 4. It's variable length and I want the actual number of valid bytes. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 19, 2002 9:51 AM To: '[EMAIL PROTECTED]'; Carle, William T (Bill), ALCAS

RE: Decode

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: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: SQL Query tuning help

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Schedule Statspack Report Creation

, William T (Bill), ALCAS 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

Oracle Data Compression

] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Importing .dbf files into Oracle

Hi, Is it possible to import .dbf files that were created in dbase III+ into Oracle? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat

Download site for Oracle 9.2.0.1 Upgrade

Hi, Where can I find the site to download the 9.2.0.1 upgrade. We currently have 9.0.1' Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED

RE: oracle 9i

(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: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services

RE: SMON Using Lots of Memory in 9i

that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be using lots of memory. (more than 50 mb) Has anyone else seen this or can explain it? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL

SQL Question

; This worked fine, but I was wondering if there was a way to do this in one query without having to create a view. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL

OCI and Oracle 9i - Install Question

Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access