hi friends, I need some help on these topics. i have a oracle 8i db. where can i get all the sql help of oracle. some online books(downloadable if any)? 1> can...
Man! looks like you are on some serious fire!!! For starters try out www.orafaq.org Bharat. ... databases. ... steps? ... ...
bharat@...
Sep 9, 2002 8:11 am
262
Hi Guys, Can anyone redirect me on 'How to setup OEM on linux box 6.2/7.2' Thanks, Vishakha __________________________________________________ Do you Yahoo!? ...
vish
gvishakha@...
Sep 28, 2002 12:23 pm
263
hi techies thanks in advance. pls reply in brief q> what do u mean by distrubuted transaction? q> what is two phase commit? why is it called so? q> set...
Hi all, I am looking out for a suitable opening in a good/stable firm. I am Physics graduate from Mumbai University. I have approx 4 years of experience...
Dear Friends, I am doing a project over Internet Banking System. I need to move from form to form using a html link (hyperlink). I want that whenever i click a...
irfan kazi
irfan_a_kazi@...
Oct 29, 2002 5:02 am
266
oracle's ilt is availabaleand also sts software. these 2 r good enough for certification. solaris admin is good combination with 8i. i am here to assist u...
Khurram Shahzad Butt
ksbutt@...
Oct 30, 2002 8:16 am
267
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...
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.
