RE: missed Anjo's webcast..

Once you read this book, you are sure to 'recognize' the NCX-10s and Herbies in your Oracle system / environment. I had my boss read my copy of the book, and he began using these names when talking about our bottlenecks/constraints ever since. In fact, the project he is heading now, is titled 'Ma

RE: Which table to check whether my SQL_TRACE is on for the user

Hi KG, Is "ORADEBUG PEEK" an utility that only works in 9I ? Could I use it in the user account .ie. not sys account ? I am using Version Version 8.0.6 and it does not work for me. Please advise. Thanks. SQL> ORADEBUG peek unknown command beginning "ORADEBUG p..." - rest of line ignored. Regds

RE: missed Anjo's webcast..

> To focus exclusively on response time is to fall victim to the same > fallacy as focusing exclusively on hit ratios. This is an over-generalization. There's a big difference between measuring response time for a given query vs ratios like buffer cache hits which are merely a "measure" of the

RE: DB Link Error - More Info

SQL> set arraysize 1 SQL> set copycommit 1000 SQL> copy from kgel/vinotamu@nxtp - > insert nxtp.temp_mgh - > using - > select * from rrs$.temp_mgh Array fetch/bind size is 1. (arraysize is 1) Will commit after every 1000 array binds. (copycommit is 1000) Maximum long size is 80. (long is 80) s

Was: missed Anjo's webcast.. Now: So how do I size the buffer cac

Hi all, Changed the subject line, just so that I can start another thread ;-) I did ask this question during the Webcast, but I guess Anjo was deluged with questions :) And the question is this: Given that the BCHR is NOT the best way of sizing the Buffer cache, what could we use to size the

RE: Moving a Directory Across File Systems -- Unix

> kwikhak: > > > cd $srcdir; > ls -ld $destdir; # convince yourself it exists. > find . | cpio -pdv $destdir; > fry $destdir and symlink the results back>. I would use 'find . | cpio -pdlmv $destdir (note use of 'l' flag will make sure that linked files remain linked. Otherwise linked files m

Re: DB link problem

Friend : Once time ago, i had a problem with remote connection. So, i had solved it putting the ip of other machine in the file called by "hosts". This file is located in the o OS directory. I were using sqlplus with client installed in the station. You can try to connect using the server datab

Re: Moving a Directory Across File Systems -- Unix

-- Debra Ruggerie <[EMAIL PROTECTED]> on 08/09/02 15:23:19 -0800 > I need to free about 600 MB of space on a Unix file system so that I can > create an export dump file of a database. Our sys admin is out of the > office and I am trying to move a directory (it contains sub-directories) > acros

Re: Moving a Directory Across File Systems -- Unix

cd source; tar cvf - .|(cd %TARGET;tar xvf -) On 2002.08.09 19:48 Cary Millsap wrote: > Look up "cp -R" (read the output of 'man cp' first). Used correctly, > this will do the recursive copy that you need. Then you can "rm -rf" the > old stuff after you copy it. CAREFUL!!! Read the man pages first

RE: Moving a Directory Across File Systems -- Unix

I've used "cp -r" to move entire directories. Just follow it with a "rm -r" on the source directory. -Original Message- Sent: Friday, August 09, 2002 5:23 PM To: Multiple recipients of list ORACLE-L I need to free about 600 MB of space on a Unix file system so that I can create an expor

RE: Moving a Directory Across File Systems -- Unix

Look up "cp -R" (read the output of 'man cp' first). Used correctly, this will do the recursive copy that you need. Then you can "rm -rf" the old stuff after you copy it. CAREFUL!!! Read the man pages first. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos C

Moving a Directory Across File Systems -- Unix

I need to free about 600 MB of space on a Unix file system so that I can create an export dump file of a database. Our sys admin is out of the office and I am trying to move a directory (it contains sub-directories) across file systems. According to the manual I have, mvdir only works within a f

RE: DB Link Error - More Info

I thought of those myself On DB A: GLOBAL_NAME = GETDATAP.WORLD DB_DOMAIN = DALLASHQ On DB B: GLOBAL_NAME = NXTP.WORLD DB_DOMAIN = DALLASHQ -Original Message- Sent: Friday, August 09, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Kevin, I might have a solution. On each m

RE: missed Anjo's webcast..

At 02:03 PM 8/9/2002 -0800, you wrote: 2 copies one for work and home. I'd pay double the retail for it! -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 5:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: missed Anjo's webcast..

RE: DB Link Error - More Info

Here is a copy of the SQlPLUS command used: SQL> set arraysize 1 SQL> set copycommit 1000 SQL> copy from kgel/vinotamu@nxtp - > insert nxtp.temp_mgh - > using - > select * from rrs$.temp_mgh Array fetch/bind size is 1. (arraysize is 1) Will commit after every 1000 array binds. (copycommit is 100

RE: missed Anjo's webcast..

Title: RE: missed Anjo's webcast.. I'd pay double the retail for it! -Original Message- From: April Wells [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 5:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: missed Anjo's webcast.. I would also like a copy of that

RE: DB Link Error - More Info

Kevin, I might have a solution. On each machine, can you tell me what you get when you do the following: select * from global_name; show parameter db_domain Gary Gary Kirsh Next Extent Consulting -Original Message- Sent: Friday, August 09, 2002 5:13 PM To: Multiple recipients of list

RE: DB Link Error - More Info

Kevin, This part just now caught my eye: > 3. When I try to use the plsql copy command (ultimately what I want to > do) , on machine B, I get an error stating that I am trying to Fetch out > of sequence. On machine A I get an unknow error that can not be > interpreted a long stri

RE: Bitmap Header in a Uniform LMT?

Thanks a ton Dennis. I will certainly go thru this. It looks more detailed. I also found a much similar analysis at http://www.performance-insight.com/ora3_back.html Raj

Re: Oracle Trial License

When you said OTN, I thought you meant Oracle Technet. If you look at the this site: http://technet.oracle.com/software/htdocs/devlic.html?/software/products/ oracle9i/htdocs/winsoft.html You will find the licence asks you to agree you're not someone the US doesn't like and then to accept the

RE: missed Anjo's webcast..

Same here. --Walt -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 2:50 PM To: Multiple recipients of list ORACLE-L Ditto. Put me down for at least one copy! Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Rachel Carmichae

RE: missed Anjo's webcast..

I would also like a copy of that book! April -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, August 09, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Ditto. Put me down for at least one copy! Scott Shafer San Antonio, TX 210-581-6217 > -Original Message---

RE: DB Link Error - More Info

They both failed. The describe is not the important part. That was just something I found out. The thing I really need to have running is the copy. -Original Message- Sent: Friday, August 09, 2002 3:43 PM To: Multiple recipients of list ORACLE-L What failed, the describe or the cop

RE: missed Anjo's webcast..

Amen to that! Cary, having attended your clinic, I sincerely urge you on, as well as encouraging everyone to attend your clinics. By the time your book is published I hope to have passed the OCP Performance module so I can forget "right answers" and learn the "real answers". I'm being a little sar

RE: Bitmap Header in a Uniform LMT?

Raj - My apologies for being late with a reply. Your latest message prompted me to recall that Jeremiah Wilton investigated this (or a similar aspect) back in April. I went into Google and typed "LMT bitmap headers" (without the quotes), and it retrieved the discussion. I have inserted it below fo

RE: missed Anjo's webcast..

Ditto. Put me down for at least one copy! Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Friday, August 09, 2002 3:10 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: missed Anjo's webcast..

RE: DB Link Error - More Info

What failed, the describe or the copy? Here's a work-around for the describe bug (I think from Tom on this list.) Perhaps give it a try and see if the link works at all?? /* produces output similar to the 'desc' command over a db_link takes two parameters 1. the table to be described

Re: Bitmap Header in a Uniform LMT?

Getting no responses on this, I created a test 9.0 database on my NT 4.0 workstation, with a block size of 4K. My observations are : While creating a LMT with uniform extents of size 16K, the minimum datafile size has to be 25K. With uniform extents of size 32K, the datafile size has to be more

RE: missed Anjo's webcast..

Cary, I'd like to place my pre-order on that book right now please. Rachel --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Dan, > > I think I can convince you of the contrary, but I doubt that I can do > it > solely via email. In our Clinics, where we spend three solid days > addressing of all o

RE: DB Link Error - More Info

I ran the copy using SQLPLUS from 8.0.5 trying to copy between 2 8.0.5 databases and it still failed. Any further suggestions Jared ? -Original Message- Sent: Friday, August 09, 2002 9:38 AM To: Multiple recipients of list ORACLE-L OK. I am using an 8i client here. Let me try and

RE: Migrating from 7 to 9i

> Why is that my questions hardly get any replies? It's entirely possible that no one here knows the answer. It could also be due to the broad nature of your question. Do what I did, and many others on the list have done. Read the Migration manual, cover to cover. Build test databases and ap

Analyze Vs DBMS Stats Anomaly

Oracle 8161 ... oraclei@orion> sys SQL*Plus: Release 8.1.6.0.0 - Production on Fri Aug 9 14:20:18 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Connected. SQL> create table raj_test (col1 varchar2(1)); Table created. SQL> insert into raj_test values('1'); 1 row created. SQL> c

Re: Checking the rebuildability of an index

Connor, Thanks for the info, there's obviously a lot to consider when when deciding if an index should be rebuilt. One needs to know what, if any benefits will be obtained by rebuilding, and possibly what the downside may be. As far as I know, there aren't any tools available that will allow t

RE: Shutdown abort

Stefan - It is in the Oracle Student Guide for Backup & Recovery. Here is what it says: Deferred Transaction Rollback Deferred rollback was introduced in Oracle7.3.1. It enables a database to be opened as soon as the roll forward using the redo log files is completed. The rollback of any uncommit

RE: Auditing logons

another suggestion: disable default roles. grant create session to all users. use application to enable roles with password. hth, gene >>> [EMAIL PROTECTED] 08/09/02 01:58PM >>> Why to find who and when. the best thing is to restrict the access. -Original Message- Sent: Friday, August

RE: missed Anjo's webcast..

Cary: That was a great idea to mention "The Goal". The premise of this book is a manufacturing operation is having significant difficulties meeting expected outputs. Dr. Goldratt describes a theory called the "Theory of Constraints" whereby in order to improve a process, you must remove the c

RE: Migrating from 7 to 9i

The migration issues with regards to the character sets will be sticky. Oracle9i has a character set scanner that might be able to be used in this case. But I'm not an expert on conversion of character sets within Oracle unfortunately. I can tell you that you need to be careful as conversion to di

RE: osh error when running oraenv

I found the answer to my own question on Metalink id: 1014906.102 The workaround is to comment out the call to osh. -Original Message- Sent: Thursday, August 08, 2002 5:19 PM To: Multiple recipients of list ORACLE-L A script which I have inherited is supposed to run in a cron job. In o

Bitmap Header in a Uniform LMT?

I asked this question the other day, but got no replies. I make one more attempt and rephrase the question. A curious mind wants to know " Assuming a block size of 2K, what would be the size of the bitmap header if I create a uniform LMT with datafiles of size 32K, 64K, 100K, 1M and 64M?" Metalin

Re:RE: Auditing logons

Dennis, According to damanagement: 1) the password has already been changed. Only those in the DBA group (2 of us) know what it is. 2) We will be. 3) Done 4) We suggested skinning their hands and/or amputating fingers. Damanagement favors public beheading. Reply Sep

RE: Migrating from 7 to 9i

Major suggestion is that you test...testtest...test RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i  (Sybex) The ava

Re: Physical Database Layout

yea the gurus have them all memorized :). performance is relative, if it takes 3 secs to get results back and the users are happy, then there is nothing to tune. Make then users tell you in hard time(seconds) when it should be good enough, not the "just make it faster". At some point you hav

RE: OCI files missing from installation? PRODUCTION - RESOLVED

Title: RE: OCI files missing from installation? PRODUCTION - RESOLVED It was the PATH order in the 3rd party'd ini file ugh! Thanks for all the replies! Hannah  -Original Message- From:   [EMAIL PROTECTED]@SUNGARD  Sent:   Friday, August 09, 2002 12:33 PM To:   

Re: Oracle Data Compression

I remember an instructor I had back in v6 days, who used to joke about, version 10 is the database that will totally self-sustaining, no DBA needed. Was he a visionary, bwaahahahahah, ok thats a joke ;) joe Carle, William T (Bill), ALCAS wrote: >Howdy, > >I attended a seminar on Oracle

Re:No Disk I/O Associated With The Session ???

Ian, I was not trying to refute anything you said. I believe your point being that a high BHR does not a fast database make, which is absolutely true. The combination of a decent BHR, anything above 70% and good SQL do a fast database make. BTW: it was TeamQuest which stated that the d

RE: Auditing logons

Dick, Here is my database log-on trigger. It obviously saves stuff to a database table for later review. I developed this for your same reason - to catch people logging on via c ertain account with an illegal tool. Give it a try! CREATE OR REPLACE TRIGGER WTWDBA.Wtw_Catch_Login_Trg AFTER logo

Re: RMAN guru question

I see in 9ir2, you can autbackup the control file and can restore it as a standalone before even mounting the db, then you can mount the db and start the restore process. thanks for the info, the experimentation continues :) joe DENNIS WILLIAMS wrote: >Joe - I have been working on a disaste

RE: missed Anjo's webcast..

Dan, I think I can convince you of the contrary, but I doubt that I can do it solely via email. In our Clinics, where we spend three solid days addressing of all of the reservations you've stated below (including proof with examples of why "holistic" approaches are unreliable, and why we believe

RE: Auditing logons

Why to find who and when. the best thing is to restrict the access. -Original Message- Sent: Friday, August 09, 2002 10:44 PM To: Multiple recipients of list ORACLE-L Use a logon trigger to capture everything from v$session and you can look at program name etc...it will be pretty easy t

No Disk I/O Associated With The Session ???

Thanks, though I find the response a bit strange. My point was that BHR is an unreliable indicator of performance. I picked a poorly performing query with a ridiculously high BHR to demonstrate the point. I'm well aware of Peoplesoft's performance problems especially on tables which are

RE: Physical Database Layout

Hi Manav, I'm not a guru, but a programmer turned DBA. I appreciate your concern for optimum DB design, because most of the programmers don't even care for the optimization of SQL Queries they write. Oracle gives you a lot of control over the way you want to optimize your DB, but that also means

Re: Auditing logons

Dick, I'm doing something similar. If your're on 8i+, this may work for you. create table session_logon_audit ( usernamevarchar2(30) not null, logon_date date not null--, osuservarchar2(30), machine varchar2(64), program varchar2(64) ) tablespace tools / crea

RE: Java configuratio and performance

Go to DBCA and then save it to a batch file rather than creating the DB. Go through the java installation stuff and then do it manually! Effective to learn, but not very sure whether its challenging enough! Naveen -Original Message- Sent: Friday, August 09, 2002 1:43 PM To: Multiple re

RE: Times_tamp column unreadable format

What is the datatype of that column ?? I bet it is number ... what version of ORacle ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that

RE: Auditing logons

Use a logon trigger to capture everything from v$session and you can look at program name etc...it will be pretty easy to figure out who and when. Something like this in the trigger... select distinct sid into l_sid from v$mystat; insert into session_log (select * from v$session where sid = l_sid

Re: Auditing logons

dick, I haven't done this as yet, but why not use an "on-logon trigger" and capture the username, the program, the machine etc from v$session? Of course, the other thing you could do would be to place an entry in product_user_profile and remove the ability to connect via sql*plus and/or Toad? R

Re: SOME SOLUTIONS!

Cherie: Do you know anything about the position your company has open for an Oracle DBA (KRHRCS-6)? I sent a cover letter and resume to Ken Dobson this morning. Thanks, Ken Janusz - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, August 0

RE: NLS Question

Hi John, Thanx for the good luck. What I understand of your problem, is that there are 2 different things. One is Character set and the other is National character set. National Character set determines the data inside NCHAR and Other N-Fields(NCLOB and likes) and character set determines data

RE: LAST DML on TABLE

Yes,I know.There is one view in Oracle 8.1.7 which show.I forget the name fo that view. thx -Seema >From: "Naveen Nahata" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: LAST DML on TABLE >Date: Fri, 09 Aug 2002 08:23:

RE: Migrating from 7 to 9i

Naveen - Hmm . . . the character set thing certainly adds to the issues. Myself, I have never really dealt with character set issues. But having dealt with Oracle and its issues, I can provide my ideas. First I would research the export/import route and the other alternatives to see if one of them

RE: Auditing logons

Dick Four ideas for you: 1. Change the password on the schema account. Restrict who has it, threaten those. 2. If the changes happen often, you can use LogMiner to search for more details, like the specific time of change. 3. Excellent reason to force all non-PeopleTools usage to another userid

RE: missed Anjo's webcast..

Stream of conciousness/random thoughts... To focus exclusively on response time is to fall victim to the same fallacy as focusing exclusively on hit ratios. The fallacy is that there is one and only one methodology to use for tuning/troubleshooting. In 5 years, another approach will supplant re

RE: Auditing logons

This is what I use ... CREATE OR REPLACE TRIGGER DBT_USERS_LOGON AFTER LOGON ON DATABASE -- DECLARE CURSOR cur_sess IS SELECT * FROM v$session WHERE AUDSID = USERENV('SESSIONID') AND USERNAME NOT IN ('HEARTBEAT'); -- recSesscur_sess%ROWTYPE; -- PRAGMA AUTON

Re: Times_tamp column unreadable format

In sqlplus: set numwidth 20 (or any other value until readable). "Nguyen, David M" wrote: > > I try to read date/time from times_tamp column in my oracle database but I > could not read it using SQL query. Is it a way to resolve it? > > SQL> select time_stamp from user_activity_log; > > TIME

RE: NLS Question

Thanks, Naveen, I am fortunate in that I am trying to move us from US to WE, WE being a superset of US, so I am not too concerned with corruptions. What does worry me is that I have set my NLS Lang to WE and the database still seems to be building US, which doesn't make lots of sense. Thanks, a

Auditing logons

Folks, Before I go off re-inventing the wheel once again I'll ask the group is anyone has tried this before. What I have is a request from damanagement to tell them when someone connects to our PeopleSoft database using the schema username, but outside of PeopleTools. The reason is that the

Re: Unix Script Quest : Urgent

Never say "never". The output from "truss" shows all "system calls"; which includes file opens. Here is an interesting exercise for those on *nix boxes. >From one window/session do the following ... $ sqlplus >From a different window where you are logged onto the system as root find the pid (pr

RE: LAST DML on TABLE

You can use audit or some triggers. maybe there is some other way to find this out too, but i leave it to other more experienced and knowledgable people. Naveen -Original Message- Sent: Friday, August 09, 2002 9:33 PM To: Multiple recipients of list ORACLE-L Hi How to know when was t

RE: NLS Question

That's what I though, so if it's not explicitly in my environment, not in the init.ora and not in the create statement itself, where exactly is my nls getting miss-set at creation?! TIA, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday, Augus

RE: LAST DML on TABLE

By auditing the table ... 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. QOTD: Any clod can have facts, but having an opi

RE: Unix Script Quest : Urgent

Hannah,   I'm no Unix guru either but in this situation I use 'truss',  e.g.   truss procname   HTH   Chris -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 09 August 2002 16:08To: Multiple recipients of list ORACLE-LSubject: Unix Script Quest : Urge

RE: NLS Question

Aha, there you are. Since I have to do a Character set conversion pretty soon, I have done a bit of research(read RTFM) on this just today. The message means that since the character set in which the export was done and the charcter set in which the dtabase to which you are importing don't match.

RE: Unix Script Quest : Urgent

Thanks, But I don't know the file or pid. Here's what we are doing: From an NT box, we are trying to run Sagent software to an Oracle db on unix sun solaris (both 64bit). When we try to refresh, we get a sagent error - OCI file not found. Of course it does not sp

LAST DML on TABLE

Hi How to know when was the table last inserted/updated/deleted? The dba_objects show only last DDL history. Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FA

RE: Unix Script Quest : Urgent

I think that will give you files that it successfully accessed, but not the ones that were referenced but not found. You can do what you're asking on VMS and NT, so it seems like there should be a way in Unix, although I asked my Unix SA's that same question a few years back and they said that t

RE: NLS Question

NLS is defined in database creation. You can check your NLS configuration executing this SQL command as sys. SELECT * FROM SYS.V_$NLS_PARAMETERS; Regards. -Original Message- Sent: sexta-feira, 9 de Agosto de 2002 16:33 To: Multiple recipients of list ORACLE-L All, when running an i

Re: Unix Script Quest : Urgent

ldd should give you the dependencies. --- [EMAIL PROTECTED] wrote: > Is there a way to capture all files hit by a > process/user in unix (Sun Solaris 9, ksh)? I am > seeing an OCI file not found on my production box. > I can't resovle it. > > So, I want to run the same process on my develop

RE: Migrating from 7 to 9i

Thanks Dennis for a beautiful reply Anyways, since I have been pushed into unknown territory(Oracle 7) on which I have never worked before, I can't go home and sleep that early :-) The downtime will not be a problem. I'm yet to see the database, but will be working on the migration pretty s

RE: SOME SOLUTIONS!

OK, I think I'll jump in a little late here (thanks for the plug Lee!). As far as pricing is concerned, it's best if you contact a sales rep (I have noticed an increasing amount of competition around here :>). Broadly, here are the licensing structures: SQLExpert is now only sold in 3-packs (3 "s

RE: Unable to conenct from Java front end

What driver are you using to connect to java? are you trying to connect to the DB using an applet? Naveen -Original Message- Sent: Friday, August 09, 2002 8:38 PM To: Multiple recipients of list ORACLE-L Hi, I am trying to connect to Oracle database (8.1.7) from Java. But I am gettin

NLS Question

All, when running an import I am seeing: import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set import server uses US7ASCII character set (possible charset conversion) export client uses US7ASCII character set (possible charset conversion) export server uses US7ASCII NCHAR

Re: Unix Script Quest : Urgent

> Is there a way to capture all files hit by a process/user in unix (Sun > Solaris 9, ksh)? I am seeing an OCI file not found on my production box. > I can't resovle it. > So, I want to run the same process on my development box (where it works) > and get a list of files that it is hitting (I ca

RE: Migrating from 7 to 9i

Naveen - Sorry, I was sleeping. Of course, by now you are probably sleeping. We have a few list participants on your side of the globe, but maybe not a critical mass of people yet. I apologize if you feel your messages have been overlooked. Since replies are voluntary, I tend to read a message

Unable to conenct from Java front end

Hi, I am trying to connect to Oracle database (8.1.7) from Java. But I am getting the following error. http param elementcode = 30011 Can you please let me know the solution to fix this? Thanks in advance. regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -

Re: OCI files missing from installation? PRODUCTION

Reinstall the Oracle client software using the programmers version. Also, be aware that the installer is not intelligent enough to know what it installed. You may get link errors because the installer is attempting link to software that it did not actually install. You may need to run 'relink c

RE: DB Link Error - More Info

They are both 8.0.5. -Original Message- Sent: Thursday, August 08, 2002 6:48 PM To: Multiple recipients of list ORACLE-L What version of Oracle are the two databases? There are bugs with desc over db_links (can't remember the details but see it often), and also with copy 'fetch out of

Unix Script Quest : Urgent

Is there a way to capture all files hit by a process/user in unix (Sun Solaris 9, ksh)?  I am seeing an OCI file not found on my production box.  I can't resovle it.   So, I want to run the same process on my development box (where it works) and get a list of files that it is hitting (I can

RE: DB Link Error - More Info

OK. I am using an 8i client here. Let me try and do it thru the 8.0.5 SQLPLUS. Thanks -Original Message- Sent: Thursday, August 08, 2002 6:21 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Kevin, This is a bug in sqlplus. You are using two different releases Oracle, and when you a

RE: DB Link Error - More Info

Arraysize 1 and copycommit 1000 -Original Message- Sent: Thursday, August 08, 2002 7:03 PM To: Multiple recipients of list ORACLE-L What values are set for SQL*Plus variables arraysize and copycommit? Maybe adjusting those wwould eliminate the fetch out of sequence error. > Kevin Lan

RE: How to connect rdb Oracle 7 database under VMS using Sql*Net ?

Hi Jean, Yes, you can use SQLNet to access the RDB databases. If you are accessing by ODBC now, then chances are you already have the "SQL Services" software installed. And you have created a service in SQLSRV_MANAGE which uses the SQL/Services protocol. Now, to use SQLNet you have to create

Re:RE: missed Anjo's webcast..

Ian, You have run into something that I've seen in the past which is a performance problem, but which is not caused by a bad BHR. What I have noticed are PeopleSoft queries, done by their query tool(YUCK), that have all of their data in memory and are just spinning around and around the same

OCI files missing from installation? PRODUCTION

Hi,   We are seeing an error from a 3rd party etl tool that says:        Cannot find or load Oracle OCI module   This is occurring on a production box.  In comparing the oracle files to our development box, we are seeing differences (files missing).  However, Oracle seems to

How to connect rdb Oracle 7 database under VMS using Sql*Net ?

Hello, Currently we use ODBC drivers to establish connection between Windows clients and Rdb databases installed on VMS servers. We have several Oracle databases under Solaris, but I don't know Oracle RDB databases under VMS ... In this case, is it possible to user Sqlnet tools to avoid ODBC dr

RE: SOME SOLUTIONS!

Dennis, The sales critter could give better pricing for Leccotech's SQL*Expert. For a SWAG I believe it's less than a $1000 per seat and I believe that is sold with a per-database component to the pricing. I think there are also discounts when you buy more copies. It was well worth what we pai

Physical Database Layout

Hi, Unlike the gurus on the list, I'm just a programmer who happens to ensure the DB structure is correct/valid, should hold its ground if an external (read customer's) DBA goes through it with a microscope. Its not always possible to have a full time DBA suggesting the layout, and moreover, most

Re: missed Anjo's webcast..

I know that we have a new target for shooting practice in Mogen's garden ;-) Anjo. Connor McDonald wrote: but...but..."Increasing your buffer hit ratio from 95 to 99 willgive a 400% improvement in performance!"I know I read that somewhere :-)Connor --- Cary Millsap <[EMAIL PROTECTED]> wrote

RE: Migrating from 7 to 9i

Why is that my questions hardly get any replies? Is it that I don't give sufficient details? Or is that because my questions are too simple for most of you experts? Or is it simply because of the time difference(Because I post my questions during Indian working hours)? Whatever the reason, I d

RE: SORT_AREA_SIZE

There are two nice papers about it on Steve Adams' site. http://www.ixora.com.au You can find it in the newsletter section. One for daily oltp : Basically it says to measure the daily disk sort size used, dived it by the sort count and you have your aver

Re: missed Anjo's webcast..

Cary, I love to talk about the response time thing, but it shouldn't be a lunch but a big dinner (will also settle for Tuborg and hotdogs ;-)). I think it is acutally great to see this discussion on the BCHR. I don't except people to jump to response time tuning directly and drop the ratio t

Optimized solution for large amount of data

Hi all, I have a table with two columns of type:- (a) Number - Primary Key (b) BLOB The size of binary data in blob column can range from 200-400 KB and there will be around 40,000 records over the period of one year. This tantamount to around 12GB of data (300KB(avg.) * 40,000). Read

  1   2   >