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: Hi Shubhangi,You should go to any institute that is Oracle Education Partner. And duration is dependent of your grasping power. But 20 days are enough if you are going to learn Oracle (9i/10g) Funda 1 and SQL.Sandeep ...
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: Advantages in using Locally Managed Tablespaces:Because locally managed tablespaces do not record free space in data dictionary, it reduces contention on these tables. Local management of extents automatically tracks adjacent free space, eliminating the ...
View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Go Top