-
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.
-
What is row chaining
deepikadba
- Jun 7th, 2008
If a datablock is not able to store a complete row due to its less size then a row is store in another blocks & address of that row is stored in the previous block.it degrade performance of a database & there r more IOS generated.
sandhya
- Jun 27th, 2005
If any of he empty row is not sufficient to hold the row. then row is placed in multiple blocks. it happenes when the block size is small and rows are of large size. then it cause chaining. Due to chaining performance degrades and will cause more IOs
-
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...
-
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.
-
How to know which query is taking long time?
pabroy
- May 5th, 2008
You can search Top ten sql.Top 10 Sql. SELECT *FROM (SELECT rownum,Substr(a.sql_text,1,200) sql_text, Trunc(a.disk_reads/Decode(a.executions,...
senthilora
- Sep 24th, 2007
You can use STATSPACK to take SNAPs while running those queries and get the report with details of SQLs taking more time to respond.
-
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...
-
Disk (sort) Ratio
The ratio of disk (sort) is high. Is that good or bad? Why? How will you reduce disk sort?
rajendra_thanekar
- Apr 17th, 2008
Hi,Disk(sort)ratio is high is not good.Please set sort_area_retained_size and sort_area_size so that session can sort in max in memory.
-
Determine Number of Blocks Corrupted
You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted?
kunal1017
- Apr 1st, 2008
you can use the DBVERIFY utility to check the corruption in datafiles so that you can now number of blocks corrupted.Here is the procedure :On o/s prompt login as oracle user : $ dbv file= &...
hemant.agarwal03
- Mar 12th, 2008
You can check the "V_$DATABASE_BLOCK_CORRUPTION" view to determine the corrupted blocks.
-
Difference between failover and switch over servers
kailasTile
- Mar 27th, 2008
Failover: Primary fails and standby is made primary.Switchover: Primary and secondary interchanges the role.Effectively, in both cases, standby becomes primary, main difference is, when failover happe...
-
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) ...
-
Compression Parameter
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
hemant.agarwal03
- Mar 18th, 2008
COMPRESSION =(METADATA_ONLY | NONE) - This parameter applies from Oracle 10.2. It specifies whether to compress metadata before writing to the dump file set. Compression reduces the amount of disk spa...
-
Datafile Size
What is your datafile size? How long it can go? What is the max limit to which you can extend?
hemant.agarwal03
- Mar 18th, 2008
v$datafile data dictionary view will tell us the size of a datafile.to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.you can also resize the datafile size.
-
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...
-
DBMS_meta_data Parameter
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
hemant.agarwal03
- Mar 12th, 2008
To find the structure of a external table we used this package.syntax is below:SELECT DBMS_METADATA.GET_DDL ('TABLE','<Table Name in CAPS>')||';' FROM DUAL
-
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...
-
Cache Fusion Technology
What is Cache Fusion Technology?
bhuvannpg
- Feb 28th, 2008
Cache Fusion is a new technology that uses a high speed interprocess communication (IPC) interconnect to provide cache to cache transfers of data blocks between instances in a cluster. This eliminates...
-
How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?
mhans
- Feb 25th, 2008
1. Always you should have one more user activated as SYSDBA and this is achieved by using orapw utility2. If there is just one SYS user then on unix platform, login as ORACLE user (DBA group)3. sqlplus '/ as sysdba'alter user sys identified by 'xyz' ;This would change SYS pwd
senthilora
- Sep 24th, 2007
I think there are 2 ways to do that.1. Login as SYSTEM and change the SYS password by using ALTER USER.2. Recreate the password file using orapwd and set remote_password_file=exclusive and then restart the instance.
-
Explain about Oracle Statistics parameter in export?
ramanava1
- Feb 22nd, 2008
Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed in dump file.
-
Installing Oracle9i/10g at unix (RedHat) environment
While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time?
skpanuganti
- Feb 8th, 2008
.bash_profile has to set at OS level before connecting to oracle database.
-
What is the difference between materialized view and snapshots
Oracle DBA Interview Questions
Ans