04 2013 档案
摘要:查看SGA参数信息SQL> show sga;Total System Global Area 3256942592 bytesFixed Size 2217752 bytesVariable Size 1795164392 bytesDatabase Buffers 1442840576 bytesRedo Buffers 16719872 bytesSQL> show parameter SGA_MAXNAME TYPE ...
阅读全文
摘要:ObjectivesInstall perfastat schemaperfstat->performance statisticscaptrure snapshotsReportConfigure parametersMaintenance<<参考文档:$ORACLE_HOME/rdbms/admin/spdoc.txt>>Install perfstat schemaPrepair tablespace不能放在system、undo、user、temporatory tablespace里面Execute spcreate.sqlcreate tablespa
阅读全文
摘要:Settting Up Your EnviromentSetting up the SCOTT/TIGER SchemaExecuting the ScriptCreating the Schema without the ScriptSetting Your EnvironmentSetting up Autotrace in SQL*PlusInitial Setupcd [ORACLE_HOME]/rdbms/adminlog into SQL*Plus as SYSTEMrun @utlxplanrun CREATE PUBLIC SYNONYM PLAN_TABLE FOR PLAN
阅读全文
摘要:Compoments of a PL/SQL PackagePackage Specification是必须要有的,Package body是可以没有的(bodyless);但是如果你在package specification中声明了cursor,subprogram等,那么就必须要有package body,来实现上面的cursor、subprogram声明.Internal and External Visibility of a Package`s ComponentsDeveloping PL/SQL Packages:OverviewCreating the Package Spe
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the followingDescribe packages and list their componentsCreate a package to group together related variables,cursors,constants,exceptions,procedures,and fuctions.Designate a package construct as either public or privateInvoke a package
阅读全文
摘要:Course ObjectivesAfter completing this course,you should be able to do the following:Create,execute,and maintain-Package constructs-Database triggersManage PL/SQL subprograms and triggersUse a subset of Oracle-supplied packages to generate screen and file outputIdentify various techniques that impac
阅读全文
摘要:1、不与Linux交互,直接添加用户密码View Code [root@DG1 shell]# useradd user01[root@DG1 shell]# echo 123456 | /usr/bin/passwd --stdin user01更改用户 user01 的密码 。passwd: 所有的身份验证令牌已经成功更新。2、批量添加、删除用户脚本批量添加#!bin/sh# Author:ArcerZhang <E-mail:arcerzhang@163.com># The script to add user# /etc/passwd infoecho "plea
阅读全文
摘要:方法一、使用命令ntpdate time-a.nist.gov方法二、本地安装ntpdate客户端在本地安装ntpdate客户端,更新时用ntpdate cn.pool.ntp.org如果你的机子不支持域名,则可以用 ping cn.pool.ntp.org 得到该域名的IP地址。然后用 ntpda...
阅读全文
摘要:课程大纲Shell编程语法Shell编程调试Shell编程实例
阅读全文
摘要:Autonomous TransactionsAutonomous Transaction(AT),通过PRAGMA AUTONOMOUS_TRANSACTION;指明当前的事务操作只针对自身有效,不涉及到其他事务.Trapping User-Defined ExceptionsExamples:User-Defined ExceptionDECLARE v_deptno NUMBER := 500; v_name VARCHAR2(20) := 'Testing'; e_invalid_department EXCEPTION;BEGIN ...
阅读全文
摘要:Exception TypesPredefined Oracle Server --Implicitly raisedNon-predefined Oracle Server --Implicitly raisedUser-defined --Explicitly raisedSyntax to Trap ExceptionsSyntaxEXCEPTION WHEN exception1 [OR exception2...] THEN statement1; statemen...
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Define PL/SQL execeptionsRecognize unhandled exceptionsList and use different types of PL/SQL execption handlersTrap unanticipated errors.Describe the effect of exception propagation in nested blocksCustomize PL/SQL except
阅读全文
摘要:AgendaAfter completing this training,you should be able to do the following:How to install OpenSSQLThe basic of encryption/decryptionIntroduction of SSLHow to configure Apache with SSL.Configuration of CA on server side and client side.SSL attack and common implementaion mistakes.Lab EnvironmentInst
阅读全文
摘要:FOR Loops RulesReference the counter only within the loop;it is undefined outside the loop.Do not reference the counter as the target of an assignment.Neither loop bound should be NULL.Use the REVERSE keyword to force the loop to decrement from the upper bound to the lower bound.You must still make
阅读全文
摘要:Logic TablesBuild a simple Boolean condition with a comparision operator.ANDTRUEFALSENULLTRUETRUEFALSENULLFALSEFALSEFALSEFALSENULLNULLFALSENULL ORTRUEFALSENULLTRUETRUETRUETRUEFALSETRUEFALSENULLNULLTRUENULLNULLNOTTRUEFALSEFALSETRUENULLNULLBoolean Expression or Logincal ExpressionWhat is the valu...
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Identify the uses and types of control structuresConstruct an IF statementUse CASE statements and CASE expressionsConstruct and identify loop statementsUse guidelines when using conditional control structuresPL/SQL中,要区分sta
阅读全文
摘要:1、在一个pl/sql block中,可以有多个transaction,一个transaction可以跨越多个PL/SQL block;PL/SQL块执行完成,但是事务没有提交SQL> begin 2 insert into tt values(1); 3 end; 4 /PL/SQL procedure successfully completed.SQL> select * from tt; ID---------- 0 1验证事务没有提交方法SQL> select addr from v$transaction;ADDR-----...
阅读全文
摘要:当磁盘大小超过标准时会有报警提示,这时如果掌握df和du命令是非常明智的选择。 df可以查看一级文件夹大小、使用比例、档案系统及其挂入点,但对文件却无能为力。 du可以查看文件及文件夹的大小。 两者配合使用,非常有效。比如用df查看哪个一级目录过大,然后用df查看文件夹或文件的大小,如此便可迅速确定症结。 下面分别简要介绍df命令可以显示目前所有文件系统的可用空间及使用情形,请看下列这个例子:View Code [oracle@arcerzhang DATACENTER]$ df -hFilesystem Size Used Avail Use% Mounted on/...
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be table to do the following:Determine the SQL statements that can be directly included in a PL/SQL executeable block.Manipulate data with DML statements in PL/SQLUse transaction control statements in PL/SQLMake use of the INTO clause to hold the val
阅读全文
摘要:Nested Tables[表中有表]关联数组,是用在PL/SQL中的一种普通数据类型,无法存储在数据库中;嵌套表既可以在PL/SQL中使用,也可以存储在数据库中.VARRAY可变数组,既可以在PL/SQL中使用,也可以存储在数据库中.Summary of Collection TypesQuizIdentify situations in which you can use the %ROWTYPE attribute.When you are not sure about the structure of the underlying database table.When you wan
阅读全文
摘要:DECLARE SUBTYPE location_t IS VARCHAR2(64); TYPE population_type IS TABLE OF NUMBER INDEX BY location_t; l_country_population population_type; l_count PLS_INTEGER; l_location location_t;BEGIN l_country_population('Greenland') := 100000; l_country_popu...
阅读全文
摘要:Associative Arrays(INDEX BY Tables)An associative array is a PL/SQL collection with two columns:Primary Key of integer or string data type(主键可以使整型值,可以使字符串值)Column of scalar or record data typeIOT表表示存储在数据库中的一种数据类型.INDEX BY Table只能用在PL/SQL中,不能存储在数据库中.Associative Array StructureThe Order of Associative
阅读全文
摘要:The PL/SQL Text Book《Oracle PL/SQL Programming》Anchored DeclarationsWhen you anchor a datatype,you tell PL/SQL to set the datatype of your variable based on the datatype of an already defined data structure-another PL/SQL variable,a predefined TYPE or SUBTYPE,a database table,or a specific column in
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Describe PL/SQL collections and recordsCreate user-defined PL/SQL recordsCreate a PL/SQL record with the %ROWTYPE attributeCreate associative arraysOracle数据库中,复合数据类型包含:集合(collections)、记录(records)Oracle数据库中,集合的类型:(关联数组、嵌套表、
阅读全文
摘要:1、FOR循环下,不需要显示关闭游标DECLARE CURSOR c_emp_cursor ( deptno NUMBER ) IS SELECT employee_id,last_name FROM employees WHERE department_id = deptno; r c_emp_cursor%ROWTYPE;BEGIN FOR i IN c_emp_cursor(10) LOOP DBMS_...
阅读全文
摘要:Cursor For LoopsSyntax:FOR record_name IN cursor_name LOOP statement1; statement2; ... END LOOP;The cursor FOR loop is a shortcut to process explict cursors.Implict open,fetch,exit and close cursor.The record isimplicit declared.Example:DECLARE CURSOR c_emp_curs...
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Distinguish between implict and explicit cursorsDiscuss the reasons for using explicti cursorsDeclare and control explicit cursorsUse simple loops and cursor FOR loops to fetch dataDeclare and use cursors with parametersLo
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to to do the following:Differentate between a procedure and a functionDescribe the uses of functionsCreate stored functionsInvoke a functionRemove a functionLesson AgendaWorking with functions:-Defferentiating between a procedure and a functi
阅读全文
摘要:ORA-00257: archiver error. Connect internal only, until freed.Oracle 10g数据库物理空间管理方式与以前Oracle发生了变化,对归档日志所在的Flash_Recovery_Area空间进行了另外限制 Flash_Recovery_Area空间缺省安装时比较小,只有2GB,容易用完解决过程 根据数据库目前可用存储空间情况、FLASH_RECOVERY_AREA空间为2GB的实际情况,把FLASH_RECOVERY_AREA的空间修改为20GB()。 SQL> alter system set DB_RECOVERY_FI
阅读全文
摘要:Exceptions Not HandledCalling PathSome Procedures Demo可参考脚本:192.168.1.200[oracle@DG1 scripts]$ pwd/u01/oracle/scripts[oracle@DG1 scripts]$ lltotal 60-rw-r--r-- 1 oracle oinstall 886 Apr 19 15:35 call_calculate_blance.sql-rw-r--r-- 1 oracle oinstall 220 Apr 19 14:26 s09_01.sql-rw-r--r-- 1 oracle oins
阅读全文
摘要:Passing Actula Parameters:Creating the add_dept ProcedureView Code CREATE OR REPLACE PROCEDURE add_dept( p_name IN dept.department_name%TYPE, p_loc IN dept.location_id%TYPE)ISBEGIN INSERT INTO dept(department_id,department_name,location_id) VALUES(departments_seq.NEXTVAL...
阅读全文
摘要:Using the IN、OUT、IN OUTParameter Mode:ExampleDemo 01:IN KeywordsCREATE OR REPLACE PROCEDURE raise_salary( p_id IN emp.employee_id%TYPE, p_percent IN NUMBER)ISBEGIN UPDATE emp SET salary = salary * (1 + p_percent/100) WHERE employee_id = p_id;END ra...
阅读全文
摘要:What Are Procedures?Are a type of subprogram that perform an actionCan be stored in the database as a schema object.Promote reusability and maintainabilityCreating Procedures:OverviewCreating Procedures with the SQL CREATE OR REPLACE StatementUse the CREATE clause to create a stand-alone procedure t
阅读全文
摘要:ObjectivesAfter competing this lesson,you should be able to do the following:Identify the benefits of modualarized and layered subprogram design.Create and call procedures.Use formal and actual parametersUse positional,named ,or mixed notation for passing parameters.Identify the available parameter-
阅读全文
摘要:placeholder
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Identify lexical units in a PL/SQL block.Use build-in SQL functions in PL/SQLDescribe when implict conversions take place and when explict conversion have to be dealt withWrite nested blocks and qualify variables with labe
阅读全文
摘要:Types of VariablesGuidelines for Declaring and Inititalizing PL/SQL VariablesFollow naming conventions.Use meaningful identifiers for variables.Initialize variables designated as NOT NULL and CONSTANT.Initialize variables with the assignment operator (:=) or the DEFAULT keyword:v_myName VARCHAR2(20)
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the followingRecognize valid and invalid identifies.List the uses of variables.Declare and initialize variables.List and descible various data types.Indentify the benefits of using the %TYPE attribute.Declare,useand print bind variables
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Explain the need for PL/SQLExplain the benefits of PL/SQLIndentify the different types of PL/SQL blocksOut messages in PL/SQLAbout PL/SQLStands for "Procedural Language extension to SQL".Is Oracle Corporation`s s
阅读全文
摘要:OjbectivesAfter completing this lesson,you should be able to do the following:Describle the course organizationDescrible the sample HR schemaCourse ObjectivesAfter completing this lesson,you should be able to do the following:Identify the programming extensions that PL/SQL provdies to SQL.Write PL/S
阅读全文
摘要:Rolling Back Changers to a MarkerCreate a marker in the current transaction by using the SAVEPOINT statement.Roll back to that marker by using the ROLLBACK TO SAVEPOINT statement.UPDATE ...SAVEPOINT update_done;INSERT ...ROLLBACK TO update_done;Implict Transaction ProcessingAn automatic commit occur
阅读全文
摘要:Changing Data in a TableUPDATE Statement SyntaxModify existing values in a table with the UPDATE statementUPDAE tableSET column = value [,column = value,...][WHERE condition];Update more than one row at a time(if required)Updating Rows in a TableValuesfor a specific row or rows are modified if you s
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Describe each data manipulation language(DML) statement.Insert rows into a table.Update rows in a table.Delete rows from a table.Control transactions.Lesson AgendaAdding new rows in a table-INSERT statementChanging data in
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Describe set operators.Use a set operator to combine multiple queries into a single query.Control the order of rows returned.Lesson AgendaSet Operators:Types and guidelinesTables used in this lessonUNION and UNION ALL oper
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Define subqueries.Describe the types of problems that the subqueries can solve.List the types of subqueries.Write single-row and multiple-row subqueries.single-row:查询结果返回一条记录multiple-row:查询结果返回多条记录Lesson AgendaSubquery:Typ
阅读全文
摘要:Applying Additional Condtions to a JoinUse the AND cluause or the WHERE clause to aplly additional condtions:AND CLAUSESQL> SELECT e.employee_id,e.last_name,d.department_id,d.department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id) AND e.manager_id = 149;EMPLOYEE
阅读全文
摘要:Creating Natural JoinsThe NATURAL JOIN clause is based on all columns in the two tables that have the same name.It selects rows from the two tables that have equal values in all matched columns.If the columns having the same names have different data types,an error is returned.Retrieving Records wit
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Write SELECT statements to access data from more than one table using equijoins and nonequijoins.Join a table to itself by using a self-joinView data that generally does not meet a join condtions by using outer joinsGenera
阅读全文
摘要:Using the GROUP BY ClauseThe GROUP BY column does not have to be in the SELECT list.(不过这样一般意义不大)View Code SQL> SELECT AVG(salary) AvgSalary FROM employees GROUP BY department_id ORDER BY AVGSALARY; AVGSALARY----------3475.55556 4150 4400 5760 6500 70008601.333338955.88235 ...
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Identify the available group functionsDescribe the use of group functionsGroup data by using the GROUP BY clauseInclude or exclude grouped rows by using the HAVING clauseLesson AgendaGroups functions:-Types and syntax-Use
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Limit the rows that are retrieved by a query.Sort the rows that are retrieved by a query.Use ampersand substitution to restrict and sort output at run time.Lesson AgendaLimiting rows with:-The WHERE clause-The comparison c
阅读全文
摘要:ObjectiveAfter completing this lesson,you should be able to do the following:List the capabilities of SQL statements.Execute a basic SELECT statementLesson AgendaBasic SELECT statementArithmetic expressions and NULL values in the SELECT statementColumn aliasesUse of concatenation operator,literal ch
阅读全文
摘要:Realational Database Terminology1->row;2->主键列;3->普通列;4->外键列;5->普通字段值;6->普通字段null值;Using SQL to Query Your DatabaseStructured query language(SQL) is:The ANSI standard languagte for operating relational databaseEfficient,easy to learn,and useFunctionally complete(With SQL,you can def
阅读全文
摘要:ObjectivesAfter comleting this lesson,you should be able to do the following:Understant the goals of course.Discuss the theoretical and physical aspect of arelational database.Identify the development environments that can be used fo this coureDescribe the database and schema used in this course.Cou
阅读全文
摘要:Conditional ExpressionsPrvoide the use of the IF-THEN-ELSE logic within a SQL statementUse two methods-CASE expression(SQL标准)-DECODE function(专属Oracle)CASE ExpressionFacilitates conditional inquiries by doing the work of an IF-THEN-ELSE statement:CASE expr WHEN comparison_expr1 THEN return_expr1 ...
阅读全文
摘要:General FunctionsThe following functions work with any data ype and pertain to using nulls:NVL(expr1,expr2)NVL2(expr1,expr2,expr3)NULLIF(expr1,expr2)COALESCE(expr1,expr2,...,exprn)NVL FunctionConverts an null value to an actual value:Data types that can be used are date,character,and number.Data typ
阅读全文
摘要:Nesting FunctionsSingle-row functions can be nested to any level.Nested functions are evaluated from the deepese level to the least deep level.View Code SQL> SELECT last_name,UPPER(CONCAT(SUBSTR(LAST_NAME,1,8),'_US')) FROM employees WHERE department_id = 60;LAST_NAME UPPER(CONCAT(SUB...
阅读全文
摘要:Conversions FunctionsImplicit Data Type ConversionIn expressions,the Oracle server can automatically conver the following:FromToVARCHAR2 or CHARNUMBERVARCHAR2 or CHARDATEDemo-01:View Code SQL> SELECT employee_id,first_name,TO_CHAR(hire_date,'YYYY-MM-DD HH24:MI:SS') FROM employees WHERE hi
阅读全文
摘要:Using Conversion Functions and Conditional ExpressionsAfter completing this lesson,you should be able to do the following:Describe various types of conversion functions that are available in SQLUse the TO_CHAR,TO_NUMBER,and TO_DATE conversion functions.Apply conditional expressions in a SELECT state
阅读全文
摘要:Working with DatesThe Oracle database stores dates in an internal numeric format:century,year,month,day,hours,minutes,and seconds.The default date display format is DD-MON-RR.-Enables you to store 21st-century dates in the 20th century by specifying only the last two digits of the year.-Enables you
阅读全文
摘要:Number FunctionsROUND:Rounds value to a specified deciamlTRUNC:Truncates value to a specified decimalMOD:Returns remainder fo divisionFunctionResultROUND(45.926,2)45.93TRUNC(45.926,2)45.92MOD(1600,300)100Demo-01:Using the ROUND FunctionSQL> SELECT ROUND(45.923,2),ROUND(45.923,0),ROUND(45.923,-1)
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Describe various types of functions available in SQL.Use character,number,and date functions in SELECT statements.Lesson AgendaSingle-row SQL functionsCharacter functionsNumber functionsWorking with datesDate functions/* 函
阅读全文
摘要:Constraint NameDescriblePRIMARY KEY主键约束,一张表中即可以有主键也可以没有;如果有,有且只能有一个PRIMARY KEY.FOREIGN KEY外键约束NOT NULL非空约束UNIQUE唯一约束.主键约束,从约束本身来讲就相当于(NOT NULL) + (UNIQUE)CHECK检查约束
阅读全文
摘要:SynonymCreating a Synonym for an Object Simplify access to objects by creating a synonym(another name for an object).With synonyms ,you can:Create an easier reference to a table that is owned by another user Shorten length object namesCREATE [PUBLIC] SYNONYM synonym FRO object; PUBLIC关键词,如果指定了,则全局都可
阅读全文
摘要:Indexes是可选项,可有可无;它存在的价值就是improves the performance of some queries.An index:Is a schema object Can be used by the Oracle server to speed up the retrieval of rows by using a pointerCan reduce disk input/output(I/O) by using a rapid path access method to locate data quicklyIs independent of the table t
阅读全文
摘要:Data TypeDescriptionVARCHAR2(size)Variable-length character dataCHAR(size)Fixed-length character dataNUMBER(p,s)Variable-length numeric dataDATEDate and time valuesLONGVariable-length character data(up to 2G);Oracle推荐不使用此数据类型,推荐使用CLOB、BLOBCLOBCharacter data(up to 4GB)RAW and LONG RAWRaw binary dataB
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Categorize the main database objectsReview the table structureList the data types that are available for columns.Create a simple tableExplain how constraints are created at the time of table creation.Describe how schema ob
阅读全文
摘要:Oracle Database ObjectsObjectDescribtionTableBasic unit of storage;Composed of rowsViewLogically represents subsets of data from one or more tablesSequenceGenerates numeric valuesIndexImporves the performance of some queriesSynonymGives alternative name to an object
阅读全文
摘要:SequencesA sequence:Can automatically generate unique numbersIs a shareable objectCan be used to create a primary key valueReplace application codeSpeeds up the efficiency of accessing sequence values when cached in memory.CREATE SEQUENCE Statement SyntaxDefine a sequence to generate sequential numb
阅读全文
摘要:ObjectivesAfter completing this lesson,you should be able to do the following:Create simple and complex views.Retrieve data from views.Create,maintain,and use sequences.Create and maintain indexes.Create private and public synonyms.Lesson AgendaOverview of views-Creating,modifying,and retrieving dat
阅读全文
摘要:1、常见问题解决办法:#chmod o=rx /var/ftp2、iptables -t filer -A INPUT -p tcp -m multiport --dport 40000:50000 -j ACCEPT
阅读全文
摘要:1、cmd下过滤3306端口C:\Users\MaryHu>netstat -an | find /i ":3306" TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING TCP 192.168.1.168:3306 221.182.63.243:1338 FIN_WAIT_1 TCP 192.168.1.168:3306 221.182.63.243:1395 FIN_WAIT_1
阅读全文
摘要:当今的数据处理大致分为两类:联机事务处理OLTP(on-line transaction processing)、联机分析处理OLAP(on-line Analytical Processing).OLTP是传统的关系型数据库的主要应用,主要是基本的、日常的事务处理,例如银行交易。OLAP是数据仓库系统的主要应用,支持负责的分析操作,侧重决策支持,并且提供直观易懂的查询结果。下面看OLTP和OLAP之间的比较OLTPOLAP用户操作人员,底层管理人员决策人员,高级管理人员功能日常事务处理分析决策DB设计面向应用面向主题数据当前的、最新的细节的、二维的分立的历史的、聚集的、多维的、集成的、统一的
阅读全文
摘要:Objectivesshared pool tune(shared pool 调优)After completing this lesson,you should be able to do the following:Determine the size of an object and pin it in the shared poolTune the shared pool reserved spaceDescribe the user global area (UGA) and session memory considerationsMeasure the library cache
阅读全文
摘要:Thread 1 cannot allocate new log,sequence 1466checkpoint not completecurrent log# 3 seq# 1465 mem#0:/home/ora10g/oradata/ora10g/redo03.log一般情况下,出现上述错误,基本上是由与日志被写满了,所造成的;解决方案:Provide enough groups to prevent waiting. 扩大联机重做日志文件组。 设置联机重做日志的大小.
阅读全文
摘要:1、清空数据库alert_sid.log文件内容cat /dev/null > alter_sid.log2、set timing on在命令行窗口,可以打开计时器通过上述命令;能够实时跟踪到oracle对每一条语句的执行时间;3、如何开启回收站的功能[oracle@arcerzhang ~]$ sqlplus /nologSQL*Plus: Release 11.2.0.1.0 Production on Mon May 27 10:08:43 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.SQL> conn
阅读全文
摘要:1、输出命令echoView Code #!/bin/bash#echo命令可以显示文本行或变量,或者把字符串输入到文件#-e 解析转义#\c 不换行#\t 跳格#\n 换行echo -e "enter your name:\c"read nameecho "$name"echo -n "welco...
阅读全文
摘要:Trace file分为 |-background trace file |-user trace file1、trace files是和进程相关的。2、在Oracle 中,Background Process Trace files是与server process严格区分的.3、如何查看oracle的background process trace files?View Code SQL> show parameter background_dump_destNAME TYPE VALUE-----------...
阅读全文
摘要:Oracle Database 11g includes three standard storage options:File systemNetwork attached storage(NAS)Storage area network(SAN)Direct attached storageRaw Partitions(原始分区,此种方式将逐渐被淘汰)Automatic Storage Management(AMS)Oracle Processes and FilesProcessOracle File I/OData filesOracle File I/ORedo LogOracle
阅读全文
摘要:Operating System Tuning1、首先对内存进行调优(理论上讲,内存足够大的话,就不存在IO读写) 查看一些系统快慢的时候,首先要查看系统的内存占用率. linux下查看内存使用情况命令vmstat(virtual memory)、vmstat 3(3秒钟变化一次)、top2、对I/O进行调优 linux下查看IO使用情况命令iostat3、CPU进行调优 正常情况下,CPU的利用率,应当控制在70%以下.top命令查看cpu使用情况-------------------------------------------------------------------------
阅读全文
摘要:1、问题描述将Oracle LOCK_SGA参数设置为TRUE之后,报错;SQL> show parameter LOCK_SGA;NAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSESQL> alter system set LOCK_SGA=TRUE SCOPE=SPFIL...
阅读全文