performance tuning in oracle 11g

performance sudo vi/etc/security/limits.confAdd the following code at the end (Colben is the user name, and you want to modify it to your current user name after copying)Colben Soft Nproc 2047Colben Hard Nproc 16384Colben Soft Nofile 1024Colben Hard Nofile 655367. Generally need to install the easy italicized word body, Baidu casually download a zysong.ttf, switch to Zysong.ttf where the path, run:sudo mkdir/usr/share/fonts/zh_cn/turetype/-Psudo mv z

The general process of using oracle 11g r2 LogMiner! Use the oracle log analysis tool LogMiner. set the date format to alter system set nls_date_format = 'yyyy-mm-dd hh24: mi: ss' scope = spfile; select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss ') from dual; 2. add supplemental logs if the DATABASE needs to use logminer, it should be added. Only after this LOG i

After half a month of configuration and learning about the physical standby database of Oracle replicaset uard, although the version uses Oracle 11g (11.2.0.3), the configuration process still applies to Oracle 10g. During the last 10 dataguard configurations, it was found that using rman duplicate to create a physical

Tags: reverse-occupied objects require function number maintenance RoCE timeAn index is an object provided by Oracle that provides a quick way to access the data, improving the retrieval performance of the database. The index allows the database program to not have a full table scan of the entire table, in which you can find the data you want, the directory of the book, you can quickly find the information

references to outdated backups from the warehouseDelete Obsolete--remove any unwanted backups from the disk or tape and remove the backup references from the warehouse.Catalog-The location of the user-managed backup is included in the warehouse. 2) Archive Backup: Backup XXX Keep {forever | until time xxxx} [restore point xxxx]-----The restore point xxxx is the name in the control file.V$archived_log still exists after the archive log is removed:Rman Target/Rman> crosscheck Archivelog All;rma

Windows Edition: Official website download, two compressed package, a total of 2G, extracted to the same folder, Setup.exe double-click to execute, waiting for the good, general performance of the machine about half an hour or so. After installation, edit the installation path (mine is D:\app\seven) \product\11.2.0\dbhome_1\network\admin inside the Tnsnames.ora and Listener.ora files in the " host = localhost "instead of" localhost= your computer nam

Oracle 11g is the latest database software launched, Oracle 11g has more than 400 functions, after 15 million hours of testing, development work volume reached 36,000 people/month, equivalent to 1000 employees for continuous research and development 3 years. Oracle

Due to a problem with the stability of Fedora 14 in my current version, I decided to change it to Ubuntu 10.10, just because I had used this version for a while and felt that it was superior in performance, stability is also good (for Linux, you can leave it alone ). Oracle 11g R2 is installed under Fedora 14, so the installation directory of the database system

V$parameter Record values for all items in the initialization parameter file V$lock Set all information for an object lock by accessing a database session V$session There's a conversation message. V$sql Log details of SQL statements V$sqltext Record statement information for an SQL statement V$bgprocess Show background process information V$process Information abo

Tags: managing coverage discussion file on disk non-archive 51cto generation methodThere are two ways to run an Oracle database: Archive (ARCHIVELOG) and non-archive (NO ARCHIVELOG). In non-archive mode, the log switch overwrites the previous redo log files directly and does not generate an archive log. The database runs under archive mode, and after the log switchover, the arch process archives The full redo log file, which, by default, runs in a non

Oracle RAC Listener configuration is the same as the single-instance configuration11g after installing the RAC process, do not need to execute NETCA to manually create the monitoring, when installing the cluster software, will automatically create a listener;The Tnsname.ora file is created automatically when the DBCA is built.Strongly recommend this article:Http://www.oracle.com/technetwork/cn/articles/database-pe