Re: Oracle Limits

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Jun 2018 13:17:10 -0400

On 06/29/2018 05:16 AM, nilesh kumar wrote:

Hello Gurus,

Could any one please forward the doc or metalink note no for
1. Why the datafile size can grow max to 32 gb for a 8k block size

It can grow even more. You can have big file tablespaces which can use files much larger than 32GB.

2. What happens internally when we click on create database button, which files are picked up by Oracle I know some .bsq scripts are called from the admin directory but how it works inside oracle.

Many things happen. Data dictionary is created and installation scripts are run for all the add on components, like text search, XML, multi-media and alike.

3.more over I want to understand the Oracle binaries in dept, what is meant for what..why the Binaries are so hughe in size after installation, what other information it is having.

Because Oracle is a very complex database and it takes a lot of code to create all these features.

4. Any many more questions like this....

And the answer is 42.

I tried searching in google and metalink but could not get exact note or doc for the same.

Thanks & Regards
Oracle DBA (sqlplus "/as sysdba" is my world)

"As our circle of knowledge expands, so does the circumference of darkness surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat you with experience." - Unknown

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Other related posts: