|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen Latest Answer : Oracle automatically detect deadlock , but not occar ... This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex 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 Latest Answer : Go to OEM => Databases => ... => Instance => Configuration, in "Database and Instance Information" section, the last row shows spfile ... 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 Latest Answer : 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 ... Read Answers (2) | Asked by : prasad Latest Answer : 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 their connect string. The directory server resolves the ... Read Answers (2) | Asked by : anshuman sharma 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? Latest Answer : .bash_profile has to set at OS level before connecting to oracle database. ... Latest Answer : Type the following command in the shell promptTo force killkill -9 for normal killkill ... As a Oracle DBA what are all the UNIX file you should be familar with?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
