RE: restrict login with known IP address

2001-05-09 Thread Hatzistavrou Giannis
What about the old protocol.ora? -Original Message- From: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 20:17 To: Multiple recipients of list ORACLE-L Subject: RE: restrict login with known IP address Hello, Joseph Try something like this CREATE

Re: tkprof and security?

2001-05-09 Thread Connor McDonald
On a development box, 'alter session' should not cause too much harm. If you're concerned, write a package as SYS which turns on tracing for the developers session and just grant access on that... You may want to look at _trace_files_public parameter as well so they can see their trace files.

Rollback Segments

2001-05-09 Thread Nixon_Villanueva
Hi All, Here is my environment; NT v4 Db Oracle Workgroup v8.1.6 Rollback Segments SEGMENT_NAME OWNER TABLESPACE_NAME -- -- -- SYSTEM SYSSYSTEM RBS0PUBLIC

Re: Hey, looks like MS got .NET to work!!

2001-05-09 Thread Nuno Souto
Interesting! I use their services a lot. And I also got a punter knocking on my port 80. I wonder... Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - www.grc.com got nailed: -- Please see the official ORACLE-L FAQ:

RE: OT: Off Topic - Blah, Blah, Blah...

2001-05-09 Thread Boivin, Patrice J
Yes, the oracle server newsgroup doesn't come close to this list. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Rodd Holman [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 6:44 PM To: Multiple recipients of

Re: tkprof and security?

2001-05-09 Thread Tim Sawmiller
trace_on.sql REM Script to turn TRACE MODE on for a selected SID. set serveroutput ON size 2000; set verify OFF; DECLARE r_sid NUMBER; v_sid NUMBER; v_serial NUMBER; v_usernameVARCHAR(30); v_status VARCHAR2(8); v_server VARCHAR2(9); p_server_pid

Re: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
My observation is not on the elegancy of the code but why commit at 100 rows ? Are you updating 10 000 000 rows ? I've seen a lot of ORA-1555 because of fetch across commit. --- [EMAIL PROTECTED] a écrit : Linda, Might I suggest avoiding the elegant looping and try some inelegant

OEM 2.1 java on NT quirk

2001-05-09 Thread Boivin, Patrice J
Fyi, I noticed that when my OEM repository NT machine hasn't been rebooted for a while (about a week), the jrew.exe process runs very slowly. i.e. the OEM Management Server login dialog takes a long time to appear on the desktop, and the console takes over ten minutes to appear once I log in,

Re: consistency in cost?

2001-05-09 Thread Tim Sawmiller
Interesting...CHOOSE means Oracle will decide whether to use RULE or COST. But a CHOOSE hint will force use of COST. Kind of diminishes the meaning of CHOOSE, doesn't it? Seems like a pointless hint... [EMAIL PROTECTED] 05/08/01 11:45PM If the system is Rule based and you code Hints, the

Designer 6i Question - Database Desig Transformer - Unique Key Mi

2001-05-09 Thread Andor, Gyula
Hi Gurus ! I generated tables from entities. I had defined non-primary unique keys on entities. The unique keys consist of three attributes. Two of these three attributes are optional. After the generation the columns based on these optional attributes become mandatory, but I don't know why.

9i ship date

2001-05-09 Thread Adams, Matthew (GEA, 088130)
Title: 9i ship date From the InformationWeek Daily e-mail newletter --- ** IBM One-Ups Oracle With DB2 Ship Date It looks like IBM and Oracle will ship the next major releases of their databases within a week of each other, next month. IBM says DB2 version 7.2,

Re: Pl/sql loop assistance

2001-05-09 Thread Jared Still
Stephane, This doesn't look like it will cause ORA-1002, at least I don't see it. What's the relationship between ORA-1002 and ORA-1555? I got up rather early with a headache this morning, so maybe I'm just not thinking clearly yet. :) Jared On Wednesday 09 May 2001 05:40, paquette

Re: Rollback Segments

2001-05-09 Thread Jared Still
Nixon, While SET TRANSACTION can be used to assign a rollback segment to a transaction, it cannot be assigned exclusively to that transaction as you have found. The ability to assign a rollback segment to a transaction and make it read-only for all others is something I've wanted myself for

9i Real Application Clusters

2001-05-09 Thread Jamadagni, Rajendra
Dear Friends Does anyone have any knowledge or experience with Oracle 9i Real Application Cluster stuff? If you have I'd like to hear from you about what it is and your insight. I think it is not out yet, some of you may have had the opportunity to find what it is. ... Thanks in advance

Re: tkprof and security?

2001-05-09 Thread Rachel Carmichael
That's what I love about this list before I can answer, someone has provided scripts to do things :) Thanks Tim, I'm adding these to my scripts library Rachel From: Tim Sawmiller [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

Re: tkprof and security?

2001-05-09 Thread Paul Drake
Rachel Carmichael wrote: That's what I love about this list before I can answer, someone has provided scripts to do things :) Thanks Tim, I'm adding these to my scripts library Rachel Rachel, Is that due to the speed of the list members, or the lag of the mail server? Paul --

Re: Password expiry bug 8.1.6

2001-05-09 Thread Ron Rogers
sinardy, I do not know the methodology that Oracle used is it's PASSWORD package. It is quite possable that the new password can not contain any portion of the login id. Try to use a password that does not use the word bear and post the results please. ROR mª¿ªm [EMAIL PROTECTED] 05/09/01

Designer 6i free tutorial?

2001-05-09 Thread Szecsy Tamas
Hi, does some one know of a Designer 6i tutorial (escpecially Forms generator)? The one supplied with the Designer installation CD is less than basic level. TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat

Re: Rollback Segments

2001-05-09 Thread Thater, William
On Wed, 9 May 2001,Jared Still scribbled on the wall in glitter crayon: - -Maybe 9i? Anyone know? AFAIR, I heard that RBS go away in 9i. -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta

RE: 9i Real Application Clusters

2001-05-09 Thread Haskins, Ed
Rajendra, There is a white paper on OTN about 9i RAC. I think it isn't the most up-to-date white paper, but it's a start. I'm sure there will be more available, as in documentation, once the software ships next month!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent:

Well, Well, Another Oracle vs. IBM battle!

2001-05-09 Thread dgoulet
** IBM One-Ups Oracle With DB2 Ship Date It looks like IBM and Oracle will ship the next major releases of their databases within a week of each other, next month. IBM says DB2 version 7.2, which offers tighter integration with other IBM software and performance enhancements, is scheduled to

RE: Taking your time when a crisis occurs

2001-05-09 Thread dvmrgn
Hi All, Rachel wrote want to tell me how you hold off the CEO who is breathing down your neck on the 24x7 database that's down? Answers are snipped, but no wonder DBA's have a bad reputation. In this case, the proper thing to do is give the best client service possible. Forget your

Optimizer and block size changes = trouble...

2001-05-09 Thread Nuno Souto
Another spiky one. Situation is this: V8.0.6.0, HP/UX 11, Peoplesoft Financials 7.52(heck, does it sound like I'm involved with this mob? g) Block size in DB was 16K. Totally inappropriate for the type of database this is, with huge memory use and horrendous rollback segment size overhead and

Re: tkprof and security?

2001-05-09 Thread Thater, William
On Wed, 9 May 2001,Paul Drake scribbled on the wall in glitter crayon: -Rachel Carmichael wrote: - - That's what I love about this list before I can answer, someone has - provided scripts to do things :) - - Thanks Tim, I'm adding these to my scripts library - - Rachel - - -Rachel, - -Is

RE: restrict login with known IP address

2001-05-09 Thread Vadim Gorbounov
You are right old protocol.ora is OK, of course. System Event will give us much more flexibility, i.e., restrict logins under certain conditions, anybody can easyly find dozen of them. All the best, Vadim -Original Message- Sent: Wednesday, May 09, 2001 4:06 AM

Re: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
Jared, They are many causes for the famous ORA-1555 Snapshot too old, one of them is fetch across commit. It is when you're commiting and fetching the same data. it is not accept in ANSI SQl but it is by Oracle. In numerous place, developpers have complained that I sized the rbs too small

RE: Designer 6i Question - Database Desig Transformer - Unique Key Mi

2001-05-09 Thread Jack C. Applewhite
Gyula, Your question is ideal for posting on one of the ODTUG (Oracle Development Tools User Group) lists, which are hosted at the same site as this list. Visit www.odtug.com to see how to subscribe. I suggest ODTUG-DES2K-L. Folks on that list eat, sleep and dream Oracle Designer. Jack

Oracle DBA Needed in Fairfield County, CT...Major Company.

2001-05-09 Thread OraStaff
Major state-of-the-art pharmaceutical company in Fairfield County, CT is seeking an Oracle Database Administrator to provide DBA services in support of existing and planned information systems; proactively manage database resources; and provide direction and assistance to application developers

RE: Optimizer and block size changes = trouble...

2001-05-09 Thread Scott . Shafer
Hola, Dirk! So what was the final combination that fixed things? That info might make it easier for one of the list gurus to tell you why it worked... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Nuno Souto [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 09,

Re[2]: Pl/sql loop assistance

2001-05-09 Thread dgoulet
Stephane, What you say can be true, I've seen as much, but I've also seen cases where it works just fine. The key appears to be not messing with the same data record more than once in a loop. The other, and sometimes more important key, is to make sure others are not messing with the same

Re: Pl/sql loop assistance

2001-05-09 Thread Diana_Duncan
Yeah, Stephane, that's actually one of the reasons I suggested not using a commit-within cursor loop thing. The suggestion I made wouldn't do that -- or am I missing something? Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F:

Re:Rollback Segments

2001-05-09 Thread dgoulet
Rollback segments are one of those PUBLIC assets that can be somewhat of a nightmare. While your running a simple select you may have interest in every rollback segment in the database because of the nature of these beasts. When a transaction modifies data the original copy of the row is held

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Mohan, Ross
yea with no filesystem or process quotas in place this would be painful. || -Original Message- || From: Norrell, Brian [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 09, 2001 12:01 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Cool way to crash an Oracle database,

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Norrell, Brian
You want to crash the server? On any Unix box, execute the following four commands: echo './t.sh ' t.sh echo './t.sh ' t.sh chmod 777 t.sh ./t.sh Don't even need special privileges to ruin everyone's day... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500

Re: Re[2]: Pl/sql loop assistance

2001-05-09 Thread paquette stephane
Yes, it can work but you can't be sure it will work 100% of the time. --- [EMAIL PROTECTED] a écrit : Stephane, What you say can be true, I've seen as much, but I've also seen cases where it works just fine. The key appears to be not messing with the same data record more than

select for update...

2001-05-09 Thread SuzyV
What are the negatives of using 'select for update'? Seem to recall it locks all rows within a block causing other transactions to wait on rows needed in the same block. What about performance impacts?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SuzyV INET:

RE: Rollback Segments

2001-05-09 Thread K Gopalakrishnan
Kevin ! PRivate Rollback segments are coming in to picture if you use Parallel Server (or Real APplication CLusters ??). Basically it is assigned to a particular instance in case of OPS and the other instance can NOT acquire that rollback segments. But the other instance Can READ from that

PL/SQL Exception

2001-05-09 Thread Kumanan Balasundaram
Hi all, Do you know if an exception is raised for 0 rows updated. Take the following scenario but using PL/SQL. select * from a; C1 1 1 1 1 You get: update a set c1 = 5 where c1 = 6; 0 rows updated. Thanks Kumanan ** This

Re: Inserts slowing down on OLTP systems

2001-05-09 Thread Saumyajit Mandal
In OLTP system if there are too many indexes defined on tables, insert slows down. As volume of data goes up, the system shows even worse performance. if you can reduce total no of indexes probably it will help...actually this is a trade off. Thanks, Saumyajit --- Jared Still [EMAIL

RE: Rollback Segments

2001-05-09 Thread Kevin Kostyszyn
Hi all, This brings me to a stupid question then. What is the true difference between a public and a private rollback segment? Because if I just think about it like a normal human being I would think that if a user made a Private rollback segment then only that user could use it, but of

RE: Inserts slowing down on OLTP systems

2001-05-09 Thread Mohan, Ross
as a minor embellishment to John's scriptology, you might also consider searching on the phrase 'index browning'. A little while ago, it was the esoteric, nouveau way of referring to leaf block aging. || -Original Message- || From: John Kanagaraj [mailto:[EMAIL PROTECTED]] || Sent:

RE: Rollback Segments

2001-05-09 Thread K Gopalakrishnan
Hi ! Not very much. In 9i you have an option to have AUTOMATIC_UNDO_MANAGEMENT where you specify a huge undo tablespace and the undo is managed by oracle. But you can still have the rollback segments. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- William Sent:

Re:RE: Rollback Segments

2001-05-09 Thread dgoulet
Kev, A public rollback segment is immediately placed on line after creation and is automatically picked up by the instance at startup. Consequently doing maintenance on them is a real pain in the A^. Private rollback segments on the other hand have to be listed in your init.ora file to be

RE: Optimizer and block size changes = trouble...

2001-05-09 Thread Hillman, Alex
Default value of hash_area_size is sort_area_size. What was your sort_area_size, and also what values of OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ did you finally use? Alex Hillman -Original Message- Sent: Wednesday, May 09, 2001 10:51 AM To: Multiple recipients of list

help in SqlLoader; NULLIF function

2001-05-09 Thread Venkatesh, Sankar (CAP, GEFA)
Hi Need help in SqlLoader Using Solaris and Oracle 8.1.7 What is the syntax of NULLIF condition in sqlldr , when we have multiple null conditions for a column. I could not find the syntax for multiple NULLIF conditions on Oracle8i_Utilities manual . I want to feed the column with NULL when

Re:PL/SQL Exception

2001-05-09 Thread dgoulet
There's no exception for that condition that I know of. SQL%NOTFOUND may get set though. Reply Separator Author: Kumanan Balasundaram [EMAIL PROTECTED] Date: 5/9/2001 8:46 AM Hi all, Do you know if an exception is raised for 0 rows updated. Take

RE: Rollback Segments

2001-05-09 Thread A. Bardeen
Kevin, This is a common misconception. On startup Oracle determines the number of rollback segments to bring on line based on the init.ora parameters: TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT If the number of rollback segments specified by ROLLBACK_SEGMENTS is less than that

RE: join across database link

2001-05-09 Thread Bambi Bellows
Ooh! Ooh! I did that once! What fun! I had two windows up... both logged in as system. And when I described across the link, it shut down the window I was working in and displayed the error in the other one. And it was reproducible! Ah, the fun stuff Oracle puts in for the

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Vikas Kawatra
What the heck do the following commands do ?? -Original Message- Sent: Wednesday, May 09, 2001 9:01 AM To: Multiple recipients of list ORACLE-L You want to crash the server? On any Unix box, execute the following four commands: echo './t.sh ' t.sh echo './t.sh ' t.sh chmod 777 t.sh

RE: Oracle tuning book

2001-05-09 Thread John Kanagaraj
yes I can see him in that tent I have come to save your database with the new world from on high -- tune with wait events (Gaja, you know I love you, right?) Mogens is pretty darned smart, I lump him in with the Gaja/Cary Millsap/Craig Shallahamer crowd... people who can teach me much and

Re:select for update...

2001-05-09 Thread dgoulet
Suzy, Select for update establishes a row shared lock on the affected rows as they become part of the active dataset. This can have the effect of locking out users who also want to delete or update these rows. It does not have an affect of users reading the data. Dick Goulet

username

2001-05-09 Thread Lucy Lin
Hi all, By selecting from v$sort_segment I found there is one user who is currently use temporary TS, so I want to see who is the user by following query: SQL select USER , SESSION_ADDR, SESSION_NUM, SQLADDR , SQLHASH from v$sort_usage; USER SESSION_ SESSION_NUM

RE: Rollback Segments

2001-05-09 Thread Jenner Mike
Isn't the concept of a private RBS only applicable to parallel server setups? - Mike. -Original Message- Sent: 09 May 2001 16:21 To: Multiple recipients of list ORACLE-L Hi all, This brings me to a stupid question then. What is the true difference between a public and a

RE: Anybody Using Veritas Database Edition

2001-05-09 Thread John Lewis
We use Veritas. And are very happy with it. I'm not sure which 'flavor'. If you're interested I'll give you the email of our systems guru. Respond to my email. -Original Message- Sent: Wednesday, May 09, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Greetings, We are

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Jamadagni, Rajendra
I remember in initial releases of SVR4, just for playing games on the sys admin we would try to open a large file with vi. As the file is being loaded, hit CTRL+\ and watch the fun ... sometimes just hitting the period would also crash the whole thing. Raj

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Rocky Welch
Wouldn't this create a looping situation that would start t.sh over and over again? This would, eventually, create more processes than the configuration could handle and crash. Please correct me if I'm wrong. --- Vikas Kawatra [EMAIL PROTECTED] wrote: What the heck do the following commands do

RE: PL/SQL Exception

2001-05-09 Thread udaycb
You can raise user defined exception when there are no records updated by checking the value of SQL%ROWCOUNT. for example declare x number; no_data exception; begin update a set c1 = 2 where c1 = 6; x := sql%rowcount; if x = 0 then raise no_data;

Re:username

2001-05-09 Thread dgoulet
Lucy, All temporary segments are owned by SYS. They are created on behalf of the user by the RDBMS. Reply Separator Author: Lucy Lin [EMAIL PROTECTED] Date: 5/9/2001 9:46 AM Hi all, By selecting from v$sort_segment I found there is one user

RE: Rollback Segments

2001-05-09 Thread Haskins, Ed
Kev, PUBLIC and PRIVATE Rollback segments are not specified for ALL or SPECIFIC USER use. You can specify a certain transaction to use a specific rollback segment, as stated in the post below. PUBLIC and PRIVATE Rollback Segments have to do with the instances that utilize them. For example,

RE: PL/SQL Exception

2001-05-09 Thread Nicoll, Iain (Calanais)
Don't think you get an exception as such but I think you can use %FOUND or %ROWCOUNT -Original Message- Sent: 09 May 2001 17:46 To: Multiple recipients of list ORACLE-L Hi all, Do you know if an exception is raised for 0 rows updated. Take the following scenario but using PL/SQL.

Re: Rollback Segments

2001-05-09 Thread Rachel Carmichael
According to the 9i new features summary I'm looking at: Oracle 9i databases are capable of managing their own undo (rollback) segments -- no longer will administrators need to carefully plan and tune the number and sizes of rollback segments or bother about how to strategically assign

Re:RE: Rollback Segments

2001-05-09 Thread dgoulet
Anita, True on all counts with one caveat. Transactions is derived from sessions which is derived from processes. So in a practical world you need every public rollback segment you have, therefore they all come online immediately. In my case with processes = 300 that comes to 18 rollback

RE: Taking your time when a crisis occurs

2001-05-09 Thread Rachel Carmichael
Dave, I would REALLY like to introduce you to the CEO I was thinking of there are some people (ala the pointy-haired boss in Dilbert) who want what they want when they want it, and they want it now. Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Thater, William
On Wed, 9 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -make exponentially growing files and processes And make your SA REALLY pissed off.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED]

RE: Rollback Segments

2001-05-09 Thread Rachel Carmichael
private rollback segments are used mostly with OPS... the rollback segment is private to an instance (ie, unseen by the other instance(s)) From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback

RE: join across database link

2001-05-09 Thread Tim Sawmiller
This wouldn't be the one and only Bambi Bellows, would it? [EMAIL PROTECTED] 05/09/01 01:42PM Ooh! Ooh! I did that once! What fun! I had two windows up... both logged in as system. And when I described across the link, it shut down the window I was working in and displayed the error in

Re: Oracle DBA Needed in Fairfield County, CT...Major Company.

2001-05-09 Thread Paul Baumgartel
My resume is attached. Please contact me at your convenience. Thanks. Paul Baumgartel [EMAIL PROTECTED] 917 549-4717 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 11:26 AM Major state-of-the-art pharmaceutical company

Legato Media Manager and Veritas

2001-05-09 Thread Boivin, Patrice J
The Legato software bundled with Oracle 8.1.6. only works with Legato backup servers, right? Here we use Veritas NetBackup, just checking. It is starting to look as if we will have to purchase a client to go on all our NT servers... Regards, Patrice Boivin Systems Analyst (Oracle Certified

Re: Anybody Using Veritas Database Edition

2001-05-09 Thread Vijay R
I have used Veritas Database Edition (with VCS ). It's good. You can grow volumes online. You can have large file system. The quick io is really effective. Let me know if you need more info. Vijay Randive Database Administartor [EMAIL PROTECTED] - Original Message - To: Multiple

Re: Anybody Using Veritas Database Edition

2001-05-09 Thread Vijay R
I have used Veritas Database Edition (with VCS ). It's good. You can grow volumes online. You can have large file system. The quick io is really effective. Let me know if you need more info. Vijay Randive Database Administartor [EMAIL PROTECTED] - Original Message - To: Multiple

Re: ORA-12560: TNS Protocol Adapter error

2001-05-09 Thread Michael Netrusov
Helmut, check: Doc ID: Note:124140.1 Type: BULLETIN Status: PUBLISHED on Metalink. HTH, Michael Netrusov www.atelo.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 09, 2001 13:35 Hi there! I'm getting the weird

??? run unix script on NT

2001-05-09 Thread Leslie Lu
Hi, Does anybody know some tool/utility that can run Unix kshell script on NT? Thanks! Leslie __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ:

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Deshpande, Kirti
We had one DBA who did chown -R oracle * followed by chmod -R u+x,g+x * while at / as root !! That pissed of everyone not just the SAs. It took several days (almost a rebuilt of the server) to recover. Who to blame? The supid prompt for not having a # and id when su-ed to root. - Kirti

Re: ??? run unix script on NT

2001-05-09 Thread Rodd Holman
Yes, UWIN from http://www.research.att.com/sw/tools/uwin/ works wonders. Original Message On 5/9/01, 3:03:22 PM, Leslie Lu [EMAIL PROTECTED] wrote regarding ??? run unix script on NT: Hi, Does anybody know some tool/utility that can run Unix kshell script on NT? Thanks! Leslie

RE: Optimizer and block size changes = trouble...

2001-05-09 Thread Khedr, Waleed
I saw some situations where you have to delete the statistics, analyze the tables and all the indexed columns and increase the default number of histograms. So the main issue is deleting the statistics first and then providing optimizer more data about the data distribution and the cardinality.

Re: Hey, looks like MS got .NET to work!!

2001-05-09 Thread Eric D. Pierce
Bon dia Nuno! bummer on the hacker stuff. my goal, after learning spanish/catalan and arabic, is portugese, and then going to Brazil. :) if you are interested in mysticism, check out Ibn-al-Arabi, The Great Andulsian muslim philosopher. There is a new book published by White Cloud

Re: ORA-12560: TNS Protocol Adapter error

2001-05-09 Thread William Dong
Did you check the control panel/services? Is the OracleServiceSID stared? |+--- || Michael | || Netrusov| || [EMAIL PROTECTED]| || | || | |

shutdown immediate

2001-05-09 Thread Leyden, Joseph
Sometimes the instance never shuts down, BUT the database gets closed. What else could hang up SVRMGRL ? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leyden, Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Ron Rogers
Whats wrong with those commands??? If you read the trade magazines and all the ads Oracle owns everything and is trying to read, write, and execute everything... ROR mª¿ªm [EMAIL PROTECTED] 05/09/01 04:16PM We had one DBA who did chown -R oracle * followed by chmod -R u+x,g+x * while at / as

Re: tkprof and security?

2001-05-09 Thread Rachel Carmichael
Paul -- both :) I sometimes see answers to posts before I see the original post... considering that I'm usually in dizzy mode to begin with, that does NOT help my equilibrium (someone stop the world I want to get ON) Rachel From: Paul Drake [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To:

RE: username

2001-05-09 Thread Seley, Linda
Lucy - The user column is broken in v$sort_usage in v8.1.6 and various v8.0.x. It either always displays SYS or it displays the user that you are logged in as (apparently depending on the version of the DB you have). If you search for v$sort_usage on Metalink you will see a few related items

Compare Standard Edition to Enterprise Edition

2001-05-09 Thread Tom Schruefer
Could some kind soul direct me toward the web page that contains the comparison between the two different versions of the Oracle DB ? - I used to know where it was, but the link is gone. - I promise to answer this question if it is asked again.

Question of the day

2001-05-09 Thread Ron Rogers
SATIRE, SARCASMS ON (just got our 2002 price quote) Does any person know of a statue / figure/ object that stands outside the Oracle Corporate Headquarters that stands as their idolic symbol? All I have found is the registered trademark ORACLE. I guess the cylindrical tower buildings are a

Re: Anybody Using Veritas Database Edition

2001-05-09 Thread ARUN K C
can u tell me if you have faced any probs when u enabled quick I/O, have you enabled cached quick I/O also after enabling quick I/O Let me know From: Vijay R [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Anybody Using

Re: shutdown immediate

2001-05-09 Thread Ron Rogers
Joseph If you are using Novell as your OS then a memory leak that exists in older versions of Novell might be the problem. The message mixed in with the output messages stated that a lot of resources were not released. The upgrade to Novell 4.2 appears to have solved the shutdown problem for

RE: Compare Standard Edition to Enterprise Edition

2001-05-09 Thread Kevin Kostyszyn
I believe it is.. technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76 962/ch4.html -Original Message- Schruefer Sent: Wednesday, May 09, 2001 5:11 PM To: Multiple recipients of list ORACLE-L Could some kind soul direct me toward the web page that contains the

RE: username

2001-05-09 Thread ARUN K C
why dont you go to that view and edit that sql then it will give proper username From: Seley, Linda [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: username Date: Wed, 09 May 2001 13:00:56 -0800 Lucy - The user column is

RE: Hey, looks like MS got .NET to work!!

2001-05-09 Thread Jacques Kilchoer
Title: RE: Hey, looks like MS got .NET to work!! -Original Message- From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] my goal, after learning spanish/catalan and arabic, is portugese, and then going to Brazil. :) if you are interested in mysticism, check out Ibn-al-Arabi, The

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread John Kanagaraj
Hi Kirti, We had one DBA who did chown -R oracle * followed by chmod -R u+x,g+x * while at / as root !! That pissed of everyone not just the SAs. It took several days (almost a rebuilt of the server) to recover. Who to blame? The supid prompt for not having a # and id when su-ed to root. May

Re: Enterprise Manger

2001-05-09 Thread Bambi Bellows
Ruth -- I think it's v2.1, but it's hard to tell since there's no About. HTH, Bambi. -Original Message- Date: Wed, 09 May 2001 05:41:14 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] What is the version of OEM? Ruth - Original Message - To: Multiple

RE: looking for export with dynamic compress script on VMS

2001-05-09 Thread Gogala, Mladen
Export to NLA0: would do 100% compression. Nope, I'm afraid that you can not use pipes in VMS. You may be able to create a permanent mailbox and write a program that would compress it and forward it through the network, but it would be an extremely complicated thing. My advice is to export it to

RE: Anybody Using Veritas Database Edition

2001-05-09 Thread Behar, Rivaldi
Title: RE: Anybody Using Veritas Database Edition Agree. After using Quick IO the performance is better. But I still have one problem : autoextend datafile and also extending a datafile manually is not working for datafile using quick IO. Rivaldi -Original Message- From: Vijay R

Re: Anybody Using Veritas Database Edition

2001-05-09 Thread Vijay R
No. The main disadvantage is you need to shut the database to convert the database files to quick I/O files and you can not grow quick I/O files online. In other words, you can have database file with autoextend on. We haven't enabled cached quick I/O. - Original Message - To: Multiple

Terminal Emulation Sw.

2001-05-09 Thread DKTS
Hi listers... Could you recomend me some good free (not shareware) terminal emulation software for Windows? Something little better than windows telnet.exe? Thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DKTS INET: [EMAIL PROTECTED] Fat City

RE: Optimizer and block size changes = trouble...

2001-05-09 Thread Steve Adams
Hi Nuno (and list), Changing 'optimizer_index_caching' and 'optimizer_index_cost_adj' does seem to inhibit cursor sharing under 8i. You may want to try the following test under 8.0 and see if it is any different. SQL create table t as select * from dual; Table created.

RE: shutdown immediate

2001-05-09 Thread Leyden, Joseph
Title: RE: shutdown immediate I am at Oracle 8.0.5 AIX 4.3.2 should I upgrade my Oracle db to get a good shutdown immediate? -Original Message-From: Behar, Rivaldi [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 09, 2001 2:46 PMTo: Multiple recipients of list

LSNRCTL Password

2001-05-09 Thread Smith, Ron L.
Can anyone tell me what the syntax is to start, stop, or reload the listener when there is a password on it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Cool way to crash an Oracle database, any time, any place

2001-05-09 Thread Tim Sawmiller
Not as pissed off as the time he trusted me with the root password, and I absent mindedly ran this command from the root partition: chown me * [EMAIL PROTECTED] 05/09/01 03:16PM On Wed, 9 May 2001,Mohan, Ross scribbled on the wall in glitter crayon: -make exponentially growing files and

RE: Terminal Emulation Sw.

2001-05-09 Thread Ed Maurer
look at http://www.uk.research.att.com/vnc/ HTH Ed Maurer -Original Message- From: DKTS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L Subject: Terminal Emulation Sw. Hi listers... Could you recomend me some good

never mind -- Re: ??? Again: run unix script on NT

2001-05-09 Thread Leslie Lu
--- Leslie Lu [EMAIL PROTECTED] wrote: Thank you for all those who answered my question. I just installed uwin. I'm running a script upgrade_db.ksh. In the script, there is someting like: function check_login { # Login to

  1   2   >