netappfilers

2003-03-07 Thread kommareddy sreenivasa
Hi All: OS: solaris 2.8 DB: 8i I am new to the concept netappfilers. I dont know even abc of this. What I know is, they are some sort of disks and used to improve I/O. Can somebody through some light on this ? if anybody have any documentation, URLs etc, can you pass it to me? Thanks and

raw devices

2003-03-07 Thread kommareddy sreenivasa
Hi all: OS: Solaris 2.8 How do I know that a device is Raw of coocked ? We are using Quick I/O for some of our instance. Just curious to know the devices are raw or coocked. Thanks and Regards, Srinivas __ Do you Yahoo!? Yahoo! Tax Center -

Error SQL 02115 Code interpretation problem check COMMON_NAME usage

2003-03-07 Thread VIVEK_SHARMA
At a production databaseafter making a Pro C source changewe are getting the Orace error SQL-02115 "Code interpretation problem -- check COMMON_NAME usage" The same executableworks fine on another Dummy machine with atestdatabase Oracle 8.1.7 on Compaq Tru64 Unix 5.1 Production

how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread kranti . pushkarna
Hi Gurus, Is there any way to find out which queries are taking say more than 20 min in oracle 8.1.7 Database. Regards, Kranti Pushkarna This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it

64 bit shared library

2003-03-07 Thread John Dunn
I am trying to create a 64 bit version of a shared library that I currently use. This is for use with Oracle 9i. When I try to access this shared library Oracle complains Cannot run a file that does not have a valid format What do I need to do differently to create a valid 64 bit .so file on

Re: Character Set / Encrypted text question

2003-03-07 Thread Bjrn Engsig
As I noted in my other reply to this thread, you should NEVER use any character datatype (char, varchar, varchar2, clob and their 'N' versions plus long) to store any sort of binary data. ?If your data is binary, it must be stored in one of the binary datatypes, RAW, BLOB (or LONG RAW in

Re: Fudging outlines

2003-03-07 Thread Bjørn Engsig
I have been using the attached script to do exactly this on an 8.1.7 database - usual disclaimers apply. /Bjrn. Chuck Hamilton wrote: I have an application query that I do not have the source code for. It gets a crappy execution plan. I can add a hint or two to it and significantly

Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Prem Khanna J
Guys, SQL drop tablespace DATA14 including contents; Tablespace dropped. the name of the datafile in DATA14 tablespace is DATA141.DBF SQLselect * from v$tablespace where name = 'DATA14'; no rows selected SQLselect * from v$tdatafile where name = 'DATA14.DBF'; no rows selected when i try to

RE: 64 bit shared library

2003-03-07 Thread Stephane Faroult
I am trying to create a 64 bit version of a shared library that I currently use. This is for use with Oracle 9i. When I try to access this shared library Oracle complains Cannot run a file that does not have a valid format What do I need to do differently to create a valid 64 bit .so file on

RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Stephane Faroult
Hi Gurus, Is there any way to find out which queries are taking say more than 20 min in oracle 8.1.7 Database. Regards, Kranti Pushkarna Switch your mobile phone on :-). Unless you put your database in trace mode, it is fairly difficult to get this information. Something which comes to

RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread kranti . pushkarna
Stephane, LAST_CALL_ET lets u know that user is idle for so long (correct me id i am wrong) and I want to know which queries are taking long time. Unfortunately I cannot use Oracle trace for it. Regards, Kranti Pushkarna

Re: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Waleed Khedr
Try again after 5-15 minutes. Waleed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 5:54 AM Guys, SQL drop tablespace DATA14 including contents; Tablespace dropped. the name of the datafile in DATA14 tablespace is

RE: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Mercadante, Thomas F
Jp, (B (BIf you bounce the database (shutdown normal Startup), you will be able to (Bdelete the file. Sometimes, NT (or Oracle on NT) does not immediately (Brelease the file. By bouncing the database, you will be able to delete it. (B (BHop this helps. (B (BTom Mercadante (BOracle

Re: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Connor McDonald
You could upgrade to ver 9 where there is an elapsed time column in v$sql - very very nice. In ver 8, run some queries of your own to get a reasonable figure on how many disk reads and buffer reads you can do per second. Then look at the buffer_gets and disk_reads for each sql in v$sql to get a

RE: RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Stephane Faroult
LAST_CALL_ET means the elapsed time since the last call. If the session is inactive the idle time is therefore LAST_CALL_ET minus the (unknown) time taken to process this call. I have just checked on a 8.1.7 database an ACTIVE session for which LAST_CALL_ET was increasing each time I was

AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Stefan Jahnke
Hi Khanna(?) (B (BHappens alot. Windows still holds a handle to the file. Just wait 'till next (Bscheduled reboot (shouldn't be too long;). (B (BRegards, (BStefan (B (BStefan Jahnke (BConsultant (BBOV Aktiengesellschaft (BVoice: +49 201 - 4513-298 (BFax: +49 201 - 4513-149 (Bmailto:

RE: Tricky SQL Question

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: Tricky SQL Question Thanks Steven, I believe Tom touched on this in his discussion at recent Hotsos conference. My requirements were slightly different, but the logic is still good for me. Thanks Raj - Rajendra dot

RE: System tablespace Oracle 9202

2003-03-07 Thread Godlewski, Melissa
Title: RE: System tablespace Oracle 9202 This is a UNIX Solaris running 5.8 I created the database from sqlplus using scripts. I somehow thought the default was LMT for system rather then DICTIONARY. I changed the script to LMT and recreated, but I was surprised by the Dictionary system

Re: AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Prem Khanna J
thank u guys. (Bthanks for letting me know this. (B (BWINDOSE :- (B (B (B (B7-3-2003 21:53:50, Stefan Jahnke (B[EMAIL PROTECTED] wrote: (B (BHi Khanna(?) (B (BHappens alot. Windows still holds a handle to (Bthe file. Just wait 'till next (Bscheduled reboot (shouldn't be

Re: AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Prem Khanna J
thanks a lot stefan. (Bjust fedup with MS-Win. (B (B (B7-3-2003 21:53:50, Stefan Jahnke (B[EMAIL PROTECTED] wrote: (B (BHi Khanna(?) (B (BHappens alot. Windows still holds a handle to (Bthe file. Just wait 'till next (Bscheduled reboot (shouldn't be too long;). (B (BRegards,

RE: Tricky SQL Question -- Solved

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: Tricky SQL Question -- Solved Jonathan, Thanks for the tips ... let me see how I incorporate this ... things to do ... 1. write a *clever* routine to look at sys.mon_mods$ with dbms_stats.flush_database_monitoring_info to decide which tables to analyze in the next session. 2.

RE: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Khedr, Waleed
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab (Base_id=NOTp_id=222033.1 (B (B (BWaleed (B (B-Original Message- (BSent: Friday, March 07, 2003 8:00 AM (BTo: Multiple recipients of list ORACLE-L (B (B (BTry again after 5-15 minutes. (B (BWaleed

OS/390 Oracle Client TNS-3506

2003-03-07 Thread James Howerton
DBA's We are trying to get an Oracle client running on OS/390 so CICS and (pro*COBOL) can connect to a remote Oracle DB. After install we are trying to run TNSPING as a first step to demonstrate something is working, here is the error: TNS-03506: Failed to create address binding Any help

RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread Wolfgang Breitling
Title: RE: how to find elapsed time for a query in oracle 8.1.7 Database LAST_CALL_ET is the time the last call was made. So for a session in status 'INACTIVE' it shows since when it is inactive/idle, or if you subtract LAST_CALL_ET from sysdate, how long it has been inactive/idle. If the

Re: Fudging outlines

2003-03-07 Thread Chuck Hamilton
Title: RE: Fudging outlines I tried it but it's disabled in standard edition. It's the one instance I have running on standard edition and the only one I have a need to do this on. Murphy strikes again. - Original Message - From: Jamadagni, Rajendra To: Multiple recipients

RE: RE: how to find elapsed time for a query in oracle 8.1.7 Database

2003-03-07 Thread rgaffuri
I thought the accepted way to do this was to use SQLTRACE=TRUE and use TKPROF? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

remota / as sysdba

2003-03-07 Thread becker . bill
I have got this working now; I am able to connect remotely using connect sys/[EMAIL PROTECTED] as sysdba and able to do remote imports with sys as the userid. Thanks to the four J's (Jacques,Jared,Julie,Jeremiah) for their suggestions. The solution seems to be dropping and re-creating the

Re: AW: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Jared Still
Though this is how it works on NT, I was pleasantly surprised the other day when I was able to delete the files from a tablespace that had just been dropped on Win2k. Jared On Friday 07 March 2003 04:53, Stefan Jahnke wrote: Hi Khanna(?) Happens alot. Windows still holds a handle to the

Re: System tablespace Oracle 9202

2003-03-07 Thread Chuck Hamilton
Which is a good reason to save scripts from DBCA as opposed to having it create the DB for you. I always do this. I can't tell you how many times I tried to let DBCA create the DB directly only to have it crap out for one reason or another, and then you need to go back and plug in all the custom

Re: Re[2]: Export data to dbf

2003-03-07 Thread Jared Still
I don't know how to do this directly from Oracle, and I don't think that you can via SQL or PL/SQL. You could do so easily with Perl and the DBI, DBD::Oracle and DBD::XBase modules. DBD::XBase works with dbase files. Jared On Thursday 06 March 2003 20:58, Sergey V Dolgov wrote: Hello Jared,

RE: What privs are required to alter a trigger owned by SYS?

2003-03-07 Thread Rick_Cale
Yes but do you have an answer to original question Jamadagni,

Re: perl DBI question: fetchrow_array

2003-03-07 Thread Tim Bunce
On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote: 1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted. 2) I see you've already set RowCacheSize. Anecdotal evidence ( not just mine) suggests that the diminished returns obtained by setting this 100 aren't

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Chuck Hamilton
SAN is fine as long as you keep track of what's mapping to what physical disks. I for one don't believe the SAN vendors that say their caching takes care of performance for you and you don't need to worry about where data is stored physically. Place datafiles the same way you would for local

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Darrell Landrum
Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle. [EMAIL PROTECTED] 03/07/03 09:43AM SAN is fine as long as you keep track of what's mapping to what physical disks. I for one

RE: What privs are required to alter a trigger owned by SYS?

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: What privs are required to alter a trigger owned by SYS? Rick, My 2000 crashed yesterday and I lost my reply to you, so here it is ... alter any trigger is the privilege ... but here is a better solution ... create or replace sys.enable_trigg_proc is begin execute immediate

Oracle position on hints

2003-03-07 Thread Stephane Paquette
Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL

Re: netappfilers

2003-03-07 Thread Chip
http://www.netapp.com/products has Network Appliance (NetApp) product information. Have Fun :) kommareddy sreenivasa wrote: Hi All: OS: solaris 2.8 DB: 8i I am new to the concept netappfilers. I dont know even abc of this. What I know is, they are some sort of disks and used to improve I/O.

nt script

2003-03-07 Thread Joan Hsieh
Hi Dear list; I don't have experience on NT scripting. but I have an urgent need for nt script. Someone's help would be appreciated. Here is the question; How to convert this script to nt script? I need to reboot the nt server if there is any error on this sql statement instead of paging someone

Re: perl DBI question: fetchrow_array

2003-03-07 Thread Jared Still
Thanks Tim. I'll have to play with that code a bit. Jared On Friday 07 March 2003 07:09, Tim Bunce wrote: On Thu, Mar 06, 2003 at 02:54:19PM -0800, [EMAIL PROTECTED] wrote: 1) fetchrow_arrayref is faster than fetchrow_array, as Alex has noted. 2) I see you've already set RowCacheSize.

RE: System tablespace Oracle 9202

2003-03-07 Thread Godlewski, Melissa
Title: RE: System tablespace Oracle 9202 Isn't that the truth. GUI's don't seems to make our DBA work easier. -Original Message- From: Chuck Hamilton [mailto:[EMAIL PROTECTED]] Sent: Friday, March 07, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Subject: Re: System

Re: remota / as sysdba

2003-03-07 Thread Jared Still
Interesting. Was this on some flavor of windows? I've found it necessary to create a new password file when cloning a database, though according to the docs, that shouldn't be necessary. Jared On Friday 07 March 2003 06:44, [EMAIL PROTECTED] wrote: I have got this working now; I am able to

Re: remota / as sysdba

2003-03-07 Thread becker . bill
*** Comments by BECKER, BILL Fri Mar 07, 2003 -- 10:56:38 AM No Windows. Env is Oracle Enterprise 9.2.0.2 on Solaris 5.9 (or 2.9 or 9, whatever version number happens to be the version-du-jour) *** Original

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick
Darrell, Could I have a copy of that white paper if you still have it? Thanks, Scott At 08:19 AM 3/7/03 -0800, you wrote: Amen! For several years we heard from EMC reps, don't worry about it, don't worry about it, then recently we we're given a white paper from EMC on striping for Oracle.

RE: Oracle position on hints

2003-03-07 Thread Freeman Robert - IL
This is facinating, where does this come from? This is the second time in a week that I've heard this statement being made by someone. Hints will never go away IMHO, and Oracle continues to add more and more of them. I was told by someone at a client site that they were told by an Oracle

Re: Oracle position on hints

2003-03-07 Thread rgaffuri
Ive seen Tom Kyte post on his site that he doesnt like hints. However, even in 9i there are times when I need to use hints to improve performance. Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA

RE: Oracle position on hints

2003-03-07 Thread Khedr, Waleed
The first day hints are gone, I will change my career! I do not think it will go away, since Oracle itself uses them to control the way PQ slaves and other background processeswork. Also stored outlines is part of it. Regards, Waleed -Original Message-From: Stephane Paquette

RE: Oracle position on hints

2003-03-07 Thread Jamadagni, Rajendra
in 9202, oracle uses hard coded hints for recursive SQL ... and they say that analyzing SYS schema is okay ... Ha !! Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can

RE: Oracle position on hints

2003-03-07 Thread Pete Sharman
You just gotta wonder about some instructors. :( I haven't heard anything about them going away. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA. -Original Message-

RE: Oracle position on hints

2003-03-07 Thread Paula_Stankus
Title: RE: Oracle position on hints I heard this from a COTS vendor once. I also thought it was ridiculous. It is one of the useful ways to tune SQL Statements. I have only gotten the impression from their inception into the Oracle RDBMS that they were advocated by Oracle. -Original

9iAS Hardware Questions

2003-03-07 Thread David . Schmoldt
I have three questions pertaining to the hardware for Oracle 9ias with the infrastructure. 1) The server we are looking at purchasing comes with a choice of 2 processors. One is a 2.8 GHz with 512KB cache, the other is 2.0 GHz with 2MB cache. Does anybody have any suggestions or experience with

Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread rgaffuri
Yes, I know this isnt a job board and this is the one and only time Ill do it. The market is tight. My current contract is up in two weeks. Im a US Citizen(no clearance) and Im more developer than DBA. I have a good track record with strong references. Anyone know of anything? Preferably

Re: nt script

2003-03-07 Thread Joan Hsieh
Hi Jose, Many many thanks to you. This is great. Joan Jose Luis Delgado wrote: Hi!! I'll try to help you between lines... i.e. I'll write the corresponding CMD line for your script. Regards! JL in a .CMD file: echo Sending mail!!! echo Sending mail!!! dt=$(date

RE: Oracle position on hints

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: Oracle position on hints Pete when you say ... I haven't heard anything about them going away. you mean the hints or them instructors ?? Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly

RE: Oracle position on hints

2003-03-07 Thread Stephane Paquette
Hi, I have to write a SQL and PL/SQL guide for our developpers. Some are good but most of them can use help. I'm not a big fan of hints except for insert append, I used them only if I really need to. In last october I went to a 3 days DB2 UDB course, unless I miss something there are no hint

RE: nt script

2003-03-07 Thread Jacques Kilchoer
Title: RE: nt script Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin. For example, I have no idea what this statement does: FOR /F TOKENS=1,2* %%A IN ('DATE/T') DO

Re: Oracle position on hints

2003-03-07 Thread Jonathan Lewis
There's always the possibility of a gap between what was said and what was heard. In my seminar, I tell people about hints, and mention a useful ones - and then say they should avoid using them if possible. Perhaps the quoted instructor said something more like you shouldn't use hints in 9i if

RE: remota / as sysdba

2003-03-07 Thread Jacques Kilchoer
Title: RE: remota / as sysdba I'm glad that worked for you, but I've never had to recreate the password file after a password change. (In my little part of the world we have password files on databases ranging from Oracle versions 8.0 to 9.2 on both Windows NT/2000 and Solaris).

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Darrell Landrum
I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. [EMAIL PROTECTED] 03/07/03 10:55AM Darrell, Could I have a copy of that white paper if you still have it?

RE: nt script

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: nt script I have found http://www.calweb.com/~webspace/batch/index.htmto be useful. Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an

RE: Cannot delete datafile from O/S -- Help !!

2003-03-07 Thread Jacques Kilchoer
Title: RE: Cannot delete datafile from O/S -- Help !! (B (B (B (B (BAs others have said, it's probably because on Windows you sometimes have to wait a few minutes. (BI did want to mention that this statment: (Bselect * from v$datafile where name = 'DATA14.DBF'; (Bseems wrong to me, since

RE: Oracle position on hints

2003-03-07 Thread Molina, Gerardo
I have heard from Oracle that you should stop using RULE hints as the Rule-based optimizer (RBO) will eventually be retired or totally unsupported. We are moving away from analyze as well and using dbms_stats instead because analyze is also going away. Migrating to dbms_stats is a first step for

RE: nt script

2003-03-07 Thread Darrell Landrum
Windows NT Shell Scripting by Tim Hill is a very good start. [EMAIL PROTECTED] 03/07/03 12:34PM Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin. For example, I have

RE: Oracle position on hints

2003-03-07 Thread Pete Sharman
Title: RE: Oracle position on hints The hints, actually, but then I haven't heard anything of the instructors going away either! J Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no it's not. It's much harder than that! Bruce Pihlamae,

RE: nt script

2003-03-07 Thread Jeff Herrick
C:\ HELP and C:\ HELP FOR In there you'll find a note that the context variable should have '%%' instead of '%' in front of it when running in a bat file. You were using the bat file syntax from a command linewon't work. The opposite is also true...ask me how I know =8-) Jeff Herrick

ora-06512 errors - flushing shared_pool takes care of it - WHY?

2003-03-07 Thread Fedock, John (KAM.RHQ)
I have a perplexing issue that I hope someone may have some ideas on. We have aWindows2000 server using COM+ applications to connect to a 8.1.7.4 OPFS HP-UX database to process large amounts of EDI records. There is no pattern, but on average 2 times a week, this application that is

RE: nt script

2003-03-07 Thread Kevin Lange
Title: RE: nt script If you just do a HELP COMMAND, where command is the name of the command you need help on, you can find out as much as you really need to know about BATCH. In your sample of FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B They were trying to set a variable

Re: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Scott Stefick
That's great! Thanks a ton. -Scott At 10:44 AM 3/7/03 -0800, you wrote: I'm pretty sure I only recieved a hard copy (I'm not in the office to check), but they publish a lot of pdf documents on their site. I'll see if I can locate it there and send a URL. [EMAIL PROTECTED] 03/07/03 10:55AM

Re:RE: Oracle position on hints

2003-03-07 Thread dgoulet
Stephane, I'm going to agree with many on the list in that I don't believe Oracle will drop the concept. But on the other hand I don't like them either, not do I like the idea of stored outlines either. The reason is that with both your trying to ham string the optimizer into doing things

LPAR on AIX and Oracle Licensing

2003-03-07 Thread Henry, Keith
Our systems folks are talking about consolidating a couple of machines by using LPARs. If we have a machine running AIX with 6 processors, can we license Oracle with 2 processors if those are segmented out within an LPAR? It's always a challenge to get hold of our sales rep, so I thought I

RE: nt script

2003-03-07 Thread Darrell Landrum
One bump you might encounter is some of the more useful NT shell commands are only available from the NT resource kit. [EMAIL PROTECTED] 03/07/03 01:09PM C:\ HELP and C:\ HELP FOR In there you'll find a note that the context variable should have '%%' instead of '%' in front of it when

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Thomas Day
Send resume as word attachment to [EMAIL PROTECTED] I can't guarantee anything and you will have to be clearable but there's sure a lot of work going on here.

RE: nt script

2003-03-07 Thread Branimir Petrovic
Title: RE: nt script Do yourself a favour - resist temptation of even considering DOS batch "language" (as it isnothing morethan a horrid pile of I-won't-say-what;-) Better choiceis WSH and VBScript or JScript. Windows Scripting Host comes with every IE - therefore every Windows machine.

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Spears, Brian
We ran ORacle on NETapps... about a 100 Production Databases and I spent a massive amount (6months) of time verifying that Certain applications were not hindered by the Netapp SAN... There was alot of doubt buy everyone... but in the end it was clear the San preformed fine..and all the glitches

RE: perl DBI question: fetchrow_array

2003-03-07 Thread gmei
I tried fetch (which is same as fetchrow_arrayref): $dat-bind_columns(undef,\($row)); while($dat-fetch) { print DATA $row\n; } And it seems the performance improved a bit (about 5%). Using RowCacheSize or not does not seem to matter. The size of the table can vary from 1 row to 1

OT: Who Owns Unix?

2003-03-07 Thread Orr, Steve
Title: OT: Who Owns Unix? Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion: http://www.infoworld.com/article/03/03/06/HNsco_1.html How can this be?

Metalink related question

2003-03-07 Thread Jamadagni, Rajendra
Title: Metalink related question Call me whatever, but how the heck one find out what changes when the note on Metalink|My Headlines says Performance Locking Library Index changed on 2003/03/07. What changed? maybe I need glasses, but it hasn't been easy to find exactly which documents

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Ryan
clearance takes a long time to get. Ran into this before. I had to sign a bondage agreement before they do the background check. Cant stay unemployed for that long and its unethical for me to take a job with another company and quit on them. How are the bondage agreements with CSC? Everyone who

RE: Date format is unreadable

2003-03-07 Thread Nguyen, David M
Title: RE: Date format is unreadable It works better but it still does give correct output. I'd like to see hour,min,sec as well. 1 select user_name,node_name,to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400 from user_activity_log 2 from user_activity_log 3 where user_name =

Re: Fine Grained Access Control (FGCA)

2003-03-07 Thread Murali Menon
Hi Madhavan Thanks to you and Jonathan for the input. Another question on the same subject. How are policies defined for child tables. For example if you have anparent tablewhich has say company id so you define a policy on this column. now a parent child related table, the child tableis related

RE: Who Owns Unix?

2003-03-07 Thread Jacques Kilchoer
Title: RE: Who Owns Unix? Computerworld says: http://computerworld.com/governmenttopics/government/legalissues/story/0,10801,79153,00.html IBM has built its own AIX Unix under license since February 1985, when the company entered into a Unix license agreement with ATT Bell Laboratories,

Re: OT: Who Owns Unix?

2003-03-07 Thread Lyndon Tiu
But GNU is not UNIX. -- Lyndon Tiu Quoting Orr, Steve [EMAIL PROTECTED]: Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion: http://www.infoworld.com/article/03/03/06/HNsco_1.html How can this be? -- Please see the official ORACLE-L FAQ:

monitor transactions over time

2003-03-07 Thread Ehresmann, David
List, Does anybody know a way to monitor the number of transactions occurring over time, say 5 minute or 10 minute intervals? I am looking at v$undostat and it appears to have a problem accumulating transactions under txncount when it should report over a 10 minute interval ( metalink doc#

RE: Who Owns Unix?

2003-03-07 Thread Brian Dunbar
-Original Message- Sent: Friday, March 07, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Per the below link, SCO owns Unix and they're suing IBM for a paltry $1Billion: http://www.infoworld.com/article/03/03/06/HNsco_1.html How can this be? Which part? SCO owning 'Unix' or

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Sherman, Paul R.
Well, I'm not sure that you want to get into a bondage agreement, unless you like getting kinda kinky. You can get 'bonded' through a bonding agency (that does a background check of varying depth and intensity depending on the scope of the job's responsibilities. Not the same as getting a

Re: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Ryan
sorry about that one... didnt realize it went to you guys. :( - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 3:43 PM clearance takes a long time to get. Ran into this before. I had to sign a bondage agreement before they do

[no subject]

2003-03-07 Thread Schafer, Connie J
SET ORACLE-L NOMAIL SET RMOUG-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schafer, Connie J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Date format is unreadable

2003-03-07 Thread Jacques Kilchoer
Title: RE: Date format is unreadable to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400 is a DATE expression formatting of DATE values is done with the TO_CHAR function (see SQL Reference Manual) for example: to_char (to_date('01/01/1970', 'MM/DD/') + time_stamp / 86400,

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-07 Thread Jared . Still
NetApp SAN? My understanding of NetApps was that is strictly NAS: Network Attached Storage. Basically, JBOD with NIC. SAN's offer quite a few more management and configuration options than NAS. Jared Spears, Brian [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/07/2003 12:19 PM

RE: monitor transactions over time

2003-03-07 Thread Jamadagni, Rajendra
Title: RE: monitor transactions over time I wrote a script to fix the problem in 9202, but don't tell Oracle ... we want them to fix the bug. as soon as they know there is a workaround, the priority on the bug will go down. Log a iTar and request a patch ... the bug# is 2506744 Raj

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Scott Stefick
How do you get government clearance and why does it help with being a DBA other than working for a government agnecy? Just wondering. At 01:44 PM 3/7/03 -0800, you wrote: Well, I'm not sure that you want to get into a bondage agreement, unless you like getting kinda kinky. You can get 'bonded'

RE: Anyone looking fora Developer/DBA in Wash DC area?

2003-03-07 Thread Jacques Kilchoer
Title: RE: Anyone looking fora Developer/DBA in Wash DC area? This site explains some of the details on how to get a security clearance. http://www.taonline.com/securityclearances/scdetails.asp If you want to get one your employer has to apply for you. It can help you get jobs for a

RE: monitor transactions over time

2003-03-07 Thread Deshpande, Kirti
Title: RE: monitor transactions over time From what IknowOracle Development folks have identified the code changes to correct thisproblem. Just do not when Oracle would issue the patch. Since the bug was logged against 9i R2, patch would be provided. This bug was originally logged in Aug