Re: Brainbench Oracle certifications

2002-04-11 Thread Jack van Zanen
Hi I did not learn for it , was working with ORACLE for two years, failing the Oracle self tests, but PASSED the Brainbench test while having spend just half hour for all Questions during lunch hour. Draw your own conclusions Jack

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Jack van Zanen
Hi I hope it doesn't matter. We have been using dynamically created "create controlfile" for years now to copy production DB to test/developnment. I believe the files are alfabetical in our case. jack

RE: Rule based engine

2002-04-11 Thread prem
Could you  give me more information on this. I do not have the Oracle 7.3 doc's

RE: Rule based engine

2002-04-11 Thread Khedr, Waleed
Check Oracle 7.3 documentation -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, April 12, 2002 1:58 AMTo: Multiple recipients of list ORACLE-LSubject: Rule based engineDoes anybody know what algorithms a rule based engine uses.?

re: Brainbench Oracle certifications

2002-04-11 Thread rpapnoi
To me, Brainbench certifications are practice tests, which are cheaper than OCP tests. They definetely increases the knowledge on the subjects or alteast gives you area of study where you feel you are weak. I found many of them and that's how I developed myself in this area. I don't think, Brai

Rule based engine

2002-04-11 Thread prem
Does anybody know what algorithms a rule based engine uses.?

RE: empty string = null?

2002-04-11 Thread Reardon, Bruce (CALBBAY)
Jonathan, I can't offer a solution but did come up with a simple example showing this behaviour for those (like me) who hadn't needed to investigate this before but were surprised by it. (done under 81714 on NT4) SQL> create table str_test ( a integer , str varchar ( 20) ); Table created. SQL

RE: Brainbench Oracle certifications

2002-04-11 Thread Abdul Aleem
Well! What's the criteria for a degree being of some value? I think at least these 3 1- How many people know about that degree 2- How hard the issuing authority works to maintain its standards for passing score, exam questions, etc.? 3- How has one obtained it, The sites like cramsession, braind

Re: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Joe Testa
no such animal svrmgrl does NOT exist (or or thatmatter connect internal either) on 9i. joe Reddy, Madhusudana wrote: >try this : >svrmgrl > connect internal; > >svrmgrl > startup; > >Then you should be able to see the error message and post that message here > >--Madhu > >-Original Messa

Re: empty string = null?

2002-04-11 Thread Jonathan Gennick
On Thu, 11 Apr 2002 17:33:18 -0800, you wrote: >I feel I had the same dream. Anyway this from Oracle 9i doc: >Nulls snip >(Oracle currently treats a character value with a length of zero >as null. However, this >may not continue to be true in future releases, and Oracle recommends that >you do no

RE: Brainbench Oracle certifications

2002-04-11 Thread Kimberly Smith
No. And I have them. -Original Message- Sent: Thursday, April 11, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t o

Re: insert performance

2002-04-11 Thread Mohammed Shakir
No enough inserts to bog down the CPUs? --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > Thanks, Mohammed and Anjo, for your replies. > > Now my question is this: given that the table structures (freelists, > etc.) are identical on the two machines, the init.ora parameters are > identical for th

RE: empty string = null?

2002-04-11 Thread Khedr, Waleed
I feel I had the same dream. Anyway this from Oracle 9i doc:Nulls"If a column in a row has no value, then the column is said to be null, or to contain a null. Nulls can appear in columns of any datatype that are not restricted by NOTNULL or PRIMARY KEY integrity constraints. Use a null when

RE: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Mohammed Shakir
try to start it manually and see what happens. Might give you clue of what is wrong. --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > Well, for one thing, you should edit /etc/oratab. That might help. > > > -Original Message- > > From: Zsolt Csillag [mailto:[EMAIL PROTECTED]] > > Sent:

empty string = null?

2002-04-11 Thread Jonathan Gennick
Oracle has always treated empty strings (e.g.: '') as nulls. As I sit here and think about this, I can convince myself that I read somewhere that Oracle9i provided an option to treat empty strings not as nulls, but truly as empty strings. Is this the case, or is my mind manufacturing memories? J

RE: redo_size values in v$sysstat

2002-04-11 Thread Mohammed Shakir
I recently started getting these high numbers in my statspack statistics. We have Oracle 8.1.6.0.0 on Solaris 2.6 platform. Shakir --- "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> wrote: > Glenn, > Without commenting on the value of the hit ratio, I can comment on > the suggestion that the bug

Re: How to determine number of freelists

2002-04-11 Thread Anjo Kolk
Paul, The number of freelists should be a prime number that is equal or just less than the number of concurrent processes inserting. Anjo. Paul Baumgartel wrote: > Hi, all. Now that I know that I must increase freelists for my tables > with heavy insert activity, does anyone have a method f

RE: redo_size values in v$sysstat

2002-04-11 Thread Reardon, Bruce (CALBBAY)
Glenn, Without commenting on the value of the hit ratio, I can comment on the suggestion that the bug affects all platforms. I am running 8.1.7.1.4 on NT4 and your query gives the following: SQL> col name for a20 SQL> col value for 999,999,999,999,999,999,999 SQL> select name,value from v$sysstat

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Molina, Gerardo
I wouldn't rely on a list generated from doing an ls on a directory because there may very well be files in that directory that are not part of the database (like files that used to be part of the db but not any more). I have a Perl script that queries dba_data_files on both source and target db'

How to determine number of freelists

2002-04-11 Thread Paul Baumgartel
Hi, all. Now that I know that I must increase freelists for my tables with heavy insert activity, does anyone have a method for determining just how many freelists the tables should have? So far, I haven't found anything in either TFM or the Net other than "increase the number of freelists". Th

RE: No DBAs needed on AS400

2002-04-11 Thread Tony Johnson
Going to show my age here ... Actually IMAGE is a network database and not a hierarchical one. It is patterned after a database called TOTAL that back in the days preceding Oracle, Sybase,etc. was installed almost everywhere. While you didnt need a DBA it was good to have people that were knowled

RE: OEM Error On Unix

2002-04-11 Thread Reddy, Madhusudana
No I was trying to start the OEM console , which requires OMS, but I do not have it on HP Unix server. So I have installed OEM on Windows and now able to work with console from my m/c. Thanks for suggestions , but not much help Thanks Madhu -Original Message- Sent: Thursday, April 11, 20

RE: init file ???

2002-04-11 Thread Reddy, Madhusudana
$OH/database is the place where ORACLE will look for the parameter file and here you can (also) have a soft link created to the Actual location of the parameter file i.e. . PFILE directory(ORA_HOME/admin/SID/pfile) . And for the control file location see the init.ora file ( parameter control_file

RE: test

2002-04-11 Thread Reddy, Madhusudana
SUCCESS !! And Congrats -Original Message- Sent: Thursday, April 11, 2002 6:19 PM To: Multiple recipients of list ORACLE-L test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (

RE: comming down the pipe

2002-04-11 Thread Paul Baumgartel
Well, at least according to Mr. Crawford... --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > The 1904 World's Fair is where "coming down the Pike" originated. > But the > reference wasn't to a turnpike or to the family of North American > fishies... > > http://www.crawforddirect.com/1904wf.html

test

2002-04-11 Thread Ivan Llamoca
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ivan Llamoca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -

RE: Brainbench Oracle certifications

2002-04-11 Thread DENNIS WILLIAMS
Andrey - Value is in the eye of the hiring manager. OCP can be most useful for consultants because you are frequently sending your credentials around. If the hiring manager has never heard of OCP, it doesn't have much value. If the guy he just fired had an OCP, he may not regard it with much value

RE: Brainbench Oracle certifications

2002-04-11 Thread Khedr, Waleed
Another piece of paper! -Original Message- Sent: Thursday, April 11, 2002 5:39 PM To: Multiple recipients of list ORACLE-L > Dear gurus ! > May i ask for your opinions regarding the value of the Brainbench Oracle > 8i Administration certifications. > I understand that it can not be comp

Re: PX Deq: Table Q qref

2002-04-11 Thread Babu Nagarajan
All I have some more information on this. I turned on event 10046 on this. From this I was able to note the following... 1. I start the sql script and spool the results 2. It waits for less than a second on "process startup" and "PX Deq: Join ACK". I think these are waits for starting up the pa

FW: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread DENNIS WILLIAMS
Rich - I frequently clone our production database to test. Since the location of the files is different, I usually end up editing the CREATE CONTROLFILE in a major way, resorting the contents sometimes to the name of the datafile and sometimes sorted to the location. We have about 200 datafiles.

RE: IOUG conference get together

2002-04-11 Thread John Kanagaraj
All, Charlie Mengler kindly forwarded a link that may help us first-timers to San Diego. Please browse at http://www.gothere.com/sandiego/gaslamp.htm Maybe we can decide a location for Dinner ahead of time! John -Original Message- Sent: Thursday, April 11, 2002 1:59 PM To: Multiple r

Re: Brainbench Oracle certifications

2002-04-11 Thread Suzy Vordos
One certain company (to remain nameless) is asking employees to obtain at least 4 Brainbench Certifications this year. And that company also uses Brainbench assessment tests for pre-employment screening. So there are certain employers taking advantage of Brainbench. But otherwise, I haven't fo

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread John Kanagaraj
Rich, Interesting one, but the order of files in the CCF really does NOT matter. As far as I could observe, Oracle is able to determine the file number from the datafile header and arrange itself. I regularly clone a 125Gb/205 file (and growing) Apps Database from one server to another and wildly

Re: disk subsystem performance question

2002-04-11 Thread Gaja Krishna Vaidyanatha
I beg to differ. I am not so sure whether what you are suggesting is even feasible on most VLDB environments today. Imagine if you have to implement at 2TB hybrid database with 500 datafiles on a RAID 1, you will have to individually maintain a large number of "independent RAID 1 logical volumes".

Re: OEM Error On Unix

2002-04-11 Thread Suzy Vordos
Wouldn't it be: oemapp dbastudio & "Reddy, Madhusudana" wrote: > > $ /usr/local/bin/sudo find / -name *oem* -print > /usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/ > 1/DataFiles/Expanded/Scripts/oemapp > /db01/app/oracle/product/8.1.7/bin/oemapp > $ > > The above

init file ???

2002-04-11 Thread Leslie Lu
Hi, I'm using 9.0.1 on win2000. When a database is created using configuration assistant, two init files are created: one in ORA_HOME/database, and the other in ORA_HOME/admin/SID/pfile. Here are my questions: 1. what's the difference between these two, why created two copies. 2. the one in O

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Jenkins, Michael - EDS
No, the order does not matter. We create control files frequently when we clone from production to test and development. We use this piece of code to generate the listing in Korn Shell: ls /*/oradata/SID/*.dbf | while read FN; do echo "'"$FN"',"; done Of course you will have to replace the fin

RE: Brainbench Oracle certifications

2002-04-11 Thread Jon Baker
Title: RE: Brainbench Oracle certifications About the only value for it is a non-IT recruiter to see if you at least know how to spell Oracle. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 11, 2002 6:09 PM To: Multiple recipients of lis

RE: Brainbench Oracle certifications

2002-04-11 Thread Janardhana Babu Donga
OCP has $125 more value than Brainbench. -Original Message- Sent: Thursday, April 11, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can n

RE: How to Find Every View In Which a Column is Used.

2002-04-11 Thread Khedr, Waleed
Ugly way: 1- Select the list of valid views. 2- Rename the table. 3- Create new table with the same name but missing the column (empty table). 4- Compile all views. 5- Invalid views are using this column. Regards, Waleed -Original Message- Sent: Thursday, April 11, 2002 5:19 PM To: M

RE: Phoee, Find views with column name

2002-04-11 Thread Jamadagni, Rajendra
This won't work if I alias the column name in the view definition, would it? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc

Re: Brainbench Oracle certifications

2002-04-11 Thread DBarbour
Andrey, The Brainbench exams are good for self-testing your knowledge of the product and exposure to nuances you may not have previously considered or come into contact with. In this regard, it's really much like the OCP, without the "official" stamp of approval. I take their exams for a varie

Re: No DBAs needed on AS400

2002-04-11 Thread Tim Gorman
Title: RE: No DBAs needed on AS400 I believe that there are ODBC and JDBC drives for OS/400... - Original Message - From: Godlewski, Melissa To: Multiple recipients of list ORACLE-L Sent: Thursday, April 11, 2002 1:28 PM Subject: RE: No DBAs needed on AS400

Brainbench Oracle certifications

2002-04-11 Thread Andrey Bronfin
> Dear gurus ! > May i ask for your opinions regarding the value of the Brainbench Oracle > 8i Administration certifications. > I understand that it can not be compared t othe OCP, but is there any > value at all for it ? > Thanks a lot in advance. > Andrey. > > -- Please see the official ORACL

RE: OEM Error On Unix

2002-04-11 Thread Reddy, Madhusudana
$ /usr/local/bin/sudo find / -name *oem* -print /usr/local/oracle8i/disk1/stage/Components/oracle.sysman.emcommon/2.2.0.0.0/ 1/DataFiles/Expanded/Scripts/oemapp /db01/app/oracle/product/8.1.7/bin/oemapp $ The above will confirm that , I do not have oemctrl on my Oracle Client on HP Unix machine.

Re: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Ron Rogers
Rick, I believe the order of the datafiles in the BACKUP CONTROLFILE TO TRACE comes from the file# in V$DBFILE. If you select from v$dbfile there is no guarantee the list will be in order of the file# and the file# is not the order in which the datafiles were created. Ron ROR mª¿ªm >>> [EMAIL P

Phoee, Find views with column name

2002-04-11 Thread dgoulet
Darn E-mail package. Every once in a while I get a message as I'm deleting one or more I don't want & one I do want goes as well. Well, I guess that's IBM/Lotus for you. Anyway, someone asked how to find all the views that include a specific column. Try the following: select view_name

Re:Brainbench Oracle certifications

2002-04-11 Thread dgoulet
Nope. Reply Separator Author: Andrey Bronfin <[EMAIL PROTECTED]> Date: 4/11/2002 1:23 PM Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared

Re: Brainbench Oracle certifications

2002-04-11 Thread Tim Gorman
is there any value to OCP? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 3:23 PM > Dear gurus ! > May i ask for your opinions regarding the value of the Brainbench Oracle 8i > Administration certifications. > I underst

RE: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Gogala, Mladen
Well, for one thing, you should edit /etc/oratab. That might help. > -Original Message- > From: Zsolt Csillag [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 11, 2002 4:04 PM > To: Multiple recipients of list ORACLE-L > Subject: ORACLE 9i doesn't start on Linux > > > > Hi, > > > I

Re: Phoee, Find views with column name

2002-04-11 Thread Igor Neyman
This provides you with the "view" columns, not the columns from the tables, which the view is based on. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 5:23 PM > Darn E-mail packa

Re:ORACLE 9i doesn't start on Linux

2002-04-11 Thread dgoulet
OH, OLD problem. Take a look in /etc/oratab . The file is formatted as :: Where the Y/N means do I or don't I start the database. It defaults to N. Change it to Y and dbstart will start your database. Dick Goulet Reply Separator Author: Zsolt Csillag

IOUG Get-together

2002-04-11 Thread John Kanagaraj
Hi all, Here's hoping this is in time for y'all who are visiting/presenting at IOUG. I believe most of you will be getting in either late Saturday or early Sunday. After completion of registration, etc., I guess we should be free on Sunday evening for a quick introduction so we know some names an

Re: Change language need help

2002-04-11 Thread Stephane Faroult
Sinardy Xing wrote: > > Hi all, > > I try to change the error message to French, Don't do that. French-speakers have to translate back to English to understand what they mean. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Aut

RE: How to Find Every View In Which a Column is Used.

2002-04-11 Thread Jamadagni, Rajendra
Ian, AFAIK, there is no direct way, as the view text is stored in dba_views and column list can be seen in ALL|DBA_tab_columns. Looks like you'll have to do some parsing ... but on the brighter side, you can restrict your look up to only those views that appeared in the dependency list of the tab

Brainbench Oracle certifications

2002-04-11 Thread Andrey Bronfin
Dear gurus ! May i ask for your opinions regarding the value of the Brainbench Oracle 8i Administration certifications. I understand that it can not be compared t othe OCP, but is there any value at all for it ? Thanks a lot in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://ww

RE: insert performance

2002-04-11 Thread Mohammad Rafiq
Disk layout and disk speed itself matters. While testing one same batch job with similar data on prod and test machine, test machine was performing same job in half of the time(2 hours) than prod(4 hours) and difference was fast fiber optical drives on test box even with slower processor but as

RE: No DBAs needed on AS400

2002-04-11 Thread Jay Hostetter
This is interesting, even though it is 2 years old: http://www-1.ibm.com/servers/eserver/iseries/db2/todba.htm It seems to be saying (if I may summarize): "As we catch up to the features and functionality of Oracle, you will need a DBA." Jay -Original Message- Sent: Thursday, April 1

Re:RE: No DBAs needed on AS400

2002-04-11 Thread dgoulet
Hey, just wait around till the Oracle support bill shows up. No, better yet, leave before then. If he/she is making decisions based strickly on expense you might as well be one of the early rats, namely leave the ship before it sinks! Dick Goulet Reply Separator

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Hand, Michael T
Rich, I believe the datafile order in a CREATE CONTROLFILE statement is critical, from lowest FILE# to highest. I'd be reluctant to prove myself wrong by testing our database copy process (I used sed to map the datafiles.), but we are moving 500-600Gb databases around and rerunning it would requ

RE: Favorite Urban Myth

2002-04-11 Thread Schauss, Peter
I'll add mine: We had a developer on a Sun box who somehow managed to set all of his source files to be executable. On that particular version of Solaris, when you went into filemgr and double click on an executable file, filemgr executed it as a shell script. As it happened, the standard heade

Re: How to Find Every View In Which a Column is Used.

2002-04-11 Thread Stephane Faroult
"MacGregor, Ian A." wrote: > > The dependencies tables do not go down to the column level. If I want to know all >views that access the sal column of scott.emp how do I do this. I can find out the >name of the views which access the table via "dependencies", get the view text and >parse it

ORACLE 9i doesn't start on Linux

2002-04-11 Thread Zsolt Csillag
Hi, I've installed Oracle 9i on Suse Linux 7.1. The lsnrctl starts nicely, however when I type "dbstart" then it does absolutelly nothing. No error message, but the database won't start. Any ideas? Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http:/

RE: comming down the pipe

2002-04-11 Thread Ron Rogers
Rich, Thanks for the update on the "Coming down the Pike" and no I wasn't at the fair then I feel as if I was at times. The pipe in reference to the "coming down the pipe" could be a plumbing joke too. Maybe I should have referenced a crystal ball by I'm not psychic, psycho maybe but not psych

RE: IOUG conference get together

2002-04-11 Thread Deshpande, Kirti
Ethan,    Do you have any recommendations for a place near the Convention Center/Downtown?   Thanks,   - Kirti -Original Message-From: Stephen Andert [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 11, 2002 1:34 PMTo: Multiple recipients of list ORACLE-LSubject: Re: IOUG

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Jesse, Rich
But you assume too much. We have three copies of our production system to three different test/dev/playground databases. First, is our nightly hot backup that gets started up as a new instance (on the prod server) for our users as a playground after the datafiles are put to tape. Second is our

Re: Exchanging partition takes a lot of times

2002-04-11 Thread Jonathan Lewis
See the book - chapter 12, page 250. It's normal behaviour. There is one bizarre SQL run if you do the exchange "without validation" and another (usually cheaper) if you do it "with validation". This relates to checking primary and unique keys, rather than the partitioning constraint. The solu

RE: Currently log-in users

2002-04-11 Thread Reddy, Madhusudana
users and what they are doing ? select v2.sid, v2.username, v2.machine, v2.program, v1.sql_text from V$sql v1, V$session v2 where (v1.address = v2.sql_address or v1.address = v2.prev_sql_addr) and v2.username is not null ORDER BY 1 ---Madhu -Original Message- Sent:

RE: NVARCHAR2 datatype and FK. Bug???? Feature ????

2002-04-11 Thread Vadim Gorbounov
BUG. Fixed in 9i. -Original Message- Sent: Thursday, April 11, 2002 12:51 PM To: Multiple recipients of list ORACLE-L Hi everybody, Oracle 8.1.7.2, Solaris. What is your opinion on this? Seems, Metalink doesn't have any :( SQL> create table test_pk( 2 id nvarchar2(20) primary k

move database to new server and higher version of same 8.1.7

2002-04-11 Thread Jeffrey Beckstrom
I don't think this should be a problem but just asking.   This is all on NT/W2K   On server A, I have a database running 8.1.7.1.5   On server B, I have other databases running 8.1.7.3.2.   To consolidate servers I plan to:1.  Take a hot backup (since it is production) of the database on Server

RE: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Reddy, Madhusudana
try this : svrmgrl > connect internal; svrmgrl > startup; Then you should be able to see the error message and post that message here --Madhu -Original Message- Sent: Thursday, April 11, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Hi, I've installed Oracle 9i on Suse Lin

RE: insert performance

2002-04-11 Thread DENNIS WILLIAMS
Paul - My point is that I have seen performance decrease when too many processes are used. For example, with imports, a multi-cpu system may import faster with two import jobs running. But at some point it seems that Oracle and/or the operating system is just trying to switch between each process

RE: comming down the pipe

2002-04-11 Thread DENNIS WILLIAMS
Rich - Thanks for this cultural education. -Original Message- Sent: Thursday, April 11, 2002 2:19 PM To: Multiple recipients of list ORACLE-L The 1904 World's Fair is where "coming down the Pike" originated. But the reference wasn't to a turnpike or to the family of North American fish

RE: ORACLE 9i doesn't start on Linux

2002-04-11 Thread Vadim Gorbounov
Hi Zsolt , check /etc/oratab, you may need to replace N by Y hth Vadim -Original Message- Sent: Thursday, April 11, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Hi, I've installed Oracle 9i on Suse Linux 7.1. The lsnrctl starts nicely, however when I type "dbstart" then it

RE: comming down the pipe

2002-04-11 Thread Sherman, Paul R.
Hello, Pipeline is for sales and gas, almost the same thing. "It's coming down the (turn)pike" is the way to describe something that is anticipated soon. Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message-

RE: OEM Error On Unix

2002-04-11 Thread Nguyen, David M
Try to do $which oemctrl or $find / -name *oem* -print Someone on the distro might add in comments David -Original Message- Sent: Thursday, April 11, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I could not see this on HP-UNIX client ( $OH/bin ) where I have inst

V$SESSION

2002-04-11 Thread Charlie Mengler
If there is an entry in V$SESSION, does it imply that user has a current session within the instance? If not, how do I determine which users have logged out of the DB? Under what conditions would I not be able to obtain any SQL from V$SQLAREA for any given SID? 1 select username, osuser, sq

Re: cache buffer chains contention

2002-04-11 Thread Jonathan Lewis
It's certainly possible for Oracle to be pushed into very heavy CPU usage, particularly for PX slaves, but even in serial queries. Two common 'causes' are queries with correlated sub-queries against small tables; and queries which have been over-indexed and hinted to avoid table-scans. Bottom

RE: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread DENNIS WILLIAMS
Jesse - No, order isn't important. This is a relational database after all - right? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 2:13 PM To: Multiple recipients of list ORACLE-L I'm writing a Perl script to automate the procedu

How to Find Every View In Which a Column is Used.

2002-04-11 Thread MacGregor, Ian A.
The dependencies tables do not go down to the column level. If I want to know all views that access the sal column of scott.emp how do I do this. I can find out the name of the views which access the table via "dependencies", get the view text and parse it by eye. But I don't want to do th

Re: Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Rick_Cale
Order of files in alter system backup... does not matter. Wow using Perl to do this when then procedure is documented a 1000 times over. I am sure you have some very good reason. Automating something that I would think is not very frequent may be overkill. Oh well enjoy. Rick

RE: No DBAs needed on AS400

2002-04-11 Thread Godlewski, Melissa
Title: RE: No DBAs needed on AS400 Comments were made that DB2 and AS400s are not "open".  Does this mean that you couldn't write a client/server program to access data on DB2 (say using C++ from Windows 2000)? RUMBA/400 formerly pc support connects to the AS400 from a windows pc.  Last I kne

RE: insert performance

2002-04-11 Thread Paul Baumgartel
Dennis-- The faster machine had 10 database connections, the slower, 50. Not all were used in either case. But my comparison is for inserts done by a single session, i.e., it's not the aggregate insert rate, but a direct comparison of the same insert statement in a single session on each server.

Do you use Rman

2002-04-11 Thread Freeman, Robert
If your company is using Rman right now, please send me a private email and let me know. I'd like to know your company name and number of databases that you backup with Rman. I would be most thankful as I will be using this information to demonstrate the viability of an Rman book to Oracle Pres

Re: Currently log-in users

2002-04-11 Thread tday6
I'm sure that everyone is sending you their version of this: ttitle off set pages 40 lines 132 column value heading '' column sessions_current format 999,999,999 heading '# Currently Logged On' column sessions_highwater format 999,999,999 heading 'Most # Logged On' column pusername format a8 head

Re:RE: No DBAs needed on AS400

2002-04-11 Thread dgoulet
DataTrieve!! That useful pile of *&^%!! I have not heard of that tool in the last 10 years, boy are you ever tweaking the memory! It was one tool that I hated to love. Yes you did have to do some configuration before it would work, but once it was working could you ever parse a file. Slice &

RE: No DBAs needed on AS400

2002-04-11 Thread tday6
I would ask myself the question, "Do I want to be working for someone this technically clueless?" I foresee a long education process via-a-vis this guy (I'm assuming that it's a guy) or a never-ending struggle just to get the basic tools that you need to do your job.

RE: comming down the pipe

2002-04-11 Thread Jesse, Rich
The 1904 World's Fair is where "coming down the Pike" originated. But the reference wasn't to a turnpike or to the family of North American fishies... http://www.crawforddirect.com/1904wf.html Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad

Is DATAFILE order important in CREATE CONTROLFILE?

2002-04-11 Thread Jesse, Rich
I'm writing a Perl script to automate the procedure to create a copy of an 8.1.7 production DB to a development server. Both production and dev are HP/UX 11.0. In doing this, I've created a file that cross-references where the production datafiles are and where they are to be placed in dev. Thi

RE: comming down the pipe

2002-04-11 Thread Ball, Terry
I alway thought it was pipeline. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, April 11, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Wasn't that expression originally "coming down the pike", as in turnpike? :-) _

RE: No DBAs needed on AS400

2002-04-11 Thread Jay Hostetter
Thank you for all the replies that I have received. It sounds like a version of DB2 comes along with the OS, or a full fledged version of DB2 can be installed. From what I have heard about their AS400 system, they can access their files directly - without going through a database. This remi

Add Instance

2002-04-11 Thread Hamid Alavi
Hi List, I have 4 instance(for 4 databases) running on sun solaris oracle 8.1.6, if i want to add one of these instance as secondary instance to one of my database is it possible or not? if YES how? Appreciate Hamid Alavi Office 818 737-0526 Cell818 402-1987 ===

Re: IOUG conference get together

2002-04-11 Thread Stephen Andert
Count me in.  When/Where?  Any San Diego local(s) on the list?   Stephen Andert>>> [EMAIL PROTECTED] 04/09/02 07:43AM >>>Do we have a location, date, time???--- Joe Testa <[EMAIL PROTECTED]> wrote:> So for those of us going to the IOUG Conf, do we> want to plan a get > together?> > Throwing

RE: OEM Error On Unix

2002-04-11 Thread Reddy, Madhusudana
I could not see this on HP-UNIX client ( $OH/bin ) where I have installed all the Oracle Client ( Administration ), Would you let me know the location , where I can find this on UNIX --Madhu -Original Message- Sent: Thursday, April 11, 2002 12:29 PM To: Multiple recipients of list ORACLE

RE: Currently log-in users

2002-04-11 Thread Nguyen, David M
Thanks for the script. It is useful for me. David -Original Message- Sent: Thursday, April 11, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_US

Re: cache buffer chains contention

2002-04-11 Thread Anjo Kolk
Yep, Using CPU or being re-scheduled by the OS. Anjo. "Adams, Matthew (GEA, 088130)" wrote:   Would it seem likely for Oracle to be doing ANYTHING for a full 30 seconds without hitting another wait? Matt Adams - GE Appliances - [EMAIL PROTECTED] Reason is 6/7ths of treason. - The Xtals -

Re: Submit job last day of each month

2002-04-11 Thread Igor Neyman
Oops... Sorry, should be: 'TRUNC(LAST_DAY(SYSDATE))' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 1:03 PM > Your job interval should be: > > 'TRUNC(LAST_DAY(SYSDATE) +

RE: migrate from 8i to 9i

2002-04-11 Thread Shaw John-P55297
You must be thinking of something else, I just got thru doing a 9i import of an 8i dmp file. -Original Message- Sent: Thursday, April 11, 2002 12:03 PM To: Multiple recipients of list ORACLE-L I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot conn

RE: migrate from 8i to 9i

2002-04-11 Thread Wong, Bing
If that new box is a sand box, I would just play to see if exp of 8i can be imported in 9i. -Original Message- Sent: Thursday, April 11, 2002 10:03 AM To: Multiple recipients of list ORACLE-L I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot con

Re: No DBAs needed on AS400

2002-04-11 Thread Brian_P_MacLean
In the late 80's and early 90's I worked on an AS/400. We also had NO DBA, and the box looked and ran like we had NO DBA. Back then IBM pushed AS/400's as a "put it in and forget it/don't worry about it" box. And as a result our "database" looked and ran like a POS. I remember submitting jobs

  1   2   >