Re: ORACLE-L Digest -- Volume 2003, Number 328

Thank you very much Regards Vaishali On Mon, 24 Nov 2003, Oracle RDBMS Community Forum wrote: ORACLE-L Digest Mon, 24 Nov 2003 Volume 2003, Number 328 In This Issue: Subject Author ---

Anybody familiar with OWB setup and config out there?

Hi! Is anybody out there familiar with OWB setup an config? We are having problems with the OWB-specific-listener required for OWB. This is OWB 9.0.4 on HP-UX 11.11 Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut INET: [EMAIL

RE: what is oracle rdb?

I heard that Lego is one a big user of RDB. Don't know if it's true. Patrice. -Original Message- Sent: Monday, November 24, 2003 6:04 PM To: Multiple recipients of list ORACLE-L I believe it *is* still sold; it is certainly still supported. As to why you would buy it, I don't know

AW: Experiences with Oracle and MS .Net data providers

Hi Some coworkers implemented an application using C# and the MS .NET provider for Oracle (9.0.1 DB). One thing I can remember: Mapping C#'s float datatype to Oracle FLOAT (or NUMBER(...)) somehow didn't work that great. Another thing was that they could not use transaction processing via the

Re: UNIX OT: exclude files in tar

It doesn't use the exclude, but it would do what you want: cd /home/user01 tar -cvf /dev/rmt0 mark01 mark02 where /dev/rmt0 is your tape device, or you can substitute a disk destination. HTH, Mike

WebSphere and Oracle

All, We are putting up a new Java application that is running under WebSphere. WebSphere uses two different schema's - the one where the application tables are all built, and another schema that contains one table (SESSIONS) that it uses to keep track of the application. This SESSIONS table has

Re: Re[2]: what is oracle rdb?

And then Tanel wrote: TP BTW, you can do this in 9i as well... Really? I think when you get down to it, there are some prerequisites to worry about. I just tried the following: C:\Documents and Settings\Jonathansqlplus /nolog SQL*Plus: Release 10.1.0.0.0 - Beta on Mon Nov 24 21:07:30 2003

Move datafiles, but can't delete them

Hi gurus, Oracle 8.1.7.4 on Windows 2000 Yesterday I wanted to move 2 datafiles (for the same tablespace) to another disk. 1- I placed my tablespace offline 2- I copied my 2 datafiles 3- I altered my controlfiles to reflect the new path 4- I brought my tablespace back online 5- I backuped up my

FW: RMAN Script

Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format

IOUG 2004

Title: RE: RE: Development vs. Production DBA I was informed last night that they accepted my seminar proposal, I will be doing an introductory session on how to administer Oracle databases. Hope to see many of you in Toronto next April. In the meantime if there are questions you would

RE: Move datafiles, but can't delete them

Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these files for some odd reason. In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. Tom Mercadante Oracle Certified

RE: Move datafiles, but can't delete them

Tom, I didn't know that I absolutely have to bounce the database. Tx Luc -Original Message- Sent: November 25, 2003 8:36 AM To: '[EMAIL PROTECTED]' Cc: Demanche, Luc Luc, The next time you bounce the database you will be able to delete the files. Windows keeps a lock on these

Re[2]: what is oracle rdb?

Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: BPJ I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. Heh, I just spent the better part of my Sunday afternoon buying compartmentized boxes and helping my son sort

RE: Move datafiles, but can't delete them

Luc, Its weird. I've seen it both ways. Sometimes, Windows releases the lock and allows you to delete the file, and sometimes it doesn't. Bouncing the database always allows you to do it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25,

Re[4]: what is oracle rdb?

Tuesday, November 25, 2003, 8:04:25 AM, Tanel Poder ([EMAIL PROTECTED]) wrote: TP Ok, it's not as simple as with RDB... You still need to start the instance. You'd need to create a control file first, wouldn't you? Or would all that default as well. Hmmm I should probably try it some time. I

RE: what is oracle rdb?

list lurker off Same opinion here, my company is in the process of migrating our software to run on Oracle 9iR2. Currently, we have over 325 production sites that have RDB databases running. RDB is a single schema database so each customer site has multiple databases running. Very easy to

RE: Re[2]: what is oracle rdb?

Jonathan Gennick scribbled on the wall in glitter crayon: Tuesday, November 25, 2003, 7:04:25 AM, Boivin, Patrice J ([EMAIL PROTECTED]) wrote: I heard that Lego is one a big user of RDB. Don't know if it's true. As in Lego blocks? Cool. AFAIK, it's THE largest user of RDB. but that was

RE: Move datafiles, but can't delete them

What is most likely happening is that a server, as in client dedicated, has an interest in those files consequently Windoze won't let you delete then until the end user terminates their session. Now while Unix won't give you an error in this situation you'll notice that you don't get the disk

Re: Experiences with Oracle and MS .Net data providers

On 11/25/2003 07:39:30 AM, Stefan Jahnke wrote: Hi How is it, that data providers can be in incompatible in .NET ? Stefan Stefan, lets talk about obscene language. As you know, obscene language is not always the same. The phrase zum Donnerwetter can and will be understood as swearing,

RE: Move datafiles, but can't delete them

.. and the reason you don't get the space back immediately is because the file is still open, and not actually deleted yet. Jared On Tue, 2003-11-25 at 06:24, Goulet, Dick wrote: What is most likely happening is that a server, as in client dedicated, has an interest in those files

RE: WebSphere and Oracle

The problem is most likely in the JDBC driver, not the database. I've run into similar problems with JDBC and ODBC drivers in the past. I've got to agree with IBM, upgrade the driver all should be well. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent:

RE: Move datafiles, but can't delete them

In a way, it's better than Unix. You can't delete Windows Oracle files while the database is open, but in Unix you can. In a way, it's a real pain in the butt. Try looking at log files that are held open by other apps while they write to them. No problem on unix, often impossible on windows.

Re: sql trace - XCTEND rlbk=1, rd_only=1

hmmm... I think I meant OCITransCommit() there, not OCITransRollback(). Nobody caught that? :) Jared On Mon, 2003-11-24 at 18:29, Jared Still wrote: OCI defaults to rollback on transactions on disconnect if OCITransRollback() has not been called. Don't ask me for too much detail, as I'm

RE: IOUG 2004

Title: RE: RE: Development vs. Production DBA It occurred to me that there probably aren't many new DBAs on the list... LOL Patrice. -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: Tuesday, November 25, 2003 9:19 AMTo: Multiple recipients of list

AW: Experiences with Oracle and MS .Net data providers

Hi Mladen Nice metaphor. Did you intentionally use zum Donnerwetter as a little word play on MS's Hailstorm - project (R.I.P.) ?. That get's pretty close to obscene language, too. I guess I was actually gullible enough to believe that .NET might be comparable to the Java world. Maybe not ;). Or

Re: UNIX OT: exclude files in tar

I never rely on tar to do that. Here is the trick that I use when I want to be selective: tar zcvf /tmp/test1.tgz `perl -e 'foreach (*.pl) { if (/connect/) {print $_\n;}}'` Basically, you write a small perl script which will output only the files you want and hand that to tar. Works each and

RE: what is oracle rdb?

I've said it before and I'll say it again...coding for RDB was a dream. Instead of having to rely on a preparser, there was a separate compiler that tokenized your SQL code into a object module to be linked with your program(s). Aside from making program maintenance potentially easier, it also

RE: WebSphere and Oracle

Thanks Dick. I agree it's not a database problem, but they try and push it my way because it's Oracle. I'm pushing back. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 25, 2003 9:50 AM To: Multiple recipients of list ORACLE-L The problem is

RE: Re[2]: what is oracle rdb?

Where's our Award-Winning Educator and former Lego DBA, Mogens? If there is one dream job for me, it would be an Oracle DBA at Lego. And I was upset to find that someone took my legoman username from my ISP at home. :( Rich Rich Jesse System/Database Administrator

PowerPoint and Oracle

A wild one here - but has anyone stuffed PowerPoint files into Oracle, together with associated metadata? Either complete (the easier solution) or decomposed for easier review. thanks, peter edinburgh * This e-mail message,

Re: Experiences with Oracle and MS .Net data providers

Actually, it was a deliberate word play, just to remind you that not all MS projects are successful. They were talking about porting .NOT to Unix, but gave up. It's a MS-only world. On 11/25/2003 09:54:51 AM, Stefan Jahnke wrote: Hi Mladen Nice metaphor. Did you intentionally use zum

Re: UNIX OT: exclude files in tar

tar cvf /tmp/test1.tar `perl -e 'foreach On 11/25/2003 12:24:26 AM, Ross Collado wrote: Hello, On Solaris 8 I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01 /home/user01/mark01

SUN question

Does anybody know what the SZ is represents(SUN SOLARIS) ps -efly | egrep 'ora|SZ' bach# ps -efly | egrep 'oracle|SZ' S UID PID PPID C PRI NI RSS SZ WCHANSTIME TTY TIME CMD S oracle 27845 1 0 77 20596552 617600? 02:00:04 ?0:26

insert in batch loading

Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of tables and their indexes

Re: insert in batch loading

How big are yor redo logs? How many o them do you have? On 11/25/2003 10:29:37 AM, David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when

RE: Move datafiles, but can't delete them

Side note on this - while you can delete files that are in use by Oracle on UNIX, you have not actually deleted them until there are no processes accessing that file anymore. The file will no longer be there to other applications, but the space used by that now-deleted file will not be released

RE: [***SPAM***] - Experiences with Oracle and MS .Net data providers - Found word(s) to be removed remove based list e-mail in the Text body.

We are using the latest ODP.net provider and up until we upgraded to 92040 had few and minor problems with it. Mostly it was differences between all of the different drivers that our programmers were using based on either the cycles of the moon or which team won the World Series. Since we went

Re[2]: what is oracle rdb?

Tuesday, November 25, 2003, 10:04:39 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote: JR Instead of having to rely on a preparser, there was a separate compiler JR that tokenized your SQL code into a object module to be linked with your JR program(s). Yeah, the module compiler was cool. I once wrote a

AW: Experiences with Oracle and MS .Net data providers

I have to remember that as a good example for my wife's German classes. Stefan -Ursprungliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 25. November 2003 16:20 An: Multiple recipients of list ORACLE-L Betreff: Re: Experiences with Oracle and MS .Net data

Re: insert in batch loading

David Boyd wrote: Hi All, We have some batch loading jobs that truncate the tables first, then insert into the tables as select from tables through database link. Those jobs run daily. Every time when those jobs run, they cause cannot allocate new log, Checkpoint not complete. All of

RE: UNIX OT: exclude files in tar

Maybe can use -prune option of find to send file list to tar: cd /home find ./user01 -name mark03 -prune -o -print -Original Message- I can't seem to get the tar command right. I wanted to tar a directory but EXCLUDE one of the subdirectory in it. Example: /home/user01

RE: Move datafiles, but can't delete them

If you do happen to erroneously delete an open file on unix, you can recover from it if you keep your wits about you and don't panic. oh yeah. working on another DBA's databases (he was out ill), and rushed in the wrong directory when gzipping and moving files to free up space. Because

RE: UNIX OT: exclude files in tar

You can use the -L option and have a file listing everything you want ie, ls file edit file and remove the dir you don't want tar files with the -L option and the file you created above. never done this myself -Original Message- [EMAIL PROTECTED] Sent: 25 November 2003 16:44 To:

Re: insert in batch loading

We have 5 groups of redo log. Each group has two members. Each member is 100 MB. David From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov 2003 07:44:33 -0800 How

Re: insert in batch loading

Janne, Thanks for your reply. We have 6 redo log switchings during inserting a table that has 1 million records. Our redo log size (100 MB) dominates the checkpoint frequency. The table has two indexes. We don't set them to unusable during inserting. David From: Jan Korecki [EMAIL

RMAN Script

Title: RMAN Script Hi list, Need a little help with this, have seen in metalink both ways with and without the equal (=) sign. What is wrong with this script, am getting an error in SETSIZE; I removed it and the same error. run { allocate channel c1 type disk format

Beginning of a global unravelling?

Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick accents. Um. Thick, non-Texan, accents. Anyway, this may bode well for us technical folks if this [and the previously discussed article] are the

RE: WebSphere and Oracle

Absolutely. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, November 25, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Thanks Dick. I agree it's not a database problem, but they try and push it my way because it's Oracle. I'm pushing

Re: sql trace - recursive relationships

Boris, Cary is correct. It gets a little confusing, especially with pl/sql involved. It also helps to remember to differentiate between database calls (parse/execute/fetch) and other events (wait/stat). Using your example below, I'll attempt an explanation inline. Daniel Fink Boris Dali wrote:

Re: IOUG 2004

Title: RE: RE: Development vs. Production DBA If I was doing a introductory administration session, I'd emphasize the right way of thinking the most. That is 1) Always make sure that you know what you're doing and what are the potential consequences of your doings 2)Do not do extensive

RE: Beginning of a global unravelling?

Bambi, I'm afraid I read something different in that story, but equally pleasant. Like a lot of things in this world sometimes we need to push the press-to-test button and see how the shoe fits before making up our minds. Companies I believe needed to do the same thing with

Re: sql trace - XCTEND rlbk=1, rd_only=1

Jared, actually your initial post made sense anyway - since you can't roll back committed transactions anyway. Also, rollback is done on session end if you haven't done the rollback manually ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: SUN question

man pages states(-y converts it to Kb instead of pages): SZ (l) The total size of the process in virtual memory, including all mapped files and devices, in pages. See pagesize(1). What does this mean? Does this mean that peocess 27845 is

Re: Beginning of a global unravelling?

i heard it was just the corporate call centers coming back? not the private call centers? dell tech support isnt any good no matter where it is. its just an entry level position. The guys who get good move up or on to other things. gateway is bad too. From: Bellow, Bambi [EMAIL PROTECTED]

Re: UNIX OT: exclude files in tar

This approach might cause problems, if you have really lots of files - your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 4:54 PM I

Re: UNIX OT: exclude files in tar

Then I'll pipe it to cpio -H tar, which will solve the problem. On 11/25/2003 01:24:26 PM, Tanel Poder wrote: This approach might cause problems, if you have really lots of files - your shell argument buffer (or whatever is the correct name for it) becomes full Tanel. - Original

Active Directory and ORACLE passwords

Title: Active Directory and ORACLE passwords Hi all, Has anyone heard of or seen any information on using Active Directory for password rules and authentication to an ORACLE database. An example would be that Active Directory would set up the rules for the password and the time that the

Oracle networking temp files in /tmp

Hey all, Running Oracle 9.2.0.4 on Linux, I've noticed several files in /tmp owned by the oracle user: BEQ10202 DCE10202 DEC10202 I1S2 ISPX10202 ITCP10202 LU6210202 NMP10202 RAW10202 SPX10202 TCP10202 TCPS10202 US10202 VI10202 BEQ29871 DCE29871 DEC29871 I2S4 ISPX29871 ITCP29871

Re: Beginning of a global unravelling?

Does that mean that we will not have to replace ourselves with the cheap labor from Elbonia? On 11/25/2003 12:49:31 PM, Bellow, Bambi wrote: Friends -- Looks like Dell is moving call centers from India to Texas and Tennessee. Seems that the folks in India, while very polite, have thick

Re: UNIX OT: exclude files in tar

On 11/25/2003 11:44:26 AM, [EMAIL PROTECTED] wrote: Maybe can use -prune option of find to send file list to tar: Why do it in a simple way when there is an opportunity to (ab)use perl? Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain

Valid Packages/Procedures/Triggers that are NOT

We had a weird situation yesterday on a database that had been upgraded from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being in production for a day and a half, 93 previously VALID packages, package bodies, triggers and procedures went INVALID. We have not been able to figure

ora 8176

Hi all. Two users have received ora-8176 error while running their reports today. These reports have been accessing the tables against which an alter table exchange partition command was performed possibly while the reports were being executed. Based on what I read about the 8176 error on

RE: Active Directory and ORACLE passwords

David - I hope you get some good replies. I asked about this awhile back and there didn't seem to be any sites getting MSAD and Oracle LDAP working. Part of the problem is that the world's #1 and #2 software companies don't talk much. I think your first obstacle is finding out the LDAP

8i to 9i import

List, Has anybody seen this behavior or know the work around. I am doing a full import into a 9i (9.2.0.1.0) database from an Oracle 8i (8.1.7.4.0) database. The users are not pre-created and anytime it wants to import a user who owns objects it fails and gives: . importing USER's objects into

RE: Beginning of a global unravelling?

if you work for a PHB, then yes. We will miss you Mladen ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion

RE: Valid Packages/Procedures/Triggers that are NOT

db will _try_ to recompile any code that is encountered after it gets marked as invalid. So, it may not be a bug after all. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

Re: IOUG 2004

Good points, Tanel. More to the point, forget about formulating a backup strategy. Focus on a recovery strategy. RE: RE: Development vs. Production DBAIf I was doing a introductory administration session, I'd emphasize the right way of thinking the most. That is 1) Always make sure that

RE: Valid Packages/Procedures/Triggers that are NOT

We have been seeing this ever since we went to 9i and in multiple calls to Oracle support they have not been of much help. Most of the time we get an error dump in udumo and things go on there merry way. A couple of times the packages go invalid and wont work but when looking at them thru

Re: Valid Packages/Procedures/Triggers that are NOT

Hi Victoria Are you sure that nobody alter some table or view include in these pkgs ??. Mariano Database Administrator. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Valid Packages/Procedures/Triggers that are NOT Date:

Re: 8i to 9i import

I just did one of those this weekend (from 8.1.6 to 9.2.0.1). I created an empty 9i database with all the tablespaces before starting the import. The full=y errored out , but it did create the users before it died. I had to go back and do schema imports for each user. Vicki Pierce Database

Re: Valid Packages/Procedures/Triggers that are NOT

Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are

Re: insert in batch loading

What does it mean that redo log size dominates checkpoint frequency? It brings to mind cases of Edmund Blackadder and Baldrick or Ace Rimmer and Lister Kryten, both very clear cases of domination. I'm sure that J. Lewis, as a Britt, can tell you more about Black Adder and Red Dwarf, despite the

ows, oas, ias product names

Oracle has gone back to Oracle Application Server as the name for iAS, it seems. Oracle Web Server 3.0.1.1 (1998 says the manual) Oracle (Web) Application Server 4.0 (? 1999 ?) Oracle Application Server 4.0.8.2 (May 2000 for Windows) Oracle Internet Application Server 8i 1.0.1 (August 2000 for

Re: insert in batch loading

What I meant is that checkpoint occurs only when redo log switches. We set log_checkpoint_interval = 21 and our OS block size is 512. If I increase the size of redo log to 500 MB, checkpoint will occur before log switching. Will the transaction wait until checkpoint complete during

analyze after truncate

Hello All, We have a huge table both is terms of number of columns and rows. It is list partitioned. it has 7 mill rows and its avg row length is 600 bytes. One of the developers has come up with a method of truncating and reloading the table on a daily basis thorough sqlloader. everyday

RE: [***SPAM***] - Re: Valid Packages/Procedures/Triggers that are NOT - Found word(s) to be removed remove home list error e-mail in the Text body.

The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in the database, nothing happening except the normal day-to-day operation of the system. We have seen this happening since 8i. We recently upgraded to 92040

Re: insert in batch loading

Hi! I suggest you set up a test where you check the redo. For example: - start test SQL select LOG_MODE from v$database; LOG_MODE ARCHIVELOG SQL create table append_test as select * from all_objects where 1=2; Table created. SQL create index append_test_ind on

RE: Move datafiles, but can't delete them

When dropping a tablespace, we've had better success deleting the files by the delete command from CMD rather than using Windows Explorer. Also, found that you need to wait a period of time before you can delete the file - eg try again in 30 secs 5 mins time. This is mentioned in a forum at

Re: Valid Packages/Procedures/Triggers that are NOT ...

Have you tried checking dba_dependencies for the objects that go invalid? You may see a pattern. Jared On Tue, 2003-11-25 at 13:34, Tony Johnson wrote: The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in

RE: Move datafiles, but can't delete them

Bruce, Thank you, the problem is not when I dropped the tablespace but want I moved datafiles. I will bounce the database. Luc -Original Message- [mailto:[EMAIL PROTECTED] Sent: November 25, 2003 5:02 PM To: Multiple recipients of list ORACLE-L When dropping a tablespace, we've had

Re: analyze after truncate

Presumably, after you truncate the huge table, it's no longer a huge table. DBMS_STATS will run much faster after you truncate the table. You've just discovered a great optimization. That's exactly what I've been saying for a long time: my database would work extremely fast, if there weren't any

Re: sql trace - XCTEND rlbk=1, rd_only=1

Thanks, Jared, Tanel. I was a little supprised to see a combination rlbk=1,rd_only=1. Why read-only bit is set here if it rolls back anyway? So I thought may be they mark their tx explicitly as read-only (aka set transaction read-only). Reveiwing OCI fine manual there seemed to be an option of

Re: analyze after truncate

You are truncating a table so as to add another 0.7% of its size in inserts, and to update 1.4% of the rows? My first thought would be to stop doing that. Modify the extent sizes (if needed) so that your 50k rows fairly fill up the extents allocated on the insert ( so as to avoid wasting space

Re: RMAN Script

Hi Ramon, I guess you are on 8i : your setsize and fileperset specs should be inside the backup command not outside i.e. something like this : backup fileperset 2 setsize 2000 database

Re: sql trace - XCTEND rlbk=1, rd_only=1

Using a slightly modified version of run_stats to return timings in 1/1 of a second, the timing of 1000 iterations of a loop executing noop vs. 1000 doing rollback: .0005 secs .0354 secs Here are the stats that were different between the two, kind of what you would expect: LATCH.cache

RE: UNIX OT: exclude files in tar

I like that logic! I might just start (ab)using Perl now. Thanks to all replies. Now I've got a few options to play around with to do this 'exclude files' and not necessarily tar . Rgds, Ross -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26

test

Yahoo! Personals - New people, new possibilities. FREE for a limited time!

Re: AW: Experiences with Oracle and MS .Net data providers

Several of the Miracle guys are getting ready to be certified in SQL Server. They have a ball with the 1000-page books, which talk about alternative operating systems - meaning Windows 95, Windows X, Windows y, :;-) Stefan Jahnke wrote: Hi Mladen Nice metaphor. Did you intentionally

Re: what is oracle rdb?

As the AWE (Award-Winning Educator) of the year, I have a huge responsibility placed on my shoulders: I have to answer questions regarding Rdb truthfully. So here we go... Back in the year 1994, Digital very discreetly asked their three biggest customers (including Lego) what they thought of

Re: sql trace - recursive relationships

Thanks for your reply, Daniel. Yes, it makes sense for the EXEC calls, but it doesn't explain the PARSEs, does it? PARSING IN CURSOR #1 len=94 dep=0... PARSE #1:c=0,e=141,p=0,cr=0,cu=0,mis=0,r=0,dep=0... PARSING IN CURSOR #2 len=68 dep=1... PARSE #2:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=1...

how to send messages to other users

hi, I need to send messages like 'system shutting down in 1 min' to all users currently login. How can i do this in oracle or a third party software that i can use? users are connected using web browser. Messages are send over the wan. thanks. -- Please see the official ORACLE-L FAQ:

Re: how to send messages to other users

BOFH On unix, there is a utility called init. You should log in as root and type the following: init 0 please log off the oracle database and everybody will get the message. /BOFH Other then that, you could use an exotic utiity called Outlook Express to schedule a database shutdown a week in

Linking to a SQL Server

Hi All, Has any of you had an exprience in accessing SQL Server data from Oracle database. I am woking on Oracle 9i on RH Linux 9. Does it work?? If so can you please list the steps that I need to try to do the same. Also wanted to clarify if generic connectivity is supported on Linux.