Home » RDBMS Server » Server Administration » can we change db_block_size in 10g
can we change db_block_size in 10g [message #337836] Fri, 01 August 2008 05:33 Go to next message
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
---------------------------------------------------------------
Re: can we change db_block_size in 10g [message #337854 is a reply to message #337836] Fri, 01 August 2008 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) No.
2) No at tablespace level

Regards
Michel


Re: can we change db_block_size in 10g [message #337929 is a reply to message #337836] Fri, 01 August 2008 10:52 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: can we change db_block_size in 10g [message #337936 is a reply to message #337932] Fri, 01 August 2008 11:37 Go to previous messageGo to next message
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
Re: can we change db_block_size in 10g [message #337941 is a reply to message #337936] Fri, 01 August 2008 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: can we change db_block_size in 10g [message #337945 is a reply to message #337941] Fri, 01 August 2008 12:16 Go to previous messageGo to next message
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
Re: can we change db_block_size in 10g [message #337953 is a reply to message #337945] Fri, 01 August 2008 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: can we change db_block_size in 10g [message #338102 is a reply to message #337953] Sun, 03 August 2008 10:25 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Michel contradicting your views ...

Why don't you give link of oracle documentation Smile
Re: can we change db_block_size in 10g [message #338132 is a reply to message #338102] Sun, 03 August 2008 22:34 Go to previous messageGo to next message
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



Re: can we change db_block_size in 10g [message #338141 is a reply to message #338132] Sun, 03 August 2008 23:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I agree with aaryaan, I just give my experience as interviewer (and interviewed).

Regards
Michel
Previous Topic: service handle not initialized
Next Topic: maximum instances
Goto Forum:
  


Current Time: Sun Dec 04 00:35:57 CST 2016

Total time taken to generate the page: 0.03966 seconds