-
How to DROP an Oracle Database?
You can do it at the OS level by deleting all the files of the database. The files to be deleted can be found using: 1) select * from dba_data_files; 2) select * from v$logfile; 3) select * from v$controlfile; 4) archive log list 5) initSID.ora 6) In addition you can clean the UDUMP, BDUMP, scripts etc Clean up the listener.ora and the tnsnames.ora. make sure that the oratab entry is also removed.
ianilreddy
- Aug 7th, 2010
Start the database with startup mount restrictthen drop the database using drop database command.
-
Restricted Mode Memory Gap
How to check to memory gap once the SGA is started in Restricted mode?
sonaligujral1
- Aug 7th, 2010
No memory gap would occur whether database is started in open or restricted mode.
-
Database Auto extend question
This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is growing up and it is reaching the 4GB of my database space...Now, i would like to extend my Database space to 20 GB or 25 GB... what are the things i have to do " Pls give me the accurate Solutions or alternates...
alex.v
- Jul 11th, 2008
Better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold of 85 % full
-
Changed Performance
When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?
vijender reddy
- Aug 13th, 2010
First we must check for any locks on the objects, if we get any locks then just release that lock.Here is how you can know if there is a lock on an object1. Find sidSQL>select distinct sid from v$...
-
Oracle Backsets created by RMAN
Can you use Backsets created by RMAN with any other utility
-
How are the index updates
alvinstars
- Sep 7th, 2010
The database automatically maintains and uses indexes after they are created. The database also automatically reflects changes to data, such as adding, updating, and deleting rows, in all relevant indexes with no additional actions required by users.
-
DB Server Performance Bottlenecks
What are four performance bottlenecks that can occur in a database server and How are they detected?
-
Db_buffercache tuning
Db_buffercache : How we will tune it.
dbashashi
- Dec 2nd, 2010
You can take advantage of db_cache_advice in the parameter file. you can also use v$db_cache_advice.When using db_cache_advice = On; a proper caution is adviced as it can take some memory from Shared_pool will be affected which otherwise meant for same purpose
-
Oracle DB Buffer Cache
How the data is processed in DB Buffer Cache.
dbashashi
- Dec 2nd, 2010
Hi,Db_buffer_Cache is nothing but a memory allocated out of physical Memory (RAM) and is part of SGA.When the database server starts for the first time the DB_buffer_cache doesnt have any information ...
-
Difference between 9i OEM & 10G OEM.
Explain the differences between 9i OEM & 10G OEM along with new features that changes the way you do your daily job
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
-
Familar Unix Files for DBA
As a Oracle DBA what are all the UNIX file you should be familar with?
pandish
- Dec 31st, 2010
/etc/hosts/etc/passwd/var/opt/oratab/var/adm/messages (Solaris) var/log/messages(Linux)df -k (df -h on Solaris 5.10+)
fnlin
- Oct 31st, 2010
The question refers to a "file", not a process. As far as file, DBA should check the file system capacity and usage via "df -hk ." command (or "df -hk /db?", if the datab...
-
Troubleshoot an Error
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
pandish
- Dec 31st, 2010
Depending on error1. Try to use your judgement,experience to understand and resolve it. You can even ask to reproduce it.2. Search the metalink. or run oerr utility by passing the ORA message number t...
samsam1414
- Jan 19th, 2010
Search forums for similar error codes or symptoms and make a plan, then submit it to your supervising DBA if you are not authorised to carry it out yourself.
-
Check database state using pfile/spfile.
How to check whether database whether it is opened by pfile/spfile.
Kapil Relan
- Apr 15th, 2011
if you are not aware about what your database has chosen at startup ie PFILE or SPFILE you can simply try the following SQL statement:,which i tried create spfile from pfile;if you get the output that...
-
HOW 2 ENABLE PARTITIONING FEAUTURE IN ORACLE 8i
senthilora
- Sep 24th, 2007
PARTITION is one of the options, which you can enable when you install Oracle Enterprice Edition.You may enable it later if you didn't choose to install at first time. You will have to insta...
V.A.SURESH
- Nov 12th, 2005
Install 8i enterprise version. partition enables automatically
-
What is a deadlock and Explain
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
- May 23rd, 2011
One process waiting for another process which never ends is known as deadlock.
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 ...
-
What is an Oracle sequence
ashu_641981
- May 24th, 2011
Sequences are special database objects that provide numbers in sequence for input to a table.
soccer_champ
- Jun 18th, 2005
A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row. It i...
-
Oracle OERR Utility
What is OERR Utility
Alpana G
- Jun 20th, 2011
The OERR utility will display the complete error message text and the source of the error and recommended steps for resolving the problem.Syntax- oerr ora “error”oerr ora 0060000600, 00000...
-
Is it possible to drop more than one table using single sql statement? if yes then how.
skranof
- Jul 2nd, 2009
I assume you already figured this out, but if notsimplyuse dbNamegodrop table table1, table2, table3
-
Where does the SCN resides (system change number)
g.mrunalini
- Feb 12th, 2008
SCN changes for every 3 minutes in 10g and for each and every action in 9i. It resides in control files and data files. CKPT (checkpoint) background process updates the SCN numbers from control files ...
senthilora
- Sep 24th, 2007
SCN - System Change Number - is always getting incremented by Oracle server and will be used to make sure the consistency across the database.SCN number will be updated in almost all places of th...
-
What are the components of physical database structure of Oracle database
vanithaananth
- Jun 24th, 2011
Physical structures of oracle database consists of datafiles,controlfiles redologfiles and archivelogfiles...
dj_dj_dj
- Feb 18th, 2010
Dear, Oracle Physical Database Structure consist of Datafiles, Controlfile & Online Redo Log files. ...
Oracle DBA Interview Questions
Ans