-
How do you find wheather the instance was started with pfile or spfile
Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns NULL in the value column if you are using pfile and not spfile3) SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL; // if the count is non-zero then the instance is using a spfile, and if the count...
-
-
You have taken import of a table in a database. you have got the Integrity constraint violation error. How you are going to resolve it.
senthilora
- Sep 24th, 2007
Another suggestion could be: Find the Master Table(s) of the given table and export / import them all.
balakrishna
- May 28th, 2006
If u want to import the table just say constraints=n the movement table got imported then u create constriant on that tables.
-
What is ORA-1555?
senthilora
- Sep 24th, 2007
ORA-1555 error can occur in Oracle 10g also even with UNDO RETENTION GUARANTEE enabled. ORA-1555 happens, when Oracle server process could not find the block-image in UNDO tablespace for the read...
paparao
- Oct 23rd, 2006
This shanshot too old. -> problem occurs generally in 9i only. Whether in 10g, at the time of tablespace creation, retuntion guarentee is applied it automatically we can supress( by default i...
-
-
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...
-
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?
-
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.
-
Oracle Dead Locks
If dead lock happened for 2 applications at a time in a banking sector..how to resolve this issues without forcing any one of the application ..we should not have to stop the transaction...
Dharma Kotha
- Oct 10th, 2011
A deadlock occurs when data was locked simultaneously by two sessions(users) and waiting for data, this can be resolved by rollback statement.
dharma
- Aug 23rd, 2011
Dead Locks can be resolved by rollback statement.
-
-
What is a datafile
csanthoshreddy
- Mar 6th, 2012
Datafile is the physical storage location of the database.tablespace is logical.for creation of tablespace one or more datafiles needed.we can define the datafile location with the following parameter
db_create_file_destDharma Kotha
- Oct 10th, 2011
Datafiles are physical data location of oracle architecture. Table space contains no.of datafiles.
-
-
What does database do during mounting process?
midhunam
- Mar 7th, 2010
When the startup command enters the mount stage, it opens and reads the control file. The control file is a binary file that tracks important database information, such as the location of the databa...
cmanne
- Jan 4th, 2006
During database mount process, Oracle would check for the existence of controlfiles mentioned in init.ora file but it wont check the contents of the controlfile which is done during the opening of database.
-
How can you check which user has which Role.
-
What is the database holding Capacity of Oracle ?
paparao
- Oct 23rd, 2006
Exatly upto 512 peta bytes ( refer to Oracle Database Concenpts manual).
-
When a database is started, Which file is accessed first?
raghukiranreddy
- Aug 19th, 2008
you want to starting up a database by using STARTUP command....SQL>STARTUPto start instance, database must read the intialization parameter from either a server parameter file(SPFILE)or a trad...
-
Database Auto extend question
This is an Interview Question By BMC Software.. " while installing the Oracle 9i ( 9.2) version, automatically system takes the space of approximately 4 GB.. thats fine.... Now, if my database is growing up and it is reaching the 4GB of my database space...Now, i would like to extend my Database space to 20 GB or 25 GB... what are the things i have to do " Pls give me the accurate Solutions or alternates...
alex.v
- Jul 11th, 2008
Better make the autoextend off and add more datafiles to the tablespace. Making a single datafile to a bigger size is risky...By making autoextend off you can monitor the growth of the tablespace....schedule a growth monitoring script with a threshhold of 85 % full
-
How to find which tablespace belongs to which datafile ?
ravichandiran
- Nov 16th, 2007
run this query in the sql promptsql> select tablespace_name,file_name from dba_data_files;
-
Oracle Database Monitoring
If Several databases are up and running, which command will help to monitoring in os ?
-
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