Data Centers

Hi Friends : I work at the company that is looking for a Data Center. The needs is to put a product that run in internet, (E-procurement). If you know some internet address , please send to me. Nowadays the product is developed in Java/Oracle/Linux and i think that others options will be also a

Stripe Width Setting

1) Gaja Wrote :- "Systems that are Hybrid in nature and need to Support large data intensive Transfers , it is Recommended to Set this to at Least 1 MB (or even 4MB in some Cases) " Qs Would there be any NEGATIVE Effect on OLTP operations in particular if the Stripe Width is OVER-Sized ? NOTE

RE: Inline View Query Versus Ordinary Query - Comparison

Stephane, List Qs If you mean in a LOOP (as a Cursor maybe) the Real Performance would be Visible ? Qs What are the General Advantages of Using Inline View Queries Over Ordinary Ones ? Qs Any Limitations ? Any Links / Docs ? Thanks -Original Message- Sent: Wednesday, May 22, 2002 4:3

Pentium 4 and Apache - Javac.exe aborts

Hi, I would like to ask, if any one on this list had the same experience as I. We have several desktop Compaq boxes with Windows 2000 installed. I tried to install Oracle 8i server and the Apache web server on one of them. I used the modified installer, as mentioned earlier on this list, to avoid

DIRECT PATH READ wait events

List, I am trying to tune a SQL query. Oracle 8163 , Windows NT 6 SP6. How can I eliminate DIRECT PATH READ wait events. I have traced a session (10046, level 12) and find a whole lot of waits for DIRECT PATH READ. It waits 200 seconds for this event. WAIT #1: nam='direct path read' ela= 0 p1=1

RE: I/O EVENTS

Cary, This is greatness. Jack --- Cary Millsap <[EMAIL PROTECTED]> wrote: > I have an example for you (Anjo, I hope you won't > mind). A prospect we > visited once upon a time had been fighting a > performance problem with an > Oracle Payroll program. They "knew" what their > problem was: very

RE: Partition Exchange

Hello Holly, Make sure and pay attention to the clause that allows you to skip validation. Don't remember it right off the top, but it will save you beaucoup time if you are sure about your data. Jack --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > It means partitioning a non-partitioned t

RE: I/O EVENTS

I have an example for you (Anjo, I hope you won't mind). A prospect we visited once upon a time had been fighting a performance problem with an Oracle Payroll program. They "knew" what their problem was: very clearly, v$system_event was telling them that their overwhelmingly dominant system perfor

RE: Partition Exchange

It means partitioning a non-partitioned table using "exchange partition" mechanism, and creating non-partitioned table from partitions of a partitioned table. You can find detail info in the Database Administrator's Guide. Regards, - Kirti -Original Message- Sent: Tuesday, May 21, 2002

RE: Oracle 9i and Tables Owned by SYS

Ian, Probably the O7_DICTIONARY_ACCESSIBILITY parameter which is set to FALSE by default in 9i is causing you problems. It defaulted to TRUE in prior releases. When set to FALSE, it will not allow 'select any table' to work on SYS owned tables. However, access to tables owned by other schemas is

Re: System tables for generating the object privileges

Hello Vasu, You can find much in dba_tab_privs there is information about procedures, views, tables, synonyms in it. Wednesday, May 22, 2002, 9:03:22 AM, you wrote: VR> Hello All, VR>I am trying to generate a script to grant privileges on the DB VR> objects by extracting them from system ta

Re: Partition Exchange

The alter table exchange partition lets you transfer data from the partition of a partitioned table to a non partitioned table. It changes the adress in the data dictionnary, no data is moved, that's why it is fast. For example, I'm using it in a system to exchange old data with new data. The new

RE: calling a stored procedure from a sitescope monitor

Chris, You could try "exec" but I'm still not sure what your procedure is going to show. If it has no parameters then it can't "return" a value as such. Maybe it shows a value on the screen using dbms_output? If so, I would doubt this will work over JDBC. What should your procedure do / show? B

Re: Data Warehouse experts, a simple question for you

HEBREW flows right to left dear --- Jack Silvey <[EMAIL PROTECTED]> wrote: > Yeah, that's a common misconception. You actually have > to prop the book on your forehead since English flows > to the left and downwards. I have heard that Chinese > flows from right to left and upwards or somethi

RE: Data Warehouse experts, a simple question for you

Mladen, That IS what I do with the documentation CD. But Jack and I were talking about REAL books here, you know, those things that are made of paper, have printing on the pages, words, diagrams all that sort of stuff Rachel --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > No, no, no and no! Y

Re: oratab file

The oratab is provided by Oracle Corp. We created our own oratab file to handle more parameters. --- Babu Nagarajan <[EMAIL PROTECTED]> a écrit : > All > > On one of the database servers we have, the oratab > file has been changed to include a : > after each entry and that parameter is used t

Partition Exchange

Dear all, What's the meaning of "Partition Exchange"? tia, Holly -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / M

Oracle 9i and Tables Owned by SYS

I am in the process of moving a small database to Oracle 9.0.1.3. I have installed my own space management spaces. It measures growth of objects and tablespace usage and works well in Oracle 8i. The package does not work well with the 9i SYS tables; it returns "table or view does not exist"

System tables for generating the object privileges

Hello All, I am trying to generate a script to grant privileges on the DB objects by extracting them from system tables. I know that the following system tables can be used to get the system, role privileges, and table and column access privileges. dba_sys_prives dba_roll_prives db

RE: ID This Wait stat

The problem with Statspack is that it internally pre-defines what waits are "idle" waits and excludes them from the report. Some of this exclusion, as well as inclusion of other waits, IMO, is rather confusing. I would like to see SQL*Net related waits reported (in some situations) and waits relat

RE: ok one for you windows/oracle people out there

Joe, >From an old posting I made about a year ago (& I hope it is still correct): " As for Very Large Memory (VLM) support under NT / Windows 2000 I have a copy of a document posted to this list (paper called "Oracle8i on Windows NT/2000: Architecture, Scalability, and Tuning Ap

RE: Data Warehouse experts, a simple question for you| Outdated?

I am new to his books, three chapters in. The first release of the "Data Warehouse Toolkit" defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a highly normalized structure which stores information from various sources. We build data marts wi

8.1.7.4

Has anyone patched up to 8.1.7.4 yet??? Anything we should be aware of??? Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californ

RE: Data Warehouse experts, a simple question for you

Title: RE: Data Warehouse experts, a simple question for you Okay you guys are silly.  I have probably a stupid basic question to ask.  How important is it to store data (let's say state codes, county codes with leading zeroes as character versus numeric).  What is the standard out there?  Doe

Re: oratab file

Changing the structure of a vendor required file is never a good idea. Jared "Babu Nagarajan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/21/2002 03:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject

RE: init.ora params for quick i/0

There would be an error value at the end of the call, and the next call would be a standard write call ( pwrite I think ). Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/21/2002 02:29 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT

Re: ID This Wait stat

You can ignore them. See: http://www.ixora.com.au/q+a/waits.htm "Tom Schruefer" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/21/2002 01:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:ID

RE: ORA_ENCRYPT_LOGIN

Title: SQL Server to Oracle DB Even without this parameter being set the password is encrypted.  What the parameter does is stop the password from being sent in the clear if logging in with the encrypted password fails.   I believe the encryption is a 54-bit  variant of DES.  It is very rar

RE: Memory usage by an Oracle instance

Peter & List, This is probably one of the most misunderstood parts of ps... Take a look at MetaClunk note 174555.1. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net

Re: Statistical sampling and representative stats collection

Hi Rafiq, We have been using 35 percent on our warehouse, even on our fact partitions. Now that I have thought about it for a while, that seems like a lot given the volume of data. If a representative sample can be gathered with 10,000 or 50,000 or 100,000 rows, and our fact partitions have milli

Re: DECODE HELP SOLVED

Thanks Lyuda and Ron for your help! --- Lyuda Hoska <[EMAIL PROTECTED]> wrote: > Something like this would work. > SELECT GREATEST(FIRST_DATE, > NVL(SEC_DATE,THIRD_DATE),NVL(THIRD_DATE,SEC_DATE)) > FROM ; > Just an idea, you can explore it further.. > > -Original Message- > Sent: Monda

Re: Inline View Query Versus Ordinary Query - Comparison

VIVEK_SHARMA wrote: > > Query using Inline View Query an Ordinary one ? > Which is Better w.r.t. Performance & Why ? > > EXAMPLE - Following 2 SAMPLE Queries give the SAME Output . > But which would be better ? > Second is better because it accesses half the number of blocks. In this order of

Re: ITL Deadlock Example?

Sure, MAXTRANS=1, insert 2 or more rows start 2 sessions update seperate rows and voila Anjo. Walter K wrote: > Can someone post an example of how to trigger a > deadlock (ORA-0060) due to ITL shortage? This is for > informational/fact-finding purposes. > > I've created a test table with MAXT

Re: DB Freeze

Hi, Take HANGANALYZE dump, and upload it to iOraHangAnalyzer at http://www.ubTools.com/products/iorahanganalyzer/iorahanganalyzer.html. regards... "Rodrigues, Bryan" wrote: > One way is to do a system state dump level 10. > > It is done either as svrmgrl or as sqlplus with sysdba privileges. Y

Re: DB Freeze

Hello, Please be careful while reading system state dumps. Because, Oracle's system state dumping function doesn't make consistent read. I mean you can see a process which waiting for a lock while there is no holding process. regards... "Gogala, Mladen" wrote: > Next time do sqlplus "/ as sysd

RE: Shared Pool Tuneup

Here we are talking about objects other than tables like package, package body and procedures etc which are pinned through shared pool package. To start with you can make candidates such objects which are executed around 100 times and are also loaded frequently. This is a continous process to

RE: Export 7.3.4 / Import 8.1.7

Ron - Just don't try to import the system objects into your new database. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 3:00 PM To: Multiple recipients of list ORACLE-L I need a full export of a 7.3.4 database that will be imported

RE: Appending date to export file name in NT

Put this in a batch file for /f "tokens=2-4 delims=-/ " %%i in ('date/t') do set filedate=%%i%%j%%k exp / file=exp_%filedate%.dmp On my machine this gives "YYYMMDD" but it all depends on the date format setting in the control panel/regional settings. You may also change the order of i, j, k abov

RE: Statistical sampling and representative stats collection

Jack - I believe that you are on the right track. If you think about it, political pollsters randomly assess national populations with only a few thousand samples, and it works pretty good as long as it isn't biased by bad questions, lying respondents, etc. And you don't have those issues here.

Re: Statistical sampling and representative stats collection

The most of the list memeber agrees on estimate with 30% Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 21 May 2002 13:43:33 -0800 Hi all, Did some investigation about statistical sampling this weekend since we are going

RE: host from SQL> prompt

Title: RE: host from SQL> prompt Thanks to all that replied...inserting into PRODUCT_USER_PROFILE does the trick! -Original Message- From: Pass Stephanie [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: host from SQL

RE: Shared Pool Tuneup

Thanks for reply, I run the query for number of execution bigger than 50 and find out few tables in the list, my question is if for example one table executed more than 100 times can we pined the table into memory, so if YES what about all the DML on this table. Thanks -Original Message-

oratab file

All   On one of the database servers we have, the oratab file has been changed to include a : after each entry and that parameter is used to determine whether the database is supposed to be shutdown at a certain time.   It kind of struck me as a odd way to do this... This created problems

RE: init.ora params for quick i/0

Jarred, Here is a sample what I get from truss..There are no error messages saying which indicates that AIO calls are falling back to standard IO calls...Is there any other way of identifying that? And also thanks for the book suggestion..I was waiting for a newer release though, but will go wit

RE: Appending date to export file name in NT

I couldn't find any way to do it, so I had to write a Jared...I mean a Perl. Sorry, I get those two confused... -Original Message- Sent: Tuesday, May 21, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Hi Everyone, I can easily append the date to my export file names in unix. Ca

RE: ID This Wait stat

Arrggghhh. Well that was a easy problem to fix, just define 'wait' differently. Now on to the next item on my list. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Rachel > Carmichael > Sent: Tuesday, May 21, 2002 5:16 PM > To: Multiple recipients

RE: Tru64 Unix and Oracle

Michele - Tru64? Talk about fighting for deck chairs on the Titanic. Great box, given us really solid service, too bad it never achieved the market share it deserved. Yes, there are kernel parameters similar to Sun, but obviously different. Look in the Oracle Tru64 Installation Guide unde

ok one for you windows/oracle people out there

Whenever more users logon to the database we get Oracle error 'out of process memory' and the process fails. It indicates that OS could not allocate memory for the process. For Windows NT Enterprise Edition a feature 4 GB Memory Tuning is available. Anyone know anything about it, does it work, et

RE: Shared Pool Tuneup

Or you can use the method posted by Suzy Vordos on 20/4/02 If on 8i you could use a startup trigger for this. Here's mine: create or replace trigger sys.pin_db_objects after startup on database begin sys.dbms_shared_pool.keep('SYS.DBMSZEXP_SYSPKGGRNT'); sys.dbms_shared_pool.keep('SYS.DB

Statistical sampling and representative stats collection

Hi all, Did some investigation about statistical sampling this weekend since we are going to optimize our analyze process soon, and would like some input from all you orabrains on this one. I opened a TAR with Oracle asking about the sampling algorithm of stats collection, and they assured me it

RE: Data Warehouse experts, a simple question for you

And these CD's.are you supposed to eat them one byte at a time? Thank you, thank you, tip your waiters and waitresses, I will be here all week! /jack --- "Gogala, Mladen" <[EMAIL PROTECTED]> wrote: > No, no, no and no! You are supposed to eat your > documentation CD, > preferably with fa

Re: Data Warehouse experts, a simple question for you

Yeah, that's a common misconception. You actually have to prop the book on your forehead since English flows to the left and downwards. I have heard that Chinese flows from right to left and upwards or something though - you might consider taking it up as a new language if you are set on the under

RE: ID This Wait stat

That is a wait for parallel query slave to finish processing. > -Original Message- > From: Tom Schruefer [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 4:32 PM > To: Multiple recipients of list ORACLE-L > Subject: ID This Wait stat > > > > You know I could have all the docume

RE: Data Warehouse experts, a simple question for you

I second Jared's opinion. Ralph's books are clear and easy to read. This is the fundamentals of data warehousing. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 21, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Yup, $60, and worth e

Re: ID This Wait stat

I think if you look at the v$session_event view, you will find that these are idle waits by the various dbw slave processes. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon

RE: Data Warehouse experts, a simple question for you

No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apar

Re: Appending date to export file name in NT

exp / file=exp_%DATE%.dmp >>> [EMAIL PROTECTED] 05/21/02 04:43PM >>> Hi Everyone, I can easily append the date to my export file names in unix. Can anyone tell me how to do on NT. An example would be great! I've had very little NT experience. Thanks for any help. Shirley :-) -- Please see

RE: Shared Pool Tuneup

Hamid, Madhu is right. But comination of execution and load will be more practical .Run following query and see number of executions... select substr(c.owner,1,5)"OWNER",substr(c.name,1,25)"name", round(c.sharable_mem / 1024) K, c.loads, c.executions, c.kept from v$d

RE: patching 8.1.7

> -Original Message- > From: Ron Thomas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 4:14 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: patching 8.1.7 > > > > BTW, looks like 8.1.7.4 has been released for most platforms. > Just downloaded HP-UX and linux >

RE: DB Freeze

Thanks Gopal, Next time we will keep that in mind. We are upgrading to 9013 soon to fix memory leakage related to temp LOBs and smon memory leaks, so let's see if that changes anything. Cheers Raj __ Rajendra Jamadagni MIS, ESPN In

RE: DB Freeze

Next time do sqlplus "/ as sysdba", then "oradebug setmypid", then "oradebug dump systemstate 10" and then "oradebug tracefile_name" to find out the name of the generated trace file. That is good enough for oracle. If your platform is 64 bit HP-UX 11.0, then you need an OS patch. Included is the

Memory usage by an Oracle instance

Looking at the output from the ps command on AIX I see that each of the Oracle background processes, user processes and the lgwr, dbw0, pmon, reco, ckpt ... is listed as using about 30 mb of memory (based on the SZ column. 1. Does this value represent both data and code? 2. Is there any way to

RE: DB Freeze

Do you have archive logging turned on? Yes: Is your log_archive_dest full? Is the directory for your online redo logs full? -Original Message- Sent: Tuesday, May 21, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database froze, I mean the only way w

Re: ID This Wait stat

according to the docs and a friend in COE, slave wait is an "idle event" -- it means that the dbwr slave is waiting for something to do in other words, it ain't busy... not a "real" wait --- Tom Schruefer <[EMAIL PROTECTED]> wrote: > > You know I could have all the documentation for Oracle pri

RE: ITL Deadlock Example?

SET PCTFREE=0 and fill the rows in that data block. Then update two DIFFERENT rows in that block from DIFFERENT sessions. You will get the required deadlock !! Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, May 21, 2002 1:14 PM To: Multiple recipie

RE: DB Freeze

Kevin, No it wasn't a problem with log_archive_dest or on-line redo logs, these locations have more than enough space allocated. As for redo, we weren't generating much, I mean there were only 2 baseball games going on at that time. We have managed 7 concurrent games and the DB doesn't even show

Appending date to export file name in NT

Hi Everyone, I can easily append the date to my export file names in unix. Can anyone tell me how to do on NT. An example would be great! I've had very little NT experience. Thanks for any help. Shirley :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Taylor, Sh

Tru64 Unix and Oracle

Hi all, I am new to the Tru64 flavor of Unix and would like to find out if there are kernal parameters that need to be set for Oracle (similar to the shm parameters on SUN)? Also, I would like to know if there are any other differences in terms of an Oracle installation on Tru64. TIA, Miche

RE: Export 7.3.4 / Import 8.1.7

Thanks! -Original Message- Sent: Tuesday, May 21, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions.

RE: DB Freeze

One way is to do a system state dump level 10. It is done either as svrmgrl or as sqlplus with sysdba privileges. You would use the command "alter sesssion set events 'immediate trace name systemstate level 10';" (if you do not have a large user dump file capacity you can alter your session to in

RE: How to enable Java

You don't need this article if in 8.1.6. Java installations and upgrades became a lot more complicated as of 8.1.7. Jay Miller -Original Message- Sent: Tuesday, May 21, 2002 11:53 AM To: Multiple recipients of list ORACLE-L I don't have an account with metalink, and I can't get to th

RE: host from SQL> prompt

Product profile has worked to stop this and others since version 6. It is very easy to create the table and add a row to disable certain types of commands. Don't you just love nosey users :) -Original Message- Sent: Tuesday, May 21, 2002 12:12 PM To: Multiple recipients of list ORACLE

RE: Export 7.3.4 / Import 8.1.7

Ron, I'm doing the same thing; full export from 7.3.4, full import into 8.1.7.3. I used the 7.3.4 export binary and the 8.1.7 import binary. No complaints about different versions. Mark Stahlke DuhBA Denver Newspaper Agency -Original Message- From: Smith, Ron L. [SMTP:

RE: DB Freeze

Raj: You can dump the SYSTEMSTATE/PROCESSSTATE using ORADEBUG dump and analyze the trace files. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Rajendra Sent: Tuesday, May 21, 2002 1:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database fr

Re: Data Warehouse experts, a simple question for you

gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) --- Jack Silvey <[EMAIL PROTECTED]> wrote: > I find that if I wrap my books in Saran Wrap, I can > read in the shower. And if you prop the book up on > your shoulder, you can rea

RE: Statspack Problem

I ran 'statscre' again and got the same message again. It seemed to prevent SQL*Plus from logging into any account. So, I quit, re-started SQL*Plus and logged in as Perfstat and ran the remaining two scripts, which then completed without incident. I have been able to take a couple snapshots wi

ID This Wait stat

You know I could have all the documentation for Oracle printed on my brain, buy all the books ever written about the subject, but the primary wait problem that comes up will never be directly addressed. So, what exactly does 'Slave Wait' mean and what can I do about it? I am using DBWR Slaves,

Re: host from SQL> prompt

> Richard Huntley wrote: > > How can I prevent users from typing "host" to get to an OS prompt > while logged > into a DB account with an OS account? They can host to a prompt now, > but they > can't do anything useful from there, since $ORACLE_HOME is the only > thing in their > PATH...just won

Re: Korn Shell & Sqlplus

I must agree with Jared on this practice. By following this practice, you never bounce database to just get rid of hanging sessions holding locks as some listers are complaining about that they had to bounce database to get rid of hanging sessions becuase they killed process on database level f

RE: Shared Pool Tuneup

Hamid, what happens , if an object is getting executed once in a while but takes huge sharable memory, we may not be getting full use of pinning it in the shared pool, except wasting the memory, So we need to consider the number of executions also. if the number of executions are high for any obje

Re: UPDATE Results

> "Burton, Laura L." wrote: > > Is there a way to access 'something' that would denote if any rows > were updated? > > Feedback lets you set up how many rows will be effected before a count > is returned, but WHERE is this number coming from? > > I have found a 'Returning' clause of the update

RE: Outstanding bugs in 8.1.7.2

Cherie, The majority of the documentation is available for download at http://docs.oracle.com click on database and then the version and OS you want. Ron ROR mô¿ôm >>> [EMAIL PROTECTED] 05/21/02 02:39PM >>> I've dumped the Solaris one to: http://www.westbend.net/~legoman/readme_solaris_8173.ht

Re: patching 8.1.7

BTW, looks like 8.1.7.4 has been released for most platforms. Just downloaded HP-UX and linux today. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] "The problem with some people is that when they aren't drunk, they're sober." --William Butler Yeats.

ITL Deadlock Example?

Can someone post an example of how to trigger a deadlock (ORA-0060) due to ITL shortage? This is for informational/fact-finding purposes. I've created a test table with MAXTRANS=1 and can cause the enqueue waits between two sessions contending for the same block but I can't seem to cause a d

Re: Data Warehouse experts, a simple question for you

I find that if I wrap my books in Saran Wrap, I can read in the shower. And if you prop the book up on your shoulder, you can read it backwards in the rearview mirror during drive time. Also, if you learn to read in your sleep, you can get LOADS of stuff done. ;) hth, /jack silvey --- Rachel

Re:RE: OS patches required by Oracle

You be right!! Dick Goulet Reply Separator Author: "Karniotis; Stephen" <[EMAIL PROTECTED]> Date: 5/21/2002 11:22 AM Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architec

Export 7.3.4 / Import 8.1.7

I need a full export of a 7.3.4 database that will be imported into a 8.1.7 database. I know there are several ways to do this. I would like to import as much as I can, (grants, users, etc...) in one pass if I can. Will an import full ignore=y work or will it complain about the different version

Re: Data Warehouse experts, a simple question for you

I second that emotion. the guy that wrote it is a PhD and owns Red Brick or something. totally knows what he is talking about. One of my top five books, best warehousing book by far I have ever read. /jack silvey --- [EMAIL PROTECTED] wrote: > Yup, $60, and worth every penny. > > It may be 4 ye

DB Freeze

Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't co

Monitoring Oracle License

How does one monitor oracle license, is v$license the only option? Is this useful in case of processor based license? Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

Re: Data Warehouse experts, a simple question for you

it's cheaper on bookpool :) especially when Borders is out of stock you guys are killing my credit card! I went out and bought Inmon's Building the Data Warehouse, BOTH Kimball books and and considering the Webhouse one as well geez, when do I have time to READ this stuff? Rachel --- [EMA

Shared Pool Tuneup

Hi List, I have run some scripts for Tune up shared pool,here is the result of one script which i run : Script: SELECT name,sharable_mem FROM v$db_object_cache WHERE sharable_mem > 1 AND (TYPE = 'PACKAGE' OR TYPE = 'PACKAGE BODY' OR TYPE = 'FUNCTION' OR TYPE = 'PROCEDURE') AND KEPT = 'NO' ORDE

Re: I/O EVENTS

>Go ahead an post an informative example of > how the v$ views don't allow you to diagnose a specific problem, > and how Precise products do. > We wanna know, and I don't imagine he'll mind. Indeed I won't mind. Go ahead, tell us. :) Jared Greg Moore <[EMAIL PROTECTED]> Sent by: [EMAI

Re: Korn Shell & Sqlplus

Stephane Faroult wrote: Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set somethi

Re: Data Warehouse experts, a simple question for you

Yup, $60, and worth every penny. It may be 4 years old, but the information is still pertinent. Jared Joe Testa <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 05:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> c

Re: patching 8.1.7

Most of us on the list would probably recommend that you patch to 8.1.7.2.x, though you probably should check the patch readmes on MetaLink and check for RMAN bugs. Jared "Ruth Gramolini" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/21/2002 05:48 AM Please respond to ORACLE-L

Re: init.ora params for quick i/0

Silly question maybe, but have you verified that those kaio call are succeeding? Their mere appearance in the truss output only verifies async is being attempted. If the kaio calls fail, they fall back on standard io calls. Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, y

RE: OS patches required by Oracle

Is Dynix still supported by Oracle? I thought they cancelled support for that OS. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday

RE: Export problem

But why would you want to? If you export using the 7.3.3 database using the 7.3.3 export utility you should be able to import it into your 8.1.7 database using the 8.1.7 import utility. It's backward compatible. You just can't go the other way (import an 8.1.7 export to 7.3.3). Jay Miller

urgent help needed

Hi List , at some point of time  in our production database number of bequeth processes becomes very high and tomcat (application) stops  responsing . After bouncing tomcat this becomes okay .Can somebody hint what are these bequeths and whay they goes so high at some point of time . Thanks

  1   2   >