If Several databases are up and running, which command will help to monitoring in os ?
Latest Answer: ps -ef|grep smon ...
Hello,I am Shubhangi and I want to know which are the institutes in Mumbai that offer good training for Oracle DBA course? and is it wise to go for a fast track course(20 days) rather than regular 3 months
Latest Answer: You must study the theory throughly. So you need this much time to study. Don't go for fast track courses. ...
Latest Answer: Sql>grant select_catalog_role to user;This is the Privilege to users to select the data dictionary. ...
Latest Answer: In 8i ' 5 ' & from 9i ' 10 ' archival destinations are allowed. ...
Latest Answer: Applications can create multiple databases with in a single file.This is useful when database are both numerous and reasonably small,in order to avoid creating a large number of underlying files.Putting multiple databases in a single physical file ...
Latest Answer: When we set to PARALLEL_ADAPTIVE_MULTI_USER=true, enables an adaptive algorithm designed to improve performance in multiuser environments that use parallel execution. The algorithm automatically reduces the request degree of parallelism based on the degree ...
Latest Answer: STANDBY_ARCHIVE_DEST is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database. ...
Latest Answer: Locally Managed Tablespaces Include the following Benefits:1.Free extents are managed in the Tablespace.2.Bitmap is used to record free extents.3.Each bit corresponds to a block or a group of block.4.Bit value indicates free or used. ...
Latest Answer: In adddition to the answers given earlier.In a technology like Orcale one should always remember there is nothing absolute everything is optimum.There is nothing actual advantage of using Locally Managed Tablespace over System Managed Tablespace. The ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>
Go Top
