two_task parameter

2001-07-25 Thread Arslan Bahar
Title: RE: OT, "It's all about Alex"     what is the function of two_task parameter. i have searched metalink and documantion cd  but i could nor find  any note or document.    please could you give information ?

Re: Solaris.. help.!!

2001-07-25 Thread Peter McLarty
Start at Oracle Technet there is documents on installing and administering on Solaris. After that maybe ask specific questions on this list about something you don't understand and provide error messages if you have any from installing or using it. It isn't all that hard if you just want to g

Re: Help ! ORA-00600 : internal error code

2001-07-25 Thread Saurabh Sharma
this is an error code that must be reported to Oracle support along with full description of error, procedure performed that caused this error and also details about your database environment settings. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Origi

Help ! ORA-00600 : internal error code

2001-07-25 Thread John Dunn
Help ! What does this mean? ORA-00600: internal error cod, arguments : [733], [33719116], [pga heap], [], [], [], [], [] John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (

Solaris.. help.!!

2001-07-25 Thread Saurabh Sharma
Hi all,   please help me in finding the right doc about starting from scratch on Solaris. I'm looking for Solaris for Oracle. can anyone suggest me some good starting documentation or links on this. like introduction, architectue, installtion and configuration etc..   thanks.   Saurabh Shar

RE: Best way to upgrade database/move data

2001-07-25 Thread Reardon, Bruce (CALBBAY)
If you want to change the block size at the same time (and not use 9i) then I think a new database build / import will be required. If you need to speed up the import process then it may help to use BMC's PATROL DB-Import for Oracle. http://www.bmc.com/dataone/dbimport Note the trial is free but

question about d2k - urgent

2001-07-25 Thread novicedba
hi everyone,    wanted to know about key mapping in developer 2000. I know that hot key mapping can be changed by modifying .res file. but it has its own limitations (I was told this) 1)Combinations are restricted. 2) if any other product made in D2k is installed then its shortcuts wil

servlet 2.3

2001-07-25 Thread vsharma
When will be the servlets 2.3 integrated with Oracle IAS.Which version will be released for this? Thanking You, Regards, Vinay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-50

Re: UNIX command

2001-07-25 Thread Don Granaman
# vxva & -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 12:23 PM > Hi gurus > Which command is for to see disk layout in sun cluster and veritas cluster > on sun solaris. > Thanks

Re: OT, "It's all about Alex"

2001-07-25 Thread Don Granaman
Title: RE: OT, "It's all about Alex" Matt, I made two of them (as well as one of Alex's) ...  but then again, I'm "almost nobody" :-)   -Don Granaman [certifiable OraSaurus] - Original Message - From: Adams, Matthew (GEA, 088130) To: Multiple recipients of list ORACLE-L

Re: (Fwd) Re: Oracle 8i and clustering

2001-07-25 Thread Don Granaman
I don't know exactly the context in which you heard this (NT cluster specific?), but rest assured that OPS is not going to be "replaced", except in name. The current party line is that "real application clusters" is a radical departure from OPS. It simply isn't true. RAC is a very major upgrad

Re: Best way to upgrade database/move data

2001-07-25 Thread Jared Still
'Best' depends on a lot of things. If you have a narrow window of opportunity, export/import may not be a viable solution as it is so slow. Dumping your data to flat files and using sqlloader to load the data may be another way for you to do this. More complex that exp/imp, takes more planning

Oracle8i/NT(cluster) - some web resources, etc.

2001-07-25 Thread Eric D. Pierce
Look like I was wrong, Oracle/NT-cluster installs once via autodiscovery/propogation to each node: http://www.oracle.com/ip/deploy/database/collateral/parallel_server_ds.pdf (see bottom of page 5) similar: http://www.oracle.com/collateral/parallel_server_fo.pdf http://docs.oracle.com/a91029

(Fwd) Re: Oracle 8i and clustering

2001-07-25 Thread Eric D. Pierce
--- Forwarded message follows --- To: Ali Mesdaq <[EMAIL PROTECTED]> Date sent: Wed, 25 Jul 2001 14:12:34 -0700 I can't imagine that installing the oracle executables on shared storage would be a good idea. see below for an Oracle tech note. note that

Re: Looking for a tool

2001-07-25 Thread Peter McLarty
Not sure what parts it doesn't cover these days but Corvu may be a solution www.corvu.com HTH Peter At 03:36 AM 26/07/2001, you wrote: >Dear friends ! > >I'm desperately looking for a reporting tool with the following >characteristics. > >It should be able to deploy various types of charts (B

RE: Looking for a tool

2001-07-25 Thread Reardon, Bruce (CALBBAY)
Don't know about Discoverer 9i but I believe earlier versions would work with any ODBC database. With Oracle Oracle and Oracle Rdb that has SQLNet installed then you will get time estimations etc. ie - more features with Oracle (eg scheduling reports on dbms_job queues) but I believe will work wi

RE: NON-oracle question: perl script to syn time with an vax hos

2001-07-25 Thread Reardon, Bruce (CALBBAY)
Hi Patrick, Not a Perl script but, Do you run Pathworks on the Vax and if so what version? With Pathworks V5 and above you can do it from an NT cmd line with a simple net time command. eg if running Pathworks and VAX is called vax1 then from NT command line: net time \\vax1 /set /y (ie NT wil

RE: Some other Oracle list

2001-07-25 Thread Reardon, Bruce (CALBBAY)
Steve is also still posting a few messages to his answers and newsletter lists. See http://www.ixora.com.au/newsletter/index.html and http://www.ixora.com.au/q+a/index.html Regards, Bruce Reardon -Original Message- Sent: Thursday, 26 July 2001 8:56 Don't know about Steve A. He sometime

Trigger on Create User

2001-07-25 Thread Maser, Donna (SEA)
Hi Guys, I was hoping to use the new 8i triggers to prevent new users from getting assigned to the SYSTEM tablespace. Has anyone seen a way to build a trigger on a CREATE USER statement? Thx, Donna Maser The information contained in this email is intended for the personal and confidential use

NON-oracle question: perl script to syn time with an vax host

2001-07-25 Thread ph
hi, anyone know where i can find an perl script to syn a PC clock to a VAX clock? thanks for any help, sorry for non-oracle question === Patrick Housholder Sr. Staff Anl Tech Spt Design United Airlines Flight Training Center Denver CO -- Please see the official ORAC

RE: Some other Oracle list

2001-07-25 Thread Deshpande, Kirti
Don't know about Steve A. He sometimes posts to the comp.databases.oracle.misc.servers something.. newsgroup. May be he is still out there. But Gaja was on the road and currently he is teaching a class in Canada (IOUG-A Univ something ) So is Ari Kaplan. - Kirti Deshpande Verizon I

RE: listener problem......

2001-07-25 Thread Page, Bruce
What are you trying to do? If you set up 2 listeners for the same database, the tnsnames.ora that is used to access it needs to have an entry pointing to that port and sid. > -Original Message- > From: Harvinder Singh [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 5:39 PM >

Re: strt.cmd security hole??

2001-07-25 Thread Jared . Still
Dave, What's the platform? NT? Jared "Farnsworth, Dave"

RE: strt.cmd security hole??

2001-07-25 Thread Gogala, Mladen
Look under SYS$ORACLE:[ORACLE.HOME] > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 5:07 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: strt.cmd security hole?? > > > Where is the strt.cmd file? I don;t see it any

Re: Some other Oracle list

2001-07-25 Thread Pablo ksksksk
Thanx everybody. Does anyone know if Steve Adams and Gaja are still on this list, I haven't seen any answer from them in the last month and I quite enjoy their answers. I learn a lot from them. thanx Pablo ksksksk wrote: > > I'd like to subscribe to another list too. > > Does anyone know if th

RE: listener problem......

2001-07-25 Thread Harvinder Singh
ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA.. -Original Message- Sent: Wednesday, July 25, 2001 5:02 PM To: Multiple recipients of list ORACLE-L Do you have the second port defined in your tnsnames.ora? > -Original Message- > From: Harvinder Singh [mailto:[EMAIL PROTECTED]]

Re: Some other Oracle list

2001-07-25 Thread Thater, William
Pablo ksksksk wrote: > > I'd like to subscribe to another list too. > > Does anyone know if there's some other list as good as > this one? > > thanx nope. trust me, been there, done that. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~

Re: OT, "It's all about Alex"

2001-07-25 Thread Thater, William
"Adams, Matthew (GEA, 088130)" wrote: > > Don't feel bad for Alex. Almost nobody from > the list came to any of mine, and I did four. > But, I had a great time doing it. I plan > to submit 3 abstracts this time (last time > I submitted four, hoping to get one accepted). and if i remember right

RE: listener problem......

2001-07-25 Thread Harvinder Singh
PORT SPECIFIED IN TNSNAMES.ORA IS 1526 -Original Message- Sent: Wednesday, July 25, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Harvinder, Where is the application resolving the port from? Tnsnames / ONames? Check the port defined with the connect string in these de

RE: strt.cmd security hole??

2001-07-25 Thread Cale, Rick T (Richard)
Under oracle_home\database -Original Message- Sent: Wednesday, July 25, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Where is the strt.cmd file? I don;t see it anywhere under $ORACLE_HOME. > -Original Message- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > Sent

Some other Oracle list

2001-07-25 Thread Pablo ksksksk
I'd like to subscribe to another list too. Does anyone know if there's some other list as good as this one? thanx ___ Do You Yahoo!? Yahoo! Messenger: Comunicación instantánea gratis con tu gente - http://messenger.yahoo.es -- Please

RE: Some other Oracle list

2001-07-25 Thread Jamadagni, Rajendra
Hi Ksksksk (how do you pronounce this?), Last time I checked there was nothing close to this one do yourself a favor ... don't waste time looking for better list ... there is none ... nothing ... zip ... nada ... absolutely none .. Hope you get the idea ... this is not to discourage you, bu

Re: 9i - Linux Rhat 7.1- Error SIGSEGV 11* segmentation

2001-07-25 Thread Ron Rogers
the error is Oracles method of telling you that 9i is not supported on RedHat 7.1. After the squabble is over and the two of them are on good terms again the RedHat certified Oracle 9i will have the error removed. Sorta a'kin to the copy protection that software had in years past. On the oth

RE: OT, "It's all about Alex"

2001-07-25 Thread Deshpande, Kirti
In any event, Alex is the LMT man !! :) - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 3:39 PM > To: Multiple recipients of list ORACLE-L > Subject:

RE: strt.cmd security hole??

2001-07-25 Thread blair
Where is the strt.cmd file? I don;t see it anywhere under $ORACLE_HOME. > -Original Message- > From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 4:47 PM > To: Multiple recipients of list ORACLE-L > Subject: strt.cmd security hole?? > > I inherited

RE: listener problem......

2001-07-25 Thread Page, Bruce
Do you have the second port defined in your tnsnames.ora? > -Original Message- > From: Harvinder Singh [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 25, 2001 4:39 PM > To: Multiple recipients of list ORACLE-L > Subject: listener problem.. > > > Hi, > > I have configured 2 lis

RE: listener problem......

2001-07-25 Thread Yadav, Shailesh
Harvinder, Where is the application resolving the port from? Tnsnames / ONames? Check the port defined with the connect string in these destinations as they will be the ones who will identify which port the app goes to. HTH Shailesh -Original Message- Sent: Wednesday, July 25, 2001 4:

Re: 9i - Linux Rhat 7.1- Error SIGSEGV 11* segmentation

2001-07-25 Thread Ron Rogers
Additional Linux and Oracle 9i posts on 06/28 by [EMAIL PROTECTED] and another post 06/19 by [EMAIL PROTECTED] ROR mª¿ªm >>> [EMAIL PROTECTED] 07/25/01 04:00PM >>> Did anyone try to install Oracle 9i on Linux 7.1 .. I was trying to install it and running into this error . (when running runI

Re: (Fwd) Oracle 8i and clustering [NT]

2001-07-25 Thread Richard Ji
You can install Oracle on a shared drive but you will need to install on each machine once into the same location. This makes both machines' registry captures the Oracle stuff. >>> [EMAIL PROTECTED] 07/25/01 04:00PM >>> please also directly reply to non-list member: [EMAIL PROTECTED] ---

RE: (Fwd) Oracle 8i and clustering [NT]

2001-07-25 Thread Vadim Gorbounov
Hi Eric, Ali, I'd install Oracle locally and put data/control/redo on shared. Although this means some redundancy and more administration, you will be able to narrow down maintenance window while patching/upgrading. Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, July

RE: OT, "It's all about Alex"

2001-07-25 Thread Adams, Matthew (GEA, 088130)
Title: RE: OT, "It's all about Alex" Don't feel bad for Alex.  Almost nobody from the list came to any of mine, and I did four. But, I had a great time doing it.  I plan to submit 3 abstracts this time (last time I submitted four, hoping to get one accepted). Matt Adams - GE Applianc

strt.cmd security hole??

2001-07-25 Thread Farnsworth, Dave
I inherited an Oracle 7.3.4 database that nobody knew the internal password for. So I was doing some research on metalink and came across an article that mentioned the strt.cmd file would have the password. I was amazed to open up this file and see the unencrypted password for internal. I then

RE: e-mail from within the database

2001-07-25 Thread Fred Smith
The -force was the trick that made it work. Thank you. -Fred S. >From: "Naik, Sandesh S" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: e-mail from within the database >Date: Wed, 25 Jul 2001 12:21:30 -0800 > >Fred, >

RE: Veritas Backup Exec Error

2001-07-25 Thread Kevin Kostyszyn
Hi,     I use this same product, however I don't use it to actually backup the databases.  But you never know, maybe my memory will come back to me and I could semi help.:) What OS are you using, what's the 1010 error again? KK -Original Message-From: [EMAIL PROTECTED] [mailto:[

listener problem......

2001-07-25 Thread Harvinder Singh
Hi, I have configured 2 listeners one name listener(default) on port 1521 and listener1 on 1526 for same database... and specify port 1526 in local_listener in init.ora when default listerner on port 1521 is stopped while listener1 is up...when i try to run application i get error TN

RE: OT, "It's all about Alex"

2001-07-25 Thread Grabowy, Chris
Alex did great. I learned a lot...err...just not sure what I learned. (grin) Unfortunely, I had to miss his second presentation. -Original Message- Sent: Wednesday, July 25, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Alex, how did the paper/present go? -Original Messa

Re: Tuning question - Why did this index help so much?

2001-07-25 Thread Stephane Faroult
"Miller, Jay" wrote: > > The other week a new production process was running much more slowly than > anticipated. A file needed to be sent out by 6:00pm and at the rate the > table was being populated it wouldn't complete until around 9:30pm. The > production people and developers came to me fo

Re:e-mail from within the database

2001-07-25 Thread dgoulet
Fred, Did you run loadjava for $ORACLE_HOME/plsql/jlib/plsql.jar? (Oracle metalink note 130785.1). Dick Goulet Reply Separator Author: "Fred Smith" <[EMAIL PROTECTED]> Date: 7/25/2001 11:41 AM I am running 8.1.7.0.0 on Windows NT. I ran INITJV

RE: e-mail from within the database

2001-07-25 Thread Naik, Sandesh S
Fred, You can load pl/sql using following to load pl/sql in database. loadjava -force -user sys/ plsql.jar It works fine for us. You have to use -force to load it if the script fails. Sandesh -Original Message- Sent: Wednesday, July 25, 2001 3:42 PM To: Multiple recipients of list O

(Fwd) Oracle 8i and clustering [NT]

2001-07-25 Thread Eric D. Pierce
please also directly reply to non-list member: [EMAIL PROTECTED] --- Forwarded message follows --- > Date sent: Tue, 24 Jul 2001 13:51:48 -0700 > From: Ali Mesdaq <[EMAIL PROTECTED]> > Subject: Oracle 8i and clustering > > [via Date sent: Tue, 24 Jul 2001 20:29:11 -0400 > Send reply to:

9i - Linux Rhat 7.1- Error SIGSEGV 11* segmentation violation

2001-07-25 Thread Apps Sol
Did anyone try to install Oracle 9i on Linux 7.1 ..   I was trying to install it and running into this error . (when running runInstaller )   SIGSEGV   11*  segmentation violation All the prerequisites are in place ..  Any thoughts??   Cheers RK      

Re:Rollback Segment Question

2001-07-25 Thread dgoulet
Kamel, Yours is an old question and I really doubt that recreating the rollback segment had anything to do with correcting the error. Rollback segments are a global resource used by every session connecting to the database. The misconception is that each session acquires one segment whe

Veritas Backup Exec Error

2001-07-25 Thread Jeffrey Beckstrom
Installed 8.0.6/8.1.6 as part of Oracle Financials 11i on a new server.  Installed 8.1.7 in a separate home.  Installed Veritas Backup Exec.  The Oracle Agent keeps getting a 1010 error.  Thinking might be related to the 8.1.7 stuff, renamed the 8.1.7 directory.  Still get the same error. 

RE: Tuning question - Why did this index help so much?

2001-07-25 Thread Mercadante, Thomas F
Jay, I'm guessing here, but maybe because *most* of the index was already in memory. Further, skipping the table blocks is a huge payoff - think of skipping disk access for all of the rows involved in the query. A simple 25% reduction does not really work here. That is the theory behind the IO

e-mail from within the database

2001-07-25 Thread Fred Smith
I am running 8.1.7.0.0 on Windows NT. I ran INITJVM.SQL successfully. When I try to run INITPLSJ.SQL I get the following errors: SQL> @D:\ORACLE\ORA817SE\RDBMS\ADMIN\INITPLSJ.SQL; Call completed. Error while resolving class oracle/plsql/net/TCPConnection ORA-04043: object oracle/plsql/net/TCPCo

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

2001-07-25 Thread Harvinder Singh
i tried removing the spaces but it didn't help..if the client and server r on the same machine ... will it use ipc instead of tcp and if so do i have to configure dispacher for ipc and mention ipc in local_listener. -H -Original Message- Sent: Wednesday, July 25, 2001 3:09 PM

Re[2]:RE: Data load options

2001-07-25 Thread dgoulet
Mohammad, That only works if you can truncate the table. Dick Goulet Reply Separator Author: "Mohammad Rafiq" <[EMAIL PROTECTED]> Date: 7/25/2001 9:16 AM Truncation was the solution in this case as I observed in the past that direct load optio

RE: Tuning question - Why did this index help so much?

2001-07-25 Thread Miller, Jay
Hi Tom, That's why I expected a 25% decrease in processing time (instead of reading 2 index blocks and 2 table blocks it read 2 index blocks and 1 table block). But why would it give a 75% decrease? Jay -Original Message- Sent: Wednesday, July 25, 2001 2:29 PM To: Multiple recipients of

OT -- RE: Sun cluster vs Veritas cluster

2001-07-25 Thread Austin, Steve S
You're showing your age. ;) I'm more akin the the $6.0 E+06 homo sapien. You know, "a man barely alive"; "we have the technology," blahblahblah -- all that Six Million Dollar Man stuff (whose character was -also- "Steve Austin" for those who haven't caught it in reruns). It's amazing how much

RE: re-archiving a redo log file

2001-07-25 Thread Miller, Jay
Hmm, would it work to do an OS level copy so long as you get to the redo log before it starts being written to again? Just a random thought... -Original Message- Sent: Wednesday, July 25, 2001 12:42 PM To: Multiple recipients of list ORACLE-L I don't think, it's possible. Most probably

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

2001-07-25 Thread Durinda.Jones
A couple of things I would check. I don't believe you need the ADDRESS_LIST parameter, unless you will have multiples. I would remove the spaces in the parameter. I would make sure that the HOST equals the machine name, possibly make the entry upper case. As foolish as it sounds, I've seen the

RE: books on data modelling

2001-07-25 Thread Rachel Carmichael
but you haven't lived until David Hay has made an origami animal for you :) >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: books on data modelling >Date: Wed, 25 Jul 2001 10:28:37 -0800 > > >I haven't yet seen a

Re: statement for directory objects

2001-07-25 Thread Igor Neyman
You should be able to see the one you created in dba_directories: select * from dba_directories; Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 1:10

RE: 4 drives, 2 controller ( 3 drives on the SAME controller !)

2001-07-25 Thread John Kanagaraj
Rahul, The 3 drives are sharing the controller and are daisy-chained. An IBM CE can reroute the cables, and depending on what's currently there, you *may* need to purchase cables/end connectors. Since you have the same Wide SCSI adapters/drives, this is less complicated than it could have been..

Re: Data load options

2001-07-25 Thread Jared . Still
I forgot to add: there was a commit for every 1000 rows. Jared Denny

RE: books on data modelling

2001-07-25 Thread Jared . Still
I haven't yet seen a reference to David Hay's 'Data Model Patterns : Conventions of Thought'. If you haven't read and understood it, then sorry, you don't know data modeling. http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=996081527/sr=2-1/ref=aps_sr_b_1_1/104-1357679-6149513 'A Practica

RE: Tuning question - Why did this index help so much?

2001-07-25 Thread Mercadante, Thomas F
I think it's because the optimizxer did not have to go to the table b to satisfy the query - it went to the index only. does this make sense? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, July 25, 2001 12:57 PM To: Multiple recipients of list ORACLE-L

Re: Looking for a tool

2001-07-25 Thread Rocky Welch
Hi Andrey, Try Cognos. http://www.cognos.com/ HTH, -Rocky --- Andrey Bronfin <[EMAIL PROTECTED]> wrote: > Dear friends ! > > I'm desperately looking for a reporting tool with the following > characteristics. > > It should be able to deploy various types of charts (Bar, Column, Line, > Pie > e

RE: Tuning question - Why did this index help so much?

2001-07-25 Thread Miller, Jay
Kirti made a similar suggestion. But I had done a select count(*) on the table so that all the table rows would be loaded into memory. I suppose that the index blocks might not have been, but even there the likelihood that any given one of the million plus reads wouldn't find one of the 4,000 row

RE: Looking for a tool

2001-07-25 Thread Jamadagni, Rajendra
Discoverer 9i the demo at ODTUG was capable of doing almost everything that you mention here. Only two problems ... 1. works with Oracle only (AFAIK) 2. It is not available yet (last time I saw, it wasn't). Raj __ Rajendra Jamadagni

RE: MTS IS CONFIGURED BUT STILL DEDICATED CONNECTIONS USED

2001-07-25 Thread Harvinder Singh
this option is not set so i assume default is OFF... any other clue... -Original Message- Sent: Wednesday, July 25, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Check the client's sqlnet.ora. It can override the server config with USE_DEDICATED_SERVER=ON setting. Ste

UNIX command

2001-07-25 Thread Seema Singh
Hi gurus Which command is for to see disk layout in sun cluster and veritas cluster on sun solaris. Thanks in advance. -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

Re: re-archiving a redo log file

2001-07-25 Thread Igor Neyman
Title: re-archiving a redo log file I don't think, it's possible. Most probably it checks 'archived' column in v$log. Also, it keeps track of archived files in v$archived_log.   Igor   - Original Message - From: Adams, Matthew (GEA, 088130) To: Multiple recipients of li

effect of Initial and Next exents...

2001-07-25 Thread Raghu Kota
Hi Friends I obsered in my big database Tables and Indexes set different Initial and next extents..So How it will effect on performance?? Suppose one my big table has initial 72Mb and next 245Mb..All big indexes(6Gb) was set low Initial and next around 245Mb..Any ideas about the performance

Re: Data load options

2001-07-25 Thread Denny Koovakattu
At least she didn't have a commit after every insert and ask you to tune the database ;) Denny [EMAIL PROTECTED] wrote: > > I will second Lisa's recommendations. > > If you have much data, and/or will be doing this frequently, SQL*Loader > is your friend. It is very fast. > > Loading from

RE: version

2001-07-25 Thread Ramasamy, Baskar
Rukmini, select * from V$version Baskar -Original Message- Sent: 22 July 2001 17:17 To: Multiple recipients of list ORACLE-L Hi All, How can we find what version of oracle (standard/enterprise/workgroup) is running in the system. Is there any view/table ? Thanks rukmini -- Pl

Re: Data load options

2001-07-25 Thread Mustafa
Title: RE: Data load options It's a pain-killer:   http://www.painmanagementsolutions.com/products/vicodin/vicodin.html   BTW, in the US, a lot of Hollywood stars are in rehab due to the addictive effects of this drug.   Defry - Original Message - From: Robertson Lee - lerob

Re: data files the busiest

2001-07-25 Thread Jared . Still
The fact that you see the same busy file from your script as Jon's script shows is merely coincidence. Consider the output with varying levels of read and write activity. Jon's approach is more correct. Jared

RE: books on data modelling

2001-07-25 Thread Guy Hammond
I've seen some data models where the only book they read was probably "How To Smoke A Big Fat Pipe O' Crack". About the only book I've actually needed was Korth's "Database System Concepts" - all the rest of the knowledge needed is application-domain specific, for example, understanding how the r

Re:RE: Data load options

2001-07-25 Thread Mohammad Rafiq
Truncation was the solution in this case as I observed in the past that direct load option use empty blocks above HWM thus using lot of space above it. If it is possible target table should be truncated before such loads... Regards MOHAMMAD RAFIQ Reply-To: [EMAIL PROTECTED] To: Multiple re

Re: Tuning question - Why did this index help so much?

2001-07-25 Thread Rachel Carmichael
it's possible that the index was small enough to stay cached in the SGA? >From: "Miller, Jay" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Tuning question - Why did this index help so much? >Date: Wed, 25 Jul 2001 08:31:

Re: statement for directory objects

2001-07-25 Thread Beatriz Martínez Jiménez
Hello again, Before sending this email,I have done some intents to get this information. One of this was through this view (user_objects) but there is no object directories in it. The way in which I have created it is 'create directory XX AS 'E:\XXX';, and I get no error, the one I think is the c

Re: Best way to upgrade database/move data

2001-07-25 Thread Mustafa
Your best way is to do a full export of the 8.0.5 data and import it into the new 8.1.7 database. Hope this helps, Defry - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 12:02 PM > Hi DBAs, > > Currently I have NT server

Looking for a tool

2001-07-25 Thread Andrey Bronfin
Dear friends ! I'm desperately looking for a reporting tool with the following characteristics. It should be able to deploy various types of charts (Bar, Column, Line, Pie etc.) to a web environment. It should be able to extract its raw data from an Oracle (or other) RDBMS , using SQL. It should

RE: both dbms_stats & dbms_utility are gathering stats on sys obj

2001-07-25 Thread Miller, Jay
Yep. That's what we do also. -Original Message- Sent: Tuesday, July 24, 2001 8:51 PM To: Multiple recipients of list ORACLE-L objects Well, first of all, you could use dbms_utility.analyze_schema() and analyze all the schemas except SYS ... or couldn't you run dbms_utility.analyze_data

RE: Rollback Segment Question

2001-07-25 Thread Yadav, Shailesh
Kamel, Looks like you may have had multiple transactions in your PL/SQL prg. Since one transaction ended, the slot used by it to store undo information was reused by other transactions. Your query did not find the required undo information and thus "Snapshot too old error". Had this been a long

Patch Level

2001-07-25 Thread Mohammad Rafiq
How could we check patch level(like c,d etc) for AP module. We are running Oracle Financials 10.7 char with database 7.3.4.5. TIA MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Plea

RE: Sun cluster vs Veritas cluster

2001-07-25 Thread Farnsworth, Dave
> Austin, Steve Hey, didn't I see you on Monday Night Raw and Smackdown?? :o) -Original Message- Sent: Wednesday, July 25, 2001 10:26 AM To: Multiple recipients of list ORACLE-L We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris -- 2.6, 2.7 and 8. It seems l

OT, "It's all about Alex"

2001-07-25 Thread Mohan, Ross
Alex, how did the paper/present go? -Original Message- Sent: Wednesday, July 25, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients

Best way to upgrade database/move data

2001-07-25 Thread Cale, Rick T (Richard)
Hi DBAs, Currently I have NT server 4.0/Oracle 8.0.5 with about 400 million records/450 tables,indices,etc. We will be getting a new NT server with Oracle 8.1.7. We will increase block size from 2k to 8k What would be the best way to move data/users/sequences,etc from existing server to new se

RE: OT, WOW really early

2001-07-25 Thread Henry Poras
Yes, Big Blue-teeth. -Original Message- Sent: Wednesday, July 25, 2001 11:17 AM To: Multiple recipients of list ORACLE-L "Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel Territory" Is that catchy enough? Something you can sink your blueteeth into? ;-) -O

RE: Sun cluster vs Veritas cluster

2001-07-25 Thread Austin, Steve S
We're using Sun Cluster 2.2 and a mix of VCS implementations, all on Solaris -- 2.6, 2.7 and 8. It seems likely our HP Service Guard will also migrate to VCS as well. The SC2.2 product has had more sensitivity to the Oracle version than the VCS product. It also seems to have more of its "guts"

RE: Dangerous AIX Bug!

2001-07-25 Thread Durinda.Jones
Ross, We're running 8162 OPS on AIX 4.3. Chat away... Durinda -Original Message- Sent: Wednesday, July 25, 2001 9:36 AM To: Multiple recipients of list ORACLE-L ...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 o

RE: OT, WOW really early

2001-07-25 Thread Jared . Still
> What is required to submit a paper/presentation to IOUGA and get excepted. > Christopher R. Spence Why Chris? Were you excepted? ;) Jared Christopher

Tuning question - Why did this index help so much?

2001-07-25 Thread Miller, Jay
The other week a new production process was running much more slowly than anticipated. A file needed to be sent out by 6:00pm and at the rate the table was being populated it wouldn't complete until around 9:30pm. The production people and developers came to me for help and I saw that the SQL E

Re: UNIX SCRIPT ISSUE - URGENT

2001-07-25 Thread Mustafa
Try awk or perl. They can handle string manipulation from OS commands simply and quickly. A simple awk script to take the first 16 characters of the output of ls and put it into a data file follows: gawk 'BEGIN { while ("ls" | getline) print substr($1,1,16) "| Report by Hosts"}' > new.dat Defr

RE: OT, WOW really early

2001-07-25 Thread JOE TESTA
yeppers, if i've got the outline done, then the whole presentation is done at that point, geez. :(   joe >>> [EMAIL PROTECTED] 07/25/01 11:06AM >>> For those of you who have been speakers before, there appears to be a new wrinkle in the submission process.  They now want an outline of the pres

RE: ERROR IN INSTALING PATCH 8.1.6.3.0

2001-07-25 Thread Miller, Jay
We had a similar problem when installing the patchset for Oracle Client on Windows. We ended up renaming each existing .dll (.dll.old) and continuing. Worked fine. Jay Miller -Original Message- Sent: Tuesday, July 24, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Had a simila

RE: Data load options

2001-07-25 Thread Jared . Still
I will second Lisa's recommendations. If you have much data, and/or will be doing this frequently, SQL*Loader is your friend. It is very fast. Loading from a SQL script is very bad unless you have small amounts of data. I once worked with a duhveloper who could not be dissuaded from loading a

RE: OT, WOW really early

2001-07-25 Thread Mohan, Ross
"Oracle 9i XML Web Apps for Wireless ERP/CRM Support in Deep DB2/Siebel Territory" Is that catchy enough? Something you can sink your blueteeth into? ;-) -Original Message- Sent: Wednesday, July 25, 2001 10:52 AM To: Multiple recipients of list ORACLE-L to submit a paper, you just n

  1   2   >