10g gbic

For some time did not engage in Oracle, recently to others in Win 7 under the Oracle 10g, special record memo.Using Http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip, Direct Thunder can be downloadedAfter decompression, change: \db\disk1\install the Oraparam.ini file, add the following (the red part is the added part):[Certified Versions]#You can customise error message shown for failure, provide value for Certified_version_fa

Tags: optimizer int ica parameter Viso mode recommend limited statThe SQL Access Advisor makes suggestions about indexes and materialized views which might improve system performance. This article describes how to use the SQL Access Advisor in Oracle 10g. Enterprise Manager Dbms_advisor Quick Tune Related views Related articles. SQL Access Advisor in Oracle Database 11g Release 1 Enterprise ManagerThe SQL Acc

Tags: style blog color using file data sp div problemThe backup file was exported from 11g with the exp command, and the above error occurred with IMP Import under 10g, in the case of a lower version of the backup that does not support a higher version, so the use of 11g test, or the above problem.In fact, the size of the table space is not enough, the following is the answer on the Internet:Table space is not sufficient first query MAXDATA tablespace

It is slow to add a NOT null field before 11g. It was soon after 11g. Let's do a test first and then explore the principles.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biPL/SQL Release 10.2.0.1.0-productionCORE 10.2.0.1.0 ProductionTNS for 64-bit windows:version 10.2.0.1.0-productionNlsrtl Version 10.2.0.1.0-productionsql> drop table test

Today, friends on the AIX 5.3 system installed Oracle 10g build database is used bare device, DBCA to 2% error exit, observe alert log discovery is the temp table space caused by insufficient space. View the tablespace data file with a bare device capacity of 512M, the data file size given when the database was built is also 512M. Perhaps because the AIX system is calculated in 1000, and the Oracle database compute capacity is a 1024-based gap, then t

Stratum 11Driftfile/var/lib/ntp/driftBroadcastdelay 0.008Edit the/etc/ntp.conf file from the node and edit the contents as follows:Server 192.168.11.12 prefer #注意192.168.11.12 the IP address of the primary nodeDriftfile/var/lib/ntp/driftBroadcastdelay 0.008After the configuration is complete, start the NTP service.[[email protected] ~]#/etc/init.d/ntpd start[Email protected] ~]# chkconfig–level 345 ntpd on(3) View performance (master-slave)[Email protected] ~]# ntpq-pRemote refID St T when poll

Tags: Hash CPU nbsp PRE Compute Oracle Bytes Info SELECT There are several scanning methods under Oracle 10g, note that the last scan method will not be partitioned when the columns of the partition are computed. This is the same as evaluating an indexed column, which results in an unusable index. --Scan individual partitions PARTITION RANGE single--Continuous scanning of multiple partitions PARTITION RANGE ITERATOR--Non-sequential scanning of multipl

Oracle 10G DBCA ORA-03113 ORA-27102Scenario Description:1. installation, when running Runinstaller, install software and no error;2.DBCA, run to 4%, error ORA-03113 ORA-27102;3. I started from ORA-03113 analysis, is the network problem, after taking manual build library, still error ORA-03113.Problem solving:1. Check the $oracle_home/cfgtoollogs/dbca/trace.log, and no obvious error;2. Check the/etc/sysctl.conf file under Linux, found that the Kern

Label:1. Under WinXP, install 10g, default selection, all the way OK. (Pre-install self-test with DHCP warning, can be ignored directly) 2. Command line, under XP, enter Sqlplus, you can start, login with Sqlplus/as sysdba with admin login 3. When restoring Oracle, first establish the tablespace, build the user, and grant the user authorization and unlock in Sqlplus. ----Create a table space Create Tablespace jbpmLoggingDataFile ' D:\oracle\product\10

Tags: WinForm style blog http color fileOriginal address: http://www.cnblogs.com/alxc/archive/2011/03/25/1995279.htmlBecause like new things, so basically computer development tools are the latest, Oracle also installed 11g R2, but colleague classmate is not 11g R1 is 10G, from here I exported the DMP file in their direction in, all show:IMP-00010: Not a valid export file, header validation failedFor this problem has been distressed, almost want to un

When Oracle database is created, a series of default user and table spaces are created User name/password for Oracle 10g default installation Username Password Description See Also Ctxsys Ctxsys The Oracle Text account Oracle Text Reference Dbsnmp Dbsnmp The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the

Tags: style color io strong data for AR CTIAdding a NOT null field before 11g is very slow, very fast after 11g, let's do a test first and then explore the principle.Sql> select * from V$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-64biPL/SQL Release 10.2.0.1.0-productionCORE 10.2.0.1.0 ProductionTNS for 64-bit windows:version 10.2.0.1.0-productionNlsrtl Version

Tags:/etc/rc.d/rc.local oracle 10g self-bootingEnvironment: Redhat 5.9 64-bit, Oracle 10g1.To modify the Dbstart script:$ VI $ORACLE _home/bin/dbstart#ORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleoracle_home_listner= $ORACLE _home2.Modify the/etc/oratab to the following format:$ vi/etc/oratabSID: $ORACLE _home:yNote: The above SID and $oracle_home are replaced with real content, for example:Orcl:/data/oracle/product/10.2:y3.modifying/etc/rc.d/rc.local

This article will detail the Oracle 10g OEM general error -------Unknown host specified workaround, you need to know the friend can refer to the following refer to the detailed source: http://www.jb51.net/article/32135.htmReinstall the Oracleon the notebook,after the installation is complete, the OEM console can be used , but log off after logging back or restart the system after logging in, or the notebook using the network environment has cha

This article is only used for learning communication, commercial use, please support the genuine! Reprint Please specify: http://www.cnblogs.com/mxbs/p/6217052.htmlPreparation: Oracle 10g for Win (32-bit), System environment Win7 32-bitInstallation:Right-click setup.exe and select "Run as Administrator (A)" To see the prompt version failed,A minor modification is required to install it at this time. Right-click Setup.exe, select "Properties (R)", sele

Execution:Results of SQL3 Execution:From the above, the fastest sql2 executed by SQL1 is the slowestThe above is from the case of small watch and then look at the following statement (check the case of large tables):1Select a.* from iodso.qos_hisentry_sheet_td a where a.arch_time between trunc (sysdate-1, ' DD ') and trunc (sysdat E, ' DD ') and sheet_no in (select Sheet_no from Iodso.qos_hisentry_sheet_jtext_td t);2Select A.* from (SELECT * from iodso.qos_his

Core Home-> Oracle-> Oracle 10g Release 1 (10.1.0.2) on Fedora core 1 Oracle Database 10g Release 1 (10.1.0.2) installation on Fedora core 1 Please note that Oracle Database 10g are not certified to run on Fedora Linux, therefore your should not use this Combinatio N on a production server. can examine Oracle certification matrix at Metalink Contents 1. Downloadi

Redhat Linux AS4 install Oracle 10g (10.2) 1. Hardware requirements (1) memory> 1024 MB Memory swap Partition > 1024 MB 2 times memory > 8192 MB 0.75 times memory Display memory commands 2)/tmp> 400 M 3) detection command Memory # Grep MemTotal/proc/meminfo Swap Partition # Grep SwapTotal/proc/meminfo /Tmp Partition # Df-k/tmp Cpu Information # Grep "model name"/proc/cpuinfo 2. software requirements 1) Operating System Red Hat Enterprise Linux AS/E

Install Oracle 10g graphic tutorial in redhat 4, -- Note: This article only installs Oracle and does not create a database. I. Install a readhat4 System in the Virtual Machine Ii. IP Address Allocation The configured IP address is as follows: 3. create user groups and users Note: oracle users should have the same uid. Groupadd-g200oinstall Groupadd-g201dba Useradd-u200-goinstall-Gdbaoracle Passwdoracle 4. Create a directory Modify the file owner -- C

whether the deletion is successful; SQL>selectnamefromv$tablespace; NAME ------------------------------ ....... UNDOTBS2 12rowsselected. 13. Update pfile SQL>createpfilefromspfile; Filecreated. 14. The data file in the volume except the original UNDO tablespace is named as the result of execution in the step. #rm$ORACLE_BASE/oradata/$ORACLE_SID/undotbs01.dbf The solution to the insufficient disk space caused by the large Oracle