-
-
What is a private synonym
Dan
- Jul 9th, 2005
To create a private synonym in your own schema, you must have CREATE SYNONYM system privilege. To create a private synonym in another user's schema, you must have CREATE ANY SYNONYM system ...
-
What is a redo log
imran44
- Jul 10th, 2009
At the time of database creation 2 redo log files are created, these redo log files act in circular fashion, when log switch occur, redo log file will dump its contents in archived log destination, an...
nagabhushan reddy
- Feb 8th, 2006
Redo log file contains data which changes made to the database.it is used for recovery purpose.
-
What is a database instance and Explain
imran44
- Jul 10th, 2009
SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background pro...
cmanne
- Jan 4th, 2006
An Oracle instance is a combination of background processes and memory structures (SGA)
-
What is a Database instance ? Explain
A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The memory structure that are used to store most queried data from database. This helps up to improve database performance by decreasing the...
ranjanam
- Aug 26th, 2007
Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database.
satyam_Ora
- Aug 18th, 2007
A database instance also know as server is a set of memory structures and background processes that access a set of database files.It is possible for a single database to be accessed by multiple insta...
-
-
What is the difference between materialized view and snapshots
-
Version Upgrade
How would you plan for an Oracle upgrade? What are the prerequisites?
-
-
-
-
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 are the diffrent file types that are supported by SQL*Loader?
RASH
- Mar 24th, 2007
I'm sceptical about the .mdb.The simple, answer is Fixed width or Delimited TEXT files.
-
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...
-
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.
-
What is directory naming in oracle9i ?
pradeesh04
- Dec 7th, 2007
Oracle Net Services use a centralized directory server as one of the primary methods for storage of connect identifiers. Clients configured directory usage can use the connect identifiers in the...
-
What is the difference between Pctused and PctFree?
dinesh1909
- Nov 19th, 2007
Consider 8K block size. The total bytes 8 x 1024 = 8196 bytesEach block requires approximately 117 bytes for the header. Please note that the header size varies depending upon the block size. The tota...
C.Ramesh
- Nov 16th, 2007
PCT USERD - The Percentage of Minimum space user for insertion of New Row data. The value determines when the block gets into the FREELISTS structurePCTFREE - The Percentage of Space reserved for future updation of existing dataC.Ramesh
-
Physical and Logical Backup
What kind of backup you take Physical / Logical? Which one is better and Why?
mselva84
- Feb 22nd, 2010
Logical Backups: In this backup Oracle Export utility stores data in Binary file at OS level.Physical Backups: In this backup physically Datafiles are copied from one location to another( Disk, Tape etc.)
bishma
- Aug 30th, 2008
Logical backup means backing up the individual database objects such as tables, views , indexes.. using the utility called EXPORT, provided by Oracle. The objects exported in this way can be imported ...
-
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.
-
Oracle Datafiles limit
How do you control No. of Datafiles one can have in an Oracle Database.
olilogu
- May 11th, 2009
At creation time you can set up the maximun numer of datafiles.CREATE DATABASE .....MAXDATAFILES 500If you want to check it:select * from V$CONTROLFILE_RECORD_SECTION where type ='DATAFILE';If you want to increase it, you have to recreate control file.
Oracle DBA Interview Questions
Ans