How to define Data Block size ?
Answers were Sorted based on User's Feedback
Answer / orawhiz
A data block size is specified for each ORACLE database when
the database is created. A database users and allocated free
database space in ORACLE datablocks. Block size is specified
in INIT.ORA file and cann't be changed latter.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nishi
A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can't be changed latter.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by merge in oracle and how can you merge two tables?
Why we use bulk collect in oracle?
what is the use of system.effective.date variable in oracle?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
What are the types of trigger in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
What are the execution control statements in oracle?
How do I recompile a procedure in oracle?
Find all employees in Dept “Marketing”.
why dont we assign not null constraint as table level constraint.