Insert problem ( sqlarea)

Hi, While using insert command on one of my table, In V$SQLAREA I found below data for that table. Can anybody help me why I am gettting this? select SQL_TEXT,ROWS_PROCESSED,DISK_READS,BUFFER_GETSfrom v$sqlarea ; SQL_TEXT ROWS_PROCESSED DISK_READS BUFFER_GETS insert into

Re: Clusters and IOT's

Khedr, Waleed wrote: SYS objects could be a good starting point for clustered objects. You have a point :-). That said, the way dictionary objects are accessed (buffered in the library cache, most of the time) make them, IMHO, hardly suitable to be used as 'role model' for an application

Off - topic: Ingres

Beside dealing with oracle databases, I will have to administer some Ingres stuff, too. I would like to hear (read) your experiences regarding Ingres. I have already visited www.ingres.com, but don't want to read about the best, the most blah, blah... product description. What I need is real

Re: Insert problem ( sqlarea)

Ajay, Do you have tables with more than 255 columns? Oracle handles tables with more than 255 columns using intra-block chaining. There was a bug where the table fetch continued row was incorrectly incremented when accessing those tables. HTH, -- Anita --- Ajay Singh Rathore [EMAIL

Re: TRUNCATE IN PL/SQL

On June 22, 2001 11:15 pm, Rachel Carmichael wrote: Greg, you gotta read my apologies first :) I already was informed about that, and apologized for the lack of caffeine/lack of sleep (should never have those two in combination!) error Happy Friday! Rachel D'oh! That's what I get for

RE: Clusters and IOT's

I do not think any of the database objects including SYS has its data buffered in the library cache. I know I'm saying something that contradicts with the public thoughts. I think what gets buffered in the DC is only the required control structures and metadata of these objects. I do not

RE: exp performance question ( direct=y)

And all i do is plug my free website :) -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/22/01 5:47 PM But Lisa, don't you think Chris posts too much, just like on LazyDBA? very evil grin -Original Message- Sent: Friday, June 22, 2001 5:27 PM To: Multiple

When it is better to use paralel Query?

Hi gurus, Can anyone explain When it is better to use paralel Query? CPU constraint ,Table row count. All answers are appreciated. Thank you. Bunyamin Karadeniz

SGA QUESTION

Hi GURUS,I HAVE A QUESTION. I will newly create a database and I have 8 GB RAM. I will create mySGA as 1 GB . IS it a good Idea? I see that there is avariable size for the SGA , How can I arrange that? How much must be log buffers for a 1GB SGA? Thanks . BUNYAMIN STARTUP ORACLE instance

Re: ORACLE-L Digest -- Volume 2001, Number 174

'Oracle RDBMS Community Forum' wrote: - ORACLE-L Digest Sat, 23 Jun 2001 Volume 2001, Number 174 - - In This Issue: - - Subject Author - --- - Re:

Re: SGA QUESTION

Hoo boy! That's a pretty healthy SGA you got there. Why do you think you need to dedicate that much RAM to your SGA? Why not start with something more reasonable, like say, 200 meg for shared pool and 200 more for the database buffers? A large shared pool can actually impede performance.

Re: When it is better to use paralel Query?

Are you building a data warehouse and/or data marts? Cuz if you're not, you probably don't need parallel query. From your previous post we know that you built a 5 gig SGA. That only leaves 3 gig for parallel query and OS, which is not nearly enough free RAM for using many parallel query

Re: SGA QUESTION

Jared, If he has 8GB of memory, why not allocate 4GB to the data buffer instead of 200MB? I realize simply adding memory is not the solution for fixing a poorly tuned database, but on the other hand, if you have a lot of memory why not use it? - Greg -- Please see the official ORACLE-L FAQ:

RE: trimming the replies

We're all shadow processes here, flickering on the walls of the cave. :-O -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/22/2001 6:49 PM My humble apologies Oh Great Ross! Forever I am in your shadow... grin Scott Shafer San Antonio, TX 210-581-6217 Do not

Re: SGA QUESTION

On Saturday 23 June 2001 15:15, Greg Moore wrote: If he has 8GB of memory, why not allocate 4GB to the data buffer instead of 200MB? I realize simply adding memory is not the solution for fixing a poorly tuned database, but on the other hand, if you have a lot of memory why not use it?

thank you, all! -- Re: Query help !!!

--- Leslie Lu [EMAIL PROTECTED] wrote: Just to clearfy my previous question (as follow): if 1 has F and A and B, that what I want. If 1 has F all the time, that's not what I want. If 1 has A, B, C, but never F, that's not what I want either. --- Leslie Lu [EMAIL PROTECTED] wrote:

RE: exp performance question ( direct=y)

Kirti, Nice assessment. Even I have a tried recordlength = 128K on HP-UX 10.20 and results very fantastic. However HP 11 does not allow me to exceed 65K Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 22 Jun 2001 14:11:12 -0800

Re: thank you, all! -- Re: Query help !!!

try this.. SELECT DISTINCT AA FROM AA A WHERE STATUS='F' AND AA IN (SELECT AA FROM AA B WHERE A.AA=B.AA AND STATUS 'F' GROUP BY B.AA HAVING COUNT(B.AA) 1) Ramana --- Leslie Lu [EMAIL PROTECTED] wrote: Just to clearfy my previous question (as follow): if 1 has F and A and B, that what