Re: consistent read gets
Title: Message Thanks Mark Bobak syed - Original Message - From: Bobak, Mark To: Multiple recipients of list ORACLE-L Sent: Monday, January 26, 2004 6:39 PM Subject: RE: consistent read gets (I'm sending the reply to the freelists.org list as well. Hope you all agree that's a reasonable thing to do.) no work - consistent read gets - Oracle needs a block that's consistent w/ a particular SCN, goes to the buffer cache, finds it there. It's done.cleanouts only - consistent read gets - Oracle needs a block that's consistent w/ a particular SCN, goes to the buffer cache, finds it there, but discovers it was recently modified and never cleaned out. It needs to do extra work to clean out the block.rollbacks only - consistent read gets - Oracle needs a block that's consistent w/ a particular SCN, goes to the buffer cache, finds it there, but discovers that the SCN on the block is too recent. So, it refers to data stored in rollback, to roll back the block until it's old enough to be consistent w/ the query SCN.cleanouts and rollbacks - consistent read gets - Oracle needs a block that's consistent w/ a particular SCN, but discovers it needs to cleanout the block, does so, then discovers it needs to roll it back, and does that too. Hope that's clear. In reality, there are lots of different types of situations that can occur. The above is probably a bit simplified, but I think accurate as far as it goes. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message-From: Sultan Syed [mailto:[EMAIL PROTECTED] Sent: Monday, January 26, 2004 8:44 AMTo: Multiple recipients of list ORACLE-LSubject: consistent read gets Hi all, Could somebody give example scenario for the followings please no work - consistent read gets cleanouts only - consistent read gets rollbacks only - consistent read gets cleanouts and rollbacks - consistent read gets And Is ther difference between consistent read gets and consistent gets? Thanks in advance Syed
consistent read gets
Hi all, Could somebody give example scenario for the followings please no work - consistent read gets cleanouts only - consistent read gets rollbacks only - consistent read gets cleanouts and rollbacks - consistent read gets And Is ther difference between consistent read gets and consistent gets? Thanks in advance Syed
Re: fast commit
Thank You Jonathan. Syed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 22, 2004 1:29 PM > Note in-line > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick Jr > > > Next public appearance2: > March 2004 Hotsos Symposium - Keynote > March 2004 Charlotte NC - OUG Tutorial > April 2004 Iceland > > > One-day tutorials: > http://www.jlcomp.demon.co.uk/tutorial.html > > > Three-day seminar: > see http://www.jlcomp.demon.co.uk/seminar.html > UK___February > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 22, 2004 6:29 AM > > > Hi list, > > 1)Why fast commit generate no redo ? > > It's called a fast commit BECAUSE it doesn't generate redo > (except for a tiny bit that describes the change to the transaction > table entry in the segment header block that marked the transaction > as active). > > It doesn't need to generate redo because it's going to leave > (most of) the lock and change information on the blocks that > have been changed, and let some other visiter to the blocks > clean up the mess. > > 2)Is delayed cleanout generate redo? > > Delayed "block cleanout" - where a later operation simply READS > a messy block and cleans it up (by referring back to the transaction > table to get the necessary commit details) will generate redo. > > Delayed-logging "block cleanout" - which occurs when the first > transactions cleans out a few of the blocks it has dirtied but > does not log the cleanout - is effectively not going to generate > redo, as the next transaction to MODIFY the date will generate > some undo which looks as if it started from a clean block, rather > than the partly dirty block that is really there - so the cleanout is > effectively free. > > 3)In a block dump even after transactions commit why it shows lock 1 in ITL? > > Because Oracle doesn't clean the block out properly, it will either > not revisit it at all (1), or just revisit the ITL and a couple of header > bytes (2). > > > Thanks in advance. > Syed > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jonathan Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
fast commit
Hi list, 1)Why fast commit generate no redo ? 2)Is delayed cleanout generate redo? 3)In a block dump even after transactions commit why it shows lock 1 in ITL? Thanks in advance. Syed
Re: recreable/freeable chunks
Thanks for all guys Syed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 06, 2004 7:09 PM Hi! I wrote about recreatable chunk handling from memory and mixed up chunk freeing routines and chunk's data recreation routines: A callback routine is used when a process wants to free a recreatable chunk -> it can't reuse it just like that, because the original allocator (parent object) still has pointers pointing to this chunk, so the same object who allocated the chunk, has to do the freeing as well. That's my understanding, it'd be interesting to know whether it's correct ;) Tanel. > Recreatable: > This chunk is used, but its contents can be regenerated if needed (such are execution plans for cursors for example), thus Oracle can automatically reuse these chunks for others (of course when these chunks aren´t in use, thus unpinned). So when this information orignially stored in recreatable chunk is needed again, a callback function is executed, to recreate the contents in a chunk - callback functions containing instructions to recreate the information are registered for each recreatable chunk in heap manager's area if I recall correctly...) > Information about unpinned recreatable chunks are held in heap LRU lists. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Top level heaps/subheaps
Hi, I am getting little confussion how the memory is allocated for top-level heaps and subheaps in shared pool. How can we know what are all the top-level heaps and subheaps and their hierarchy. Is it possible to get it from any X$ tables. Freeable chunks can be flushed out?If yes ,then why there should be another type as recreatable chunks? Please explain. Thanks in advance Syed
recreable/freeable chunks
Hi list Happy new year for u all. Could you explain what is recreatable /freeable chunks and once recreatable chunks is removed from memory where it is kept. Thanks in advance Syed
Re: db block gets /consistent gets
Mark I know you from the metalink. Thank you for your detailed explanation. Syed - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 11:24 AM > Syed, > > Oracle accesses blocks in one of two modes, current or consistent. > > A 'db block get' is a current mode get. That is, it's the most up-to-date > copy of the data in that block, as it is right now, or currently. There > can only be one current copy of a block in the buffer cache at any time. > Db block gets generally are used when DML changes data in the database. > In that case, row-level locks are implicitly taken on the updated rows. > There is also at least one well-known case where a select statement does > a db block get, and does not take a lock. That is, when it does a full > table scan or fast full index scan, Oracle will read the segment header > in current mode (multiple times, the number varies based on Oracle version). > > A 'consistent get' is when Oracle gets the data in a block which is consistent > with a given point in time, or SCN. The consistent get is at the heart of > Oracle's read consistency mechanism. When blocks are fetched in order to > satisfy a query result set, they are fetched in consistent mode. If no > block in the buffer cache is consistent to the correct point in time, Oracle > will (attempt to) reconstruct that block using the information in the rollback > segments. If it fails to do so, that's when a query errors out with the > much dreaded, much feared, and much misunderstood ORA-1555 "snapshot too old". > > As to latching, and how it relates, well, consider that the block buffers > are in the SGA, which is shared memory. To avoid corruption, latches are > used to serialize access to many linked lists and data structures that point > to the buffers as well as the buffers themselves. It is safe to say that > each consistent get introduces serialization to the system, and by tuning > SQL to use more efficient access paths, you can get the same answer to the > same query but do less consistent gets. This not only consumes less CPU, > it also can significantly reduce latching which reduces serialization and > makes your system more scalable. > > Well, that turned out longer than I planned. If you're still reading, > I hope it helped! > > -Mark > > -Original Message- > From: Sultan Syed [mailto:[EMAIL PROTECTED] > Sent: Thu 12/18/2003 1:39 AM > To: Multiple recipients of list ORACLE-L > Cc: > Subject: db block gets /consistent gets > Hi list, > > What is db block gets and consistent gets.? > How can I reduce consistent gets ? > Ask Tom says each consistent gets is latch, how it could be? > Thanks in advance > > Syed > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bobak, Mark > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db block gets /consistent gets
Hi list, What is db block gets and consistent gets.? How can I reduce consistent gets ? Ask Tom says each consistent gets is latch, how it could be? Thanks in advance Syed
Re: cache buffer chains latch
Thankyou Jonathan for your reply. So if I use for example DEPT,EMP tables, assume dept in one hash chain and emp in another hash chain; if my statement is something like this select e.* from emp e where e.deptno =(select d.deptno from dept d where d.deptno=10); 1 step -process will go to dept hash chain and -acquire the latch -read the block -bring the result 2 step -process will go to emp hash chain and -acquire the latch -read the block -bring the result Here the latch release will happen two times by the same process? 1 st from dept chain and 2nd from emp chain? Thanks - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 03, 2003 12:39 PM > > My current understanding is: > a)For normal buffer gets, > the latch is acquired, > the chain is scanned > the buffer is pinned > the latch is released > the buffer is used > -- > the latch is acquired > the pin is dropped > (although the pin may be held > for the duration of the SQL or pl/sql > call if Oracle expects to revisit the buffer) > > b)Consistent gets - examination > the latch is acquired > the chain is scanned > if the buffer can be found it read > the latch is dropped > > Iin case (b), Oracle can make use of a > shared read latch - where the underlying > CPU supports it. > > But I may be wrong - especially about (b), > and I haven't identified all the cases where > an examination is legal. > > > Question 2 - the best answers come from Steve Adams. > But in summary, think library cache latch children - you > may need to validate several objects in the library cache > at once, and they could be covered by different child latches. > > Latches have a level#, from 0 to 9, and there is a precedence > of latch acquisition across levels that is designed to stop latch > acquisition deadlocks (again see S.A.). > > The holding of multiple latches also explains the presence of > the column named (something like) waits_holding in v$latch. > You have waited for this latch whilst holding another latch. > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > The educated person is not the person > who can answer the questions, but the > person who can question the answers -- T. Schick Jr > > > One-day tutorials: > http://www.jlcomp.demon.co.uk/tutorial.html > > > Three-day seminar: > see http://www.jlcomp.demon.co.uk/seminar.html > UK___November > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, December 03, 2003 4:19 AM > > > Hi All, > > My system is suffering in cache buffer chain,I found the reason. > My general questions is > 1) > When the process holding the latch how long the latch will be held ,until > the hase chain is read or > the process goes to the particular block and return the rows(output) ? > > 2) > When the situation will occur for the process to hold two latches(different > or same) simultaneously ? > > Please reply. > > Syed. > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jonathan Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
cache buffer chains latch
Hi All, My system is suffering in cache buffer chain,I found the reason. My general questions is 1) When the process holding the latch how long the latch will be held ,until the hase chain is read or the process goes to the particular block and return the rows(output) ? 2) When the situation will occur for the process to hold two latches(different or same) simultaneously ? Please reply. Syed.
Re: state objects
I understood,Thanks KG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, October 26, 2003 12:24 PM > Sultan: > > PGA is a private memory area which holds actual memory components > (like sort area, event settings,parameter settings and UGA). State objects > are just the data structure which holds the info about the OS resources > (b)locked by the instance. > > In other words, state objects can be called as global and PGA components > are local to that process (in crude terms.) > > KG > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, October 26, 2003 10:59 AM > > > > Hi K Gopalakrishnan , > > Wishing you the same > > Thanks I understood what is state objects,but another question > arisses,when > > this > > state objects having process status then what this PGA really do and > > why that process status recorded again in PGA? > > Please clarify > > > > > > > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Friday, October 24, 2003 8:59 PM > > > > > > > Wishing you all a very Happy Diwali.. The festival of lights ! > > > > > > State object is a structure inside the shared pool which keeps the > details > > > about > > > every components (for example, process or session or enqueues) and their > > > status (or state). Basically it is an operating system resource related > > to > > > the > > > oracle instance (or an OS resource held by oracle instance) which has > > > multiple > > > states (free/init and dead I think). The background process PMON is > > > responsible for freeing those resources to the OS should any of the > state > > > object dies because of the process failure. > > > > > > Typically the SYSTEMSTATE dump will have the details about the state > > > objects. > > > Part of this info is visible in the V$sysstat. You will see the state > > object > > > as SO in the > > > system state dump. Along with you get the owner (holding that SO) and > the > > > state > > > of the state object (is that too confusing?) which tells whether that > SO > > is > > > in the freelist > > > or initialized or dead. > > > > > > For better understanding of the various state objects I would recommend > to > > > take a > > > systemstate/process state dump and have a look at the trace files. > > > > > > > > > Regards, > > > K Gopalakrishnan > > > Bangalore, INDIA > > > > > > > > > > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Friday, October 24, 2003 9:29 PM > > > > > > > > > > Does anybody have a definition for the Oracle shared pool component > > "State > > > > Object"? An Object that holds the state of something? Using Google, I > > get > > > > some hints, but just wondered if someone has something definite. > > > > > > > > Sultan - your question got my curiosity aroused. I'm sorry I lost your > > > reply > > > > that confirmed you were indeed looking at the SGA. > > > > > > > > > > > > > > > > Dennis Williams > > > > DBA > > > > Lifetouch, Inc. > > > > [EMAIL PROTECTED] > > > > > > > > -Original Message- > > > > Sent: Wednesday, October 22, 2003 8:59 AM > > > > To: '[EMAIL PROTECTED]' > > > > > > > > > > > > Sultan - Are you referring to the Oracle shared pool components that > are > > > > identified as state objects? A quick Google also revealed that Java > has > > > > state objects. > > > > > > > > > > > > > > > > Dennis Williams > > > > DBA > > > > Lifetouch, Inc. > > > > [EMAIL PROTECTED] > > > > > > > > -Original Message- > > > > Sent: Wednesday, October 22, 2003 3:14 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Can someone please explain what is 'state objects' in oracle and what > is > >
Re: state objects
Hi K Gopalakrishnan , Wishing you the same Thanks I understood what is state objects,but another question arisses,when this state objects having process status then what this PGA really do and why that process status recorded again in PGA? Please clarify - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 8:59 PM > Wishing you all a very Happy Diwali.. The festival of lights ! > > State object is a structure inside the shared pool which keeps the details > about > every components (for example, process or session or enqueues) and their > status (or state). Basically it is an operating system resource related to > the > oracle instance (or an OS resource held by oracle instance) which has > multiple > states (free/init and dead I think). The background process PMON is > responsible for freeing those resources to the OS should any of the state > object dies because of the process failure. > > Typically the SYSTEMSTATE dump will have the details about the state > objects. > Part of this info is visible in the V$sysstat. You will see the state object > as SO in the > system state dump. Along with you get the owner (holding that SO) and the > state > of the state object (is that too confusing?) which tells whether that SO is > in the freelist > or initialized or dead. > > For better understanding of the various state objects I would recommend to > take a > systemstate/process state dump and have a look at the trace files. > > > Regards, > K Gopalakrishnan > Bangalore, INDIA > > > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, October 24, 2003 9:29 PM > > > > Does anybody have a definition for the Oracle shared pool component "State > > Object"? An Object that holds the state of something? Using Google, I get > > some hints, but just wondered if someone has something definite. > > > > Sultan - your question got my curiosity aroused. I'm sorry I lost your > reply > > that confirmed you were indeed looking at the SGA. > > > > > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, October 22, 2003 8:59 AM > > To: '[EMAIL PROTECTED]' > > > > > > Sultan - Are you referring to the Oracle shared pool components that are > > identified as state objects? A quick Google also revealed that Java has > > state objects. > > > > > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, October 22, 2003 3:14 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Can someone please explain what is 'state objects' in oracle and what is > > that real work? > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: K Gopalakrishnan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: state objects
Yes ,Dennis. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 7:04 PM > Sultan - Are you referring to the Oracle shared pool components that are > identified as state objects? A quick Google also revealed that Java has > state objects. > > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, October 22, 2003 3:14 AM > To: Multiple recipients of list ORACLE-L > > > Can someone please explain what is 'state objects' in oracle and what is > that real work? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
state objects
Can someone please explain what is 'state objects' in oracle and what is that real work?
Re: pct increase
It is not precalculated ,it will calculate(allocate) extent when there is not enough space for your data. You can consider locally managed tablespace if u are in 8i and above. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Monday, October 13, 2003 8:19 PM Subject: pct increase Hi List , I have a table set with pctincrease 50. After growing many times now it is asking for 520M of disk space and I dont have that much space in dba_free_space . Now I want to change pctincrease to 0. So that it doesn't have spiraling requirement . But event after changing pctincrease to 0 this table is still coming in my list of monitored exntents which doesn't have room for next growth. Question is , when does oracle calcs next space requirement ? It looks like its precalculated . -ak
Re: Concurrent Manager
Thanks April,
Concurrent Manager
Hi , In Oracle Apps why concurrent manager and report server should be in database tier when other application servers are in application tier.? Thx
consistent gets
Hi, What does the meaning for this consistent gets. Some time my statement return more consistent gets in statistics. How I can reduce this Consistent gets. Thanks in advance.
PGA Size
Hi, How can I know the PGA size which my session is utilizing? Thanks in advance. Syed
X$tables
Hi, I have a doubt,please clarify. All we know about x$tables(fixed tables) and these all are in-memory table.When instance startup the data will be brought back in this tables , when Instance off data will go,correct? My question is since data is not stored in datafiles for this tables how it brings the data when instance startup, from where it brings.? Please answer. Thanks in advance. Syed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
test
TEST -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sultan Syed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Materialized view
Hi How can I create materialized view(mv) for the following statement using 'refresh fast' method. I can use 'refresh complete' option to create this mv, but how can I use 'refresh fast' option for the below statement in order to improve performance in query. Any workaround ? select mas.salesrep_id,sum(del.qty*del.price)-sum(del.discount) from sales_master mas, sales_details del where mas.transaction_id =del.transaction_id group by mas.salesrep_id. Thanks in advance
Oracle Tools
Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance
[no subject]
Hi, How can I complie PRO*C code.Please Thnks
Calling report
Hi friends I am using following command to call report from report srw.run_report ('report=d:\test.rdf destype=file desname=try.out desformat=dflt batch=yes'); I have tested this using After Report /Before Report/Action Trigger. But this is not calling the report. Any solution will be appreciated. Syed
[no subject]
Hi friends I am using following command to call report from report srw.run_report ('report=d:\test.rdf destype=file desname=try.out desformat=dflt batch=yes'); I have tested this using After Report /Before Report/Action Trigger. But this is not calling the report. Any solution will be appreciated. Syed
Unique value
Hi friends, I have a tables A and B DESC A ID NUMBER NAME VARHAR2(10) DESC B --- ID NUMBER SUBNAME VARCHAR2(20); In the above table B.ID is the foreign key to A.ID. How can I create unique value for B.SUBNAME based on A.NAME. Means , A.NAME has value '" andB.SUBNAME has values '', ''; when I insert value again in B.SUBNAME as '' it should not agree for the combination value of A.NAME(''), but '' can agree when I enter value for A.NAME other than '' Please give some ideas, Thanks in advance syed.
Oracle Application Server
Hi friends I would like to know is there any difference between Oracle Application Server and Oracle 9i Application server.? If there is difference ,then what is the First version of Oracle 9i Application Server? The term is confusing me. Any one clarrify me please. Thanks in advance syed
PRO*C Question
Hi When I compile Pro*c program in my server it shows 'pcc' not found. Syntax: pcc iname = test.pc oname=test.c host=c What I am missing here to get that error. Thanks in advance sultan
Re: PRO*C question
Hi zhu chao, Really I dont understand what you have send. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 26, 2002 1:43 PM > > This is a multi-part message in MIME format. > > --=002_Dragon644527081078_= > Content-Type: text/plain; > charset="GB2312" > Content-Transfer-Encoding: quoted-printable > > sultan=A3=AC=C4=FA=BA=C3=A3=A1 > > [oracle@rac1 oracle]$ which proc > ~/9.2.0/bin/proc > > =3D=3D=3D=3D=3D=3D=3D=3D 2002-08-25 22:03:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3=BA =3D=3D=3D=3D=3D=3D=3D=3D > > Hi , > > How can we come to know pro*c installed in the machine. > If it is installed ,in which directory we can find out. > > Thanks in advance > > sultan > > =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2 > =C0=F1=A3=A1 > > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= A1=A1=A1zhu chao > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= [EMAIL PROTECTED] > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= A1=A1=A1=A1=A1=A1=A1=A1=A12002-08-26 > > --=002_Dragon644527081078_= > Content-Type: text/html; > charset="GB2312" > Content-Transfer-Encoding: quoted-printable > > > > http-equiv=3DContent-Type> > > face=3D=CB=CE=CC=E5>sultan=A3=AC=C4=FA=BA=C3=A3=A1 > > [oracle@rac1 oracle]$ which > proc~/9.2.0/bin/proc > > =3D=3D=3D=3D=3D=3D=3D=3D= > 2002-08-25 22:03:00 =C4=FA=D4=DA=C0=B4=D0=C5=D6=D0=D0=B4=B5=C0=A3= BA > =3D=3D=3D=3D=3D=3D=3D=3D > > > > > > > style=3D"BORDER-LEFT: #00 2px solid; MARGIN-LEFT: 5px;= > MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px"> > Hi , > > How can we come to know= > pro*c installed in > the machine. > If it is installed ,in which= > directory we > can find out. > > Thanks in= > advance > > size=3D2>sultan= > > > =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D= > =3D =3D > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=D6=C2=C0=F1=A3 =A1 > > =A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= A1=A1=A1=A1=A1=A1zhu= > chao > size=3D2>=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= A1=A1=A1=A1=A1=A1 href=3D"mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED] > size=3D2>=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1= A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A1=A12002-08-26= > > > > --=002_Dragon644527081078_=-- > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: zhu chao > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sultan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PRO*C question
Hi , How can we come to know pro*c installed in the machine. If it is installed ,in which directory we can find out. Thanks in advance sultan
Printer Help !Urgent
Hi gurus I am calling report from Form The report DESTYPE is screen. Here I want user to print that output only once. Then the system shuold exit or should not allow them to print agian. How can I set ? Help needed please syed
Re: SQL Help Urgent!!!!!!!!!
I got it.Thank you Gurus for your reply. Regards syed > > sultan wrote: > > > > Hi gurus > > > > I have two tables like this > > > > > > SQL> select * from bb; > > > > ID AMOUNT DT > > -- -- -- > > 1 1000 10-MAY-02 > > > > > > > > > > SQL> select * from cc; > > > > ID AMOUNT > > -- --- > > 1200 > > 1300 > > 1500 > > > > > > My query like this > > = > > SQL> select a.id,sum(a.amount),sum(b.amount) from bb a,cc b where > > 2 a.id=b.id > > 3group by > > 4a.id; > > > > ID SUM(A.AMOUNT) SUM(B.AMOUNT) > > -- - > > > > 1 3000 1000 > > > > > > Based on the details table rows it sum up three times the master > > amount ,that is why it shows 3000. > > > > > > But my output should be like this > > > > > > ID SUM(A.AMOUNT) SUM(B.AMOUNT) > > -- - > > > > 1 1000 1000 > > > > > > Anybody can help me in this issue please. > > > > Regards. > > syed > > Do the GROUP BY in an in-line view. BTW in the case you give as example, > you just need to put B.AMOUNT in the GROUP BY clause. > -- > Regards, > > Stephane Faroult > Oriole Software > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sultan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Help Urgent!!!!!!!
Hi gurus I have two tables like this SQL> select * from bb; ID AMOUNT DT-- -- -- 1 1000 10-MAY-02 SQL> select * from cc; ID AMOUNT-- --- 1 200 1 300 1 500 My query like this = SQL> select a.id,sum(a.amount),sum(b.amount) from bb a,cc b where 2 a.id=b.id 3 group by 4 a.id; ID SUM(A.AMOUNT) SUM(B.AMOUNT) -- - 1 3000 1000 Based on the details table rows it sum up three times the master amount ,that is why it shows 3000. But my output should be like this ID SUM(A.AMOUNT) SUM(B.AMOUNT) -- - 1 1000 1000 Anybody can help me in this issue please. Regards. syed
SQL Help Urgent!!!!!!!!!
Hi gurus I have two tables like this SQL> select * from bb; ID AMOUNT DT-- -- -- 1 1000 10-MAY-02 SQL> select * from cc; ID AMOUNT-- --- 1 200 1 300 1 500 My query like this = SQL> select a.id,sum(a.amount),sum(b.amount) from bb a,cc b where 2 a.id=b.id 3 group by 4 a.id; ID SUM(A.AMOUNT) SUM(B.AMOUNT) -- - 1 3000 1000 Based on the details table rows it sum up three times the master amount ,that is why it shows 3000. But my output should be like this ID SUM(A.AMOUNT) SUM(B.AMOUNT) -- - 1 1000 1000 Anybody can help me in this issue please. Regards. syed