RE: Query elapsed time

Dick V$session_longops has a column elapsed_seconds and a sid column HTH John -Original Message- Sent: 15 November 2002 18:59 To: Multiple recipients of list ORACLE-L Quick question, Does anyone know of a location in the V$ tables where the elapsed time of the current query is

Re: how to download all the openworld documents?

Does their has way that can download (or purchase CD) all the ORACLE Openworld documents? Some of the presenters alluded to them being uploaded somewhere, but I haven't found it. The presentations I saw, I simply emailed the presenter to get a copy. You might try this. HTH, Sean --

Netbackup [#2]

Is no-one out there using NetBackup???. Without wishing to sound rude I'll assume a non-response indicates an affirmative to that OR that you're all too busy to voice an opinion ;) -Original Message- Sent: Thursday, November 14, 2002 15:04 To: 'List, OracleDBA [Fatcity]' Howdy Folks,

Re:RE: Too many db calls

Cary, This is one topic I'll disagree with you. Assume an application that uses the database, but is on a machine outside the db server. Having a number of calls that return one or two rows will have a negative network impact that is the results of SQL*Net and it's inefficiencies. It is

[no subject]

Hi, How can I complie PRO*C code.Please Thnks

move USERS tablespace to locally managed

If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local), what are the steps I need to take? John John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET:

Re: Netbackup [#2]

Since no one else replied I will give you my experience: (Backupexec for oracle 816 on NT/2000) We are working with it and got backup speed up to 300MB per minute. There are some limitations: 1) Backupexec does not delete archive logs. We wrote a script that marked all existing archive logs

replace lines feeds in a string

I want to replace any carriage returns and lines feeds 'OD0A' and '0A' in string, with a space. Can this be done with TRANSLATE, if so how do I code this? John Dunn Sefas Innovation Ltd 0117 9154267 www.sefas.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John

RE: move USERS tablespace to locally managed

Hi John, If the TS contains just tables, and you have enough space, you could simply create a new users LMT, and alter table move the tables to the new tablespace. You could also export all of the objects from the DMT, and import them in to the newly created LMT (the old reorg method). Mark

Re:RE: Too many db calls

One thing to remember is that not every user call becomes a network interaction. It is actually far from that. For example: open, parse, bind, define, execute - is 5 user calls but one sqlnet round trip. (AKA bundled or deferred) Anjo. On Monday 18 November 2002 03:33, you wrote:

RE: Netbackup [#2]

Same experiences here too. When restoring to a different node, its a big proble manually moving all the DataFiles and Control Files out of their directories. Yechiel, can you elaborate on how you mark and delete the archive logs? and how do you run the script from backupexec? Please attach the

RE: How to identify objects that will fail to extend?

Rich, How about using the next_extent*2 compared with the select max(bytes) from dba_free_space where tablespace_name ='tablespace name in question'; That will show you if there is enough free space for two extents or more. I display sum(bytes) and max(bytes) to give a complete picture of the

RE: move USERS tablespace to locally managed

John, Why would you *not* want to use the package provided by Oracle? The answer to your question is to: 1). create a new USERS tablespace 2). issue ALTER TABLE table_name MOVE new_tablespace commands 3). issue ALTER INDEX index_name REBUILD commands. 4). issue ALTER USER username DEFAULT

RE: New development in Cobol or PL/SQL - please help

Babette - For some code, PL/SQL will offer significantly better performance. For other code it may not matter so much. One of an organization's biggest hidden investments is their code. If they feel COBOL is where they prefer to invest, that isn't the end of the world. For one thing, it doesn't

RE: Event 10046 and Performance

Title: RE: Event 10046 and Performance No, we are 9201 on Test/Prod ... we are getting ready to test 9202 though ... As Cary suggested ... I am going to watch is today ...let's see ... it would be interesting .. Raj __ Rajendra Jamadagni

RE: raw versus Mounted File Systems

Vivek - There used to be a good paper on Oracle's website. The paper asked the question: If benchmarks show raw to be faster that file systems, why don't you see a difference in production? The answer the paper provided is that on a well-tuned OLTP system, disk isn't the bottleneck. There are many

RE: New development in Cobol or PL/SQL - please help

Babette, The decision really comes down to the organization. If they see themselves as *never* leaving the Cobol arena, and they have an ample supply of Cobol programmers, then they should stay with it. What you could do is to make friends with the applications people, and show them how PL/SQL

Re: Netbackup [#2]

Worked at a place with NetBackup on top of RMAN for enterprise backup ie about 50 servers all going to mega storage tek tape library. No problems with software - just make sure the hardware infrastructure is up to pace with what you need. In this case, a private backup network made a lot of

Re: RMAN backup

And of course there is the obvious reason, a level 0 also backs up the controlfile. This is essential for point in tijme recovery. Ruth - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Saturday, November 16, 2002 1:23 PM

Re: move USERS tablespace to locally managed

roughly speaking create new tablespace X for each table alter table move tablespace X for each index alter index rebuild tablespace X hth connor --- John Dunn [EMAIL PROTECTED] wrote: If I want to move my USERS tablespace to locally managed(without using dbms_admin.migrate_to_local),

Re: replace lines feeds in a string

Hi, Why not just use the replace function? select replace('Line1'||chr(10)||'Line2',chr(10),' ') from dual select replace(my_string,chr(13)||chr(10),' ') from my_table; HTH, -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 11/18/2002 7:18 AM, John Dunn [EMAIL PROTECTED] wrote: I want

Re: replace lines feeds in a string

select replace(input_val,search_val,replacement_val) from ... hth connor --- John Dunn [EMAIL PROTECTED] wrote: I want to replace any carriage returns and lines feeds 'OD0A' and '0A' in string, with a space. Can this be done with TRANSLATE, if so how do I code this? John Dunn Sefas

RE: raw versus Mounted File Systems

Dennis, I think the paper you ae thinking of is Makingthe decision to use raw devices, and it's MetaLink Doc ID 29676.1. It was written by this guy named Cary Millsap, who seems to think he knows a thing or two about Oracle performance tuning;-) -Mark On Mon, 2002-11-18 at 08:28, DENNIS

RE: move USERS tablespace to locally managed

Tom, There are actually reasons not to use the package Oracle supplies to go from DMT to LMT. For the full details, see Connor McDonald's paper on http://www.oaktable.net/ . -Mark On Mon, 2002-11-18 at 08:08, Mercadante, Thomas F wrote: John, Why would you *not* want to use the package

RE: New development in Cobol or PL/SQL - please help

Babette, If they are a Cobol shop then there is nothing wrong with using Pro*Cobol. I disagree with your statement about using PL/SQL for the business logic. I personally think you should put as much of that in the database. Rick

RE: RMAN backup

Joe - Which type of RMAN backup are you doing? If you are doing RMAN datafile backups, then the size of your datafiles matter. If you are using the RMAN backup command, you are creating RMAN backup pieces. RMAN backup pieces contain parts of several data files, and you can't control that. You can

RE: Oracle Developer Application Tuning Resources/Guidlines.

You should take a look at the book Oracle Performance Tuning 101 as a good foundation. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 11:23 PM To: Multiple recipients of list ORACLE-L Hi All ! I am new to

RE: AIX vs Solaris

We had IBM come in and try to tune the depth queue - apparently there is some bug between their aix box and the hitachi san - they could only get a depth queue of 1 - whereas the sun box could go to a depth queue of 32. [EMAIL PROTECTED] 11/17/02 08:18AM John, You should be able to tune

Re: Event 10046 and Performance

I am in the middle of this fight myself. We had an Oracle consultant come in to look at our performance problems. He spent a 3 days examing the sql and coming up with various reasons that our code was slow. Then the "BUG" cropped up - one of his reports that had been running great all of a

RE: New development in Cobol or PL/SQL - please help

Title: RE: New development in Cobol or PL/SQL - please help Rick, You put BI into db using pl/sql anyways ... (well Java is another thing ..) Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

Oracle Portal w/Single-signon

Saw demos of Oracle Portal and really liked it. Have decided to implement it. We are also running Oracle Apps 11i (11.5.3 patched to 11.5.6+). From what I have seen it appears that portal must be installed in the 11i database. This just does not seem to make sense. Why would my intranet

Anyone using Net appliance near store r100

I've got a new client thats just about sold on it but they are looking for third party verification of anyone using it and if it works as stated. thanks, joe

RE: [Q] MS ODBC for ORACLE driver connection problem!!

Try using the 'Home Selector' utility to set the appropriate default home and then give it a go. Regards, Charu. -Original Message- Sent: Friday, November 15, 2002 3:49 PM To: Multiple recipients of list ORACLE-L We are testing the ORACLE 9iR2 client server connection. On PC side, we

RE: Query elapsed time

V$session_longops only store info for create index, etc, not query. Oracle use buffer_gets/500 as estimated time, you can get it at v$sql, v$sqlarea -Original Message- Sent: Monday, November 18, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Dick V$session_longops has a column

RE: AIX vs Solaris

HP-UX does support async I/O. /you only need to include /dev/async in the kernel. IBM and SUN support async I/O, too. Linux does not. -Original Message-From: Rich Holland [mailto:[EMAIL PROTECTED]]Sent: Sunday, November 17, 2002 9:19 AMTo: Multiple recipients of list

RE: move USERS tablespace to locally managed

Mark, Thanks for the reference. But it seems to quibble with detail that may not affect very many people. My conclusion after reading of what was found is to go ahead and use the package. If you experience the error reported, then the site gives an appropriate work-around. It dopes not,

RE: Oracle on MVS able to submit JCL ??

Babette, If you are on a UNIX platfrom you can ftp the JCL directly to the JES reader to submit a job on the mainframe. You need to set the parameter site filetype=JES. On my web site (http://www.oracle-developer.us/code.htm) I have code posted to allow Oracle 8i or greater to FTP directly from

RE: Anyone using Net appliance near store r100

Joe - We have a Net Appliance on our test system. It works well for that purpose, but I wouldn't use it for a critical production application. What are they planning to use it for? We have had ours for maybe a year - have they made some improvements since then? How are you planning to hook it in -

RE: raw versus Mounted File Systems ...

Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or Mounted Filesystem? Qs Like Filesysem Block Size (e.g. 8K) , is there a Concept of Block-size on raw devices / partitions ? -Original Message- Sent: Monday, November 18, 2002 1:03 PM To: Multiple recipients

FW: Export from Previous Release

I didn't see this show up this morning, so I'm asking again... -Original Message- Hi all, My developers are using a 9iR2 client and need to run exports against a 9iR1 instance. Has anyone seen anything like this? I seem to remember a descussion at one point saying that it was possible

Re:RE: New development in Cobol or PL/SQL - please help

I disagree with your last statement. Since IBM purchased informix, we are in battle with their so-called concurrent licensing ripoff. [EMAIL PROTECTED] 11/17/02 09:43PM Ron, Thankyou, I appreciate it. And for the individual who proposed that it might be better to do it in Pro*Cobol for

RE: raw versus Mounted File Systems

Mark - Thanks very much. You are right, that Cary guy really nails those performance issues. The original paper date is 1992. I guess that if you say something about Oracle over 10 years ago and it is still relevant, that would have to qualify as a classic. Dennis Williams DBA, 40%OCP Lifetouch,

RE: raw versus Mounted File Systems ...

1)It's your choice. Both could be done. 2)No -Original Message- Sent: Monday, November 18, 2002 10:19 AM To: Multiple recipients of list ORACLE-L Qs.Using Veritas for Striping across Raw Devices ,creates a RAW partition or Mounted Filesystem? Qs Like Filesysem Block Size (e.g. 8K) ,

set arraysize in Pro*C

Dear List-Members, Some of the batch queries can be improved by increasing the arraysize to 1000 ( the default in SQL*Plus is 15); I would like to find out the equivalent of this in Pro*C programs. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

[Q] ORACLE 9i fast_start_mttr_target and log_checkpoint_interval parameter?

I saw a document mention if log_checkpoint_interval define on ORACLE 9i, the fast_start_mttr_target parameter will be ignore. My question is: 1. we have following on init.ora file: log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 log_checkpoints_to_alert = true

RE: move USERS tablespace to locally managed

One thing my article did not cover was of course the possibility that you end with up with a miniscule extent size multiple in the bitmap because you have to existing extent sizes that are close to being relatively prime. Will this hurt...dunno really. I haven't played with deliberately

RE: RE: Too many db calls

Dick, I think you've misunderstood me. I'm not advocating the case for doing joins in the client or anything like that. I'm saying only that PL/SQL makes it too easy to write code that is extremely db-call-inefficient. Here's an excerpt from a Hotsos-internal document written by Jeff Holt that is

Re: set arraysize in Pro*C

It is implicitly declared by the smallest array used in the EXEC SQL statement. Thus, in the EXEC SQL DECLARE section of the PRO*C program, if one array were declared with 100 elements and another with 50 elements and both were used in the same EXEC SQL statement, then PRO*C would perform array

Re: Oracle SAN Experiences?

Some observations based on experience. Allocating storage based on the controllers helps if the database is large enough. e.g. 1 controller manages 100G of physical disk. Use that as a mount point. This does improve io somewhat if you can have mount points in 100G multiples (or whatever your

Re: how to download all the openworld documents?

Try this link: http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html I went to openworld.oracle.com , and click my way through to get to the above link. Gillian [EMAIL PROTECTED] wrote: Does their has way that can download (or purchase CD) all the ORACLE Openworld

Re: set arraysize in Pro*C

I have not done it for a while but look in the precompiler options. There is an option to increase. Rick Govind.Arumugam@

RE: raw versus Mounted File Systems

-Original Message- Sent: Monday, November 18, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Mark - Thanks very much. You are right, that Cary guy really nails those performance issues. The original paper date is 1992. I guess that if you say something about Oracle over 10 years

Re: how to download all the openworld documents?

Thank you, but what I want is download 'ALL' docuemnts NOT one by one. From: Gillian [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: how to download all the openworld documents? Date: Mon, 18 Nov 2002 10:18:30 -0800 Try

RE: how to download all the openworld documents?

Well, for myself, I'm glad to have ANY access. So thank you, Gillian, and no buts about it. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 18, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Thank you, but what I want is

RE: Query to predict failure on second extent of segment

OK, once again, this isn't what I'm looking for. Comparing NEXT_EXTENT*2 to the largest free space will only work in some cases. Consider that a segment has NEXT_EXTENT of 30M and there are two 40M free spaces in the TS. The segment clearly has enough room to extend twice, but comparing

OT: Informix Training for Oracle DBAs

I just inherited responsibility for a set of informix databases. Has anyone taken the Informix Training for Oracle DBAs, 4 day crash course given by IBM Informix and was it worth it? Thanks, Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET:

Hint-O-The-Day: MetaLink index pages search

Hey all, Just a helpful Hint-O-The-Day for quick searching of MetaLink. I'm sick of having to weed through every search because the results are flooded with DEC Rdb links (an issue that Oracle hasn't resolved yet). Under the Advanced Site Search, I entered: {library index} as my Keywords,

RE: Query to predict failure on second extent of segment

Yes, this is a nice query, but it doesn't address my original topic. I've changed the subject to reflect the thread I orginally started. Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA

Cognos Reporting Tool

Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman --

RE: how to download all the openworld documents?

ditto. Even one by one isn't bad if you didn't get to be there April Wells Oracle DBA Great spirits have always encountered violent opposition from mediocre minds -- Albert Einstein -Original Message- Sent: Monday, November 18, 2002 2:49 PM To: Multiple recipients of list ORACLE-L

RE: how to download all the openworld documents?

wget might do the trick. -Original Message- From: dist cash [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Re: how to download all the openworld documents? Thank you, but what I want is download 'ALL'

Re: OT: Informix Training for Oracle DBAs

I just went to the DB2 UDB fast track for experienced DBA at IBM. If it's 4 days then it should be fine. Our course was only 2 days and we asked so much questions that we only saw two third of the topics (and we had done overtime). As usual, it depends a lot on who is giving the course. ---

clustering Win2000 Oracle DB Server

Hi All! Could some one pointed me to the good source of info about clustering Win2000 Oracle DB Server? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

sys.aud$ - auditing user activities?

Hello All, Do any of you have suggestions for a good way to monitor sysdba user activities on the sys.aud$ table? Or, in terms of logging everything, what would be the keypoints to log scrub on? Any suggestions would be wonderful. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

How to make ORACLE Developer 6i understand ORACLE 8i client?

We used ORACLE developer 6i on PC. The ORACLE Developer 6i use ORACLE 8.0.5 client. We don't have ORACLE 8.0.5 client. Does their has way to make ORACLE Developer 6i connect through 8i client? Thanks. _ Tired of spam? Get

FW: sys.aud$ - auditing user activities?

-Original Message- From: Dana Mueller Sent: Monday, November 18, 2002 11:45 AM To: '[EMAIL PROTECTED]' Subject: sys.aud$ - auditing user activities? Hello All, Do any of you have suggestions for a good way to monitor sysdba user activities on the sys.aud$

Re: Query to predict failure on second extent of segment

Jesse, Rich wrote: OK, once again, this isn't what I'm looking for. Comparing NEXT_EXTENT*2 to the largest free space will only work in some cases. Consider that a segment has NEXT_EXTENT of 30M and there are two 40M free spaces in the TS. The segment clearly has enough room to extend

RE: how to download all the openworld documents?

-Original Message- Sent: Monday, November 18, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Try this link: http://www.oracle.com/oracleworld/sanfrancisco/conference/ems_search.html I went to openworld.oracle.com , and click my way through to get to the above link. Gillian

Updated Question (sorry for the spam)

Is there a way to log the sysdba account accessing sys.aud table? In my reading, I have not found a solution to this yet. Thanks Again, Dana Mueller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services--

Running/Licensing Hyperthreaded Intel Pentium4 Xeon CPU's on Linu

OK, I've got this new Dell Linux server with 4 Hyperthreaded Pentium4 Xeon CPU's. There are 4 physical CPU's but with hyperthreading the O/S sees 8 CPU's as is reported in top. I've installed Oracle on this machine and it seems to run as if there really were 8 CPU's. Could that be true? Is there a

RE: clustering Win2000 Oracle DB Server

-Original Message- Sent: Monday, November 18, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Hi All! Could some one pointed me to the good source of info about clustering Win2000 Oracle DB Server? Thanks. Greg. There _are_ some interesting articles from OpenWorld grin ...

Re: Hint-O-The-Day: MetaLink index pages search

Now if you could just save those preferences so they always came up... Debi At 11:38 AM 11/18/2002 -0800, Jesse, Rich wrote: Hey all, Just a helpful Hint-O-The-Day for quick searching of MetaLink. I'm sick of having to weed through every search because the results are flooded with DEC Rdb

RE: Too many db calls

Does anybody knows if it possible to implement something like bulk binds and bulk collection facilities using VB - like ADO. Alex Hillman -Original Message- McDonald Sent: Saturday, November 16, 2002 1:19 PM To: Multiple recipients of list ORACLE-L With the advent of bulk bind and bulk

RE: RE: Too many db calls: Follow up question

Hi folks, I have one follow-up question on this. Suppose you are doing commit work with pl/sql with large amounds of data and you are limited in rollback size. The goal being that you wish to fetch Large amounts of data and use to commit data inserts to an unrelated table. Of course, you don't

Re: Netbackup [#2]

Sean, Mostly the 'too busy' category. NBU works fine for us so far, not quite done implementing. It does more than schedule RMAN, NBU keeps a catalog that tracks which tape a backup is on for a given date, so that you don't have to. Jared O'Neill, Sean [EMAIL PROTECTED] Sent by: [EMAIL

RE: how to download all the openworld documents?

Oracle sets it up so that it's impossible to download them all. and to be honest, when I went out to the site, and looked over the Database presentations, I only WANTED a few of them. There are only so many sales pitches I can read, I don't use RAC so I wanted none of the RAC presentations (and

RE: How to make ORACLE Developer 6i understand ORACLE 8i client?

Hello, Well, I believe that it just wants to use part of the Oracle 8.0.5 client, and during the install, you can direct the 8.0.5 files to a non-invasive folder. Having said that, you will have to modify your env path to put your 8i bin path ahead of the Designer bin path (unless of course, you

Re:

Platform please?? Dick Goulet Reply Separator Author: sultan [EMAIL PROTECTED] Date: 11/18/2002 3:53 AM Hi, How can I complie PRO*C code.Please Thnks !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META

Re: sys.aud$ - auditing user activities?

SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i with the AUDIT_SYS_OPERATIONS parameter set to TRUE. SYSDBA operations are always logged to the OS audit trail, including access/modifications to the SYS.AUD$ table... The reason that these records are only logged to the

Re[2]:RE: New development in Cobol or PL/SQL - please help

Gene, Well at least I'm not the only one who got tossed out of the frypan into the fire!! Dick Goulet Reply Separator Author: Gene Sais [EMAIL PROTECTED] Date: 11/18/2002 7:27 AM I disagree with your last statement. Since IBM purchased

RE: raw versus Mounted File Systems

I have framed a Basic Doc on RAW Versus CFS , Mounted FS I will send it directly to any who seek it for review , perusal . Thanks to all who helped in making the same -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City

SQL puzzle - using where (a, b, c) in select (a, b, c from...) an

Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null Maybe there is a simple solution, but I'm too tired to think of one now. I have two tables, widgets and widgets_copy. Each table has columns that can contain null values. SQL select id, cost,

RE: sys.aud$ - auditing user activities? - follow up

Tim - Thanks for the well worded response. Very, very helpful. So my next question: Are there any 3rd party applications available to do what Oracle won't? -Original Message- Sent: Monday, November 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L SYSDBA activities are not

Re: Cognos Reporting Tool

On DW project, we have used Cognos Impromptu and Powerplay tool in 1998-1999. We used the client-server version as Powerplay for the web was a tool bought from another company and was not quite integrated with the other Cognos products. The main drawback were that the Powerplay part to build the

Re: sys.aud$ - auditing user activities? - follow up

please be a little more specific? what exactly is it that oracle won't do? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 18, 2002 7:58 PM Tim - Thanks for the well worded response. Very, very helpful. So my next question:

SUMMARY: SQL*Net Message to client/SQL*Net more data to client

Well, I thought I'd let everyone know what we came up with. First of all many thanks to all who helped, Cary, Jared, Dennis, Anjo and others. Everyone gave me more ammo to point the finger outside the database and some of the suggestions started a better dialogue between our different groups

How to compile Java code Pro*Cobol.

Dear Friends, How to compile Java and Pro*Cobol from Windows flot form. thanks * * +++ *+M Ramesh + *

RE: sys.aud$ - auditing user activities? - follow up

Tim / All. I figured it out. Basically assign users SYSDBA privies and track accordingly. -Original Message- Sent: Monday, November 18, 2002 7:44 PM To: Multiple recipients of list ORACLE-L please be a little more specific? what exactly is it that oracle won't do? - Original

RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...) an

Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null Since Id, Cost and Sell are all NUMBERs, so they cannot contain CHARs, which makes a perfect case for decode. You can useCHARs to substitute for NULLs in DECODE. Following is the query I wrote:

RE: SQL puzzle - using where (a, b, c) in select (a, b, c from...

Title: SQL puzzle - using where (a, b, c) in select (a, b, c from...) and columns can be null SQL edWrote file afiedt.buf 1 select * from widgets_copy 2* order by 1,2,3SQL / ID COST SELL-- -- -- 1 10 20 1 10 20 1 10 30 1 10 30 1 10 1 10 1 1 8