Re: HELP HELP HELP HELP !!!!!!

Check the Alert log to see what's going on Ali TOYGAR

Re: HELP HELP HELP HELP !!!!!!

What version of Oracle are you using, what is your operating system, and what happened to cause you to resart the server several times? I don't think that's going to help you, in fact it may make things worse. Looks like Oracle is trying to perform an instance recovery from a crash and applying

RE: HELP HELP HELP HELP !!!!!!

Always try to use a meaningful subject! When ny mail recipe rules ( my consciuos) see a subject like this, its is interpreted for spam or virus mail hence ignored/deleted - could have done better with: Back to the topic: Check the OS logs also for possible cause of loss of services. A clip into

subtract minute from date/time

I want to subtract a minute from a date/time How can I do this? 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: (858) 538-5051 San Diego, California-- Public

Re: subtract minute from date/time

date-1/(24*60*60) Jack John Dunn

RE: subtract minute from date/time

I know that if you have a date field then you can get the hour using the formula date_field/60/60/24 thus to get the minutes will be date_field/60/60 -Original Message- Sent: Thursday, April 11, 2002 14:08 To: Multiple recipients of list ORACLE-L I want to subtract a minute from a

Re: subtract minute from date/time

select to_number(to_char(sysdate, 'MI')) from dual; JP On Thu 11. April 2002 13:08, you wrote: I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

RE: subtract minute from date/time

date_fld - 1/1440 Iain Nicoll Test and Release De-Regulated Services Internal : 700 2331 External : 0141 568 2331 -Original Message- Sent: Thursday, April 11, 2002 12:08 PM To: Multiple recipients of list ORACLE-L I want to subtract a minute from a date/time How can I do this?

Re: subtract minute from date/time

To subtract a minute you can do it this way select to_char(sysdate,'DD-MON- HH24:mi:ss') , to_char((sysdate - 1/(24*60)),'DD-MON- HH24:mi:ss') from dual; Hope this answers your query John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/11/02 04:38 PM Please respond to

Re: subtract minute from date/time

Try this query: select to_char (sysdate - (1/(24*60) * 5),'HH24:MI:SS') from dual; ^ this subtracts 5 mins from current date time. On Thu, 11 Apr 2002, John Dunn wrote: I want to subtract a minute from a date/time How can I do this? John

RE: disk subsystem performance question

I just started a couple days ago at this client. They're using Hitachi technology in the QA and prod environment with 181G disk. I asked the SA twice and he confirmed the 181 G disk. I'll ask more details to the SA as soon as I know him better. --- Deshpande, Kirti [EMAIL PROTECTED] a écrit 

Re: subtract minute from date/time

Sorry this is one second :-) Jack van Zanen

Utl_file

Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the columns bold and right positioned. Please give me an easy example on how to write the code. Thanks in advance Roland -- Please

RE: Does index need rebuilding when table is truncated

Good point Robert, The reason the index space still exists after a lot of deletes is the method the index is stored in the database. very similar to the old organization chart of a large corporation. If you eliminate all of the people between the CEO and the janitor you still have the multiple

RE: subtract minute from date/time

I'm glad its not just me thats having a bad morning making the numbers work... My understanding of it goes something like this: When working with date/times, oracle considers 1 to mean One day. There are 24 hours in every day, so to get the figure for one hour you use 1/24 eg sysdate - 1/24

PLS-00201: identifier 'SYS.DBMS_AQ' must be declared

Hi all. I am using the package dbms_aq in a pl/sql program and it's working fine but when i changed the same program into a trigger it's showing the error PLS-00201: identifier 'SYS.DBMS_AQ' must be declared. I have granted execute permission on dbms_aq to that user . Do i need to

Re: Utl_file

utl_file.put_line(file_id, col1||','|| col2||','|| col3); etc for a CSV file hth connor --- [EMAIL PROTECTED] wrote: Hallo, Is it possible to do a select from some tables in the database and then use utl_file package to create an excel file. And also to make the headers in the

RE: Does index need rebuilding when table is truncated

But the original poster was referring to a truncate ... aka Enron using your metaphor :-) Cheers Connor --- Ron Rogers [EMAIL PROTECTED] wrote: Good point Robert, The reason the index space still exists after a lot of deletes is the method the index is stored in the database. very

Re: Utl_file

Connor, Do you really think, that Roland will be satisfied with your reply ?:-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 9:23 AM utl_file.put_line(file_id,

comming down the pipe

List, I just returned from a 9i seminar and in one of the presentations a NEW version of Oracle was briefly discussed, 10i. It is planned to be able to handle the buffer cache, memory allocation, datafiles, tablespaces , etc, etc automatically and efficiently. There were many other items

Re: TKPROF?

I have heard two different ones, no idea if either is correct :-) trace kernel profiler transient kernel profiler John [EMAIL PROTECTED] wrote: What does it stand for? Tool Kit Profiler??? tia, David Nemeth __ Do You Yahoo!? Yahoo! Tax Center

Re: disk subsystem performance question

Marie, there is a thread going on this Oracle list about disk subsystem speed, I am going to forward a couple of the responses to you. I think that it is reiterating that we need to have raid 0+1 in our PROD environment. [EMAIL PROTECTED] 04/10/02 01:06PM James Howerton wrote: John,

No DBAs needed on AS400

We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400, we didn't need a DBA. Me: Then you probably were just using files. Director: No, it was a

RE: TKPROF?

I thought it was Trace Kernel Profiler. PB --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Transient Kernel Profile. - Kirti -Original Message- Sent: Wednesday, April 10, 2002 8:38 PM To: Multiple recipients of list ORACLE-L What does it stand for? Tool Kit Profiler???

Re:RE: comming down the pipe

I'll believe it when I see it. Oracle, like MicroSlop, is into vaporware too. Reply Separator Author: Jamadagni; Rajendra [EMAIL PROTECTED] Date: 4/11/2002 6:03 AM We have a bug in 9012 that we were asking for backport, but were told it is merged

RE: No DBAs needed on AS400

Jay, I would provide a list of functions you perform daily and what would happen if they are not completed in a timely manner. I would also update my resume. Sounds like a pretty naive director of IT. Either he/she is making a play to move you out and get a prior buddy in place, or is a

Re: comming down the pipe

Wasn't that expression originally coming down the pike, as in turnpike? :-) __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul

OT: Oracle to DB2 books?

I checked bookpool and amazon and can't seem to find any decent books for experienced DBA's who need to learn UDB/DB2. Has anyone found a decent book for Oracle DBA's needing to learn UDB? Since my company has chosen UDB for 'strategic' reasons on an upcoming project I need to learn this

RE: No DBAs needed on AS400

From discussions that I have had here, DB2 on the AS-400 IS implemented as indexed flat files against which you write sql. It IS a database (says rdbms right on the box). Insight... I'm not sure why he is tied to the AS-400... -Original Message- Sent: Thursday, April 11, 2002 8:54 AM

RE: No DBAs needed on AS400

On the AS400 IBM created DB2/400 that allowed DB2 to be ported to that platform. If they are not running DB2 on that platform, then they are using CICS-400 with VSAM files. Now. If you are performing queries from Oracle to DB2 (SQL Queries), that is being performed through Oracle's gateway

Re: No DBAs needed on AS400

I believe they have a form of DB2 called DB/400 (or something like that). I don't think Oracle runs on this platform. The Progress RDMS ran on it at one time, but it was a mess, so not anymore. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list

bytes per extent

Is there a query to get the number of bytes used and free in an each extent? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell

Re: No DBAs needed on AS400

It's been a while since I actually worked on a AS400 but from my understanding, DB2 is integrated into OS400, the operating system for the AS400. In the System/36 and System/38 worlds, you used RPG and a bunch of other utilities to create your programs and files. The files were flat files and

RE: insert performance

Paul - How many insert processes did you run on each system? Is the disk layout identical in terms of spreading across devices? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 10, 2002 6:43 PM To: Multiple recipients of list ORACLE-L

Re: No DBAs needed on AS400

So you can cover his ass when a problem happens. On Thu, 11 Apr 2002, Jay Hostetter wrote: We are going through a merger, and management is looking to eliminate positions. Here is a brief summary of my discussion with the new director of IT: Director: Back when I we were using an AS400,

RE: Oracle to DB2 books?

Brian - you might check IBM's Web site. They have typically been generous with their information. Another resource would be to start getting familiar with DB2 newslists. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, April 11, 2002 9:29 AM To:

Re: redo_size values in v$sysstat

Glenn, The buffer cache hit ratio is meaning less, not only after startup but any time you calculate it. I am pretty sure that I am not the first one and probably not the last one saying that on this mailing list. Now about the claim of why you need to wait until 10i to get this fixed, has

RE: comming down the pipe

It wasn't awl pike, as in the 20 - 30 ft long Swiss pikes used in the late middle ages? Never mind. What's a turnpike??? I know nothing. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, April 11, 2002 11:24 AM To: Multiple

Re: bytes per extent

Here is a script that I got from another lister. Hope it is what you're looking for. column tsname format a25 heading 'Tablespace Name' column tot format 99,999,999 heading 'Size (K)' column fsp Format 99,999,999 heading 'Free (K)' column csp Format 999,999 heading 'Free|Extents' column msp

RE: No DBAs needed on AS400

Jay - I can see the manager's confusion. After all, one expects computers to become easier and require less effort to maintain as time goes by. I forwarded your question to another list that has some AS/400 programmers. -- On the AS400 you

Re:No DBAs needed on AS400

Jay, We still have one of those dinosaurs running here called HP's TurboImage database. It also does not need a DBA, actually it does not understand what a DBA is. The database is hierachtical with the constraints set during creation. I constantly have fun with the older ManMan developers

RE: No DBAs needed on AS400

Just tell him that with AS400 one doesn't need a CIO either and that will be the end of that. AS400 is a closed system, perfect for running canned apps, maintained by somebody and is, in essence, equivalent of outsourcing. For that, you don't need to have an IT, just a person to manage the

Re: Favourite Urban Myth

He would have used 'renice' if we had let him have root. Jared On Wednesday 10 April 2002 09:33, Alan Davey wrote: You mean he didn't use the 'nice' command? ;^) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City

Re:bytes per extent

None that I aware of, but check out DBMS_SPACE. Dick Goulet Reply Separator Author: Ray Stell [EMAIL PROTECTED] Date: 4/11/2002 6:39 AM Is there a query to get the number of bytes used and free in an each extent?

Currently log-in users

How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: No DBAs needed on AS400

Jay, The AS400 machines are the heirs to the System 38 machines which were themselves derived from a 'Future System' which was so revolutionary that it was killed off by the IBM marketing on the eve of announcement for fear that it would frighten their System 360/370 customers (the cost of

Re: Favourite Urban Myth

Thanks, I was somehow not recognizing the part where you said the shell script was named 'rm'. Yeah, that would take a system down. Here's one for you. It's happened to me twice, many years ago. What happens when you want to remove all of the *.txt files in a dir and are a little slow

RE: cache buffer chains contention

Title: RE: cache buffer chains contention 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 -Original Message- From: Jonathan Lewis

Re: No DBAs needed on AS400

I never worked on AS400, but this aligns with what I recall. I believe that the System/38 was the first IBM system that had an embedded database. (System 36 did not -- it used older technology.) And that was used as the basis for the AS400. If I recall correctly, the OS used the database to

svrmgrl vs. sqlplus

Hi all, I have problem with my oracle client on linux. Using 'svrmgrl' I can connect to a database but if I use 'sqlplus', I get an ORA-01034 error. Can anybody say me why? And how to repair it? Server: Alpha with Tru64 Unix 4.0F: Oracle7 Server Release 7.3.4.0.0 with the 64-bit option -

RE: bytes per extent

Here are a few scripts: PROMPT PROMPTShow free and used blocks allocated to table or index and indicate HWM PROMPT PROMPT This script will request 2 parameters if not specified on the command line: PROMPT1 = owner of tables to check (wild cards allowable) PROMPT2 = name of table to

Re: No DBAs needed on AS400

Can't help you there. The AS/400 evolved from the S/34, S/36, and S/38 line of IBM machines. My 77-yr-old stepfather (at the time, 62-yrs-old) bought a S/38 for his trucking company in NJ, complete with payroll, GL, AR, AP, etc software. He didn't have an IT department, needless to say. They

Re: Currently log-in users

Start with v$session. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 11:53 AM How do I check who is currently logging into database, where he is accessing from and what he is

RE: Currently log-in users

v$session would be a good startin place. Dave -Original Message- Sent: Thursday, April 11, 2002 10:53 AM To: Multiple recipients of list ORACLE-L How do I check who is currently logging into database, where he is accessing from and what he is doing? Thanks, David -- Please see the

RE: svrmgrl vs. sqlplus

Michal, The only problem similar to that I have seen on 6.1 Red Hat was the result of a problem in the sqlnet.ora. Are you sure the names, TRACE_LEVEL, etc that should be the same for all the target instances (78) are the same? Good Luck! John -Original Message- Sent: Thursday, April

RE: No DBAs needed on AS400

We have DB2 running on an AS400 and have a DB2 DBA. She does those unimportant things like backup/restore, source control, duhveloper control, database reorgs and all sorts of other junk. She is busy all the time. -Original Message- Sent: Thursday, April 11, 2002 10:44 AM To:

OEM Error On Unix

Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this Management server and how to start it on HP Unix .. Thanks in advance ...OLE_Obj... Thanks, Madhu V Reddy Database Support

Submit job last day of each month

Hi, Does anyone know how I can submit a job using dbms_job the last day of each month. I know there is a last_day function but cannot figure how to use this correctly in dbms_job. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

Re: Currently log-in users

Hi, You may use the view V$SESSION. Regards M.Emre HANCIOGLU Masterfoods Services GmbH Nguyen, David M [EMAIL PROTECTED] xo.com Sent by: [EMAIL PROTECTED] 11.04.02 17:53 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

Re: package in sqlarea

Thanks Mohammed! Some comments: tools that query from the V$SQLAREA seeking inefficient SQL by looking at DISK_READS (i.e. physical reads or cache misses on the Buffer Cache) and BUFFER_GETS (i.e. logical reads) can only be as effective as the Shared SQL Area cache in the Shared Pool. That is,

Re: svrmgrl vs. sqlplus

All my sqlnet.ora is: names.default_domain = suas.cz sqlnet.expire_time = 10 John Weatherman wrote: Michal, The only problem similar to that I have seen on 6.1 Red Hat was the result of a problem in the sqlnet.ora. Are you sure the names, TRACE_LEVEL, etc that should be the same for

Exchanging partition takes a lot of times

I'm testing the exchange partition and it's taking 90 seconds to exchange a table containing 700 000 rows with a partition containing also 700 000 rows. I've noticed that SYS is doing a crazy select to check on the PK of the tables even if I used whitout validation in the exchange statement. I

Re: Currently log-in users

Some selects You can find in http://www.itsystems.lv/gints/dba_selects.htm I'm sure there are websites with more scripts around the net, of course... Gints Plivna IT Sistçmas, Meríeïa 13, LV1050 Rîga http://www.itsystems.lv/gints/ How do I check who is currently logging into database, where

Re: Currently log-in users

Here's a good starting point. If you want I also have a unix shell script driver for this that does a little more formatting. set feedback off set heading off set timing off set time off set echo off set term off set pagesize 256 set space 1 column username format a8 column machine format a8

RE: OEM Error On Unix

Oops !!! Error message is missing , here is the error: VTK-1000: Unable to connect to the management server server.mydomain.com. Please verify that you have entered the correct host name and the status of the Oracle Management Server. Thanks Madhu -Original Message- Sent: Thursday,

Re: migrate from 8i to 9i

I think you have to use only the 8i version on EXP and IMP in this case, as 9i EXP cannot connect to 8i database and 9i IMP cannot read 8i EXP dmp file. --- Kader Ben [EMAIL PROTECTED] wrote: Thanks I'm thinking about this idea, Ben --- [EMAIL PROTECTED] wrote: I'm assuming that

Re: disk subsystem performance question

Battery backup on the controller should help in this case. If there is none, write back mode should be used (instead of write through), loosing advantages of on-board caching (still helps with the reads). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple

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

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 key 3 ); Table created. SQL create table test_Fk( 2 id nvarchar2(20), 3 constraint c_test_FK foreign key(id) references

Re: Utl_file

I don't think you will be able to do what you want with utl_file unless you know the entire Excel file formatting details. I don't think BOLDING, RIGHT JUSTIFY, etc. can be part of a .cvs file. I know that Oracle has several products or options for $$$ that can do a lot of the Excel formation

Re: Submit job last day of each month

Your job interval should be: 'TRUNC(LAST_DAY(SYSDATE) + 1)' Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 12:25 PM Hi, Does anyone know how I can submit a job using dbms_job

Re: Currently log-in users

Try either of 1 script and make changes according to your requirement: 1) col LOGIN_TIME format a12 COL OSUSER FORMAT A7 COL ORACLE_USER FORMAT A8 COL PROGRAM FORMAT A25 COL PROCESS_NR FORMAT A8 col uur format A5 select to_char(a.logon_time,'DD/MM HH24:MI') LOGIN_TIME,

RE: Utl_file

search on asktom.oracle.com for owa_sylk package, this is much better to export as excel format than csv format. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: OEM Error On Unix

Try oemctrl start oms -Original Message- Sent: Thursday, April 11, 2002 11:26 AM To: Multiple recipients of list ORACLE-L Hell All, I am seeing the following error , when I am trying to start OEM console on HP Unix. Any Idea , what I am missing and would like to know , what is this

Re:Submit job last day of each month

declare job_id number; job varchar2(2000) := 'Fill in what you need'; begin dbms_job.submit(job_id, job, last_day(sysdate). 'last_day(sysdate)'); dbms_output.put_line('Job number is: '||job); end; Dick Goulet Reply Separator Author: [EMAIL

Re: No DBAs needed on AS400

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,

RE: migrate from 8i to 9i

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

RE: migrate from 8i to 9i

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

Re: Submit job last day of each month

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) + 1)'

Re: cache buffer chains contention

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: Currently log-in users

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

RE: OEM Error On Unix

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

Re: IOUG conference get together

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 this out for

Add Instance

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: No DBAs needed on AS400

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

RE: comming down the pipe

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? :-)

Is DATAFILE order important in CREATE CONTROLFILE?

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.

RE: comming down the pipe

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]

Re:RE: No DBAs needed on AS400

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: Currently log-in users

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

RE: insert performance

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

RE: No DBAs needed on AS400

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 knew,

Re: Is DATAFILE order important in CREATE CONTROLFILE?

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

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

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

RE: Is DATAFILE order important in CREATE CONTROLFILE?

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

Re: cache buffer chains contention

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.

V$SESSION

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,

RE: OEM Error On Unix

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

RE: comming down the pipe

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

RE: ORACLE 9i doesn't start on Linux

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

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

  1   2   >