Latest Answer: An Extent is a set of contignous data blocks obtain in a single allocation and used to store specific type of information. ...
Latest Answer: 1. set SHARED_SERVERS=(more than 1) in init.ora2. make changes in tnsnames.ora file to get the connection with DISPATHERS rather than dedicated servers ...
Latest Answer: Components of Physical database are:-1. Datafile - One or more2. Redo log file - Two or more3. Control File - Two or more ...
Latest Answer: Oracle logical structure follows the order likeTablespaceSegments
ExtentsDatablocksOracle database consists of tablesapces (one or more tablespace forms database)
Segments is the area in which on oracle object sores in a tablespace.One Oracle object ...
Latest Answer: data segmentundo segmenttemperory segmentIndex segments ...
Latest Answer: DBMS_METADATADBMS_STATSDBMS_SUPPORTDBMS_SESSION ...
query v$log
Latest Answer: select sum(bytes)/1024/1024 size_in_mb from v$log; ...
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; ...
Latest Answer: SELECT A.ROLE,A.PRIVILEGEFROM ROLE_SYS_PRIVS A,DBA_ROLE_PRIVS BWHERE A.ROLE=B.GRANTED_ROLE ANDB.GRANTEE='SCOTT'UNIONSELECT null role, A.PRIVILEGEFROM dba_sys_privs aWHERE a.grantee = 'SCOTT' ...
Latest Answer: Answer:
Yes, We can start a database without spfile. It is not necessary that the
database should be open with spfile. If init.ora file is there, then you
can open the database. Then later you can create a spfile from pfile.
Mohammed ...
View page << Previous 11 12 13 14 [15] 16 17 18 19 20 Next >>
Go Top
