Hi all, One of our developer is inserting a 1Gb of datafile without commiting a DATA. As LGWR copies commited and uncommitted data from redo log buffer to redo...
Hi Sameer,
DBWR will write both committed and uncommitted data to
the datafiles. When a commit is issued, then only the
buffers that were still lying around...
Sudheendra Vijaykumar
sudhi76@...
Nov 5, 2002 2:00 pm
269
DBWn writes only the committed records to the datafiles. The blocks having committed records are known as dirty blocks/Buffers. When checkpoint occurs or...
Sameer Wadhwa
swadhwa@...
Nov 5, 2002 4:53 pm
270
Is there a way of knowing the OS block size . Amith ... Do you Yahoo!? U2 on LAUNCH - Exclusive medley & videos from Greatest Hits CD...
Amith Uppal
uppal_amith@...
Nov 7, 2002 4:21 pm
271
Try This select max(l.lebsz) OSBLOCKSIZE from sys.x$kccle L / Hope it will help ... From: Amith Uppal [mailto:uppal_amith@...] Sent: Thursday, November...
Sameer Wadhwa
swadhwa@...
Nov 7, 2002 7:01 pm
272
Hi,
I'm sorry to say, but DBWR writes both committed and
uncomitted data to datafiles.
Imagine this, I start updating some records and don't
commit my...
Sudheendra Vijaykumar
sudhi76@...
Nov 8, 2002 12:35 am
273
thanks Sameer ......I guess this works ...the query gave me 512 ....looks like thats the rite answer ....have to check with the sys admin to confirm . I was...
Amith Uppal
uppal_amith@...
Nov 12, 2002 10:13 am
274
Hi Amit,
Your sys admin will surely confirm that its 512 bytes
as the redo block size is always written in terms of
OS block size. The view x$kccle contains...
Sudheendra Vijaykumar
sudhi76@...
Nov 12, 2002 1:55 pm
275
My understanding is that DBWR writes uncommitted data to the rollback segments during instance recovery . Amith Sudheendra Vijaykumar <sudhi76@...>...
Amith Uppal
uppal_amith@...
Nov 14, 2002 1:09 pm
276
Hi Experts, There is slight hot topic raised here We have a table having millons of rows and have a columns say COLX COLY ... X 1 X 2 X 3 X...
You are right in a way. Only the before image data
gets written to the undo segments. A point to note is
that the dirty buffer when flushed to the disk will...
Sudheendra Vijaykumar
sudhi76@...
Nov 14, 2002 10:14 pm
278
Hi Amith, The committed and uncommitted data store in the database buffer cache in the form of dirty blocks. which is written to the datafile either 1. A...
Sameer Wadhwa
swadhwa@...
Nov 15, 2002 10:34 pm
279
Guys , I have a tablespace with lot of fragmentation . I want to defragment it . Does dropping all the tables and recreating them fresh solve the issue . Is...
Amith Uppal
uppal_amith@...
Nov 19, 2002 4:25 pm
280
Hi amith, If you have a locally managed tablespace, then you should not worry about fragmentation as oracle handles it by keeping free space in formation in...
Sameer Wadhwa
swadhwa@...
Nov 19, 2002 6:30 pm
281
Still my question is : Is coalescing required after I drop all the objects and clean the tablespace . I dont want to drop the tablespace and recreate it . ...
Amith Uppal
uppal_amith@...
Nov 20, 2002 3:49 pm
282
Hi All , Is there a way to find out the OS file header block size.. ? - to skip ( header size / oracle db block size) while "dd" command.. Thanks, Varughese. ...
Varughese M
varughesem@...
Nov 20, 2002 9:52 pm
283
No coalescing is not required once you drop all the objects. Database buffer contains all the changed data and rollback segment contains all the before -image...
Sameer Wadhwa
swadhwa@...
Nov 21, 2002 12:27 am
284
What OS are you on ? It depends on the OS and most of
the unix flavours have 512 bytes.
Thanks,
Sudhi.
--- Varughese M <varughesem@...> wrote:
> Hi All...
Sudheendra Vijaykumar
sudhi76@...
Nov 21, 2002 9:16 am
285
Dear Friends Our Enviroment is: Server: Window NT 4.0 Database: Oracle8.1.5.0 In Lan, connection to the database using plus80w,sqlplusw or Developer...
p k s subrahmanyeswar...
bpkssrao@...
Nov 22, 2002 6:56 am
286
Further questions ..... So we do not require any coalescing to do if I drop all the objects in the tablespace . thats what I think ....but people here are not...
Amith Uppal
uppal_amith@...
Nov 25, 2002 3:42 pm
287
Does anyboby know how to insert data with special charater &? Thanks __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus –...
Hi Amith, Your first answer, Here is the simple test for checking the fragmentation SQL> select tablespace_name,bytes from dba_free_space where ...
Sameer Wadhwa
swadhwa@...
Nov 25, 2002 11:38 pm
289
I'm pretty sure you need to do the following in sql*plus SET DEFINE OFF Daniel ... From: Wei Xia [mailto:yoxst@...] Sent: Tuesday, 26 November 2002 4:16...
Thanks, Daniel!! It works. wei ... __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. ...
Hi Sameer , Yes your response yesterday was pretty well explained . Now I dont have locally managed tablespaces . The OEM output that u had sent was for...
Amith Uppal
uppal_amith@...
Nov 27, 2002 4:40 pm
292
Hi Amith , Sorry for delay in responding. if the tablespace is dictionary managed and you have a objects in it, having various extent sizes. You might have a...
Sameer Wadhwa
swadhwa@...
Dec 4, 2002 7:22 pm
293
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
We would like to introduce ourselves as Skots Consultants, a professionally managed company specializes in Executive Search and Selection. We have a team of...
Hi, We r from an IT placement company called Talent Search Inc having offices in Chennai, Bangalore and associates in US and Singapore. We work with many...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
