Answer / wafa

data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.

Answer / 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.

what is the use of ocr?

0 Answers   Oracle,

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

what is the role of dip user in our database?

0 Answers  

---

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

---

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

---

why we use cursors

1 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---