oracle 9i

Tags: ble learning entry Good type programming AMP data arc --20170322 --1.0 --Update the statistics of the tableBeginDbms_stats.set_table_stats (user, ' EMP ', numrows = 10000);EndBeginDbms_stats.set_table_stats (user, ' DEPT ', numrows = 10000);End--Re-view the statistics of the tableSelect T.table_name,t.num_rows,t.blocks from User_tables t where T.table_name in (' EMP ', ' DEPT ');/*DEPT 10000 100EMP 10000 100*/ --2.0 --View the number of blocks of data occupied by the index, cluster factor

Products: AIX, Oracle Platform: pseries, AIX Version: All Conflicts in memory access now when the process requests more memory than the total physical memory of the system, in order to handle this situation, the system swaps the program and the data between the memory and the hard disk. Control Memory Exchange operation (paging) A large number of memory exchange operations can greatly affect the performance of the system, especially when the data

) The SQL code to create the table space above is as follows.―――――――――――――――――――――――――――――――――――――CREATE tablespace "Temptablespace"LOGGINGDataFile ' C:\ORACLE\ORADATA\MYORACLE\TEMPTABLESPACE. ORA ' SIZE5M Reuse EXTENT MANAGEMENT Local―――――――――――――――――――――――――――――――――――――"See CD-ROM File": 11th Chapter \createtablespace.sql.Table Space Offline1. When do I need to take the table space offlineMake some databases unavailable and allow normal access to ot

Principles of Database Physics design 1.1 Database Environment Configuration principles 1.1.1 Operating System Environment: For small and medium-sized database system, the use of Linux operating system is more appropriate, for the database redundancy requirements of a higher load balancing system, you can use the Oracle9i RAC Cluster database method, cluster nodes in the range of 2-64. For large database systems, you can use the Sun Solaris SPARC 64-bit mini machine system or the HP 9000 Seri

Oracle 1.startup-Start the database 2.create temporary tablespace TEMP2 tempfile '/home2/oracle/oradata/sysmon/temp02.dbf ' SIZE 512M reuse autoextend on NEXT 640K MAXSIZE Unlimited; --Create transit temporary table space 3.alter database default temporary tablespace temp2; --Change the default temp table space to the new temporary table space just created TEMP2 4.drop tablespace temp including conten

The isql*plus structure is as follows: The configuration process is as follows: 1 Configuration httpd $ cd $ORACLE_HOME/Apache/Apache/conf $ vi httpd.conf 1.1 设定Server name或者Server IP地址和端口，使用非root用户启动HTTPD进程，其端口必须大于1024， 如： Listen=hpserv01:7777 1.2 设定DocumentRoot， 如DocumentRoot="/home/htdocs" 1.3 如果你也使用web server作为document content server，那么需要配置： IndexOptions NameWidth=* IndexOptions FoldersFirst AddIcon /icons/text.gif .txt .log 1.4 检查oracle_apache.conf文件 在httpd.conf的最后，iSQL*PLUS的配置文件包含在or

1. startup -- start the database2. Create temporary tablespace temp2 tempfile '/home2/Oracle/oradata/sysmon/temp02.dbf' size 512 M reuse autoextend on next 640 K maxsize unlimited; -- create temporary tablespace for transit3. Alter database default temporary tablespace temp2; -- change the default temporary tablespace to the newly created temporary tablespace temp24. Drop tablespace temp including contents and datafiles; -- delete the original tempora

When a table is accidentally deleted, hundreds of mb of data is lost? No. Now you don't have to worry about it. Oracle9i and above use a garbage collection solution, and it's easy to recover. No longer use precious time for database cloning/exp/imp as cumbersome methods: Select * from tab; TNAME TABTYPE CLUSTERID ----------------------------------------- T TABLE Now let's delete him (of course we are not careful) DropTableT DescT No view or table exists. FLASHBACKTABLETTOBEFOREDROP

and displayed in this view. However, a user can only accept the index usage in its own mode. Oracle does not provide a view to receive indexes in all modes. To use indexes in all modes, Log On As a sys user and run the following script. Note: This is not a script provided by Oracle. V $ all_object_usage is a custom view. It contains one more column, that is, the index owner ): $ cat all_ob

Your database may already have the Scott/tiger schema. Classic installation usually includes this mode, but does not require the database to have this component. The Scott example mode can be installed under any database account. Using the Scott account has no special significance. If you are happy, you can also install the EMP/DEPT table directly under your own database account. The following is the actual operation process. 1. Create a new user oracledba Sqlplus "sys/sys as sys

Oracle shutdown suddenly power off, resulting in the use of Sql/plus startup can not connect to the database, specifically described as: Connection can not be permitted, shut in progress. To the DOS prompt, type: C:\> Sqlplus/nolog Show: Sql/plus:realease9.0.2........all Rights reserved Sql> Connect/as SYSDBA Show connected to idle routines Sql>startup displays shutdown in progress. To the sqlplus inside connection: SYS/MANAGER@ORCL92 Displa

later patches are installed, you will almost never be able to use them normally. If you encounter a similar problem, please give back in time. Additional Notes: Let's take a look at the relevant OCCI content in make. bat under $ ORACLE_HOMEocisamples: : Occimakeobj Ott userid = scott/tiger intype = % 1.typ outtype = % 1out. type code = cpp hfile = % 1h. h cppfile = % 1o. cpp mapfile = % 1m. cpp attraccess = private Cl-GX-DWIN32COMMON-I. -I % ORACLE_HOME % ociinclude-I. -D_DLL-D_MT % 1.cpp % 1m.

Role of Audit1. Review suspicious activities2. monitor and collect data about specified database activitiesAudit type1. STATEMENT Audit statement auditing)2. Permission Audit privilege auditing)3. OBJECT audit object auditing)Audit informationThe audit information recorded in the AUD $ table includes.SESSIONID: The Number ID of the session.ENTRYID: the ID of the audit information item.STATEMENT: The Number ID of each executed command.TIMESTAP #: date and time when the design information is gener

Enable archive ModeSQL> shutdown immediate; SQL> startup Mount; SQL> alter system set log_archive_dest_1 = "location = D: \ oracle \ oradata \ archivelog" Scope = spfile; SQL> alter system set log_archive_start = true scope = spfile; Restart the database to make the preceding two parameters take effect. SQL> shutdown immediate; SQL> startup Mount; SQL> alter database archivelog; SQL> archive log start; SQL> archive log list; SQL> alter datab

SQL statements related to modifying the table structure in Oracle 9i1. Add a column:Alter table table name Add (column name data type );For example:Alter table emp add (weight number (38,0 )); 2. Modify the Data Type of a column (generally, the length is limited. There are many restrictions when you change it to a different type)Alter table table name modify (column name data type );For example:Alter table emp modify (weight number (3, 0) not null );

Export command: Exp Explain: Data export to use the EXP command, directly run cmd, enter the actual data can be. If the database is not a local database, use the Oracle Net Configuration Assistant to configure the local net service name. Import will be imported after export, and the imported commands are: IMP

The oracle| variable makes it easy to create a generic pin local purpose by replacing a variable, and look at the following code: INSERT into Employees (Emp_name, Emp_age, emp_dept) VALUES (' empname ', empage, empdept) Using the "" plus identifier to represent the substitution variable, note that if the data type of the column is a character or date type, enclose the substitution variable in single quotes. When executed, Isqlplus asks for three subst

The role of audit1. Review of suspicious activities2. Monitor and collect data about the specified database activityTypes of audits1. Statement Auditing (STATEMENT auditing)2. Authority Audit (Privilege auditing)3. Objects auditing (object auditing)Information on auditsThe audit information recorded in the Aud$ table includes.SESSIONID: The numeric ID of the session.ENTRYID: ID of the audit information item.STATEMENT: The numeric ID of each command executed.timestap#: Date and time when the desi

js|oracle| Paging Package com.cwbnig; Import java.sql.Connection; Import java.sql.SQLException; Import Javax.sql.DataSource; Import Javax.naming.Context; Import Javax.naming.InitialContext; Import javax.naming.NamingException; public class Databaseconn { Public Databaseconn () { } public static synchronized Connection getconnection () throws Exception { Connection conn = null; Try { Context Initctx=new InitialContext (); Context envctx= (Initctx.l

Oracle Operating Environment: Rs6000/aix 4.3.3/shell:korn (ksh)/virtual X-window Installation media: CD, a total of four, the file name is Aix64_901_disk (1-5). CPIO Installation mode: Hard disk installation mode Installation steps: 1. Pre-Installation Preparation work Create directory/oratmp, this directory to save installation files, to understand the pressure can be completed, this directory should have at least 3G Take the 5. cpio files in the bay