RE: * Oracle DBA Needed in Phoenix..

I was this close to working at seven-11, you know? *mandatory Fast Times quote* -Original Message- Sent: Thursday, July 05, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Thursday, July 05, 2001, 4:15:20 PM, you wrote: O We would like to submit someone who is a renter and who

Re: * Oracle DBA Needed in Phoenix..

On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O We would like to submit someone who is a renter and who is interested . . . .|O in Phoenix but has not applied to Phoenix companies and is not working with . . .

RE: * Oracle DBA Needed in Phoenix..

Title: RE: * Oracle DBA Needed in Phoenix.. Jonathan, I think if we retranslate it, we can ascertain what Bill was talking about. We would like to submit someone who is a renter and who is interested in Phoenix... We aren't telling you that this company doesn't really want you long term.

Stand alone Procedure v/s Package Procedure

Hi, What are the advantages/disadvantages of using procedures in a package as compare to stand alone procedures in application. Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network

Listing parameters changed at the session level

Okay, I've consulted all of the Oracle posters I have pinned to the wall here -- my TUSC posters, the Computer Associates poster -- and I've now gotten desperate enough that I'm starting to dig into the Oracle documentation on Technet. But, I figured I'd post to the list and risk getting a few

RE: OT: Just chatter about Wireless costs and PocketDBA

Most fun I ever had with my PalmPilot was when I took it up in the hills and shot it with my Remington .300. I don't miss it a bit. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, July 05, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Ross, What

Re: can/do indexes chain?

Charlie Mengler wrote: I've been asked to create an index which combines two fields, date location. For reasons I don't really want to explain, we need/desire this index to be in the order of date, location. The minor gotcha is that while location will be populated at the time the record

HOW MUCH % SGA SHOULD BE FREE IN OLTP?

Hi In general how much % SGA should be free in OLTP ? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET:

RE: can/do indexes chain?

Update in the index is done as delete and insert, so there is no chaining. Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 5:46 PM To: Multiple recipients of list ORACLE-L I've been asked to create an index which combines two fields, date location. For reasons I don't

RE: 11 disks to build a DB, suggestions

Hi Rahul, and Yosi I misunderstood you Rahul I'm sorry, you need both redo logs (log01 and log02, these are different redo goups and not different members of the same group, as I thought) (Yosi is right about this, off course) Now according to this information, I'll be still consistent with my

RE: OT: Ari and his company have been noted in InfoWorld.

Michael, No not all databases are the same but many are. DBA's as a whole are extremely inefficient. Most of us well know that we could automate much of what we do if we just sat down and thought about it for a second. I mean come on, why should a DBA have to actually check dozens of V$ views

temp tablespace is permanent tablespace

Hi, One of the generic users (multiple people use the same logon/password) on one of my db's has been assigned temporary tablespace which is a permanent tablespace type, i.e. (select contents from dba_tablespaces where tablespace_name=my_ts_name; returns PERMANENT). I was told by let it stay

Re: How to precreate tables for migration?

Since you mentioned partitioned tables, watch out for: Bug 973502 THE PARTITIONED INDEX IS NOT IMPORTED AS A PARTITIONED INDEX If you are happy with the storage parameters, you can skip steps 3 and 4, because step 5 creates everything for you - except the above !! [EMAIL PROTECTED]

RE: OT: Ari and his company have been noted in InfoWorld.

Ethan, Your scenario reminds me that I should have invested in paper company stocks when the paperless office was being theorized. Much of the inefficiency in which we indulge is due to extremely poor craftsmanship on the part of the people who produce packaged applications. When the

RE: temp tablespace is permanent tablespace

Hi Lyuda, What platform and what version? If on 815 and using global temporary tables (GTTs) then perhaps the temp tablespace was set to permanent to avoid some of the errors associated with GTTs. That said, by having the tablespace with permanent contents, the performance is probably worse.

Re: Listing parameters changed at the session level

Hi Walt - Kinda getting into this myself recently. I found a reference to an undocumented dbms package on Metalink today called: dbms_system.read_ev I'm playing around with their test scripts to see what I can do with this in conjunction with v$session and tracing and auditing. Check out

OFA (Optimal Flexible Architecture) in practice

Title: OFA (Optimal Flexible Architecture) in practice Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g..

RE: Listing parameters changed at the session level

Walt, How about select * from v$parameter where ismodified ='MODIFIED'; Extract of doco is below (817 reference manual on v$parameter) ISMODIFIED VARCHAR2(10) Indicates how the parameter was modified. If an ALTER SESSION was performed, the value will be MODIFIED. If an ALTER SYSTEM (which

OT: Learning Curve for Informatica ETL Products

Listers, For any of you who use Informatica ETL products such as PowerMart and/or PowerCenter, how steep is the learning curve for these products? I know there are lots of variables such as how quickly does the person pick up new things, are we talking about learning the basics and doing simple

Re: OFA (Optimal Flexible Architecture) in practice

Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g.. /u02/oradata/db_name1/userdata01.dbf /u02/oradata/db_name2/userdata01.dbf

Re: temp tablespace is permanent tablespace

On July 5, 2001 07:55 pm, [EMAIL PROTECTED] wrote: Hi, One of the generic users (multiple people use the same logon/password) on one of my db's has been assigned temporary tablespace which is a permanent tablespace type, i.e. (select contents from dba_tablespaces where

Re: OFA (Optimal Flexible Architecture) in practice

Linda, Try ls -ltr /*/oradata/db_name1/* Didn't think of that, didja. It's actually pretty cool that (in Unix) you can actually reference all your data/log/control files with one filespec. Doesn't work well on NT, but it's better than non-OFA. HTH, Yosi "Hagedorn, Linda" wrote: Does anyone use

RULE versus CHOOSE

Database = Oracle 8.1.7.0.0 on SunOS 5.6 . Current Database Size = 20 GB This is only a Test One the Live Production will be a BIGGER (100 GB) One . OPTIMIZER_MODE = RULE NO Statistics Exist Currently Qs.1 How does optimizer_mode=CHOOSE Compare with RULE ? Qs.2 Is there ANY Benefit of

Re: Schema organization

ya gotta love them new triggers in 8i. I used a similar scheme to keep duhvelopers from changing the passwords on common development accounts, because they would promptly forget them and call the DBA. Jared On Thursday 05 July 2001 09:21, JOE TESTA wrote: yeppers, if you want to prevent

Re: OT: Learning Curve for Informatica ETL Products

Larry, I took several training courses last year for one of their competitors products, Ardent Datastage, though it's called something else now. Anyway, they're very similar, we evaluated Informatica also. They are both very powerful products. If my experience with the Ardent products is any

No Subject

Hello guys, can anyone tell me how can i have two versions of oracle on the same machine. Is it possible. I have to put together 8.1.6 and 8.1.7 on the same machine. I'm using Windows NT. Thanks in advance Tom Pilfer _

<    1   2