ITPub博客

摘自orafaqThe Redo Logfile Size Advisor can be used to determine the least optimal online redo log file size based on the current FAST_START_MTTR_TARGET setting and MTTR statistics.Which means that Redo Logfile Size Advisor is enabled only if FAST_START_MTTR_TARGET is set. The Advisor provides a recommended optimal smallest online redo log file size.we can then adjust the online redo log file size to the recommended optimal size ,eliminating the need to manually determine an optimal size.To use

摘自OracleadviceYou can avoid having to use a TNSNAMES.ORA file by specifying the full connect string at the command prompt. The hostname is the only mandatory piece.sqlplus username/password@ [//] hostname [:port] [/service_name]Eg. sqlplus scott/tiger@moriarty:1521/ORCLSet up EZCONNECT in the sqlnet.ora file as follows:NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)[@more@]

摘自OracleadviceIn Oracle10g, fast_start_mttr_target behaves slightly differently. Specifying any non-zero valuewill tell Oracle to automatically tune checkpointing by optimizing the frequency of dirty bufferwrites. The default is to enable automatic checkpoint tuning. The only way to turn this off is toexplicitly set the parameter to 0.When Automatic Checkpoint Tuning has been disabled you can use the Redo Logfile Size Advisor to tunean optimal size for the online redo logs based on checkpointi

The SGA is read/write. All users connected to a multiple-process database instance can read information contained within the instance’s SGA, and several processes write to the SGA during execution of Oracle. The SGA contains the following data structures: ■ Database buffer cache■ Redo log buffer■ Shared pool■ Java pool■ Large pool (optional) ■ Streams pool■ Data dictionary cache ■ Other miscellaneous information Part of the SGA contains general information about the state of the databas

A system global area (SGA) is a group of shared memory structures that contain dataand control information for one Oracle database instance. If multiple users areconcurrently connected to the same instance, then the data in the instance’s SGA isshared among the users. Consequently, the SGA is sometimes called the shared globalarea.An SGA and Oracle processes constitute an Oracle instance. Oracle automaticallyallocates memory for an SGA when you start an instance, and the operating systemreclaim

Oracle uses memory to store information such as the following:■ Program code■ Information about a connected session, even if it is not currently active■ Information needed during program execution (for example, the current state of aquery from which rows are being fetched)■ Information that is shared and communicated among Oracle processes (forexample, locking information)■ Cached data that is also permanently stored on peripheral memory (for example,data blocks and redo log entries)The bas

B--BytesK--KilobytesM--MegabytesG--GigabytesT--TerabytesP--PetabytesE--Exabytes[@more@]

出错提示为 ：停止安装该组件/停止安装所有组件解决方法 ：在注册表中找到HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession ManagerPendingFileRenameOperations并删除它。这样就可以清除安装暂挂项目。 以前安装SQL Server2k的时候好像也是这么解决的.[@more@]

As with redo log files, Oracle enables multiple, identical control files to be open concurrently and written for the same database. By storing multiple control files for a single database on different disks, you can safeguard against a single point of failure with respect to control files. If a single disk that contained a control file crashes, then the current instance fails when Oracle attempts to access the damaged control file. However, when other copies of the current control file are avail

A control file contains information about the associated database that is required for access by an instance, both at startup and during normal operation. Control file information can be modified only by Oracle; no database administrator or user can edit a control file. Among other things, a control file contains information such as:1. The database name 2. The timestamp of database creation 3. The names and locations of associated datafiles and redo log files 4. Tablespace informatio

The database control file is a small binary file necessary for the database to start and operate successfully. A control file is updated continuously by Oracle during database use, so it must be available for writing whenever the database is open. If for some reason the control file is not accessible, then the database cannot function properly. Each control file is associated with only one Oracle database. 控制文件1. 二进制文件2. 在数据库使用时 ， 不停的被更新 ，不管数据库是否打开 ， 都必须

Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace. 1. A bigfile tablespace contains only one datafile or tempfile, which can contain up 32 to approximately 4 billion (2^32 ) blocks. The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks. 2. A smallfile tablespace is a traditional Oracle tablespace, which can contain 1022 datafiles or tempfiles, each of which can

You can take tablespaces offline or bring them online at any time, except for theSYSTEM tablespace. All of the datafiles of a tablespace are taken offline or broughtonline as a unit when you take the tablespace offline or bring it online, respectively.You can take individual datafiles offline. However, this is usually done only duringsome database recovery procedures.[@more@]

You can alter the size of a datafile after its creation or you can specify that a datafileshould dynamically grow as schema objects in the tablespace grow. This functionalityenables you to have fewer datafiles for each tablespace and can simplifyadministration of datafiles.Note: You need sufficient space on the operating system forexpansion.[@more@]

When a datafile is first created, the allocated disk space is formatted but does notcontain any user data. However, Oracle reserves the space to hold the data for futuresegments of the associated tablespace—it is used exclusively by Oracle. As the datagrows in a tablespace, Oracle uses the free space in the associated datafiles to allocateextents for the segment.The data associated with schema objects in a tablespace is physically stored in one ormore of the datafiles that constitute the tables

A tablespace in an Oracle database consists of one or more physical datafiles. Adatafile can be associated with only one tablespace and only one database.Oracle creates a datafile for a tablespace by allocating the specified amount of diskspace plus the overhead required for the file header. When a datafile is created, theoperating system under which Oracle runs is responsible for clearing old informationand authorizations from a file before allocating it to Oracle. If the file is large, thispro

To move or copy a set of tablespaces, you must make the tablespaces read only, copy the datafiles of these tablespaces, and use export/import to move the database information (metadata) stored in the data dictionary. Both the datafiles and the metadata export file must be copied to the target database. The transport of these files can be done using any facility for copying flat files, such as the operating system copying facility, ftp, or publishing on CDs. After copying the datafiles and import

A tablespace repository is a collection of tablespace sets. Tablespace repositories are built on file group repositories, but tablespace repositories only contain the files required to move or copy tablespaces between databases. Different tablespace sets may be stored in a tablespace repository, and different versions of a particular tablespace set also may be stored. A version of a tablespace set in a tablespace repository consists of the following files:■ The Data Pump export dump file for th

A transportable tablespace lets you move a subset of an Oracle database from one Oracle database to another, even across different platforms. You can clone a tablespace and plug it into another database, copying the tablespace between databases, or you can unplug a tablespace from one Oracle database and plug it into another Oracle database, moving the tablespace between databases. Moving data by transporting tablespaces can be orders of magnitude faster than either export/import or unload/load

One or more temporary tablespaces can be used only for sort segments. A temporary tablespace is not the same as a tablespace that a user designates for temporary segments, which can be any tablespace available to the user. No permanent schema objects can reside in a temporary tablespace. Sort segments are used when a segment is shared by multiple sort operations. One sort segment exists for every instance that performs a sort operation in a given tablespace.Temporary tablespaces provide performa