![]() |
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
![]() Related Questions Latest Answer : Alter table < Table_Name> move tablespace ; Alter index rebuild tablespace ; ... Latest Answer : PCTFREE : This clause is used for future updation, If you increase PCTFREE value, There will be less rows inserted in block ... Latest Answer : depends upon the storage parameters. ... Latest Answer : It Sotres the Oracle Data Dictionery ... Latest Answer : by correctly fixing optimal size ... Latest Answer : By Dba_segments and DBA_extents and dba_free_space views. ... Latest Answer : Calculate the total header size.Calulate the available data space per data block.Calulcate the combined column length by the avarge row.Calultate total average row size.Calculate avarge number of rows that can fit in data block.Calulate the number of ... Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio Dictionary cache is information about the databse objects stored in a data dictionary table.
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||