Fwd: UTL_FILE_DIR on 9iR2

just that other things have priority) - Bill Date: Fri, 16 Jan 2004 11:15:35 + To: [EMAIL PROTECTED] From: Bill Buchan <[EMAIL PROTECTED]> Subject: UTL_FILE_DIR on 9iR2 Hi all, I'm looking for some clarification on UTL_FILE_DIR on 9.2. I understand that this parameter is "

JVM for DBA

Java code! Thanks for any info. - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting ser

Fwd: Stored Outline Problem

Thanks for any help, - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

Stored Outline Problem

something? (CREATE ANY OUTLINE is granted) Thanks for any help, - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: orbitz fiasco

t it would be quicker to swap in a non-corrupt multiplexed copy but can't see why it should have been a disaster.). Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 85

Archive Destinations: quota_size

rror would automatically clear after REOPEN seconds when I empty the destination. Is this broken or am I missing something? (9.2.0.4 on Linux) Many thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services

Re: wakeup time manager

t falls under the category of "idle > events". Therefore I'm not going to worry about it too much - but would be > nice to know what it is. > > Thanks for any info > - Bill. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buch

Re: wakeup time manager

t falls under the category of "idle > events". Therefore I'm not going to worry about it too much - but would be > nice to know what it is. > > Thanks for any info > - Bill. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buch

wakeup time manager

ot;idle events". Therefore I'm not going to worry about it too much - but would be nice to know what it is. Thanks for any info - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-50

RE: Granting object privileges as SYS

ink Oracle keep rationing out these long-standing wish-list items with each successive release, in order to encourage us to take up those releases? Still waiting for DEFAULT_INDEX_TABLESPACE :-) - Bill.   Oh well, thanks again for the info!   Regards,   Paul -Original Message- From: Bill Buch

Re: Granting object privileges as SYS

schema X which grants the required table privileges (execute immediate) to Y and then run it (and drop it).  Not my idea - can't remember who first suggested it. HTH - Bill.   Regards,   Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.o

Fwd: Hidden Columns

when using function based indexes. - Bill. Date: Wed, 28 May 2003 14:42:31 +0100 To: [EMAIL PROTECTED] From: Bill Buchan <[EMAIL PROTECTED]> Subject: Hidden Columns Hi all, I know this is RTFM but I can't find the right part in the FM to R. So any help would be

Hidden Columns

IDDEN COLUMNS and it didn't seem to gather any stats for any columns. What is it meant to do? Thanks - Bill. PS. The complete syntax for the column is: FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan

OEM User Defined Job Environment

-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --

Re: best case scenarios for export/import

ing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -

RE: password

asysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Standards: Semicolon or Backslash

OTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services ---

Read Only Login with Source Visibility

8i. -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET

Re: Procedural Consistency

greatly appreciated... > >Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califo

RE: Lost ofall redo logs

Passo Fundo > Administrador de Banco de Dados Passo Fundo - RS - Bra5il > [EMAIL PROTECTED]http://www.upf.br > : > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gilberto Gampert

UFS logging

.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://

Re: Slightly OT: Rounding Negative Numbers

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

Slightly OT: Rounding Negative Numbers

hat is the mathematically correct rounding of -0.875?! Thanks! - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

Fwd: Lock against Inserts

This would appear to >make the trigger code too complex - surely there is a way to do this just >with simple locks? > >Any ideas much appreciated! > >Thanks >- Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED]

Lock against Inserts

is a way to do this just with simple locks? Any ideas much appreciated! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Calif

Re: Adding Control files

t; >Yechiel Adar >Mehish - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: What block size are you using for your new 9i data

nd have a 1-is-to-2 ratio of DB block >is-to FS blocks, you are still in danger of >overloading your I/O sub-system, "under the right >conditions". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat

RE: Number of CPUs vs. Speed of CPUs

For example, do we want fewer, faster CPUs or do > > we > > want more, slower CPUs? Are there any good guidelines to determine what > > the > > number of CPUs should be? > > > > Thanks in advance - > > Lisa > > -- Please see the official ORACLE-L F

Re: Recompiling Invalid Objects after Table Rename

>automatically using USER_REFERENCES prior to the drop table? - still seems >a bit clumsy) > >Does anyone have any comments on doing this? > >Many thanks >- Bill. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Bill Buchan >

Recompiling Invalid Objects after Table Rename

inaccurate over time. (Could maybe do this automatically using USER_REFERENCES prior to the drop table? - still seems a bit clumsy) Does anyone have any comments on doing this? Many thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET

Re: OCP-Network Exam

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 subscribi

DEFERRED FK Constraint

y it takes several seconds to create the constraint in the first place). Any insight welcome! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Linux for Big(ish) Databases

We've got a new database to put together. OLTP, 100-200 users, ~250Gb data. We haven't decided on a platform for this yet. Is Intel/Linux worth considering for this size of thing? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: B

Re: Old Chestnut: Tablespace Fragmentation

the place as it may >do with multiple extents "randomly" allocated. > >Any thoughts? > >Thanks >- Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

Old Chestnut: Tablespace Fragmentation

the disk to the other rather than bouncing about all over the place as it may do with multiple extents "randomly" allocated. Any thoughts? Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network

inode density for Oracle filesystems

static file archives.I'm tempted to rebuild the filesystem with more inodes. Any reason why not? (This is UFS on Solaris) Thanks for any info - Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Ser

Re: How Can I get A sequence Current Value in PROC

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: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Fwd: RE: Raw partition Vs File System

gt; >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >

RE: Need help rewriting SQL with TRUNC function

Guru') 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). -- Pl

Re: Import questions

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: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: ORA-01720 while trying to grant select on a view

roblem? Anybody can throw some light >on this? > >Thanks and Regards, > >KR >-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Re: Raw partition Vs File System

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). -- Intasys Billing Technol

SEGTYPE=DATA in v$sort_usage

ritical - just curious! >- Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Data Auditing

- Log Miner isn't really practical). Many thanks for any suggestions. - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

WHERE CURRENT OF Question

where current of c1; 7> end loop; 8> end; 9> Statement processed. SQLWKS> select * 2> from test_table 3> COLUMN_A COLUMN_B -- -- 1 4 2 6 3 8 3 rows selected. --

Any experiences with JDBC?

stage? We're interested (of course!) in stability, reliability and performance. Many thanks for any insights! Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: Platform

Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (8

Re: Upgrade to 8.1.7.2 on Linux -- an interesting happening

>also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet a

RE: Lots and lots of redo logs

t; > > > > >Hi > > > > > > > > >Yes you can untill the day that you have this runaway process that >creates > > >20Gb of redo and than crashes your database 5 minutes before the daily > > >offline backup should kick in. &g

RE: Lots and lots of redo logs

logs will never pull blocks from that area. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-

RE: Lots and lots of redo logs

;20Gb of redo and than crashes your database 5 minutes before the daily > >offline backup should kick in. > > > >But you are only mirroring, why not put your database in archivelogmode. > >You do not have so much redo per day that your disks/archiver can't handle >

Re: Lots and lots of redo logs

e this is the behaviour anyway). > > > >Jack -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Lots and lots of redo logs

formance) that I should consider? Any comments much appreciated. Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--

RE: PL/SQL changes (8.1.6 -> 8.1.7)

06550: line 3, column 9: >PLS-00307: too many declarations of 'TO_CHAR' match this call >ORA-06550: line 3, column 2: >PL/SQL: SQL Statement ignored" > >Additionally, if I remove the NVL(), then it also fails, as above, on >8.1.6. I'd be grateful for any pointers

PL/SQL changes (8.1.6 -> 8.1.7)

ils, as above, on 8.1.6. I'd be grateful for any pointers. Thanks - Bill. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cali

Dumb MTS Concepts Question

l ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

LinuxFS for Oracle

CLE-L FAQ: http://www.orafaq.com -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV