How to define data block size

bhavana · 23-01-07, 06:38 PM

How to define data block size <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

ajithcharles · 26-01-07, 07:27 PM

In windows you will have to modufy the value of DB_BLOCK_SIZE present in init.ora file which is under pfile directory.

mymailbox.21 · 13-03-08, 05:37 PM

we can define block size using db_block_size parameter either in pfile or spfile in all the platforms.

however once we created a database using some block size we cant change that.

23-01-07, 06:38 PM	#1 (permalink)
bhavana Senior Member Join Date: Jan 2007 Posts: 598 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 7	How to define data block size How to define data block size <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

26-01-07, 07:27 PM	#2 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: How to define data block size In windows you will have to modufy the value of DB_BLOCK_SIZE present in init.ora file which is under pfile directory. __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

13-03-08, 05:37 PM	#3 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: How to define data block size we can define block size using db_block_size parameter either in pfile or spfile in all the platforms. however once we created a database using some block size we cant change that.

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
interview Q&A asked in winrunner	Spoorthi	Testing Tools & QA	80	22-11-08 11:48 PM
Mega Free Download S/W Links A-Z	yathish	OTHERS	513	30-09-08 02:49 PM
How to define Data Block size ?	bhavana	Oracle Interview / Technical Questions	0	23-01-07 05:51 PM
4C Solutions Pvt Ltd Hiring Data Analyst	sridhar	EXPERIENCED JOBS	0	25-10-06 02:10 AM
hi...	gomesh_2k6	VB / ASP.NET Technologies	2	30-09-06 02:20 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)