RE: RAC system Calls

Just for fun, have you tried using truss to find out which calls are being used? That might help you. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 10, 2003 8:14 PM To: Multiple recipients of list ORACLE-L Raj, Yes.

RE: Copying database from vxfs to ufs

You have to move them to NTFS on SUN first. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 10, 2003 9:04 PM To: Multiple recipients of list ORACLE-L Hi, I have a database (200GB+ 8.1.7.4 version) on Vxfs file systems on a

RE: RAC system Calls

Title: RE: RAC system Calls That may be because with RAC there is more activity ... GCS traffic and more stats to update ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email

Re: Unique constraint violation question.

Mladen, I looked through all of the manuals and online with a google search for the dbms_rtfm.database_concepts and was not able to find it. Would you please ,PLEASE, PAAALLLEEEASE list your references? YEA RIGHT. I like to review the web sites for potential openings when I read some of the

RE: Unique constraint violation question.

Ron, It's on Oracle's wishlist of enhancements -:) Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Ron Rogers Sent: Friday, July 11, 2003 9:21 AM To: Multiple recipients of list ORACLE-L Mladen, I looked through all of the manuals and online with a google search for the

RE: Billing cpu usage on a monthly basis

Hans I just returned from vacation and thought I'd fallen into the Twilight Zone and returned to the glory days of time-sharing. My experience is that you are talking real money here and be sure whatever you build, make it bulletproof. It sounds as if you're already on the right track by

RE: RAC system Calls

Mladen, As mentioned earlier, I have lots of times funtion calls, which (my guess) relate to (60-70%)IPC send completion sync waits I got in statspack. Dont mean to fill your inboxes, but, pasting few truss lines: 26949: read(14, 01 O\0\006\0\0\0\0\011 i.., 2064) = 335 26949:

Re: Tech meetings

I agree that Regularly Irregular meetings make more sense for people with tech jobs. Makes the meetings less boring and predictable. hemant At 11:39 PM 08-07-03 -0800, you wrote: I've found both as a manager in Oracle and in Miracle that if you schedule regular meetings with the guys (and

LISTENER ON LINUX

Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema

materialized view log

Hi, All I have a question on how to interpret materialized view log, which has a field change_vector$$. I think this fields record all the changes on master table, I need to understand the updates on the master table so I can develop my own API to copy the change to a flat file. Any help would

ODS architecture

Hi all, For those having built or working with an ODS, we are in the architecture phase of building an ODS. How do check integrity between the source systems and data in the ODS ? In case of the ODS and the main source systems have lost synchronism, how do resync the ODS ? Any other major

RE: LISTENER ON LINUX

use ps -lax instead Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi When I try to see listener process on Linux

RE: RAC system Calls

The times call is very cheap and could not possibly consume so much time. Here is what man page says: NAME times - get process and child process times SYNOPSIS #include sys/times.h clock_t times(struct tms *buffer); DESCRIPTION times() fills the structure pointed to

RE: LISTENER ON LINUX

That's because it's truncating the line. Try ps -eflll instead. --Walt Weaver Bozeman, Montana -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject:

Re: LISTENER ON LINUX

ps -efw|grep tns -Candi On Fri, 2003-07-11 at 12:19, Seema Singh wrote: Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is

Store and retrieve image from bfile in Oracle 8.1.7.4

Hi, I use Oracle 8.1.7.4 to store some images with bfile. After I created a directory in DB with create or replace directory MY_FILES as '/mydir' and insert one image file with dbms_lob.loadfromfile(), then I found I don't need to insert other images in that directory. I can retrieve and display

RE: RAC system Calls

Title: RE: RAC system Calls Raj: I am discussing this issue with Ravi offline. From the initial IPC dumps, It looks like the private interconnect is not properly configured/used for cache fusion. I am waiting for more details from him.. Best Regards,K Gopalakrishnan -Original

RE: RAC system Calls

Title: RE: RAC system Calls Hmmm ... Thanks KG Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an

full usefullness of CURRENT OF ???

Could anyone give us an idea as to the full usefullness of CURRENT OF? Here are my two separate examples: /* 1 this one has a CURRENT OF */ DECLARE CURSOR EmpCursor IS SELECT * FROMEmp FOR UPDATE; BEGIN FOR EmpRec IN EmpCursor LOOP

RE: full usefulness of CURRENT OF ???

Title: RE: full usefulness of CURRENT OF ??? Try with a complicated where clause where your where_clause is a page long ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this

RE: full usefullness of CURRENT OF ???

I believe (I could be totally wrong here) the reason for the CURRENT OF is both for performance and consistency. The second example has to run the update statement seperately. CURRENT OF can go directly to the row(s) affected. CURRENT OF still has to modify each block header in the

RE: full usefulness of CURRENT OF ???

Title: RE: full usefulness of CURRENT OF ??? this is better thanusing rowid in the update clause Tom Mercadante Oracle Certified Professional -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, July 11, 2003 3:09 PMTo: Multiple recipients

Re: RE: full usefulness of CURRENT OF ???

using pl/sql with update is very slow. much slower than just sql. so only use if you absolutely have to. i avoid it at all costs. From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/07/11 Fri PM 03:09:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: full

RE: Security, private vs. public synonyms and contention data di

Title: RE: Security, private vs. public synonyms and contention data dictionary Question: Are private versus public synonyms preferred for security? Are private syn. worse administration? Do 1,000 users with private syn. cause data dictionary contention?

RE: RAC system Calls

Correct. Looks like we need to configure CLUSTER_INTERCONNECTS parameter. Automatic configuration (Sun Cluster3.0/RAC) did not choose the (correct) IP(s) for interconnect. KG noticed it. I have sent netstat -ai, oradebug IPC dump, ping -s info to him. If you are interested, I can paste it here.

Oracle security question

Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments

RE: full usefullness of CURRENT OF ???

Yes, using WHERE CURRENT OF is faster. It is the same as saying WHERE rowid = emprec.rowid, just more readable. And accesses by rowid are faster than index accesses. Also, what happens if you don't have a unique or primary constraint on the table and whole rows can be duplicated? Then you pretty

RE: RAC system Calls

Title: RE: RAC system Calls We don't use cluster_interconnects (it is null) ... but for us, the RAC is using the fat private interconnects without any problems. Raj Rajendra dot Jamadagni at nospamespn dot com

Recommended Init File for Standby

Evening folks; Does anyone happen to have any recommended init file settings for a standby database ?? We are running Oracle 8.1.7.4 on a Solaris system. I think that we may have the settings on the standbys too high and are therefore wasting resources. Kevin -- Please see the official

Re: Oracle security question

Don, Look at dba_tab_privs. Stephen [EMAIL PROTECTED] 07/11/03 12:44PM Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that

RE: Security, private vs. public synonyms and contention data di

Title: RE: Security, private vs. public synonyms and contention data dictionary I think I remember Steve Adams posting something about performance and public synonyms, you may want to check its web site www.ixora.com.au Stephane Paquette Administrateur de bases de donnees Database

RE: Oracle security question

Change the password of all Oracle related users (sys, system,...) Revoke access from all other users or make sure all other users have select only privilege on data. What is the use of such databases ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life

RE: Oracle security question

Don If only you can make updates to your Oracle database, then you must enter all the data ;-) From the tone of your posting, I'm going to assume that you are pretty new to Oracle. You may want to get a good basic administration book like Oracle9i DBA 101.

RE: full usefullness of CURRENT OF ???

--- Chris Stephens [EMAIL PROTECTED] wrote: Also, the CURRENT OF locks the table so that no one can modify (or even read) it while the transaction is taking place. This guarantees nothing is changing between retrieving values from the cursor and updating the table based on those values.

RE: full usefullness of CURRENT OF ???

--- Kevin Toepke [EMAIL PROTECTED] wrote: Yes, using WHERE CURRENT OF is faster. It is the same as saying WHERE rowid = emprec.rowid, just more readable. And accesses by rowid are faster than index accesses. Also, what happens if you don't have a unique or primary constraint on the table

RE: RAC system Calls

Do you use 1 or 2 interconnects? Does your oradebug ipc dump show both IPs? For me shows: SSKGXPT 0x3066b00 flags info for network 0 socket no 9 IP 172.168.193.2 UDP 41143 sflags SSKGXPT_UPinfo for network 1 socket no 0 IP 0.0.0.0 UDP 0

Re: full usefullness of CURRENT OF ???

Repeat after me...readers never block writers...writers never block readers... The update will lock the row(s) of the result set, but it will not block anyone from reading the data. However, they may not read the modifications made by the update until it is committed. MaryAnn Atkinson wrote:

RE: full usefullness of CURRENT OF ???

Also, the CURRENT OF locks the table so that no one can modify (or even read) it while the transaction is taking place. This guarantees nothing is changing between retrieving values from the cursor and updating the table based on those values. Actually, it is the FOR UPDATE that locks the

Re: RE: full usefullness of CURRENT OF ???

when you update inside of a cursor you have two steps. Fetch data into the cursor Update the table based on what you selected. So while you are selecting data and before you update, the record could change. This means someone else could update it and youc ould update over it without knowing

Re: Oracle security question

Stephane, Thanks for your message. The reason I ask this question is that now I am responsible for creating some reports based upon this database. But I have found that there are unaccountable data in my database, which is not from my insert script or my cron job program. Thanks! Don Stephane

RE: RAC system Calls

Title: RE: RAC system Calls Yup, we have 2 private interconnects and one public .. can't display the ips though ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are

RE: full usefullness of CURRENT OF ???

Title: RE: full usefullness of CURRENT OF ??? Locking if something oracle is very good at. It happens all over the place and it happens quickly...there is very little overhead to it. Block headers. ...each block in the affected table. By updating the table by rowid, you get the

Re: Oracle security question

Dennis: Thanks for your message. Now I have changed sys password by the following command: alter user sys identified by xxx But when I try to login from sql plus window by using sys, I cannot successfully login. Also I get an error message. The message is something like connection to sys

installed users

Okay, I have, as Mladen suggested, been running the following begin dbms_rtfm.database_concepts; end; / and even the lesser_known one of dbms_websearch.metalink to find out exactly which installed user is for what Oracle option. I've started a project to review all users in all our databases

walked around: 8.1.7.4 doesn't take stirped raw LVs for redo and

maybe nobody cares. but anyway, more experiments show as long as striped raw LV is bigger than 4092MB (4K block size), oracle datafile size could only be several MB or something, not even close to 1000MB. seems like there's some kind of overflow here. problem went away after loaded 9.2.0.3.

full usefullness of CURRENT OF ???

Could anyone give us an idea as to the full usefullness of CURRENT OF? Here are my two separate examples: /* 1 this one has a CURRENT OF */ DECLARE CURSOR EmpCursor IS SELECT * FROMEmp FOR UPDATE; BEGIN FOR EmpRec IN EmpCursor LOOP

RE: Oracle security question

Don SYS is the owner of the Oracle dictionary tables. It is a username with DBA privilege, so someone who logs in can change data. If you have changed its password, then you are assured that nobody is using that username right now. If you've changed its password, then I wouldn't worry about

Re: full usefullness of CURRENT OF ???

Hi! Actually, it is the FOR UPDATE that locks the table. No, for update still locks *only the rows* selected with for update clause. All other parts of table are available for both reading AND writing (of course if other transactions don't have locks on some rows). And you can read the

Re: Security, private vs. public synonyms and contention data di

Title: RE: Security, private vs. public synonyms and contention data dictionary A lot of people have posted messages like: "I have several applications in my DB, but I can't create new public synonyms for my new app, because public synonym with that name already exists!". So, this should be

RE: Recommended Init File for Standby

Hi Kevin, I guess all I have is more questions: 1) What else do you have running on the server that has your standby database? 2) What is the purpose of the standby database (disaster recovery or reporting)? 3) If it is for disaster recovery, shouldn't the settings on the standby reflect the

RE: Oracle security question

Oops. I meant to say that you might consider changing the PASSWORD of the username that owns your tables. -Original Message- Sent: Friday, July 11, 2003 4:14 PM To: Multiple recipients of list ORACLE-L Don SYS is the owner of the Oracle dictionary tables. It is a username with DBA

RE: Recommended Init File for Standby

I knew I would be providing more information. 1. Other standby databases (14). 2. Disaster Recovery. Automatic process applying logs only. 3. Bare essentials. When/If we have to turn to it we will replace the init file with the production init file. I am looking for exactly what you said. A

Database benchmark

The last published database benchmark was the one by eWeek over a year ago. The following article provides some insights into why database benchmarking is such a tricky business. http://www.eweek.com/article2/0,3959,1186144,00.asp Since the benchmark showed great performance by Oracle, the

RE: Recommended Init File for Standby

Kevin Sounds like a trial-and-error to me. Someone else's settings probably wouldn't help you because maybe they only have 12 standby databases. My guess is that your objective is to minimize the memory usage. Some thoughts: - Try reducing the settings until the database won't run, or fails

Re: Oracle security question

Dennis Thank you very much. My data in that database is changed three times. The first is whole data being delete. The second is over ten thousands records being added. The third is whole data related to a month being deleted. I know my working environment is very complicated. For this report

RE: Recommended Init File for Standby

Thanks Dennis. THat is what I have been doing . Guess I will continue. Kevin -Original Message- Sent: Friday, July 11, 2003 5:09 PM To: Multiple recipients of list ORACLE-L Kevin Sounds like a trial-and-error to me. Someone else's settings probably wouldn't help you because maybe

RE: Oracle security question

In addition to what Dennis said: if Orace init parameter O7_DICTIONARY_ACCESSIBILITY = FALSE (the default in 9.0 and 9.2) then to connect as user SYS you need to specify the connect string like this: connect SYS/password AS SYSDBA The reason the user SYS is more protected than the user SYSTEM is

RE: installed users

ctxsys - intermedia text (the old Context text cartridge) ordsys - intermedia data types for storing of audio and video data mdsys - data types for storing of spatial data I think that in 9.0 and 9.2, by default those users are created with expired and locked logins. -Original Message-

Re: Unique constraint violation question.

Well, DBMS_RTFM package is a package on double secret probation, accessible only to people who ask questions like how to get records which have the same unique key as a record that I'm trying to insert. I usually pull out references like that when Jupiter is in the 7th house and Venus lines up

Sparky auth file

Ok, this is a REAL reach. But does anyone out there know how to specify the dump directory in the auth file for sparky ... wait ... I'm not there yet on an OpenVMS system? OpenVMS 7.2-1 Oracle 8.1.7.4 Perl 5.6.1 The background dump desitnation from v$parameter is ORA_DUMP. The system

Re: walked around: 8.1.7.4 doesn't take stirped raw LVs for redo and

Looks like you have a 32-bit version of oracle. 4GB is a typical number to hit. On 2003.07.11 16:59, Jessica Mao wrote: maybe nobody cares. but anyway, more experiments show as long as striped raw LV is bigger than 4092MB (4K block size), oracle datafile size could only be several MB or something,

Re: Sparky auth file

user_dump_dest=dua3:[oracle.admin.SID.udump] You can use whatever device sou have instead of dua3. My last VMS experience was in 1995, with OpenVMS 5.5-2, on a VAX 4400, so it might be just a little bit rusty. Allegedly, there is a wonderful new OS, created by David Cutler, the creator of VMS 5,

Re: Sparky auth file

Oooops! I haven't read the whole post before answering. Sorry, I blew it. On 2003.07.11 19:34, Barbara Baker wrote: Ok, this is a REAL reach. But does anyone out there know how to specify the dump directory in the auth file for sparky ... wait ... I'm not there yet on an OpenVMS system?

RE: RAC system Calls

I have tested using cluster_interconnects parameter. Oradebug IPC dump shows it chooses first IP correctly, recognizes the 2nd interconnect, but with a wrong IP - 0.0.0.0. Looks like a bug.. Has anyone seen this earlier? (I understand there is a bug in HP with similar behaviour - we are on

Re: RAC system Calls

I've seen a problem with CLIC interface, which are, for some reason, not used by oracle. It is a bug (Oxford is on HP-UX) and there is a specific one-off patch. This was OPS, not RAC. The symptoms are very similar: one of the processes was spinning like crazy in the kernel mode. However, RAC !=

Re: [PMX:##] Re: cannot disable or drop the ON DATABASE trigger !

It's also in 8i. Jared On Friday 04 July 2003 11:29, Mladen Gogala wrote: Parameter to disable database triggers is: _system_trig_enabled = FALSE This is 9i parameter. Alternatively, if you start the database up in the migrate mode, system triggers will be disable (startup migrate is what

Fwd: Re: Sparky auth file

Well, what I actually thought you meant from your first answer was to change the init file from a logical to a hard-coded drive name, then that will match the auth file. Something I hadn't thought of until I read your e-mail. So you might have stumbled upon the answer after all. Anyhow, I'm

Re: RE: full usefullness of CURRENT OF ???

On Friday 11 July 2003 13:19, [EMAIL PROTECTED] wrote: So while you are selecting data and before you update, the record could change. This means someone else could update it and youc ould update over it without knowing it. This is a bad idea in the database world and is known as 'disapearing

Re: RE: utl_file on Redhat Linux Oracle 9 standard engine

On Wednesday 09 July 2003 09:59, Matthew Zito wrote: Plus the syntax is much more flexible (read: lazier) than C, so it saves time. Interestingly enough, there are organizations that are starting to decide that the perl's syntactical flexibility is a negative - look at Yahoo's choice of PHP

Re: Security, private vs. public synonyms and contention data di

And put it in a trigger in case the schema must be changed or duplicated. Or just to work around duhvelopers. Jared On Friday 11 July 2003 14:19, Tanel Poder wrote: RE: Security, private vs. public synonyms and contention data dictionaryA lot of people have posted messages like: I have

Re: Oracle security question

select * from all_users; to get all users, then change their oracle passwords so that no body can log in except you. This way you know you are the only one who can change the data. Next step is see what application can make the data change. Hope this helps. Guang On Fri, 11 Jul 2003, Don

RE: LISTENER ON LINUX

Try 'lsof -i |egrep (TCP|UDP) to see what's got the address bound. Lsof is a freely available tool that should be installed on all unix boxes, IMHO. :-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]);

RE: Do Not Call

I think the backend is probably just /dev/null. It's much faster than Oracle, and requires a lot less space to store those 10,000,000 phone numbers! Besides, then they don't have any pesky follow-up issues. You registered? Sorry, we don't have a record of that... Please register again... --

RE: Sparky auth file

Barb, Hi, I wrote Sparky, but it's been so long that it's going to take me a little time to catch up with my own code. We have some users running fine on OpenVMS, so there's certainly hope :). Would you mind privately sending me your whole trcfiled.log file? We can take it offline from here

DECODE AND SELECT

Hi I am in urgent need of backporting oracle9i pl/sql to oracle8i.I have encountered some case satements like this CASE when x0 then (select y from deptno) else (select Z from emp) end i need to convert them to decode statements.Can anybody tell me how to write a select statement within

Re: DECODE AND SELECT

You are lucky! My sinuses are getting better. Decode is a function which is to be called within a SQL statement, not the other way round. What do you translate a CASE statement into? That's elementary, my dear Hrishy: a sequence of if ... then ... else ... end if commands. On 2003.07.12 00:39,

RE: DECODE AND SELECT

One thing you could consider is to make functions out of each of the sql statements in the case. Then, in your decode statement you could call the correct function based on the value of X. Either that or put the entire logic into a function that has all the case statement broken down into