How will you find out the user(scott) belongs to which tablespaces? (in Oracle)

Shivam

• May 9th, 2023

SELECT default_tablespace FROM dba_users WHERE username=SCOTT;

Answer Question  Select Best Answer

Avinash Buliya

• Feb 9th, 2017

SGA is system global area where our Oracle Instance and Process works. And its located in our systems Primary Memory means in located RAM (Random Access Memory). SGA size is by default taken 40% of ou...

NAGARAJ OCP

• Dec 27th, 2011

Dont install oracle on C:(or on which drive you installed OS). Its not sure that it gives you great result, it better result then previous one.

Answer Question  Select Best Answer

System  Monitor (SMON)  performs instance recovery at instance start-up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance  can  also  perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers  dead  transactions  skipped  during ...

SREDDY1987

• Jun 30th, 2014

Rollback means uncommitted transaction.
Roll forward means committed transaction.

msabuu

 Profile Answers by msabuu Questions by msabuu

• Nov 6th, 2007

If server unplanned shutdown, Power failiure SMON Instant recovery. there is two type of Instant recovery 1st is Roll forward 2nd Roll back.Rollback means comitted transaction.Rollforward means uncommitted transaction.

Answer Question  Select Best Answer

Program Global Area (PGA) is a memory buffer that contains data and control information for a server process.

NARESH KUMAR

• Sep 18th, 2012

Pga is a memory area that contains data and control information for the oracle server processes. The size and contains of the pga depends on the Oracle server options we have installed.

NAGARAJ OCP

• Dec 27th, 2011

Main function of PGA is SORTING(Order by, Join and so on) will takes place on PGA memory.. If PGA memory is not enough in such cases temporary tablespaces will be used.

Answer Question  Select Best Answer

What is database security? How will you use it?

sri

• Feb 20th, 2012

That is Acl . Those levels are

Manager,
designer,
editor,
author,
reader,
depositor,
no access

Answer Question  Select Best Answer

Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.

NAGARAJ OCP

• Dec 27th, 2011

Database Buffer cache has four states: Pinned: multiple sessions are kept from wirting to same block @ same time. Other session waits to access these blocks Clean : Now the session is unpinned ...

saihaan

 Profile Answers by saihaan Questions by saihaan

• Jul 2nd, 2009

Database buffers consists of the dirty blocks. When ever we are trying to update some table/etc. First it verifies whether the data exists in database buffer , If not it fetches the information from d...

Answer Question  Select Best Answer

Database buffers, Redo Log Buffer the Shared Pool and   Cursors.

Nagaraj OCP

• Dec 27th, 2011

SGA has six parts on it

Shared pool
JAVA POOL
Stream Pool
Large Pool
Data Buffer cache - MRU, LRU
Redo log buffer

saihaan

 Profile Answers by saihaan Questions by saihaan

• Jul 2nd, 2009

Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache.

Answer Question  Select Best Answer

Why is Oracle called kernel package?

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 8th, 2011

Oracle introduced the Unbreakable Enterprise Kernel for Oracle Linux during Sep 2010 which runs directly on Oracle LINUX 5 with fast, modern, reliable kernel that is optimized for Oracle software and hardware.

Answer Question  Select Best Answer

What is a cluster and how it is used

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

An Oracle Database Cluster is a set of database instances on different nodes accessing the database related files on a shared storage.

shardin

 Profile Answers by shardin Questions by shardin

• Oct 19th, 2008

The deployment of a single database across a cluster of servers—providing unbeatable fault tolerance, performance and scalability

Answer Question  Select Best Answer

SGA  and  ORACLE  background  processes constitute an ORACLE instance. (or) Combination of memory structure and background process.

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Jun 22nd, 2009

Oracle Instance is an combination of background process and memory structures.

nareshkumarmca

 Profile Answers by nareshkumarmca Questions by nareshkumarmca

• Jun 19th, 2009

Oracle instance is the combination of SGA and
background processes. When user sends a connection request server process starts and it starts instance.

Answer Question  Select Best Answer

The Checkpoint (CKPT) process is responsible for signaling  DBWR  at checkpoints  and updating all the data files and control files of the database.

gyanudba

 Profile Answers by gyanudba Questions by gyanudba

• Feb 6th, 2009

Ckpt (checkpoint) is a background process. It synchronize SCN?of all the database files like?datafiles, control files and redo log files.

taya_ronak

 Profile Answers by taya_ronak Questions by taya_ronak

• Feb 2nd, 2009

checkpoint is backgroud process. it'll occur in some situations like during log switch, or on the basis of log_checkpoint_interval or log_checkpoint_timeout parameter in parameter file.  ...

Answer Question  Select Best Answer

The  System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.

subhash.terdale

 Profile Answers by subhash.terdale Questions by subhash.terdale

• Oct 1st, 2008

System Global Area (SGA) is component of instance which consist shared memory & control information of the instance It consist of shared pool, database buffer cached, redo log buffer, large pool, Java pool.

Mohammed Abdul Afroze

• Oct 5th, 2007

It is a shared memory region allocated by oracle?that contains data and control information for an Oracle Instance. An SGA compromises of Buffer Cache, Redo Log Buffers and Shared Pool Area.

Answer Question  Select Best Answer

DBWR  writes  when  more  data  needs  to  be read into the SGA and too few database  buffers  are free. The least recently used data is written to the data files first. DBWR also writes when CheckPoint occurs.

subhash.terdale

 Profile Answers by subhash.terdale Questions by subhash.terdale

• Oct 1st, 2008

DBWR writes* when checkpoint occures* when dirty buffers reach threshold* when RAC ping requested* when free buffers are not available* when tablespace taken offline,droped

sweety

• Apr 26th, 2006

DBWn writes when:1)checkpoint occurs2)dirty buffers reach threshold3)there are no free buffers4)timeout occurs5)RAC ping request is made6)when any tablespace is taken offline,read only,drop or truncated & when begin backup

Answer Question  Select Best Answer

LGWR   writes  redo  log  entries  into  an  on-line  redo  log  file  when transactions commit and the log buffer files are full.

subhash.terdale

 Profile Answers by subhash.terdale Questions by subhash.terdale

• Oct 1st, 2008

Log writer writes* when transaction commits* every three seconds* when 1/3 of redo full* when 1mb of redo generated* before dbwn writes

Mohd Israr Khan

• May 24th, 2006

The LGWR   writes  redo  log  entries  into  an  on-line  redo  log  file  when 1. transaction is committed.2. More than 1 MB of redo log buffer enteries.3.  1/3 of the redo log buffer is full.4. Every 3 seconds.

Answer Question  Select Best Answer

Shared  Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.

Mohammed Abdul Afroze

• Oct 16th, 2007

Shared Pool compromises of Library Cache and Dictionary Cache.Library Cache stores and shares sql stmts where as plsql stmts in memory.Dictionary Cache: Oracle continously request and update informati...

parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

Hi,Actually Shared pool is composed of two parts one is Library Cache and another Data Dictionary cache The Library cache contains the shared sql areas, private sql areas, PL/SQL procedures and packag...

Answer Question  Select Best Answer

Redo Log Buffer stores redo entries a log of changes made to the database.

Mohammed Abdul Afroze

• Oct 5th, 2007

It stores redo log entries a log of changes made to a Database.

Sivamurugesh Arumugam

• Feb 15th, 2007

Redo log buffers consists of change vectors where each vector contains information about which block is changed and where is the change done in the memory. This information will be useful when you are...

Answer Question  Select Best Answer

A  Cursor is a handle ( a name or pointer) for the memory associated with a specific statement.

aloksourav

 Profile Answers by aloksourav Questions by aloksourav

• Mar 31st, 2007

Cursor is nothing but it is temprary storage area.In other word cursor is a private sql work area whenever issuing sql and pl/sql statements ,it creates a memory area in server.this memory area is know as cursor area.

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 28th, 2006

A cursor can be viewed as a "Pointer" into the result table of an SQL SELECT statement. Cursors are needed whenever the result contains more than one row.  3rd generation programs like COBOL and ...

Answer Question  Select Best Answer

A  Shared  SQL  area  is  required  to  process  every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement.

partho sarathi konar

• Oct 1st, 2006

HiShared SQL  areas are shared memory areas; any Oracle process can use a shared SQL area. The use of shared SQL areas reduces memory usage on the database server, thereby increasing system throu...

Answer Question  Select Best Answer

Log  Writer (LGWR) writes redo log entries generated in the redo log buffer of the SGA to on-line Redo Log File.

manish hoiyani

• Sep 18th, 2006

LGWR is oracle background process.. all changes which have been made inthe database  gets recorded in the redolog buffer.. so when the users fires an commit statement , LGWR writes these changes ...

rajat dey

• Feb 21st, 2006

Hi,It is one of the main background process in oracle . In oracle and unix environment you can check this process using ps -ef |pg command . which is writting all the uncommited transaction from SGA to redologfile .regrdsrajat dey

Answer Question  Select Best Answer

DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process MonitorARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server.

kehri_anurag

 Profile Answers by kehri_anurag Questions by kehri_anurag

• Jan 13th, 2006

Mandatory Processes DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process Monitor Optional Process ARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server.

Answer Question  Select Best Answer