Software and Database's Articles/Information/Jobs & Links

List of Patchset number in metalink

2010-01-08T01:20:00.000-08:00

You want to download patchset from metalink but you don't know the patchset number. In that case it may take some moments to find patchset number. For example you want to upgrade your database version from 10.2.0.1 to 10.2.0.2. Now which patchset number you want to download? In this post the patchset number along with oracle version is below. A)For Oracle9iR2, Base version 9.2.0.1 i)To upgrade

A Data Guard Configuration Using ORACLE

2009-06-22T01:00:00.000-07:00

1) Ensure the Primary database is in ARCHIVELOG mode: SQL> archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination /export/home/oracle/temp/oracle/arch Oldest online log sequence 7 Current log sequence 9 SQL> alter database close; Database altered. SQL> alter database archivelog; Database

2008-07-22T00:12:00.000-07:00

Archive vs NOarchive log mode A production database's likelihood to lose data is greater in noarchive mode, although archive log mode is not a practical choice for all databases" and it has greater hardware requirements and therefore greater cost due to the cost for log storage. A standby database environment requires archive log mode. Noarchive log mode If the database is in

SGA STATISTICS

2007-10-10T21:47:00.000-07:00

set serveroutput onDECLARE libcac number(10,2); rowcac number(10,2); bufcac number(10,2); redlog number(10,2); spsize number; blkbuf number; logbuf number;BEGINselect value into redlog from v$sysstatwhere name = 'redo log space requests';select 100*(sum(pins)-sum(reloads))/sum(pins) into libcac from v$librarycache;select 100*(sum(gets)-sum(getmisses))/sum(gets)

Manually Database Creation

2007-10-05T02:56:00.000-07:00

Based On Windows Enviourments----------------------------------------Follow below procedure.-----------------------------1. Create Script for database creation through "DBCA".( database configuration assistant)start>run>dbcaorstart>program>oracle_home>configuration_and_migration>DATABASE CONFIGURATION ASSISTANT2. In DBCA ( windows) select "custom" option in template. ( no datafiles option)then

Oracle Cluster File System And Asynchronous I/O

2007-03-05T03:39:00.000-08:00

A cluster file system allows the nodes in a cluster to concurrently access a given file system. Each node accesses the same set of files and data. The cluster file system eliminates the requirement for Oracle database files to be linked to logical drives. OCFS volumes can span one shared disk or multiple shared disks for redundancy and performance enhancements. OCFS is designed to provide an

Sort Operations and Undo Segments

2007-03-05T03:35:00.000-08:00

One situation where a sort operation may occur is when data selected by a SQL statement is ordered by a column or multiple column values. The server will attempt to perform the sort in memory if possible. What init.ora parameter determines the amount of memory that a server process should use for a sort process?A. SORT_AREA_SIZEB. SORT_AREA_RETAINED_SIZEC. SORT_MEMORYD. SORT_DISK The correct

Diagnostic and Tuning Tools

2007-03-05T03:19:00.000-08:00

A key component of effective performance tuning is an established baseline against which to measure diagnostic and tuning results. A DBA can establish a performance baseline by collecting statistics during periods that are representative of database operations across various load situations. Once this baseline is established, a DBA can determine if something indicates a performance problem or is

RMAN Utility

2007-03-05T03:12:00.000-08:00

The Recovery Manager (RMAN) utility was introduced in Oracle8, and its functionality and ease of use have increased significantly between Oracle8, Oracle8i, and Oracle9i. RMAN provides functionality that allows a DBA to perform database backups, restores, and recovery operations. A DBA can store frequently used scripts and also access RMAN's reporting functionality to report on a variety of

NOARCHIVELOG and ARCHIVELOG Modes

2007-03-05T02:59:00.000-08:00

Mission-critical databases require complete data recovery in the event of the loss of datafiles. By default, a database is created in NOARCHIVELOG mode. In NOARCHIVELOG mode, once a redo log group is reused, a DBA is unable to use that log group to roll the database forward to perform a complete recovery from a previous database backup. A DBA can also configure the database environment for

Oracle Net Services

2007-03-05T02:52:00.000-08:00

In an Oracle database environment, Oracle Net Services is responsible for establishing and maintaining the connection between the client running an application and the database. When a client makes a request such as a SELECT statement, Oracle Net Services passes this request from the client to the database and then sends the result set back to the client. Connections between clients and databases

Managing Tablespaces

2007-03-05T02:50:00.000-08:00

Oracle9i Database supports multiple types of tablespaces. The advantage is that a DBA can configure the database with different types of tablespaces to improve sort operations, backup and recovery, and separate segments such as tables and indexes to account for different access methods and data management. At a high level, a tablespace can be categorized as either a SYSTEM or non-SYSTEM

Redo Log Files

2007-03-05T02:45:00.000-08:00

Two of the most important tasks an Oracle9i DBA must perform are to maintain database availability and prevent the loss of data in the event of a database failure. Redo log files are a critical Oracle9i Database structure that ensures a DBA can successfully perform these tasks. Oracle9i Database functionality has enhanced the manageability of redo log files and the operations that affect them.

Oracle Managed Files (OMF)

2007-03-05T02:41:00.000-08:00

The primary advantage to using OMF in Oracle9i is that you do not have to directly manage files within an Oracle database. Test your knowledge of OMF by answering the following example question: Oracle Managed Files are established by setting what two of the following parameters?A. DB_CREATE_FILE_DESTB. DB_FILE_NAME_CONVERTC. DB_FILESD. DB_CREATE_ONLINE_LOG_DEST_NThe correct answers are A and

System Global Area (SGA)

2007-03-05T02:13:00.000-08:00

Oracle9i Database is rich in features, functionality, and advanced technology. One of the most significant features of the Oracle9i Database architecture is dynamic system global area (SGA). Prior to Oracle9i Database, the SGA was static, with the size fixed at instance startup and determined most by the parameters DB_BLOCK_SIZE, DB_BLOCK_BUFFERS, SHARED_POOL_SIZE, and if set, LARGE_POOL_SIZE.

CD- KEYS

2007-03-01T21:42:00.000-08:00

WINXP-SP2 = H7C97-C67JB-G6RQR-P6H2Y-TMQ6WWIN2003 (3 IN 1) = JB88F-WT2Q3-DRXTT-Y8GHG-7YYQYWIN-2003 = JQCYB-2KG36-Q8JM6-X69CY-KF8YB- OFFICEXP = FM9FY-TMF7Q-KCKCT-V9T29-TBBBGWIN2000-PROF = DDTPV-TXMX7-BBGJ9-WGY8K-B9GHMWIN2000-SERVER 1. ETRUST-ANTIVIRUS- RWLTY-ECRXL-XKCXH-RKGRI2. PH7MD-JQCW4-VM2VG-BWXXJ-9BKRMWindows 2000 Advance Server : • KRJQ8-RQ822-YRMXF-6TTXC-HD2VMXP-MEDIA CENTER =

DBCC INDEXDEFRAG

2007-02-06T04:26:00.000-08:00

DBCC INDEXDEFRAG can defragment clustered and nonclustered indexes on tables and views. DBCC INDEXDEFRAG defragments the leaf level of an index so that the physical order of the pages matches the left-to-right logical order of the leaf nodes, thus improving index-scanning performance. DBCC INDEXDEFRAG also compacts the pages of an index, taking into account the FILLFACTOR specified when the index

Temporary Tables

2007-01-22T05:21:00.000-08:00

A temporary table is a special kind of a table that differs in two ways from base tables:Each temporary table is implicitly dropped by the system.Each temporary table is stored in the tempdb system database.Temporary tables can be local or global. Local temporary tables are removed at the end of the current session. They are specified with the prefix #—for example, #table_name. Global temporary

DateTime Related Queries

2007-01-22T05:15:00.000-08:00

SELECT CAST(CAST('1900-01-04 12:00' AS datetime) AS float)SELECT CAST(CAST('1900-01-04 08:00' AS datetime) AS float)SELECT CAST(3.3333333 AS datetime), CAST(3.3333334 AS datetime)SELECT * FROM DateSampleWHERE DateVal BETWEEN '2002-02-28' AND '2002-02-28 23:59:59.997'SELECT * FROM DateSampleWHERE DateVal >= '2002-02-28' AND DateVal < '2002-02-29'SELECT * FROM DateSampleWHERE CAST(FLOOR(CAST(

Oracle and Sql Server DBA: Locking Issue

2007-01-16T03:08:00.000-08:00

Oracle and Sql Server DBA: Locking Issue

Locking Issue

2007-01-15T02:17:00.000-08:00

X= ExclusiveRx=ROW ExclusiveRs= ROW sharedSRx= Shared Row ExclusiveS= Shared

Disk Mirroring and Duplexing

2007-01-08T01:26:00.000-08:00

DISK MIRRORINGDisk mirroring protects against media failure by maintaining a fully redundant copy of a partition on another disk. This provides protection from the downtime and expense involved in recovering lost data and restoring data from a backup storage facility. In a sense, mirroring is continual backup. Mirroring also provides some performance benefits when reading data from disks under

Replication

2007-01-04T05:17:00.000-08:00

Replication is the process of copying and maintaining database objects in multiple databases that make up a distributed database system. Changes applied at one site are captured and stored locally before being forwarded and applied at each of the remote locations. In addition to providing users with fast, local access to shared data, applications enjoy increased availability because alternate

Cheers 2OO7

2007-01-04T05:14:00.000-08:00

Online Data Evolution

2007-01-02T04:23:00.000-08:00

Online Data EvolutionOracle9i provides a powerful online reorganization and redefinition architecture.Administrators can perform a variety of online operations to table definitions, including online reorganization of tables and indexes. Essentially, Oracle9i allows an online “create table as select” operation. These operations can execute without taking the underlying data object out of service.