RE: arg list too long in unix

Hi all, Is there something like, unix is unable to use commands like ls -ltr (sort etc) when there are huge number of files in a directory(may be thousands/millions). If yes, what is the limit and how to know it on sun solaris 2.8. thnx and regards, srinivas --- "Lakhani, Vipul" <[EMAIL PROT

Re: Index hints?

Chuan Zhang, hei£¬you statement choose all rows from the table,Of course oracle will use full table scan! There is no where clause in your SQL.If you add: select a,b,c from test where a=some_value, then of course it will use the index. Regards zhu chao Each

RE: Index hints?

If you specify a hint Oracle is forced to use the index. Your hint's syntax is wrong. USE - /*+ INDEX(test index_a) */ Don't use the comma *** between the table name and the index name Naveen -Original Message- Sent: Friday, August 30, 2002 12:33 PM To: Multiple recipients of

RE: Slightly OT: Rounding Negative Numbers

Hi if you include -0.870, you should also include -0.880 in which case the split will go 6:5 either way you choose. Jack "kkennedy"

Re: PL/SQL Editor

We are using TOAD for the DBA team. For the developers we got PlSqlDeveloper and it works fine. You can check also www.quest.com for the new sql editor that they developed recently. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent

RE: Slightly OT: Rounding Negative Numbers

Why are you including -0.870?? In that case you should also include -.880. I think theoretically there is nothing right or wrong about rounding thing. You have to decide upon one way and follow that universally. Naveen -Original Message- Sent: Thursday, August 29, 2002 10:19 PM To: Mult

Re: Any do's and dont's for a 9i oracle installation on RedHat Linux

Hi, Suse7.2 is certified with 9.0.1. It will never be certified with 9.2 and later versions. Suse has a special product SLES - Suse Linux Enterprise Server. It's based on Suse 7.2 and include many official patches and upgrades. Afaik, with Suse 7.2 you may not upgrade your kernel and be certified

Index hints?

Hi, All, On a million row table, test, there is primary key on column a. when I run select /*+ index (test,indx_a) */ a, b, c, from test, according to Oracle, I should get the following explain plan. TABLE ACCESS BY INDEX ROWID test 1 INDEX UNIQUE SCAN PK_test 1 But I acctucally got : TA

Standby with TAF config. - How to ?

Guys , 1# Can Standby database be configured for TAF ? 2# If so , when the Primary DB fails will the client application be automatically failed over to Standby DB ? 3# And thereafter can the client application proceed it's process without any manual intervention ? I have read the Standby Datab

Unix Question

My var partition is 99% full of which there are lot of files in /var/tmp directory. Can i delete this files ? Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia INET: [EMAIL PROTECTED] Fat City Network Services-- (85

RE: proc. being exeucted from open_cursors

That's because it's 120 open cursors per session. So when you have multiple sessions, you will see the total from v$open_cursor greater than 120. v$open_cursor doesn't always tell u exactally the number of open cursors that's counting toward the limit. It's better to check v$sesstat for statist

proc. being exeucted from open_cursors

Hi all, DB: 817 can somebody tell me how to find out whether a package/procedure being executed. I checked v$open_cursor.sql_text. But similar text is existing in multiple procedures. from where can I get a particular procedure being executed ? 1 more Q: In one of the production instances op

RE: Identify unused indexes in 8i ?

Good words: your final sentence is very important. My only caveat is that without scouring the source code, it's difficult to determine whether an index might be used in the future. As in the stock market, "historical performance is no guarantee of future performance." The problem is that some bu

RE: Identify unused indexes in 8i ?

Or when you are done moving these suspected indexes to a new Tablespace, you can monitor the read/write statistics for the files in that Tablespace (v$filestat). Another idea is to put the indexes in the unusable state and wait for an error when the index gets used. Regards, Waleed -Orig

RE: ADV OT: Oracle-dba.com domain for sale

I would but I got to put some money down on www.phatdba.com Ethan Post perotdba (AIM), epost1 (Yahoo) -Original Message- Sent: Thursday, August 29, 2002 6:48 PM To: Multiple recipients of list ORACLE-L If you're inte

Re: Identify unused indexes in 8i ?

Your methodology is sound and bulletproof, but is also fairly effort-intensive and time-consuming. Another trick is to make a list of all indexes that are suspected for not being used, move them all into the same, otherwise empty, tablespace and take the whole tablespace offline. If any of the ex

RE: Clip Text Between Lines in Korn Shell

vi foo.txt /# = mk /# = "ad'k :wq or as a generic 'clipper' script: #!/bin/ksh vi $1

RE: Table Locks

Title: RE: Table Locks Does v$locked_object show anything for those tables? > -Original Message- > From: Alan Davey [mailto:[EMAIL PROTECTED]] > > I've noticed some locks on various tables and I'm trying to > figure out which DML statements are causing the locks.  In > this exampl

Re: Table Locks

I'm not sure it's possible to find the locking SQL and SID once the session issues other SQL statements. I spent a lot of time a few years back attempting to find it, without success. I got the people at both Platinum Technology and Savant (yes, I'm showing my age here) to try to find it as well,

RE: PL/SQL Editor

Title: RE: PL/SQL Editor I hate to seem like I don't have a sense of humour, but wouldn't a more ethical way be to pay for the full version of the product? > -Original Message- > From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] > > You said "One note about the Freeware version o

Re: basic Unix question ???

On Thu, 29 Aug 2002, Janet Linsy wrote: > Hi all, > > I have two questions. First, how to find out > information about my unix box, like version, etc. uname -a > > In my box, I can use hostname to get the machine name. > I remember there is a command called version, but I > got "Ksh: versio

Re: Select count(name) from table group by name where count(name)

Thanks. On Thursday 29 August 2002 16:47, you wrote: > You use "having count(name)=1" instead of "where count(name)=1". > > -Original Message- > Sent: Thursday, August 29, 2002 6:39 PM > To: Multiple recipients of list ORACLE-L > 1 > > > Hello guys, > > I am baffled by this problem. > > I

RE: basic Unix question ???

try: uname -a for version information. ksh is usually under /usr/bin/ksh Not every Unix comes with top, you will have to install it. Richard Ji -Original Message- Sent: Thursday, August 29, 2002 7:10 PM To: Multiple recipients of list ORACLE-L Hi all, I have two questions. First,

Re: Select count(name) from table group by name where count(name)

Thanks. On Thursday 29 August 2002 16:47, you wrote: > Use HAVING count(name) = 1 > > Example from our good friend scott.emp > > SQL> select job, count(job) > 2 from emp > 3 group by job; > > JOB COUNT(JOB) > - -- > ANALYST2 > CLERK 4 > MANAGER

ADV OT: Oracle-dba.com domain for sale

If you're interested, email me for the asking price. Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access /

Re: arg list too long in unix

ls -1 cz* > /tmp/1.1 vi /tmp/1.1 :1,$ s/^/rm -f / ZZ /tmp/1.1 joe Philip Douglass wrote: >I'm not sure xargs will work -- it seems to me that since xargs is >typically invoked as: 'ls cz* | xargs rm', Nuno is likely to get the same >arg list too long error. I think the best way to delete the f

Re: PL/SQL Editor

Gotta love that. joe Mercadante, Thomas F wrote: >Bill, > >You said "One note about the Freeware version of TOAD - it has some internal >thing >that limits it to 5 concurrent connections to the same db, which is a >problem for us in a dev shop." > > >I got around this by replacing the v$sessio

Re: Sequential Tables' Selects Versus Joins

the standard answer, try it and see as what works on my database might not work on yours. Joe VIVEK_SHARMA wrote: >Which would Perform Better ? >1) Having an SQL Query Doing a Join between 6 Tables > >2) Running 1 SQL Query on a Single Table , getting the Output Values in a Cursor >& passi

Re: Select count(name) from table group by name where count(name)

Thanks. It's the Having clause. Khedr, Waleed wrote: >select name >from table >group by name >having count(*) = 1 > >-Original Message- >Sent: Thursday, August 29, 2002 6:39 PM >To: Multiple recipients of list ORACLE-L >1 > > >Hello guys, > >I am baffled by this problem. > >I need to

Re: LIST ADMIN: ...

Hi All -- This virus instance did not affect the ORACLE-L mailing list hosted at fatcity.com. Apparently it originated from a user on the Lazy DBA list. Note that the Klez virus spoofs mail addresses, so the infecting user was probably not the actual infected individual. I recommend visiting

RE: basic Unix question ???

uname -a will give you OS version and machine type on most *nixes. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Janet Linsy [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 6:10 PM > To: Multiple recipients of list ORACLE-L > Subject: basic Uni

new email address

the [EMAIL PROTECTED] email addy has evidently been sent on to spam lists, i'm getting way too many. Since I own that domain, i'll be dropping the [EMAIL PROTECTED] and be replacing it with [EMAIL PROTECTED] Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe

Re: Letting users kill their own sessions

Just modify the script you got from MetaLink ... from v$session s, ... where ... and userenv('SESSIONID') = s.audsid Jared On Thursday 29 August 2002 13:18, Boivin, Patrice J wrote: > Does anyone have a dynamic script that would let users kill their own > sessions? > > I found something in M

Re: working with datafile > 2Gb in HadHat 7.3

If you can't do it in hardware, do it in software. Right? ltiu Ji, Richard wrote: >There is no such hardware limitation like that. Those are the OS i.e. >software limitations. For instance, the 2gb file size limit is because of >the >32 bit OS, actually, to be more specific, it's the 32 bit f

Re: basic Unix question ???

uname -an Janet Linsy wrote: >Hi all, > >I have two questions. First, how to find out >information about my unix box, like version, etc. > >In my box, I can use hostname to get the machine name. > I remember there is a command called version, but I >got "Ksh: version: not found." Any other u

RE: Select count(name) from table group by name where count(name)

You use "having count(name)=1" instead of "where count(name)=1". -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name o

Re: arg list too long in unix

> > If the arg list is too long, one way to shorten it is with 'head'. > > find /dir_2_clean -name "cz*" -print | head -1000 | xargs rm -f The whole point of xargs is that it doesn't get overlong arguments -- unless one of the file paths is > 4KB by itself. This leaves the "head" extraneous

RE: Select count(name) from table group by name where count(name)

Use HAVING count(name) = 1 Example from our good friend scott.emp SQL> select job, count(job) 2 from emp 3 group by job; JOB COUNT(JOB) - -- ANALYST2 CLERK 4 MANAGER3 PRESIDENT 1 SALESMAN 4 0

RE: Select count(name) from table group by name where count(name)

select name from table group by name having count(*) = 1 -Original Message- Sent: Thursday, August 29, 2002 6:39 PM To: Multiple recipients of list ORACLE-L 1 Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the

basic Unix question ???

Hi all, I have two questions. First, how to find out information about my unix box, like version, etc. In my box, I can use hostname to get the machine name. I remember there is a command called version, but I got "Ksh: version: not found." Any other useful commands to know about my machine?

RE: working with datafile > 2Gb in HadHat 7.3

There is no such hardware limitation like that. Those are the OS i.e. software limitations. For instance, the 2gb file size limit is because of the 32 bit OS, actually, to be more specific, it's the 32 bit file system. You can have a 32bit OS kernel, but if your file system supports 64bit, then

RE: working with datafile > 2Gb in HadHat 7.3

>From the link: http://www.in.redhat.com/products/linux/enterprise_oracle.php3 Only in the enterprise edition: 64-bit file I/O - allows access to files greater than 2GB in size for large database implementations Regards, Waleed -Original Message- Sent: Thursday, August

Re: arg list too long in unix

Might take awhile to fork 70k+ shells. I don't know of any good reason to ever use -exec. If the arg list is too long, one way to shorten it is with 'head'. find /dir_2_clean -name "cz*" -print | head -1000 | xargs rm -f Just run that til the files are all gone. Jared On Thursday 29 Augu

RE: LIST ADMIN: VIRUS Warning: Please Repsond

No, I'm not saying that people using M$ products are doing so because they are stupid or lazy. Perhaps they are if they refuse to even consider the alternatives. I don't consider myself stupid or lazy and I'm using M$ products both at home and at work. I don't like them. I suggest alternati

Select count(name) from table group by name where count(name) = 1

Hello guys, I am baffled by this problem. I need to fish out the person's name from a list but I only want the name of the person that occurs once in the list - minus those names that occurs more than once. Now, I know about "distinct" and "unique", but this is not what I want. All I want is

RE: Identify unused indexes in 8i ?

Indexes were never used. They must have been created for temporary purpose. --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > What are "unused indexes"? > > > -Original Message- > > From: Bob Robert [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 29, 2002 3:33 PM > > To: Multiple r

Re: ROWNUM strangeness?--SOLVED

> As for sorting, rownum is assigned before any sorting. However, if the data > is read via an index, the rownum appears to be assigned after the sort. Dan, I wouldn't say that. What *appears* is the sort, which doesn't take place since data is fetched in sorted order. Rownum is assigned in the

RE: Letting users kill their own sessions

Well, that explains that pesky restraining order the users issued against me... > -- > From: Gogala, Mladen[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, August 29, 2002 2:43 PM > To: Multiple recipients of list ORACLE-L > Subject: RE:

Re: working with datafile > 2Gb in HadHat 7.3

OK. I stand corrected. You do need third party tools though. But I suppose engineers can always hack their way through hardware limitations to make thing work. Like the >4GB memory limit of intels - this is not more since I believe Windows 2K and XP have this feature(in software?) where it can

RE: Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle For the really radical there is the 1-finger salute... ;-) Rodd Holman On Thu, 2002-08-29 at 16:37, Fink, Dan wrote: I prefer the Microsoft 3-fingered salute... -Original Message-

Re: working with datafile > 2Gb in HadHat 7.3

Plain ext3 = No. Adriano Freire wrote: >My question is only this: >Linux 7.3 REDHAT with ext3 work with datafiles > or = 2Gb? >If is true. How? > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, August 29, 2002 3:43 PM > > > > >>It

Re: working with datafile > 2Gb in HadHat 7.3

No. Not really. I stand corrected. Got confused again. ltiu Seefelt, Beth wrote: >Ltiu, > > > >>>Intel hardware can only handle 2Gb files sizes max. >>> >>> > >Are you sure? I don't think that's true. > > > >-Original Message- >Sent: Thursday, August 29, 2002 2:44 PM >To: Multi

RE: LIST ADMIN: VIRUS Warning: Please Repsond

Unfortunately, the only viable alternative "choice" for me would be to find a new job that doesn't use MS sExchange and MS Lookout for it's corporate e-mail. Hey! In the Online Oracle RAC Dog & Pony today, they touted that RAC saved millions for a company that had 97 e-mail servers by being able

Re: AW: Oracle Application Server BUT how about 11i

SAP will be toast only if Oracle can get their act together. The fiasco of 11i cost Oracle a lost of business to SAP and others. They best not do that again. My $0.02, Ken Janusz, CPIM - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday,

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

I am using ReiserFS. Joe -Original Message- Mladen Sent: Thursday, August 29, 2002 3:09 PM To: Multiple recipients of list ORACLE-L What file system type are you using? Are you using raw devices? ReiserFS works like a charm. > -Original Message- > From: ltiu [mailto:[EMAIL PRO

RE: Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle What if the user's name is not JOY? -Original Message-From: April Wells [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 29, 2002 3:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Letting users kill thei

v$sqlarea question.

Hi List.     does anybody know what the OPTIMIZER_MODE = NONE mean in v$sqlarea view ?     I've found this document Doc ID: 48131.996  in metalink, but it seems that I don't have access to it.       The problem I'm facing here is that I am getting this information when analyzing v$sqla

upgrade 8.1.6.2 to 8.1.7.3 or 8.1.7.4

DBA's I have to upgrade an 8.1.6.2 DB on Solaris this weekend (so much for a three day weekend). Is there any reason not to go to 8.1.7.4??? Is 8.1.7.3 less buggy, etc??? I hope to upgrade this DB to 9.2.0.1 as soon as the app vendor ok's it, thanks to our Oracle friends we can't go direct fro

RE: IMPORT sloooowwww

To see if its a straight load issue, try export with indexes=n, constraints=n, everything else you can think of = n, so on import it will basically be a batch insert and nothing else. THen either trace the import, or take a look at v$session_event whilst the import is running and see where the de

RE: Schedule Statspack Report Creation

Erik - I'm suggesting that you may be looking at the issue from the spreport.sql perspective. Spreport just compares the performance between two distinct snapshots. Rather than automating this report, consider a fresh approach. If you collect snapshots at regular intervals, then you have a wealth

RE: PROCESSING APPROACH - Oracle design issue on Unix

Paula - One word of caution which I'm sure you don't need. Often Unix scripts can process data faster than processes inside Oracle. This is an important consideration for data warehousing. I'm sure you are aware of this, but thought I would mention it. Dennis Williams DBA Lifetouch, Inc. [EMAIL

Clip Text Between Lines in Korn Shell

Anyone got an easy method to clip the lines between "# " if foo.txt contains the following? # # NAME - foo.txt # # SYNTAX - foo -dgs # # # YOU GET THE IDEA BY NOW... # # #

Identify unused indexes in 8i ?

All, Is there a way to identify unused indexes in Oracle 8i. I know that it is easy to check with 9i. I would appreciate if you could share your experience (or ideas) with me. Thanks, Bob __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quot

RE: Serving BLOB from the database

Manav - I believe that serving images from BLOBs in the database imposes a significant load on the database, as opposed to simply keeping pointers to O.S. files. Operating systems are pretty good at this sort of thing or, as you mention, the Web server. So this is not an issue to be taken lightly.

RE: LIST ADMIN: VIRUS Warning: Please Repsond

Oh boy, this looks like a deja vu. > -Original Message- > From: Seefelt, Beth [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 4:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: LIST ADMIN: VIRUS Warning: Please Repsond > > > > So basically you're saying that

Re: working with datafile > 2Gb in HadHat 7.3

My question is only this: Linux 7.3 REDHAT with ext3 work with datafiles > or = 2Gb? If is true. How? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 3:43 PM > It doesn't really matter what OS you have. Intel hardware

RE: LIST ADMIN: VIRUS Warning: Please Repsond

So basically you're saying that those of us using Microsoft products are doing so because we're stupid or lazy to change? -Original Message- Sent: Thursday, August 29, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You always have a choice. Sometimes it is difficult to make the

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

I thought of the hard drive and took it back to the store and got another one. I had the same problem with Rel2 and 9iAS Rel1 does not work with Rel2 of DB and I need it for my project. Could memory problems cause this problem? Joe -Original Message- Sent: Thursday, August 29, 2002 1:3

RE: Identify unused indexes in 8i ?

I expect that the answer is probably that an "unused index" is any index that the Oracle query optimizer will never choose for any SQL statement in the entire application. One way to compute whether an index is unused is: 1. Extract SQL from your application source code (which is nice because yo

Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Does anyone have a dynamic script that would let users kill their own sessions?   I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure

RE: Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle I prefer the Microsoft 3-fingered salute... -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 29, 2002 2:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Letting user

RE: working with datafile > 2Gb in HadHat 7.3

Ltiu, >>Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb f

RE: Oracle to publish pricing guide on Sept. 3

Oracle has moved the release date from Aug. 28 to Sept. 3. All will be revealed . . . http://www.eweek.com/article2/0,3959,491399,00.asp -Original Message- Sent: Wednesday, August 28, 2002 2:02 PM To: '[EMAIL PROTECTED]' Has anyone seen this pricing guide yet? http://www.infoworld

RE: Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle KILL JOY! -Original Message-From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 29, 2002 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Letting users kill their own sessions Yes,

Re: ora-1017 invalid username/password when trying to login as internal

I had this problem before and the cause was traced to sqlnet.ora. After commenting out a line ( sorry don't remember which line ) in that file the issue went away. Dennis Meng Database Administrator Focal Communications Corp.

RE: Identify unused indexes in 8i ?

I would assume any index that was created but never used by the optimizer. He probably wants to know if not ever used drop them. I have no idea if it is possible to determine if an index was "used".

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

The block size is 8192 when creating the tablespaces. Oracle will not support their producst on non-certified OS's. It is certified with 7.1 and 7.2 of SuSE and not 8.0. I had it running on this server for 2 months before my hard drive crashed and not I just can't seam to get it to work. If I c

Data Guard on 8.1.7

Hi I want to implement data guard on 8.1.7.can someone share some experience what are the things need to take care of before installation/after installation etc Thx -Seema _ MSN Photos is the easiest way to share and print your p

Re: working with datafile > 2Gb in HadHat 7.3

Uh... don't think so! -- we're running UnixWare 7 on Intel hardware (Xeons) and large file support is a matter of enabling the largefiles option on the Veritas (VxFS) filesystem. That being said, I only use 2Gig datafiles because it seems foolhardy to me to use >2Gig datafiles unless you have an o

Table Locks

Hi All, I've noticed some locks on various tables and I'm trying to figure out which DML statements are causing the locks. In this example, the lock isn't being released because the developer forgot to include a commit/rollback. If I look at v$session which is causing the lock and query v$sql

Re: Identify unused indexes in 8i ?

If I recall correctly, the only (reliable?) way of determining this in 8i is to use stored outlines for a purpose other than intended. I believe you would enable the creation of stored outlines and then use your app as usual, and them some time later check user_outline_hints to see which indexes i

unrecoverable..for creating Index

Hi Friends, Iam rebuilding my indexes! If I create my index as unrecoverable in Oracle 7.3 on AIX, its nologging(redo) only for creating index!! or is it applies entire life of that index!! I have strong feeling its only for creating index! It will log any inserts for table!!some one list

Re: Re:RE: Re[2]: controlling CPU usage through Oracle

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Tony,     No, as of now it does not have that functionality.     Thanks for your input.            ed - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursda

ora-1017 invalid username/password when trying to login as internal

Hi All, Oracle 8.1.6/WinNT I get ora-1017 invalid username/password when trying to connect as internal. I have recreated password file many times to no avail. Usually this all I have had to do in the past for this error. I have tried all combinations of remote_login_passwordfile. I was getting

RE: ROWNUM strangeness?

It is not the predicate that causes the behavior, but the distinct. I'm taking an educated guess here, so please correct me if I am wrong. As the row is read, the predicate is applied. If the row matches the predicate, a rownum is assigned and it is saved as part of the result set. Once the rownu

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

What file system type are you using? Are you using raw devices? ReiserFS works like a charm. > -Original Message- > From: ltiu [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 2:39 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle 9i Rel1 on SuSE 8.0 Pro > >

RE: LIST ADMIN: VIRUS Warning: Please Repsond

Etch-A-Sketch's are even better for the end(L)user -Original Message- Sent: Thursday, August 29, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Linux or MacOSX are good alternatives for the end user. ltiu kkennedy wrote: >You always have a choice. Sometimes it is difficult to

Re: ROWNUM strangeness?

Yes sir. Paul Baumgartel wrote: >I believe you have ROWNUM confused with ROWID. > >--- ltiu <[EMAIL PROTECTED]> wrote: > > >>Holes in your extents/segments. Normal. You get this after repeated >>updates/deletes/inserts. >> >>ltiu >> >>Paul Baumgartel wrote: >> >> >> >>>I've been given a

RE: Letting users kill their own sessions

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Yes, the process is called "logging out" and I normally let them do that. Keeping them tied to their computers would be a cruel and unusual punishment, against the company policy and probably illegal. -Original Message

RE: Identify unused indexes in 8i ?

What are "unused indexes"? > -Original Message- > From: Bob Robert [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 29, 2002 3:33 PM > To: Multiple recipients of list ORACLE-L > Subject: Identify unused indexes in 8i ? > > > All, > > Is there a way to identify unused indexes in Or

Re: ROWNUM strangeness?

I agree. I got confused and my second email to disregard my erroneous first emai on this matterl was apparently shot down by the mail filters so it never got to you guys in time. Sorry for the confision. ltiu Fink, Dan wrote: >Actually, ROWNUM has nothing to do with >extents/segments/inserts

RE: PROCESSING APPROACH - Oracle design issue on Unix

Title: RE: PROCESSING APPROACH - Oracle design issue on Unix Paula,   Your approach is fine.  The bigger question that your organization needs to ask is - if you leave, can they support it - do they have adequate staff on hand that can maintain PL/SQL code?   I agree with you that PL/SQL can

RE: Oracle 9i Rel1 on SuSE 8.0 Pro

As a WAG... is your blocksize compatible with the Linux filesystem?? I don't understand how the OS version has a play in Oracle giving you support. If you are paying for a legitimate license then I don't see how its and issue. Maybe you can post to the suse-oracle list http://www.suse.com/us/

SQL-2100 in Pro*C program

I guess this is my day to post questions to the list. Does anyone have any ideas on how to diagnose and fix SQL-2100 (aka ORA-2100)? The manual says ORA-02100 PCC: out of memory (i.e., could not allocate) Cause: SQLLIB was unable to allocate enough memory to execute the program. Action: Alloc

Re: arg list too long in unix

Quite true, but ironically enough, the xargs manpage (on my system as well as many others) only has examples using ls to feed xargs. I meant to end the exec param with \+ instead of \; which aggregates a set to operate on. I'm not clear on whether that means one giant set, or several smaller sets,

RE: ROWNUM strangeness?--SOLVED

To be exact... Rownum is sequentially assigned for each row that meets the predicate. If the row does not match the predicate condition, it is discarded and not assigned a rownum. Below is an example using our friendly EMP table. As for sorting, rownum is assigned before any sorting. However, if

RE: AW: Oracle Application Server BUT how about 11i

It has always been. SAP is just one of ..., as is Oracle - and none will go away for the foreseen future. The common competitor is, or would like to be, Microsoft with its acquisition of Great Plains. -Original Message- Sent: Thursday, August 29, 2002 1:54 PM To: Multiple recipients o

RE: ROWNUM strangeness?

Actually, ROWNUM has nothing to do with extents/segments/inserts/updates/deletes. It is all about access paths. The solution posted makes sense as ROWNUM can be affected by many subsequent operations. -Original Message- Sent: Thursday, August 29, 2002 11:04 AM To: Multiple recipients of l

Re: LIST ADMIN: VIRUS Warning: Please Repsond

Linux or MacOSX are good alternatives for the end user. ltiu kkennedy wrote: >You always have a choice. Sometimes it is difficult to make the right choice. >Consider a high school student who is doing poorly -- they can make the easy choice >and drop out or they can make the difficult choic

Re: ROWNUM strangeness?

I believe you have ROWNUM confused with ROWID. --- ltiu <[EMAIL PROTECTED]> wrote: > Holes in your extents/segments. Normal. You get this after repeated > updates/deletes/inserts. > > ltiu > > Paul Baumgartel wrote: > > >I've been given a query to investigate. The performance varies > >extr

  1   2   >