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. ...
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, ...
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
When a user comes to you and asks that a particular SQL query is taking more time. How will you solve this?
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 ...
Latest Answer : Export is one of taking backup. In export backup you can specify many parameters in par file or at command line. One of the parameter is statistics=y or n. If you specify y it is going to export statistics generated in the database placed ...