|
| 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 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 Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ... 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 ... Latest Answer : Additionally,PGA_Aggregate_target set when Work_area_policy is set to auto and FAST_START_MTTR_Target set may also affect d/b performance ... 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 andon 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 View Question | Asked by : Ibad Tags : Backup Hi, I've recently commissioned a hosted system from a developer who has recommended using J2EE and Oracle. Their J2EE system is quite slick and works very well in preproduction. It uses annotations Latest Answer : Changing VARCHAR2(255) to precise required width is good table design. Though it will not improve performance as such. ... My database size is 100GB. I am using compress parameter. Will my database size reduce, remain same, Increase. What will Happen. What will you do when the ASE server's performance is bad? How do you increase the performance of %LIKE operator? Latest Answer : 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 column. The other two %searchwordhere%, and %searchwordhere ... When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check? Latest Answer : Have a look into the following tables :DBA_HIST_SQLSTATdba_hist_snapshotby doing natural joins on these views for the SQL_ID, you will know about any plan changes happened. Do corrective actions as per the findings. ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
