-
Oracle DBA QuestionsWhat happen when we kill smon?What happen when we kill pmonWhat is fracture block and how to fix itWhat is corrupted block and how to fix itWhat are the oracle threads are going to start ,when we start the databaseHow to check index is working properly ,what are the steps to be taken and on what basis we have to decide particular index has to rebuild not all indexesWhat steps to be taken if receive a call that performance has gone down as DBA what steps has be takenWhat possible error can we able to see in alert fileSudden if performance go down what steps to be taken without using alert file is coz size 3m and we don't want to user alert file how to find the problem and how to fix itIf users are not able to connect database or database is down what preliminary steps to takenWhat actually do in oracle when we take hot backup where actually modified blocks are written?What should be RAM for 50gb database on what basis we have to decide the ramCan we able to connect database using listener instead of TNS namesNormally on daily basis what are the jobs DBA has to do on daily basis?Can we able to create physical standby database using hot backup if yes howIs there is something concurrent user connections are limit if yes how can we increase user connection interview said by using LISTENER FILE If we want to write query how write efficient query and how to make execution plans
ashok
- Aug 30th, 2011
When process monitor kills we can't remove locks on tables,
ianilreddy
- Aug 7th, 2010
1. When we kill any background processes database will be down.3. We can find corrupt block using v$database_block_corruption view using RMAN utility we can solve the problem recover block datafile...
-
-
-
Change parameter in pfile
how to change the log_archive_format parameter in pfile if corresponding issys_modifiable parameter is "FALSE"
give me the full step by step procedure.
Thanks
Gyan -
Difference between logical and physical Data
What is difference between logical & physical data and what do mean by physical & logical backup of data ?
-
-
Search Method
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
SSR
- Jul 20th, 2011
Depends on cardinality, for low cardinality then full scan better
prashanthpadal
- Mar 23rd, 2011
If the query has to get the output more than 5% of the full table then full scan is better than Index scan. Here is the matter of 35% then, it should go though full table scan.
-
Full Table Scan
There are about a 10,000 records in a table. A user 1 runs a query which is doing a full table scan. While doing the full table scan, user 2 changes some value x to y using a DML statement in record. What does the the 1st user see ( x or y ) ? If x, then where is the value stored?
-
How can you check which user has which Role.
-
How do you search for Index name in Oracle ?
-
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. ...
-
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...
-
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
-
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...
-
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...
-
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 ...
-
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
-
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...
-
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.
-
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...
Oracle DBA Interview Questions
Ans