RE: Oracle License for Training

Maria - Actually, I would think the best time to contact Oracle sales is when you don't have money. Good sales people can smell money. ;-) Some software companies are very liberal about providing their product for development and training purposes. My impression has been that Oracle is NOT one o

RE: Windows 2000 Cluster on oracle

Saying Windows is unstable shows no lack of understanding. It is a fact. At least a fact for me. I try to keep my Win2000 as stable as possible, but since the kernel now contains fun things like *video* (not in the original plans for this "New Technology"), I must reboot at least once a week or f

OT: Hotsos Symposium - Dallas

OK, here's the list of people who said are attending. I am not including the presenters ;) Anybody else attending ? Larry G. Elkins Kirti Deshpande Rajendra Jamadagni Charlie Mengler Ethan Post Jared are you attending ? It was a maybe couple of weeks back. Regards, Denny -- Please see the

Hanging query puzzle

Title: Hanging query puzzle We have a query from a 3rd-party tool that seems to either run very quick or crawls to a complete stop.   We can find no patterns to this behavior.    The hang can be experienced even when there are no other processes active in the database. Checking waits,

Antwort: OT: HPUX SCSI Performance

Hi david, of course there is something you can do First tell your sysadmin to stop being so negative !!! Transfererate is data/time, where time is the sum of three steps - seek: time to position the heat to the right location - latency: then r/w head has to wait for the correct sector - t

RE: Sql query

Hi Roland, Is the query producing right results in the first place? If there are n tables in the FROM clause, there must be atleast n-1 joins in the where clause to avoid the Cartesian product (which definitely screws up performance and rarely produces correct results.) In the FROM clause of you

Size of a Long Field

How do you determine the size, in bytes, of a long field?   Please. No tape measure jokes.   Ed  

RE: How to dump UGA ??

Title: RE: How to dump UGA ?? Jonathan, Thank you very much ... Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOT

RE: RMAN - delete obsolete?

Check out the doc's at tahiti.oracle.com and look up the parameter noprompt. Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/5/2003 5:48 AM Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without conf

Where is result set maintained?

When one executes a query, the result set is identified. Fetching the rows in the result set can be done over a period of time. In what form does Oracle maintain the result set, and where? TIA Paul Baumgartel __ Do you Yahoo!? Yahoo! Mail Plus -

SQL

Folks, Is there a much better way of writing the following SQL statement, bearing in mind the performace hits due to the use of functions in the GROUP BY and ORDER BY clauses? SELECT TO_CHAR(TEST_DATE, 'MON ') XXX, count(*) FROM TBL_XYZ WHERE TEST_VAL = DECODE(:P_VALUE, 'BEGIN', 'B', 'END',

Re: Partition and primary key

First create the index UNUSABLE - which will create each index as a single extent at virtually no cost. Then for rebuild each partition. Than add the PK using the index. (At least, that's what it says in my book ;) I think you'll find a similar piece of advice in the PL/SQL packages manual unde

RE: Connecting to Non Oracle databases from Oracle

Sunil - I believe your method will allow you to connect from the non-Oracle DB to Oracle. I don't believe it will allow you to do the opposite, but your subject line says "from Oracle". So I think you will need another method. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Or

Re:Connecting to Non Oracle databases from Oracle

NO, you have to do it the otherway around with Heterogenous services. Namely ODBC on the Unix platform. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 2/5/2003 1:58 AM Hi, I am trying to connect to a Non Oracle database from the Oracle

RE: HPUX SCSI Performance

What OS? What filesystem? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesday, February 05, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hi Guys I'm ho

RE: Problem with LONG column

Babu - There are two ways I can think of to do this. 1. Write a small PL/SQL procedure. 2. Use the SQL*Plus COPY command. You will probably use the method that is more familiar to you. Have you used either PL/SQL or SQL*Plus COPY before? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL

Re: How to dump UGA ??

If you want to see if tracing is on: alter session set events 'immediate trace name events level 1'; (level 2 for process level events, level 4 for system). You can obviously use the oradebug equivalent, or the dbms_support package to fire this at another session. However - if you can read the

RE: RH AS2.1 (was: RAC on linux)

OFCS? If not that, then it's left to a raw FS, correct? Just trying to get some config possibilities here for an upcoming test (hopefully)... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -

RE: US Travel for the DBA

Dave, I can see how frustrating the new regulations must be for you, and many others who are accustomed to very lax US regulations regarding foreign visitors. I'll be traveling to Italy soon, and I learned that I will have to leave my passport with any hotel receptionist for a couple of hours whi

Re: help set nomail

it should be set oracle-l NOMAIL deb From: "Ferenc Mantfeld" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: help set nomail Date: Wed, 05 Feb 2003 06:52:21 -0800 Hi All my machine has been rebuilt, with my outlook file

Sql query

I have this sql query. I am wondering why this query takes so long time, Do I need more conditions to make it run, or it it just that this query take so long time to run? Anything wrong with the query? Please help me with this. SELECT distinct PBK.VARUKORGEANREL_ULAG.ean, 0, 0, 0, rik2.vare.

RE: Windows 2000 Cluster on oracle

We have had an excellent experience with our Windows2000 clusters. Since moving to a clustered environment on our Test, Beta and Production systems over 18 months ago we have had 0 ( Zero ) outages due to Windows. in fact I have yet to see a BSOD on over 20 database servers since going to Windo

RE: 9i "Reliability" means ?

-Original Message- Sent: Wednesday, February 05, 2003 8:53 AM To: Multiple recipients of list ORACLE-L Folks We are looking to present a Talk on :- "Reliability" with respect to Oracle 9i DB How does one even approach this subject ? What Sub-Topics would this envisage other than th

RE: Question on "set autotrace on statistics"

SET AUTOTRACE only reports on DML (select, update,insert , delete) statements. The commands you ran were DDL commands If you notice at the end you did a count of the plan_table and that reported statistics John -Original Message- Sent: 05 February 2003 15:59 To: Multiple recipients of li

Partition and primary key

Title: Partition and primary key Hi List, We are using Oracle 8.1.7 (64 bits) with Solaris 8 I have a big table with over 300 millions rows (10 Go), We have partinionned this table by range of date. When we try to create a constraint primary key (with dedicated tablespace), we fail each t

Re: Question on "set autotrace on statistics"

Because you can trace DML, not DDL. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 10:59 AM > Hi: > > I am trying to understand why sqlplus did not display stats when I run >

RE: Full table scan

Title: RE: Full table scan Venu, How may records? If it's just a few hundred, a full table scan might be faster. Throw a RULE hint at it and see what happens then. What version of Oracle? CBO in 7.3.4 wasn't all that smart. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAI

OT: HPUX SCSI Performance

Title: Which rollback segment is currently active? Hi Guys I'm hoping there is sysadmin in the list that can help me.   We just received a brand new Itanium Server to play with It has 2  U320 disk not striped or mirrored or anything   Doing test and monitoring them through glance, i

Drop datafile.

Hi, I restored the database from cold backup. There seems to be a problem with one of the datafiles. Since there is no useful data in it, I tried dropping it using... SQL> ALTER DATABASE DATAFILE '' OFFLINE DROP; Database altered. I also deleted the physical file by going to that location and

info on toplink?

I am attempting to RTF google on this, but am not coming up with much. Does anyone have any suggestions on how to tune/manage toplink from an Oracle DBA perspective? "Make them stop" doesn't seem to be an option, sadly. So far the problems I've run into are that it doesn't use bind variables (and

RE: Windows 2000 Cluster on oracle

Seema, what do you mean by clustering? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, February 04, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Hi, We are looking from migration from Sun box to Windows box. Is anyone used Windows clustering wit

Re: help set nomail

Use: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 9:52 AM > Hi All > > my machine has been rebuilt, with my outlook

9i "Reliability" means ?

Folks We are looking to present a Talk on :- "Reliability" with respect to Oracle 9i DB How does one even approach this subject ? What Sub-Topics would this envisage other than the following ? 1) Oracle Architecture of Data Storage 2) Backup & Recovery Do Standby Databases & Database Repli

Re: help set nomail

Try 'set oracle-l nomail' Jared On Wednesday 05 February 2003 06:52, Ferenc Mantfeld wrote: > Hi All > > my machine has been rebuilt, with my outlook file lost, thus I do not have > the mail that describes how to set my account not to receive mail until I > say so. I sent a message to [EMAIL PRO

Forms/Reports on web with Weblogic

Can anyone provide any info on deploying forms/reports application on web using other application servers (specially Weblogic ). servlet or cgi, any implementation. i m unable to find a way to create virtual directory to map with cgi executable file. TIA Shuja -- Please see the official ORACLE-

RE: RMAN - delete obsolete?

Alex, Oracle produce a shell script to do exactly this. It is called $ORACLE_HOME/rdbms/demo/rman1.sh HTH John -Original Message- Sent: 05 February 2003 11:49 To: Multiple recipients of list ORACLE-L Hello List, I think my question is very simple... How to execute RMAN command D

RE: help set nomail

** Welcome to the Oracle-L Mailing List! ** Table Of Contents - 1) Charter for this mailing list 2) Characteristics of this mailing list 3) How to submit a posting to the list 4) How to unsubscribe from the list 5) Commonly used mailing list server command

Re: Problem with LONG column

Look into the SQL*Plus COPY command. > BanarasiBabu Tippa wrote: > > Hi everyone > > One of my development team is working on ORACLE 8 on NT (Because of > client requirement they are working on that version). One Table was > created with wrong column name. Now they wanted me to correct the > co

Re: Problem with LONG column

Title: Which rollback segment is currently active? Hi Banarasi   >One of my development team is working on ORACLE 8 on NT (Because of client requirement they are working on that version). One Table was created with wrong column name. Now they wanted me to correct the column name. But real pr

RE: Full table scan

Of course it will do full table scans! You're not limiting your join to any set of values, you are trying to read two whole tables. Because of the multiblock reads, full table scans and hash join will be more efficient then a nested loops plan where one table is read sequentially and the other i

help set nomail

Hi All my machine has been rebuilt, with my outlook file lost, thus I do not have the mail that describes how to set my account not to receive mail until I say so. I sent a message to [EMAIL PROTECTED] with content : set nomail Oracle-L. This came back as an invalid list. Could someone please tell

RMAN - delete obsolete?

Hello List, I think my question is very simple... How to execute RMAN command DELETE OBSOLETE from script without confirmation question to remove obsolete backups automatically? Many thanks for your help. -- Best regards, Alex mailto:[EMAIL PROTECTED]

Re: Recovery Solutions - URGENT

Hello Jai, Tuesday, February 4, 2003, 4:13:51 AM, you wrote: Jic> Dear friends, Jic> Could someone enlighten me on the steps to be carried out using RMAN Jic> and using OS commands for Recovery if : Jic> 1. A current redo log file is corrupted. Jic> 2. The System TS is corrupted. Jic> Thanks

Problem with LONG column

Title: Which rollback segment is currently active? Hi everyone   One of my development team is working on ORACLE 8 on NT (Because of client requirement they are working on that version). One Table was created with wrong column name. Now they wanted me to correct the column name. But real pro

Connecting to Non Oracle databases from Oracle

Hi, I am trying to connect to a Non Oracle database from the Oracle database ( Version 8.1.7.4). i want to do some thing like this : i have my ODBC set up on an Win NT machine. I have created a heterogeneous connection set up on Win NT. Now i want to connect from a Unix machine to the Listener ent

RE: Windows 2000 Cluster on oracle

SUN to Windows ?. Why do you want to used Windows. I think SUN more more better than Windows. I suggest please don't used Windows. As you you known the Windows system is not stable. SUN more more stable than Windows. I think you have to think more than twice for using Windows. -Original M

RE: Which rollback segment is currently active?

Title: Which rollback segment is currently active? Hi,   If you want to drop one of the the RBS, First you have to check in the application level. Which user that used the rollback segment.   select username,name,used_ublk, start_time,sum(waits),sum(gets), sum(waits)*100/sum(gets)from v$tran

Re: RAC on Linux vs Support

In 10i release 1 there'll be around 32 documented (not starting with _) parameters you can set, I think. In release 2 they're aiming for 22. Those two parameters you mention sound important enough to make the list :). Mogens Jamadagni, Rajendra wrote: RE: RAC on Linux vs Support

<    1   2