 Related Questions A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in Latest Answer : Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them by rolling back ... You can query dba_data_files and dba_temp_files Latest Answer : select substr(to_char(sum(bytes)/1024/1024, '999,999,999.99'), 1, 15) "TOTALMB", substr(to_char(sum(bytes)/1024/1024/1024, '999,999.99'), 1, 11) "TOTALGB" from dba_data_files; ... query v$log Latest Answer : select sum(bytes)/1024/1024 size_in_mb from v$log; ... 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 : select * from v$parameter where name='spfile'; ... Latest Answer : 1. Check the oratab file to get the list of databases on a server.Caveat: If the database is created manually, then the oratab won't updated automatically which should be done manually as oratab is updated only when the database is created using DBCA.2. ... Read Answers (7) | Asked by : rajkumarl Latest Answer : 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,0,1,a.executions)) reads_per_execution, ... Read Answers (6) | Asked by : Hasan Latest Answer : question is not clear sturucture of database can be foud in dataflies redo log control 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 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 When a user comes to you and asks that a particular SQL query is taking more time. How will you solve this? Read Answers (2) | Asked by : anjibabu padala 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
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
