How to check whether database whether it is opened by pfile/spfile.
Latest Answer: Another alternative: SHOW PARAMETER SPFILE; ...
Explain the differences between 9i OEM & 10G OEM along with new features that changes the way you do your daily job
Db_buffercache : How we will tune it.
I have to check used space/unused space in table space. Which view /command will provide me the desired answer.
Latest Answer: dba_free_spaces and dba_segments ...
How the data is processed in DB Buffer Cache.
What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)
How to create User in Oracle, allocate quota on Oracle table space
Latest Answer: SQL> create user test identified by test default tablespace XYZ quota unlimited on XYZ1 quota unlimited on XYZ2 quota unlimited on XYZ3 quota unlimited on XYZ4;User ...
Can you use Backsets created by RMAN with any other utility
Latest Answer: We need to put the tablespaces in backup mode during hot backup so that writing to datafiles related to this tablespace would stop and be written in the archive logs instead during the period of the backup. If you will not put the tablespaces in backup ...
Can you take online backup of a Control File If yes, How?
Latest Answer: Yes you could take a online backup of a control file. SQL> alter database backup controlfile to trace;This will create a text copy of your controlfile. You could use this text file to recreate your controlfile. ...
View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>
Go Top
