1) How to install patches? And what are pre-requsites?
2) How to upgrade 10.2.0.1 to 10.2.0.4 AND 11.2.0.1 to 11.2.0.3 and 10.2.0.4 to 11.2.0.1?
3) How to take the backup of oracle_home and oracle_inventory?
4) What is OCR & voting disk?
5) How to take backup of OCR and voting?
6) Which one take backup if OCR and voting disk?
7) Suppose lose OCR what happen...

Sanjay Srivastava

• Feb 9th, 2017

We can take backup of OCR file.
ocrconfig -manual backup;

alekhya kumari

• Sep 22nd, 2016

# cat /etc/issue -os name & version of os. when we start a database its version is shown

Answer Question  Select Best Answer

Ashok

• Jul 13th, 2017

Tablespace is a logical storage device, the database stores the data physically in datafiles and logically in tablespaces

NARESH NADHAN

• May 4th, 2016

Simply I say DATABASE is divided into some logical storage units that is called TABLESPACE.This is logical storage.And a TABLESPACE can have 1024 datafiles.

Answer Question  Select Best Answer

rakesh

• Aug 4th, 2017

Server Process

Rammy

• Jul 13th, 2017

Exactly server process invoke and write data from datafiles to database buffercache..

Answer Question  Select Best Answer

Manoranjan Dash

• Sep 18th, 2017

Query the v$session table.

Albert Z

• Mar 31st, 2015

SELECT SYS_CONTEXT (USERENV, HOST) from dual;

Answer Question  Select Best Answer

ayub

• Sep 19th, 2017

System tablespace is memory allocated by oracle and will be created at the time of database creation, stores information of data dictionary tables in database, with out system tablespace you can not open the database.

imran44

 Profile Answers by imran44 Questions by imran44

• Jan 9th, 2009

IN 10g, there are two system table spaces called system and sysaux(auxillary) tablespace. These system tablespaces are backbone of database, and data base will not function at all without these tables...

Answer Question  Select Best Answer

You can query dba_data_files and dba_temp_files

prasant singh

• Oct 3rd, 2017

Can you explain why using bytes/1024/1024/1024

gvishalsoft

 Profile Answers by gvishalsoft Questions by gvishalsoft

• Apr 28th, 2009

Select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files;

Answer Question  Select Best Answer

jayesh gaikar

• Nov 6th, 2018

LMT(Locally Managed Tablespace) :In LMT Extents are managed at the data file level.
DMT(Dictionary Managed Tabalespace) :Extent management in DMT is maintained and carried out at the data dictionary level.

Surya

• Jun 15th, 2017

When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks, called an extent, is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary, or in the tablespace itself

Answer Question  Select Best Answer

Hello Folks,

Hope all doing good.

I have been working for a company where they provide online classes for different technologies. My question is whenever we try to send a data into the database it shows that the info has been added successfully but, While fetching it says results no found. Kindly give me a solution for this.

Thanks

vibhour

• Mar 4th, 2020

Check if the column is redacted/masked. This you may need to check with DBA. So for example companies to protect client data, the masked certain PI columns such as names.

Himanshu Jawla

• Oct 31st, 2018

Make sure you are executing COMMIT; once insertion is done

Answer Question  Select Best Answer