OraFAQ Forum: Server Administration » can we change db_block

Home » RDBMS Server » Server Administration » can we change db_block_size in 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

can we change db_block_size in 10g [message #337836]

Fri, 01 August 2008 05:33

sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI

Member

Hello
[Note:This is only Interview question.]

In oracle 10g a database is created with db_block_size=8K now we feel that some tables requires 16K.
1)Can we change db_block_size ? or
2)Can we define db_block_size in table level ?
(If yes means can i have the syntax ?)

Thans in advance
sbmk_design
---------------------------------------------------------------

Report message to a moderator

Re: can we change db_block_size in 10g [message #337854 is a reply to message #337836]

Fri, 01 August 2008 06:24

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) No.
2) No at tablespace level

Regards
Michel

Report message to a moderator

Re: can we change db_block_size in 10g [message #337929 is a reply to message #337836]

Fri, 01 August 2008 10:52

aaryaan
Messages: 9
Registered: July 2008
Location: Bangalore

Junior Member

Hi,
You can't change db_block_size parameter, but can create 16k blocksize tablespace and move your table to that tablespace.

Regards,
Satheesh Babu S

[Updated on: Fri, 01 August 2008 10:57] by Moderator

Report message to a moderator

Re: can we change db_block_size in 10g [message #337932 is a reply to message #337929]

Fri, 01 August 2008 10:59

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not add anything to my post, it is just an ad for your blog that I removed.

Links are spam if they are not an answer to the post.

Regards
Michel

Report message to a moderator

Re: can we change db_block_size in 10g [message #337936 is a reply to message #337932]

Fri, 01 August 2008 11:37

aaryaan
Messages: 9
Registered: July 2008
Location: Bangalore

Junior Member

Alright, if that spam the list my apologies.

But who are you to tell it doesn't add any value. I gave him a alternate way to his request.

Regards,
Satheesh Babu S

Report message to a moderator

Re: can we change db_block_size in 10g [message #337941 is a reply to message #337936]

Fri, 01 August 2008 11:58

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Alternate? What is alternate to what? Is this what you would answer to the interview?
I make interviews and if you give me an answer that is outside the question you have a bad point and be lectured, and trust me I'm not the worst.

Regards
Michel

Report message to a moderator

Re: can we change db_block_size in 10g [message #337945 is a reply to message #337941]

Fri, 01 August 2008 12:16

aaryaan
Messages: 9
Registered: July 2008
Location: Bangalore

Junior Member

Well if you go for an interview to an experienced post and some one ask you a question like this and you say "NO" in a single word. Believe me it is very rude. Interviewer espect more than that from a qualified personnel. Right approach would be to give a solution to the problem.

Just replying Y/N to a question might work well in a campus recruit. For an experienced post, you need to give a solution.

Regards,
Satheesh Babu S

Report message to a moderator

Re: can we change db_block_size in 10g [message #337953 is a reply to message #337945]

Fri, 01 August 2008 12:50

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is wrong.
Some questions need short answer.
Some questions need long answer.
Giving long answer when short is required is as bad as the opposite.
These questions are short answer ones, if the interviewer wants more he/she will then add "can you tell me more?".

Regards
Michel

Report message to a moderator

Re: can we change db_block_size in 10g [message #338102 is a reply to message #337953]

Sun, 03 August 2008 10:25

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Michel contradicting your views ...

Why don't you give link of oracle documentation Smile

Report message to a moderator

Re: can we change db_block_size in 10g [message #338132 is a reply to message #338102]

Sun, 03 August 2008 22:34

aaryaan
Messages: 9
Registered: July 2008
Location: Bangalore

Junior Member

Well, he is not contradicting with me in technical aspect. He got a different view when facing interview.

If i think other person will not change his stand no matter how much you try to convince him, in that case i just keep quiet. Few people has their own way of learning things in harder way.

Regards,
Satheesh Babu S

Report message to a moderator

Re: can we change db_block_size in 10g [message #338141 is a reply to message #338132]

Sun, 03 August 2008 23:44

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I agree with aaryaan, I just give my experience as interviewer (and interviewed).

Regards
Michel

Report message to a moderator

Previous Topic:	service handle not initialized
Next Topic:	maximum instances

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 17:47:53 CST 2025