-
Overcome Alert Log Error
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
rajendra_thanekar
- Mar 24th, 2008
Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ...
-
Flash Back Query
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
hemant.agarwal03
- Mar 12th, 2008
Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of th...
-
Standby Databases
What is standby databases? Difference between Physical and logical standby databases
rajendra_thanekar
- Mar 14th, 2008
A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be eith...
-
Oracle memory segments
How do you see how many memory segments are acquired by Oracle Instance.
olilogu
- May 11th, 2009
Check on x$bh it show you what objects are in the buffer.Try this query;SELECT /*+ ordered use_hash(o) use_hash(bh) */ bp.NAME BUFFER_POOL, ...
-
Oracle segments
How do you see how many memory segments are acquired by Oracle Instance.
Baipaneni
- Jan 23rd, 2009
For shared memory segmets in UNIX or LINUX:-->In HOST1_LINUX has one instance $ ipcs -m oracle@HOST1_LINUX:$ ipcs -m------ Shared Memory Segments --------key &nb...
-
Remove Oracle memory segments
How do you remove memory segments
bassem_farouk
- Sep 18th, 2008
To see the Oracle memory segments from UNIX write ipcsthen look at the status column, the one with status is empty and? owner is oraclewrite down the shmid, ex: 2 find 2 shmid 123 and 456?in order t...
-
Oratab file
What is stored in Oratab file
mandarkelkar
- Jun 5th, 2008
This file is used by ORACLE utilities. It is created by root.sh and updated by the Database Configuration Assistant when creating a database.A colon, ':', is used as the field terminator...
-
Can you change priority of a Process in Unix
jituoracle
- Jan 6th, 2009
Unix does provide the command nice [increment] command to lower a priority of a process. As system administrator you can use the renice command to change the priority of a process, all processes of a...
-
Oracle Backsets created by RMAN
Can you use Backsets created by RMAN with any other utility
-
Oracle table space Quota and users
How to create User in Oracle, allocate quota on Oracle table space
shrikant2711
- Mar 28th, 2009
SQL> create user test identified by test default tablespace XYZ quota unlimited on XYZ1 quota unlimited on XYZ2 quota unlimited on XYZ3 quota unlimited on XYZ4;User created.
-
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 ...
-
Oracle Table space used and unused space
I have to check used space/unused space in table space. Which view /command will provide me the desired answer.
-
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 Compress Parameter
My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen.
krishna miryala
- Nov 5th, 2009
When "Y",export will mark the table to be loaded as one extent for the import utility. This option will use only if you want to do import. export size will not change if we use compress=y.
-
Oracle Snapshot too old error
What is Ora1555 error. Snapshot too Old error. Explain in detail.
jryan999
- May 1st, 2008
Oracle Rollback Segments (Undo more recently) hold a copy of data before it was modified, and they work in a round-robin fashion. Writing and then eventually overwriting the entries as soon as...
-
Export query question
exp userid=system/manager file=expfile.dmp log=expfile.log full=Y compress=Y buffer=1000000If i do't mention compress & buffer parameter , then this query will run/not.
nafees
- Aug 10th, 2008
Yes, exactly it will run perfectly because compress and buffer both are optional.
-
Layer Exception Handling
In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
-
Mutated Trigger
What is mutated trigger? In single user mode we got mutated error, as a DBA how you will resolve it?
zodiac_som
- Mar 2nd, 2009
If you are using before in trigger block, then replace it with afterMutated error, when same table access?more than once in one state.
-
Schema Procedure and Data
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like Schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?
shuklad
- Jul 6th, 2008
Procedure will be executed with the authority of A and therfore data will go to the tables owned by A. If one wants the data to go to B, use the clause authid current_user while defining the procedure.
-
Corrupt Master Database
What do you do when the server cannot start due to a corrupt master database?
rahulniki
- May 9th, 2010
If the master database is corrupt, then surely others also do have the problems and thus the need of MDF recovery comes to an immediate. However you can try out to rebuild it with rebuild.exe and restore it.
Oracle DBA Interview Questions
Ans