Explain the difference between a data block, an extent and a
segment.
Answer Posted / gaya
The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.
A segment is the space allocated for a specific logical
storage structure within a tablespace.
Space is allocated to a segment by extents.One or more
extents make up a segments.
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
What is replication? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is grd?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how to restore files with rman?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the operating modes in which database mirroring runs? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
Why would you call update statistics? : sql server DBA
what is the diffrence between core dba and apps dba?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?