![]() |
| 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 : 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 : by using dictionaray view's called v$rollstat,dba_rollback_segs. ... 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 ... Due to insufficient Shared SQL pool size. Monitor the ratio of the reloads takes place while executing SQL statements. If the ratio Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop Latest Answer : If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace; ... Each block contains entries as followsFixed block headerVariable block headerRow Header,row date (multiple rows may exists)PCTEREE (% of free space for row updation in future) Latest Answer : A block is divided into1. Header2.free space3.data spaceThe free space is in the middle shrinks as header and data space grow.Space usage in the data space :The data space is managed with 2 parametersa.pctused b.pctfreesuppose pctused=40 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||