RE: Who is Melanie Craft?

Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G Marriage Builder product, it requires plenty of tuning and costs an absolute fortune. Other features include Parallel nagging, a new wifemon process that never clears anything up and after 3 months the whole product

Re: ora-1555 under automatic undo management (resend ?)

I'm having an ora-1555 under Oracle9 database and not sure what I can do to get rid of it. I had some recollecions from Oracle8 days , but the things like adding a new rollback segment or shrinking the segments I don't think are applicable under the auto undo management. Besides separating

RE: most practical 9iR2 features?

1. that Set oracle_sid=blah Sqlplus user/password Works on terminal server. 2. I like the workspace memory management features as well. 3. trace file timings in microseconds. 4. Cursor_sharing=similar (still has the odd bug). 5. HTMLDB is marketed for 10g but will install on 9.2

Re: powerbuilder in rbo and multiple constraint question...

Chris, I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish. Cheers, Chris Dunscombe Quoting Chris Stephens [EMAIL PROTECTED]: I'm working with a 3rd party vendor

Staled Object

List, Gather Stale option of DBMS_STATS gathers statistics only for table which has modified more than 10%. Is there any way i can change this default 10% to any other value? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and

Re: Oracle vs Mysql

can't beat them, join them... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Excellent reasoning Nuno. I hadn't thought of that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services

RE: Who is Melanie Craft?

as opposed to the ever-present Oracle kernel which is arbitrary, gobbles up all resources in sight and costs the earth to maintain? --- Noyce, Robert A SITI-ITPSIE [EMAIL PROTECTED] wrote: Apparently to celebrate his new marriage, Larry is releasing the new Oracle 10G Marriage Builder product,

Connection Problem

Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an 12154 - Could not resolve service name error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their

RE: Connection Problem

Hello Mark, all 3 instances are listening on the same port. Cheers Barry. -Original Message- Mark Leith Sent: 16 January 2004 11:14 To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP

Opinion on Changing Names

Hi list, Every night I update the development DB through a cron job, now I have the requirement of change or scramble the names of our customers to protect and privacy of information. I have been thinking of adding a procedure to the script that update all the names using a REPLACE

SQL server and JOB

Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Opinion on Changing Names

Ramon, Take a look at the DBMS_RANDOM package. You can replace the name with a random number. That ought to do the trick. Good Luck Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 7:49 AM To: Multiple recipients of list ORACLE-L Hi

RE: SQL server and JOB

Try to have the SQL Server DBA fired. - --- Original Message --- - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Fri, 16 Jan 2004 04:59:26 Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L

RE: SQL server and JOB

Firstly Arslan, it should probably be pointed out that this is an Oracle list, not SQLServer. But, seeing as I deal with both database types, I'll have a stab at this.. You can create jobs under the SQLServer Agent. If you open up SQLServer's Enterprise Manager, and navigate to your Server, there

RE: Connection Problem

Mark, The (GLOBAL_DBNAME= l1000.) entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status lsnrctl services show? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16,

RE: What is Hash Join?

Thanks a lot for the information Kevin :), that's quite a light to me. So... Is it best to try to get hash join on execution plan at all time? Regards, Wendry. -Original Message- Sent: Thursday, January 15, 2004 9:09 PM To: [EMAIL PROTECTED] In my experience, Hash Joins have proven

RE: List problems (duplicate?)

For the record, I've been having the same problem at two email addresses. Iguess one question is whether it is consistently the same email that no onegets. If it's my mail gateway seeing it as spam, will everyone see it as spam?For example I got Dan's "Partioning question (duplicate?)"

Re: SQL server and JOB

First, you may have to quit your job in Oracle... on 1/16/04 5:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED]

Fwd: UTL_FILE_DIR on 9iR2

Ah! - got it. To simplify my question I hadn't mentioned that I had more than one allowed directory, and this was where the problem lay: I did: ALTER SYSTEM SET UTL_FILE_DIR = 'directory1, directory2' SCOPE=spfile; Whereas what is required is: ALTER SYSTEM SET UTL_FILE_DIR =

Re: What is Hash Join?

Hi! Note that hash joins are very prone to extreme performance degradation when statistics outdated (don't reflect real rowcounts/sizes in tables). When optimizer decides to go with hash join because it thinks that there is 1000 rows in driving table, but there is 100 instead, all driving

RE: Connection Problem

I've asked for the out put on a lsnrctl status already, but haven't heard back from him as yet.. The . does look strange.. Also, what would the impact be to have the GLOBAL_DBNAME set to the same value for all three instances? Would it not be better to set it to the same name as the instance name

Re: Checkpoint ...

I don't believe that datafiles in Read Only tablespaces have the scn updated. I've not tested it, but it is logical. Daniel Fink [EMAIL PROTECTED] wrote: All, Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any

RE: Connection Problem

Mark, I don't think that all three on the same port is a problem - heck - I do it all the time. I would comment out the GLOBAL_DBNAME entry. It certainly is not required. And output from lsnrctl would be helpful. Tom Mercadante Oracle Certified Professional -Original Message- Sent:

ORA-904 after table rename

We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904

Re: ORA-904 after table rename

Does his version of TOAD support your Oracle server version ? We tried to run our (outdated) version of SQL Navigator against a 9i DB and would get weirdness like this from time to time when accessing the Oracle data dictionary. mvg/regards Jo Norris, Gregory T [ITS] [EMAIL PROTECTED]

Re: Connection Problem

I don't believe a 12154 error has anything to do with the listener. The request never leaves the client. It has all to do with the fact that sqlnet on the client can not find the service name in the tnsnames.ora. What is names.default.domain set to in sqlnet.ora. If there is no sqlnet.ora try

Re: Checkpoint ...

Yep, you're correct, everything is frozen in datafiles when they're in read only mode (you can have read only datafiles on read only media if you want). Also, no controlfile records (like checkpoint cnt, checkpoint scn) for read only datafiles are not changed, I've verified this with controlfile

Re: Checkpoint ...

Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other

Re: Checkpoint ...

Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen..

DBMS_OBFUSCATION_TOOLKIT

Hi Listers, Does the Oracle dbms_obfuscation_toolkit (DOT) support generating a non-randomized encrypted result? In other words, can we encrypt something like ‘international’ and get the same encrypted result each time we pass ‘international’ to the DOT? - Paula W. Do you Yahoo!? Yahoo! Hotjobs:

RMOUG Training Days 2004

The Rocky Mountain Oracle User Group Training Days is just around the corner. Come join us for 2 days of technical presentations, vendor exhibits and networking. Among the speakers are oracle-l contributors Tim Gorman, Rachel Carmichael, Cary Millsap, Anjo Kolk, Tanel Poder, Daniel Fink, Don

How to update maxphys on Solaris 8 ......

Dear List, Could someone tell me how to update the parameter "maxphys" on sun solaris 8 system. At present it is having a default value of 128K. I would like to change it to 1MB. There is no such parameter in /etc/system. I need this parameter to be updated as it seems to be controlling

Reasonable layout for DSS

Does this layout seem reasonable as a starting point for a Windows 2003/Oracle 9.2 DSS database? Volume 0 Mirrored 33 GB OS (Windows 2003) Volume 1 Mirrored 33 GB Oracle Home / Archive Logs / UNDO Volume 2 Mirrored 33 GB Redo / Temp / System Volume 3 RAID 5 409 GB

how to hide oracle password from a unix ps -ef | grep?

Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it?

a quick pl/sql question

Hi: In pl/sql, I want to add chr(10) into a string in every 70th position. The string can be up to 2000 characters long. The follwoing code works. But is there an even FASTER way to do this? Thanks. Guang --- declare pos number := 1; len number; buf varchar2(2000); x

Re: how to hide oracle password from a unix ps -ef | grep?

Sure. Create the database userid so that it is authenticated externally (Identfied externally). Then the userid can log in via SQL*Plus using a / instead of a userid or password. The OS userid should be a controlled account so that everyone and his grandmother cannot log into it. If it is a

Re: how to hide oracle password from a unix ps -ef | grep?

Create a dummy user dummy with pw as dummy and only with create session priv. Execute a sql script which will connect to the username/pw and which does not have read privs at os level for others. May be someone on the list has a better idea. HTH GovindanK On Fri, 16 Jan 2004 10:04:35 -0800,

Re: how to hide oracle password from a unix ps -ef | grep?

Ryan wrote: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? Try http://asktom.oracle.com/pls/ask/f?p=4950:8:12188015396454707431::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:142212348066, -- Bricklen Anderson, Database Administrator

RE: how to hide oracle password from a unix ps -ef | grep?

Title: Message You can do any of: sqlplus /nolog connect user/[EMAIL PROTECTED] export TWO_TASK=whatever sqlplus user Password: xxx sqlplus [EMAIL PROTECTED] Password: xxx Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him

RE: how to hide oracle password from a unix ps -ef | grep?

start sqlplus then loginif a script is executing start sqlplus with /nolog then issue a connect command in the script... place the script in a secure location -Original Message-From: Ryan [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:05 PMTo: Multiple

Re: how to hide oracle password from a unix ps -ef | grep?

Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] 2). $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] (.orapwd script has to set environment variable ORAPWD to the password) 3) sqlplus [EMAIL PROTECTED] $HOME/.orapwd (.orapwd must contain one line, the password) Tanel.

Re: how to hide oracle password from a unix ps -ef | grep?

Ryan, check this out, if you haven't looked it already, it might help. http://www.orafaq.org/faqunix.htm#HIDEPSW thanks, senthil - Original Message - From: Ryan To: Multiple recipients of list ORACLE-L Sent: Friday, January 16, 2004 1:04 PM Subject: how to

Re: how to hide oracle password from a unix ps -ef | grep?

Google for hide.c -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: how to hide oracle password from a unix ps -ef | grep?

On 01/16/2004 01:34:45 PM, Tanel Poder wrote: Few ideas: 1) sqlplus /nolog connect user/[EMAIL PROTECTED] This requres putting ASCII (non-encrypted) password in the SQL script. Not very safe. 2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] This will actually show password

RE: Anyone using IBM's Flashcopy for hotbacks?

Rich, As I had indicated in a previous post on a similar topic, you will need to minimize writes to the SAN during a mirror split during FlashCopy (in IBM, BCV in EMC and ShadowImage in Hitachi). In my limited understanding, once the command to split is received by the SAN, it has to make sure

Re: how to hide oracle password from a unix ps -ef | grep?

2) . $HOME/.orapwd sqlplus user/[EMAIL PROTECTED] This will actually show password because shell will interpret the ORAPWD variable before passing the arguments to fork/exec combination. Password will be clearly visible by ps -ef. Yep, you're right... I missed this somehow... Thanks,

Re: DBMS_OBFUSCATION_TOOLKIT

Yes. As long as your KEY_STRING is same, the encrypted value will be the same. Consider: SQL exec :i := rawtohex(utl_raw.cast_to_raw (dbms_obfuscation_toolkit.DES3Encrypt (input_string='12345678', key_string='123456789012345678901234'))) PL/SQL procedure successfully completed. SQL

OT:Legato Network Port

Hi all We are trying to restore thru RMAN/LEGATO and we run into NetWorker: Cannot bind socket to connection port in configured port range on system server.domain A quick search in google and Legato provided the following: quote The message, Cannot bind socket to connection port range on system

RE: how to hide oracle password from a unix ps -ef | grep?

One more... sqlplus EOFusername/password statement1; statement2; exit EOF -Original Message-From: Tanel Poder [mailto:[EMAIL PROTECTED]Sent: Friday, January 16, 2004 12:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: how to hide oracle password from a unix ps

Rename tablespace in 9I

Is there anyway to rename tablespace in Oracle 9202. Thanks DISCLAIMER: This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the

Workspace Manager Questions

Hello, I have some Workspace Manager Questions and I'm interested in general opinions/feelings about it. A little bit of background first: Our database is about 450GB, and we maintain a separate production and development instance. Multiple projects share the same instance, and the same

SLA/metrics for RFP for programming services

Title: SLA/metrics for RFP for programming services If you were to write up a RFP for programming services, what kind, if any, metrics would you include to provide some measurements by which performance of the contract can be assessed? The tasks will typically be writing up ETL runs for our

Re: Anyone using IBM's Flashcopy for hotbacks?

We have been using Hitachi and EMC SANs. The procedure is 1. Issue BEGIN BACKUP commands for *ALL* the Tablespaces 2. Use the SAN's commands to split the ShadowImage or FlashCopy for the DataFiles FileSystems 3. Issue END BACKUP commands 4. Issue an ARCHIVELOG CURRENT command [and we also

(Non)Unique Index Vs Unique Constraint

All, Please enlighten this Junior DBA. Which method is more efficient? When should I go for option (1)? 1)NON-UNIQUE index Vs Unique Constraint drop table index_test; create table index_test(c1 number,c2 varchar2(20)); create index i1 on index_test(c1); alter table index_test add constraint

Re: SLA/metrics for RFP for programming services

Title: Re: SLA/metrics for RFP for programming services How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter... on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote: If you were to write up a RFP