Re: copying datafile nt4-w2k

This only works if you don't want to rename the database. Jared On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote: i saw this document on Metalink, it is possible to copy everything even without creating the controlfiles!! * goal: How to copy an Oracle database to another machine

RE: Week - Date function!

Hi Begun , I am very eager to know the reason why 27th Nov is taken as the base for each year. Can you please explain me the reasons. This query is really helpful for me . Thanks Regards, Shankar -Original Message- Sent: Saturday, March 29, 2003 11:39 AM To: Multiple

RE: copying datafile nt4-w2k

100% correct Re: copying datafile nt4-w2k ---BeginMessage--- This only works if you don't want to rename the database. Jared On Sunday 30 March 2003 22:48, [EMAIL PROTECTED] wrote: i saw this document on Metalink, it is possible to copy everything even without creating the controlfiles!!

PGA

hello all, how does increasing the value of SORT_AREA_SIZE affect the unix system perfomance. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Week - Date function!

I have found out the reasons. Thanks for your information. -Original Message- Sent: Monday, March 31, 2003 1:34 PM To: Multiple recipients of list ORACLE-L Hi Begun , I am very eager to know the reason why 27th Nov is taken as the base for each year. Can you please explain me

RE: snapshot too old

2. Fix: Increase Rll Back segments 1. Why: Oracle RDBMS tries to provide "Read consistent " viiew of the data ( changed or clean ) at the "statement level" read consitency and "transaction level" read consistency This isone of the whys- an Oracle DBA's makeshis living in their

RE: PGA

Arvind, When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database. In practice, it means that if u allocate too high a value for the sort_area_size and multiple users are performing multiple sorts, the Unix

RE: PGA

Your PGA directly Affects the Amt memory the OS has to shell out for Oracle Server Process so Increasing the Sort_Area_Size does not have immd effect but if your users are going to do a sort then your PGA can grow to a Maximum of Sort_Area_Size before being pulled down to the Temp Segments. Just

ORA-600 [12501] Error ??

Guys, I came across this error in ALRT log file. ORA-00600 Internal error [12501] It happened during this SELECT statement and it returned no rows, after i dropped an index on FROMPROFNO column. SELECT NAME,AGE,SEX FROM MSGHISTORY WHERE ( MEMNO = 123 AND PROFNO = 456 AND

AIX 5L - what is it?

Hello to everyone I see two options for 9i download at "technet" site - "AIX" and "AIX based 5L systems". What does that difference mean? How do I find out whether server is one or the other? Thanks, Vladimir Barac

RE: PGA

Oracle Myth #1745 When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database --- SARKAR, Samir [EMAIL PROTECTED] wrote: Arvind, When u set the sort_area_size for a database, it will allocate that much

RE: sql query

Reddy There are a variety of techniques to accomplish this, and it is difficult to determine which will work best in your situation. Here is a link to a classic article on this topic by the great Jonathan Gennick who participates in this list from time to time.

Populating VARCHAR2 with LONG data...

Hello Guys, We have a requirement to add a VARCHAR2 column to an existing table which is a part of an application and also has a LONG column with data in it. Without using PL/SQL, how can we create the new VARCHAR2 column and default it to the LONG column data? The idea is all future inserts and

Rman disk and tape work

Anybody doing Rman Disk and MML tape backups ? Do you know how to force Rman just look at tape backups? (please no change the directory on disk answers.. just lookin to see if I can automate it at the command level.) Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: PGA

So whats the reality, Connor ?? I thought it was the reverse which was the myth i.e. it is often misunderstood as the total memory available to the database user as a whole for sort operations.I believe the reality is that the sort area size is the size allocated by Oracle per user process

RE: PGA

Hello Arvind, This is sort of an open ended question. In general this parameter controls how much memory is allocated on a per session basis for in memory sorts. Sorts that require more memory than this will sort on the disk with a performance penalty. If you have the memory you should stay

help

Hello all, i am facing swapping problem ..below is the details System - IBM RS 6000, two CPU,2GB RAM,AIX 4.3,4GB SWAP SPACE DATABASE - ORACLE 8i 8.1.5, SGA 800MB, BUFFER CACHE HIT RATIO IS ABOVE 93% Now the problem is of swapping there are about 70 oracle users using this

alert log file

for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i just move this alert log file to another directory , will oracle create a new alert log file ? Do I need to bounce db ? btw its 8.1.6 ( hp-ux ) -ak

RE: Which process is taking up so much CPU???

It works under Oracle 8.0.6 as well, that's our platform version and I successfully run your queries. Thanks! -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Jeremiah Wilton Enviado el: viernes, 28 de marzo de 2003 16:19 Para: Multiple

RE: Which process is taking up so much CPU???

Dennis, you seem to be have a master in Oracle! please can you help, I can see the SPID column under table v$process, but how do I link it to table v$session so that I actually know which UNIX process it corresponds to. I think there must be another table that links both of them; you

RE: PGA

If it is a myth where do we find the truth? Allan -Original Message- Sent: Monday, March 31, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Oracle Myth #1745 When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being

RE: alert log file

just backup it ( cp alertDBSID.log backupalert.old) and empty it (echo /dev/null alertDBSID.log) no need to bounce DB rui -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: alert log file for one

Re: Populating VARCHAR2 with LONG data...

You can not do this with SQL. You must use a procedural language such as PL/SQL. If your long columns are 32k, PL/SQL will not work either. You will have to use C or Java (not sure about Java and Longs) , or some other supported procedural language. Jared On Monday 31 March 2003 07:08,

RE: alert log file

Title: Message No problems, just move it. No need to shutdown, Oracle will just create a new file next time it needs to write to it. Moving the alert log should be something you do on a regular basis. Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook

Any tips to installing Designer 9i?

Hey all, I'm downloading Designer 9.0.2.4.0 to try it out. I don't want to #$%^@ up my current ORACLE_HOME, like I've done while testing every other Oracle product for Winders 2000. Any tips? Without reading the docs yet (still downloading), I plan to install it into another ORACLE_HOME.

Re: help

Hi! You didn't send your SHARED_POOL_SIZE parameter value... but... usually, when the machine swaps is due to not enough memory allocated! I would check your shared_pool_size, sort_area_size, and db_block_buffer for verifying that there's enough memory asigned. Of course, you should diagnose

RE: Unable to lock file

Shutdown will automatically rebuild the kernel. Please correct me if I'm wrong. -Original Message- Sent: Friday, March 28, 2003 5:59 PM To: Multiple recipients of list ORACLE-L On HP you must rebuild the kernel for the change to take effect. Allan -Original Message- Sent:

Re: Week - Date function!

I have found out the reasons. Thanks for your information. That's good. P.S.: 27 of Nov is my birthday. :) -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ:

Re: Populating VARCHAR2 with LONG data...

Hi... If you do not want to use pl-sql for populating your varchar2 field, then another choice is: use the COPY command from sqlplus... for doing the pass of data. you must have into account that varchar2 just can hold up to 4000 characters! so, your long data column, should not have more than

RE: alert log file

You can rename the alert log or move it. Oracle will create a new one the next time it has to write to it. You don't need to bounce the DB. Dave -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 9:54 AMTo: Multiple recipients of list

Re: alert log file

rename it, Oracle will create a new alert log file when it needs to write to the alert log again --- AK [EMAIL PROTECTED] wrote: for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i just move this alert log file to another

Re: alert log file

If you move the alert log to another directory, Oracle will create a new one in its place. There is no need to bounce the DB. -Scott At 07:54 AM 3/31/03 -0800, you wrote: for one of the db over here alert log is biggg .Looks like its never been truncated or backup . Is it a problem if i

RE: Which process is taking up so much CPU???

I just found that v$session.paddr = v$process.addr is the join that has to be done. Right? -Mensaje original- De: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED] Enviado el: lunes, 31 de marzo de 2003 18:01 Para: '[EMAIL PROTECTED]' Asunto: RE: Which process is taking up so

RE: Rman disk and tape work

Brian - I couldn't figure out what you are asking. First of all, are you intending to use RMAN with a catalog? Are you wanting to distinguish the backups for a report or on recovery. I think that RMAN will record all the backups you have performed and will want to use the most recent backup for

Solaris/8.1.7/LOBSEGMENT

Hi all! I'm getting a report that a LOBSEGMENT has reached MAXEXTENTS. How do I modify this? ALTER LOBSEGMENT doesn't work. I'm still R'ing the FMs, but I thought I'd ask the list too. Thanks, Mike --- === Michael P.

Re: alert log file

Copy the alert log to the desired location and then CAT /dev/null into the alert log. CAT /dev/null alert.log This will zero out the alert log and allow you to keep the old data. Ron [EMAIL PROTECTED] 03/31/03 10:53AM for one of the db over here alert log is biggg .Looks like its never

RE: help

Jose - Not enough allocated or too much allocated (from the Oracle perspective)? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, March 31, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Hi! You didn't send your

RE: Rman disk and tape work

I am using RMan with and without the Catalog... if the Catalog goes down..my backups and restores just switch to Nocatalog mode and keep on ticking.. My goal is to restore/recovery just a backup that resides on tape rather than accessing the Disk copies... I guess that Rman at least with

RE: alert log file

When I see a humungous file like that, I build a little ksh script that hasn't failed me yet. suffix=`date +%y%m%d` cp -p alertSID.log alertSID_${suffix}.log alertSID.log The only thing that might happen is if Oracle is updating the log file at EXACTLY the moment you execute this script

RE: alert log file

Title: RE: alert log file We compress ours which makes them much smaller for storage. Oracle will create a new alert log file and there is no need to bounce the db. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From:

Re: help

Arvind , Do you have any other instance or application running on same box ? -ak - Original Message - [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 31, 2003 7:54 AM Hello all, i am facing swapping problem ..below is the

index ??

I have a table X with unix index on column A ,B and non unique index on A,C,D . The query give below doesn't use any index . I thought its due to function nvl being used here , so made a change in query to replace B= NVL(:b2,B) with (B=:b2 or :b2 is null ) , but this one also not using

Re: alert log file

thanks, - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 31, 2003 8:53 AM rename it, Oracle will create a new alert log file when it needs to write to the alert log again --- AK [EMAIL PROTECTED] wrote: for one of the db over

RE: Which process is taking up so much CPU???

Jared - You are right, I do type too many words. Just look how people are misled. I can hear the faint sound of laughter in the air. Fermin - If you've noticed my signature, I'm nowhere near the expert level. For joining v$process and v$session, I join v$process.addr = v$session.paddr. I can't

RE: Week - Date function!

Thanks a lot!!! -Original Message- Sent: Saturday, March 29, 2003 1:09 AM To: Multiple recipients of list ORACLE-L Hello! Sesi Odury wrote: Given a week between (1 - 52) for a particular year can we get all the dates within that week. Is there a function to do this in SQL??? Using

RE: Unable to lock file

Shutdown will NOT rebuild the kernel, you must do that manually. On HP use SAM as it does all of the work for you. Also, take a look at the owner and group associated with that file. I've seen that cause the same problems, especially the 'file already in use' one. If that doesn't fix the

RE: PGA

From MetaLink Note # 102339.1 For each session there will be a moment in time when the first sort has to be performed. At that moment, memory is allocated for performing that sort (sort area). The size of the sort area grows incrementally until sufficient memory has been allocated to perform

RE: PGA

From the Manual: SORT_AREA_SIZE specifies in bytes the maximum amount of memory Oracle will use for a sort. Afterthe sort is complete, but before the rows are returned, Oracle releases memory down to the size specified by the SORT_AREA_RETAINED_SIZE parameter. After the

Upgrade from 8.1.7.4 to 9.2.0.1.0

Is this just a data dictionary upgrade? The real question is, does the down time for this upgrade depend on the number of objects in the data dictionary or on the overall used tablespace in the database? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day

RE: Solaris/8.1.7/LOBSEGMENT

Title: RE: Solaris/8.1.7/LOBSEGMENT Thanks! I found a note on MetaLink, and got your message at about the same time. I figured it out, and applied the change. Cheers, Mike -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]Sent: Monday, March 31, 2003 10:25

RE: Unable to lock file

Actually, it won't. If you have built a kernel (SAM is usually the easiest way) then the kernel build process will boot the machine and push the new kernel into place. A simple shutdown will not do it. Allan -Original Message- Sent: Monday, March 31, 2003 10:39 AM To: Multiple

RE: ORA-600 [12501] Error ??

Title: RE: ORA-600 [12501] Error ?? Couldn't find it on Metalink. Perhaps you should open a TAR for it? Oracle version? Server version? Is there a trace file? Can you show us the DDL for the table including its indexes? -Original Message- From: Prem Khanna J [mailto:[EMAIL

Re: index ??

Title: Re: index ?? What is the selectivity of column A? How many distinct values? Is A nullable? How many rows and blocks in the table and what are the nr of leaf blocks and the clustering factors of the indexes? At 09:08 AM 3/31/2003 -0800, you wrote: I have a table X with unix index

Re: Solaris/8.1.7/LOBSEGMENT

alter table table_name modify lob (lob_column) (storage (maxextents unlimited)); Look in dba_lobs if you are unsure of the table_name the lobsegment belongs to. Rob Pegram Oracle Certified DBA --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Hi all! I'm getting a report that

RE: help

Dennis... not enough from (for) the Oracle and too much (used) from the OS perspective. That's why you can get swapped data to disk! JL --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Jose - Not enough allocated or too much allocated (from the Oracle perspective)? Dennis Williams DBA,

Re: Upgrade from 8.1.7.4 to 9.2.0.1.0

Thomas, I think you will find this in either in the upgrade manual or MetaLink. IIRC it depends on the number of DD objects, but I can't recall where it was that I read that. Jared Thomas Day [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/31/2003 10:34 AM Please respond to ORACLE-L

RE: Populating VARCHAR2 with LONG data...

Title: RE: Populating VARCHAR2 with LONG data... (answer below) -Original Message- From: Gujral, Harpal S. [mailto:[EMAIL PROTECTED]] We have a requirement to add a VARCHAR2 column to an existing table which is a part of an application and also has a LONG column with data

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

Jared - I agree with you. My understanding is that an Oracle upgrade just changes the data dictionary. An Oracle migration (like Oracle 7 to Oracle 8) involves changes to the tablespaces. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent:

RE: Rman disk and tape work

Brian - I'm still not clear on what you're trying to accomplish here. Usually I feel that RMAN has better information than I do. With automated systems like RMAN, trying to override them is usually not a good idea. I don't think there is a direct command to do what you ask. Some other ideas:

RE: PGA

IIRC, even this release down to S_A_R_S stuff was a myth in earlier releases. The MALLOC call never really returned the memory to the OS. Of course, I don't have any earlier releases to prove it now! :) Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no,

RE: Which process is taking up so much CPU???

Fermin, The following query might help you set linesize 120 select substr(vs.username,1,10)username, vs.osuser, vs.sid, vs.serial#, vs.LOGON_TIME, to_char(vs.logon_time, 'DD-MON-YY HH24:MI:SS') LOGON_TIME, substr(vs.machine,1,15)machine, vs.process,

RE: Upgrade from 8.1.7.4 to 9.2.0.1.0

Oracle 7 to Oracle 8 involves changes to the rowid itself. Hence the tablespaces are part of migration. For higher releases , the changes take place to the system , rbs tablespaces (if i recall correctly) and the user tablespaces are not touched by migration. HTH GovindanK = DENNIS

RE: PGA

Pate, Controlling duhvelopers is not like herding cats, it's more like giving them a bath!! Heavy body armor required! Dick Goulet -Original Message- Sent: Monday, March 31, 2003 2:29 PM To: Multiple recipients of list ORACLE-L IIRC, even this release down to S_A_R_S stuff

RE: Rman disk and tape work

Thanks Dennis for taking the time to grapple with this.. The scripts that do the RMAN backups and recoveries... can backup and restore without the Catalog being up.. (just run in nocatalog mode) and it automatically resyncs the catalog when it appears. I want to be able to recover/validate ONLY

How to delete name service

Hi All, Oracle 8.1.7.4 Win 2000 Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When I highlight it the 'X' is not deleted nor thru menu options. How can I safely remove name service. Thanks Rick --

RE: PGA

Did you ever see the EDS commercial on herding cats? Damn, it was funny! I still have it on my laptop, but I won't send it to the list (over 1 Mb is a bit much to send). Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than

RE: How to delete name service

Title: RE: How to delete name service -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Oracle 8.1.7.4 Win 2000 Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When

Re: index ??

Title: Re: index ?? well , at A is not null and pt present there is only one distinct value in A. ak - Original Message - From: Wolfgang Breitling To: Multiple recipients of list ORACLE-L Sent: Monday, March 31, 2003 10:34 AM Subject: Re: index ?? What

Re: Followup to jobs not running

should have bought the blue!!! At 12:04 PM 3/28/03 -0800, you wrote: Privileges should be granted to the user, who created the job. Was it system? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March

RE: PGA

S_A_R_S stuff? Please, be careful with those abbreviations. -Original Message- Sent: Monday, March 31, 2003 2:29 PM To: Multiple recipients of list ORACLE-L IIRC, even this release down to S_A_R_S stuff was a myth in earlier releases. The MALLOC call never really returned the

Re: Any tips to installing Designer 9i?

Check the readme file or installation notes. It will tell you where to install Designer to make it work. I installed a couple of years old version, and I was asked to install in another Oracle_home. Hope this helps --- Jesse, Rich [EMAIL PROTECTED] wrote: Hey all, I'm downloading Designer

RE: PGA

Pete, Then send it privately: [EMAIL PROTECTED] No I have not seen it, but I still believe it's more like giving a cat a bath. Dick Goulet -Original Message- Sent: Monday, March 31, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Did you ever see the EDS commercial on

RE: enterprise manager console and sqlplus worksheet can't work

I installed Jdeveloper 9.x on oracle 9.0.1.3 and did not have a problem with OEM or SQL worksheet. I believe, you need to install it in a separate directory. Also it does not give you any startup Icon or put the Jdeveloper in Start and program menu, so you need to start from the directory. ---

RMAN question....

Title: RMAN question List, When I got into work this morning I noticed u01 was nearly full on out production OLTP machine. I found the files and the looked to be RMAN files. They were all in '$ORACLE_HOME/dbs/.' My first thought was that they were the snapshot controlfiles. but

How to use rPerf to estimate a partitioned server capabilities

Hi. I'm trying to see whether a logical partition of a IBM server will have enough resources to support our databse based on the size of the DB. In the past the way I did it was to take an rperf, multipy by 100-125M and see whether it will exceed my estimate for a DB size (as suggested in IBM REd

Re: index ??

Title: Re: index ?? Sorry, forgot to ask the first time. What is the selectivity of B? At 12:53 PM 3/31/2003 -0800, you wrote: well , at A is not null and pt present there is only one distinct value in A. ak - Original Message - From: mailto:[EMAIL PROTECTED]Wolfgang Breitling To:

RE: Populating VARCHAR2 with LONG data...

Yes, Perl can do it also. And without 32k limits. Jared Jacques Kilchoer [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/31/2003 11:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE:

SQL Query -- List of managers

Using the EMP table as an example I want to create a query that will show a list of employees and the mgrs above them. Like this: ENAME MGRS --- -- SMITH SMITH SMITH FORD SMITH JONES SMITH KING ALLEN

how to calculate table size

Hi, Anyone having any formula to calculate table size?Basically to estimate the growth of table over a peroid of time. I have the row_size,db_block_size.How do i get the table size. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Basavaraja, Ravindra INET:

Perl DBD::Oracle - discontinuing support for Oracle 7 and Oraperl?

I released DBD::Oracle 1.14 a few days ago. In the release notes I said: NOTE: OCI 7 and Oraperl will not be supported in future releases. I'm keen to rip out the old OCI7 API code to make it easier to add support for more OCI8 features. I've had no reaction to that yet so I can't gauge how

Re: index ??

Title: Re: index ?? is has got lots of distinct values . - Original Message - From: Wolfgang Breitling To: Multiple recipients of list ORACLE-L Sent: Monday, March 31, 2003 2:38 PM Subject: Re: index ?? Sorry, forgot to ask the first time. What is the

Re: SQL Query -- List of managers

Hello 9i (ORA-01489! be aware): SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2, 19)) ename , ename mgrs FROM emp CONNECT BY PRIOR mgr = empno / Eberhard, Jeff wrote: Using the EMP table as an example I want to create a query that will show a list of employees and

RE: RMAN question....

Chris - Do you have any more details on the files you deleted that you felt were snapshot control files? How large? I may be incredibly stupid, but for the life of me I can't figure out why you would ask RMAN to restore your controlfile from backup. Was it corrupt? I would assume bad things

Re: SQL Query -- List of managers

Vladimir Begun wrote: SELECT LTRIM(SUBSTR(SYS_CONNECT_BY_PATH(RPAD(ename, 20, ' '), '/'), 2, typo: ^RTRIM -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. -- Please see the official ORACLE-L FAQ:

RE: AIX 5L - what is it?

Title: Message AIX 5L is version 5.1 or 5.2, as opposed to not 5L which would be 4.3.x -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vladimir BaracSent: Monday, March 31, 2003 7:58 AMTo: Multiple recipients of list ORACLE-LSubject: AIX

RE: AIX 5L - what is it?

Title: Message 5L is the designation for "Linux affinity". The output of 'oslevel -r' will tell you your release and maintenance level. For example, 5100-02 means you're running AIX 5L 5.1 maint level 02. The reason there are two different downloads is that 64-bit code is OS dependant;

RE: help

No, its a single instance system..here is some more details ...pls suggest if something needs to be corrected SHARED_POOL_SIZE=190MB DB_BLOCK_SIZE = 4KB DB_BLOCK_BUFFERS = 125000 (488MB) LOG_BUFFER = 5MB SORT_AREA_SIZE = 2MB SORT_AREA_RETAINED_SIZE = 1MB

RE: help

its a single instance system..here is some more details ...pls suggest if something needs to be corrected SHARED_POOL_SIZE=190MB DB_BLOCK_SIZE = 4KB DB_BLOCK_BUFFERS = 125000 (488MB) LOG_BUFFER = 5MB SORT_AREA_SIZE = 2MB SORT_AREA_RETAINED_SIZE = 1MB

RE: PGA

where can one find the other myths about oracle? Venkat -- On Mon, 31 Mar 2003 06:18:35 Connor McDonald wrote: Oracle Myth #1745 When u set the sort_area_size for a database, it will allocate that much memory PER USER for any sort operation being performed on the database --- SARKAR,