Explain the differences between 9i OEM & 10G OEM along with new features that changes the way you do your daily job

dbashashi

 Profile Answers by dbashashi Questions by dbashashi

• Dec 13th, 2010

Who said there is no OEM in 9i. OEM was there in 9i too.As far as difference is there... There are many enhancement in 10g OEM over 9i OEM. There are several tools such as AWR and ADDM has been incorporated and there is Sql Tuning advisor too.RegardsShashi singh

gurbux

 Profile Answers by gurbux Questions by gurbux

• Jul 19th, 2010

OEM came with 10g Edition. No OEM in 9i

Answer Question  Select Best Answer

If the entire disk is corrupted how will you recover the database and what are the steps to recover the database?

m4k4v3l1

 Profile Answers by m4k4v3l1 Questions by m4k4v3l1

• Jul 1st, 2009

Things Useful For Complete Recovery :1- Last Valid Backup2- Dump Files3- Archive Logs- If You Have a Valid Backup on Another Disk Rather Than The Damaged One , You Can Recover The Database till The Ti...

kalpeshbanokar

 Profile Answers by kalpeshbanokar Questions by kalpeshbanokar

• Jul 24th, 2008

Succesful backup is possible iff there is "Archive Mode" is on.that is database is in Archive Mode.and if it's offthen there are only 99.9% chancesthroughGroup1 or Group2 of Online Redo log files.

Answer Question  Select Best Answer

Is it possible to resize tablespaces and data files? If yes, how?

nafees

 Profile Answers by nafees Questions by nafees

• Jul 22nd, 2008

Hi all,Yes i agree with the answer but resize in the sense,the size should also get decrease.we can decrease even the size of the datafile but the condition is the datafile should be empty.

rajendra_thanekar

 Profile Answers by rajendra_thanekar Questions by rajendra_thanekar

• Jun 25th, 2008

hi,We can resize the datafiles which in turn resize the tablespace for which the datafile belongs. The command is alter database datafile '<datafile_name>'  resize(size)M;By this co...

Answer Question  Select Best Answer

What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?

sundarasaravanan

• May 4th, 2012

For a cold backup :shutdown oracle first and then proceed the cold(offline) back up. once you shutdown the oracle database insert the external tape/disk.pls ensure the tape/disk is in good condition. ...

doc123

 Profile Answers by doc123 Questions by doc123

• Mar 23rd, 2012

Some Common issues with Backup. If you are taking backup from no-archive log: then your database doesn't bring down due to some processes are running. If you are taking hot backup then may be newly ...

Answer Question  Select Best Answer

When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode?

kumarmvn

 Profile Answers by kumarmvn Questions by kumarmvn

• Sep 2nd, 2008

Select * from v$backup; == in this view you can check for status,if it is ACTIVE that file is still in backup mode.Hope this helps you.ThanksKumar

Ahmed2010

 Profile Answers by Ahmed2010 Questions by Ahmed2010

• Jun 17th, 2008

It freezes the headers of the file, when its in the backup mode.Tauseef A.

Answer Question  Select Best Answer

How will you rectify if one of the rollback segments gets corrupted

cmanne

 Profile Answers by cmanne Questions by cmanne

• Sep 2nd, 2009

The only option available is to restore and recover the database followed by opening the database with resetlogs.

Ahmed2010

 Profile Answers by Ahmed2010 Questions by Ahmed2010

• Jun 17th, 2008

You have to restore and recover the corrupted rollback segment.Tauseef A.

Answer Question  Select Best Answer

When the developer trying to compile the package. But the database gets hanged? What will you check?

gogune

 Profile Answers by gogune Questions by gogune

• Mar 31st, 2010

Deadlock could have occured. Check whether same object is updated by two sessions.

gvishalsoft

 Profile Answers by gvishalsoft Questions by gvishalsoft

• Apr 28th, 2009

We check the alert log file in bdump destination

Answer Question  Select Best Answer

amit19821

 Profile Answers by amit19821 Questions by amit19821

• Mar 13th, 2009

Local to Dictionary managed tablespcaes:exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tablespace');Dictionary to locally managed tablespaces:exec dbms_space_admin.Tablespace_Migrate_to_Local('tablespace');

g.mrunalini

 Profile Answers by g.mrunalini Questions by g.mrunalini

• Jul 22nd, 2008

Use the following package>execute dbms_space_admin.tablespace_convert_to_local('tablespace_name');>execute dbms_space_admin.tablespace_convert_from_local('tablespace_name');

Answer Question  Select Best Answer

What is difference between logical & physical data and what do mean by physical & logical backup of data ?

SHAVEZZ KHAN

• Aug 13th, 2011

Logical data is nothing but tables, views, indexes, tablespaces etc while the physical data refers to dbf(database) files, control files etc... coming to logical backup: logical backup is simply HOT ...

Raman

• Aug 6th, 2011

Physical data belongs to os level and logical data belongs to sql level

Answer Question  Select Best Answer

iv4122

• Jul 3rd, 2012

Using the storage options can bring further performance gains by using the techniques available for regular tables, including parallel option, partitioning or nologging for the table that holds the materialized view data.DRDPW

Sriniv@s.

• May 11th, 2012

Materialized views are useful for fast REPLICATION purpose..

Answer Question  Select Best Answer

hanuman

• Sep 4th, 2012

View does not consume space and materialized view consume space

manoj100

 Profile Answers by manoj100 Questions by manoj100

• Aug 26th, 2012

A view is a simple select statement executed each time user runs query against it A materialized view is a physical persistent object used for performance improvement of summary data or replication. ...

Answer Question  Select Best Answer

What is the difference in Oracle 10g and 11g Architecture

rahul

• Sep 25th, 2015

Simplified and improved automatic memory management etc.

Munender Singh

• Sep 13th, 2015

There are about 9-10 differences. Some of them are here: 1. The memory tuning feature is there in 11g. 2. Automatic diagnostic Repository infrastructure to prevent, detect, diagnose, and help resolve...

Answer Question  Select Best Answer

User failed to connect database due to tnsnames, what activity you are going to do?

hunk

• Aug 3rd, 2016

Ensure listener is up and running on the server, lsnrctl status SID

Tammy Harte

• Jul 6th, 2016

1) Verify tnsnames.ora file exists
2) Ensure its in the correct folder $ORACLE_HOME/network/admin
3) Ensure listener is up and running on the server, lsnrctl status SID
4) Tnsping SID to verify response / can also putty to host db server and run cmd: ps -ef |grep -I tns

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

sivaraju.sateesh

 Profile Answers by sivaraju.sateesh Questions by sivaraju.sateesh

• Apr 6th, 2009

Synonym is a alias name for an Oracle object. It can be simplified names to access the objects. Example of Synonym and how it is useful Employee is a table is HR Schema A user wants to access the...

waseemvnb

 Profile Answers by waseemvnb Questions by waseemvnb

• Nov 12th, 2007

It is just like Aliasing .. ie giving some name in order to specicifically distinguish it....In other words to simplify the names of tables , column names etc it is used.. Suppose i have a column name...

Answer Question  Select Best Answer

hmounir

 Profile Answers by hmounir Questions by hmounir

• Dec 27th, 2009

1- a private synonym is defined in the schema of a user and is available only to the user.2- a public synonym is usually created by dba and is available for use by any database user.

praveena

• Sep 12th, 2005

Two types of synonims.1.public synonim,2.private synoniim.private synonym is confined to a particular user.public can be used by all the user's.

Answer Question  Select Best Answer

Taj_N

• Jul 16th, 2007

An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index

srujana

• Aug 23rd, 2005

It is created in existing table to locate rows more quickly&efficiently. the users cannot see the indexes,they are just used to speed up the queries

Answer Question  Select Best Answer

dhussainpathan

• Apr 9th, 2007

The Redo log files records the changes made  to the database in the form of REDOLOG entries, which are helpful at the time of Database Recovery Process.

rajesh chadalawada

• Dec 2nd, 2006

     Redo Log is ment to trce or note  the modifications that are applied to data buffer cache it will note on folloing situations1)for every 3 seconds2)when redo log buffer reaches to 1MB3)before db_cache writes data to datafiles4)when ever commited

Answer Question  Select Best Answer

A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in the deadlock, thus releasing one set of data locked by that statement. Statement rolled back is usually the one which detects the deadlock. Deadlocks are mostly caused by explicit locking because oracle...

Karthikeyan Balakrishnan

 Profile Answers by Karthikeyan Balakrishnan Questions by Karthikeyan Balakrishnan

• May 23rd, 2011

One process waiting for another process which never ends is known as deadlock.

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• Aug 17th, 2007

 Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically ...

Answer Question  Select Best Answer

Sharfuddin

• Sep 29th, 2011

Select username,default tablespace,temporary tablespace from dba_users;

This query executes only if following queries is run in mount stage
1. @ $ORACLE_HOME/rdbms/admin/catalog.sql
2. @ $ORACLE_HOME/rdbms/admin/catproc.sql
3 connect system/manager
@ $ORACLE_HOME/sqlplus/admin/pupbld.sql

Rajashekar

• Sep 5th, 2011

Suppose if we are in need of the users connected to a tablespace called abcdata 6the how to findut?

SELECT USERNAME, TABLESPACE_NAME FROM DBA_USERS WHERE TABLESPACE_NAME='ABCDATA';

this will display the users connected to the tablespace abcdata.

Answer Question  Select Best Answer