-
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.
-
ASE Server Performance
What will you do when the ASE server's performance is bad?
rajat_dua
- Mar 2nd, 2009
Bad performance" is not a very meaningful term, so you'll need to get a more objective diagnosis first. Find out (i) what such a complaint is based on (clearly increasing response times or ju...
-
Accessing Dual Table
Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
abdulraheem_ar
- Aug 5th, 2008
Dual is a system owned table created during database creation. Dual table consist of a single column and a single row with value xWe will not get any error if we execute select sysdate from scott.emp?...
-
Increase %LIKE Operator Performance
How do you increase the performance of %LIKE operator?
ravinder.pathania
- Oct 6th, 2008
The wildcard char % can be placed in one of three ways: %searchwordhere% searchwordhere% %searchwordhere The searchwordhere% is the fastest because it can use an index if one is specified on that ...
-
Estimate SGA Size
How to estimate the size of SGA?
rajat_dua
- Mar 2nd, 2009
SQL> show sgaTotal System Global Area 167772160 bytesFixed Size 1247900 bytesVariable Size 58721636 bytesDatabase Buffers 104857600 bytesRedo Buffers 2945024 bytes
-
Troubleshoot SQL * Plus
If the SQL * Plus hangs for a long time, what is the reason?
gurbux
- Jul 19th, 2010
SQL statement is taking long time to retrieve results from database.See which statement is taking longtime by running SELECT * FROM sqltext; or SELECT * from v$session_longops;
-
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.
-
Execute Analyze Table Command
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
harisivati
- Jul 13th, 2008
Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table .
-
Replication Server
Explain how will you setup Replication Server & sync it?
vijaykaushik
- Dec 31st, 2008
Replication server can be setup using many ways1)Using Oracle Streams2)Using Advanced replication 3)Using Mviews.Each has their own mechanism to sync data. Regards,Vijay Kaushik
Oracle DBA Interview Questions
Ans