Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h45JFSh19936 for ; Mon, 5 May 2003 14:15:28 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h45JFRA19931 for ; Mon, 5 May 2003 14:15:27 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id JAA75538; Mon, 5 May 2003 09:50:31 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0058FA89; Mon, 05 May 2003 08:37:39 -0800 Message-ID: Date: Mon, 05 May 2003 08:37:39 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Subject: Fw: 9i doubts Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Jared I know , I ask too many questions I can try out question 6 and find out Most of the others were theoretical questions I had these doubts after going through the Oracle 9i release 2 documentation. If anyone knows anything about these questions please let me know, I asked a lot of people and read a quite a few manuals ......... Would it be better if I asked a few questions at a time ? > > ----- Original Message ----- > From: "Jared Still" > To: ; > Sent: Sunday, May 04, 2003 07:45 > Subject: Re: 9i doubts > > > > > > why not build a 9i database, test each of these, and > > let us know the results? > > > > Sorry, too many questions for me, some of which the > > answers are easily ascertained from the documentation. > > > > Jared > > > > On Friday 02 May 2003 22:56, bulbultyagi@now-india.net.in wrote: > > > Hello list > > > I had some doubts I had after going thru Oracle documentation for 9i > > > release2 : > > > > > > > > > Q1. Which components of the sga other than the shared pool and the > > > database buffer cache are dynamically sizable ? > > > > > > Q2. Which components of the sga allocate memory in granules and which > do > > > not ? > > > > > > Q3. If I specify sga_max_size=199M then does upon startup, oracle > allocate > > > this much memory straight away and then start allocating it to various > sga > > > components ? > > > > > > Q4. If the answer to the above question is yes then does oracle allocate > > > 199M or an integral multiple of granule size ? ( 199M is not an exact > > > integral multiple of 16 MB or 8MB) > > > > > > > > > Q5. "SMON is responsible for coalescing contiguous free extents within > > > dictionay managed tablespaces" > > > => then who does the coalescing within locally managed tablespaces ? > > > > > > Q6. Can the oracle block size be smaller than the operating system block > > > size ? > > > > > > Q7. Is data dictionary information cached in the database buffer cache > > > also ? > > > > > > Q8. The administrators guide says "Whenever a transaction is commited a > > > system change number is assigned to identify the redo records for each > > > commited transaction." > > > => is the scn assigned to the transaction ( which means that every > > > statement in the transaction gets the same scn) > > > or is a different scn assigned to each and every statement within the > > > transaction " ? > > > > > > Q9. "When checkpoints are not set to occur between log switches , make > all > > > groups the same size to guarantee that checkpoints occur at regular > > > intervals" {SAG pg 7-9} > > > How do I disable checkpoints between log switches ? > > > should i use fast_start_mttr_target ? > > > > > > Q10. Do I have to shutdown and then go to the mount state just to > rename a > > > log member ? Can't it be done when the dataabse is open and the group is > > > not current or active ? > > > > > > Q11. Where are the free list groups and the freelists stored ? > > > > > > Q12 When the server process does not find a block in the database > buffer > > > cache it fetches it from the datafile and leaves a copy in the buffer > cache > > > . What happens when Oracle has to reconstruct a read-consistent image > from > > > the undo segment ? ( example when a row has changes that were not > committed > > > at the start of the query ) . Will the existing copy of the data block > in > > > the buffer cache be over-written ? > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: