How will you identify database size when you create a database first time?

Caesar Dutta

• Nov 6th, 2017

Select sum(bytes) from dba_segments

SURAJ BANSODE

• Oct 14th, 2016

To find the size of database we need to Sum (datafiles+redo log files+temp files+control files)

Answer Question  Select Best Answer

Tablespaces and the Database's Schema Objects.

mosin

• Jan 18th, 2018

Tablespace
Segments
Extent

Heena

• Sep 17th, 2017

Tablespaces, Segments, Extent, Data blocks

Answer Question  Select Best Answer

Which parameter specifies the number of DBWn processes?

mosinpatel

• Jan 18th, 2018

SQL> show parameter db_writer_processes
NAME TYPE VALUE
------------------------------------ ----------- -------
db_writer_processes integer 1

srinivasarao

• Mar 22nd, 2015

DB_WRITER_PROCESS=""

Answer Question  Select Best Answer

ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files.

Naresh

• Feb 14th, 2018

Use DBMS_CRYPTO for encrypt and decrypt the objects

Harshad Khuspe

• Dec 27th, 2015

Components of Physical Databases are Oracle files which are in disk. i.e. Datafiles, Online Redolog files, Archive log files, Parameter file, Password File, Controlfile etc.

Answer Question  Select Best Answer

Souravi

• Jun 6th, 2018

No , new columns cannoot be added in view. The view is just a select query so it should be dropped and recreated for any such requirement.

patelmosin

• Jan 18th, 2018

Yes

Answer Question  Select Best Answer

What is high watermark in oracle ?

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Oct 15th, 2018

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Prabhat Sahu

• Oct 4th, 2017

-- High Level Watermark: ------------------------- --> HLW is a term used with table segment in DB to show the amount of datablock occupied(level) by the table data. --> As per PCTUSED and PCTFREE ...

Answer Question  Select Best Answer

The related columns of the tables in a cluster is called the Cluster Key.

Dheemathi

• Mar 4th, 2019

Cluster is a schema object that contains data from one or more tables, all of which have one or more columns in common. Oracle database stores together all the rows from all the tables that share the same cluster key.

pradeep

• May 5th, 2015

The related columns of the table in the cluster are called the cluster key

Answer Question  Select Best Answer