OracleÊý¾Ý¿âÐÔÄܵ÷ÊÔ¹¤¾ß
Oracle Enterprise Manager Oracle EMÊÇÓû§°²×°Oracle£¬´´½¨ÁËÊý¾Ý¿â²¢ÅäÖúÃÍøÂç×ÊÔ´ºó£¬Oracle¸½´ø°²×°µÄÒ»¸öÊý¾Ý¿â¹ÜÀíÈí¼þ¡£Í¬Ê±£¬EMÒ²Ìṩ¶ÔÐÔÄܵ÷ÊÔÓаïÖúµÄ¹¤¾ß£¬ÈçSQL*LoaderºÍRecovery Manager £¨RMAN£©µÈ¡£ Oracle Diagnostics Pack (ODP) ODPÓ¦¸ÃËãÊÇOracleÊý¾Ý¿â»·¾³ÐÔÄܵ÷ÊÔµÄ×îÖ÷ÒªºÍ×îÓÐЧµÄ¹¤¾ß£¬ËüÌṩÐÔÄÜÆ¿¾±×Ô¶¯Ê¶±ð(Automatic Identification of performance bottlenecks)£¬Òýµ¼ÐÔÎÊÌâ½âÎö£¨Guided problem resolution£©ºÍÍêÕûµÄϵͳ¼à¿Ø¡£ODPµÄÖ÷Òª¹¦ÄÜ°üÀ¨Automatic Workload Repository (AWR)£¬Automatic Database Diagnostic Monitor (ADDM)ºÍActive Session History (ASH)¡£ Oracle Database Tuning Pack Oracle Databae Tuning PackÍê³ÉÁËÊý¾Ý¿âÓ¦ÓÃÐÔÄܵ÷Õû¹ý³ÌµÄ×Ô¶¯»¯£¬Òò´Ë¿ÉÒÔÏÔÖøµØ½µµÍÊý¾Ý¿â¹ÜÀí³É±¾£¬Ìá¸ßÐÔÄܺͿɿ¿ÐÔ¡£Ö÷Òª°üº¬µÄ¹¦ÄÜÓУº 1. SQL Tuning Advisor Tuning Advisor¿ÉÒÔÈÃÓû§ÊäÈëÒ»¸ö»òÕ߶à¸öSQLÓï¾ä£¬È»ºóÊä³ö¾ßÌåµÄÕë¶ÔSQLµ÷ÓŵĽ¨ÒéºÍÍƼö£¬Í¬Ê±¶ÔÿһÌõ½¨Òé¸ø³ö½âÊͺÍÔ¤¼ÆºÃ´¦¡£Ã¿Ìõ½¨Ò鶼ÓëÔÚ¶à¸ö¶ÔÏóÉϵÄͳ¼ÆÐÅÏ¢£¬´´½¨ÐµÄË÷Òý£¬Öع¹SQLÓï¾ä»òÕß´´½¨SQL ProfilesÓйء£ 2. SQL Access Advisor ¸Ã¹¦ÄÜͨ¹ýÍƼöºÏÊʵÄmaterialized views, view logs, Ë÷ÒýÒÔ¼°partition for a given SQL workloadÀ´ÓÅ»¯SQL²éѯµÄÊý¾ÝÁ¬½Ó·¾¶¡£ Oracle Real Application Testing Ö÷ÒªµÄ¹¦ÄÜÓУº 1. Databse Replay ¸Ã¹¦ÄÜ¿ÉÒÔÈÃÓû§ÔÚProductionϵͳÀï»ñÈ¡Êý¾Ý¿âµÄÔËÐÐ×´¿ö£¬È»ºóÔÚ²âÊÔ»·¾³ÖУ¬ÓÃͬÑùµÄʱ¼äºÍ²¢·¢À´ÖØ·Å¡£ 2. SQL Performance Analyzer Õâ¸ö¹¦Äܼòµ¥¶øÑÔ£¬¾ÍÊÇÔÚÓû§³·Ïú»òÕßÌí¼ÓSQLÓï¾äµÄÐÞ¸ÄÖ®ºó£¬À´²éÔÄSQLÓï¾äÐ޸ĵĺóµÄÐÔÄÜÒÔ¼°Ð§¹ûµÄ¡£
Ïà¹ØÎĵµ£º
OS :RHEL AS 4 oracle 10g
0±¸·Ý½Å±¾
#!/bin/bash
# incremental level 0 backup script
source /home/oracle/.bash_profile
current_day=`date +%Y%m%d`
mkdir /home/ora ......
package com.svse.dao;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class UserDAO {
/*
* javaµ÷Óô洢¹ý³Ì
*/
public int addUser(String username,int userage)
{
Connection conn = null;
int useri ......
ÓÃϵͳ¹ÜÀíÔ±£¬²é¿´µ±Ç°Êý¾Ý¿âÓм¸¸öÓû§Á¬½Ó£º
SQL> select username,sid,serial# from v$session;
Èç¹ûҪͣij¸öÁ¬½ÓÓÃ
SQL> alter system kill session 'sid,serial#';
......
¶ÔÓÚ Oracle µÄ rownum ÎÊÌ⣬ºÜ¶à×ÊÁ϶¼Ëµ²»Ö§³Ö>,>=,=,between...and£¬Ö»ÄÜÓÃÒÔÉÏ·ûºÅ(<¡¢<=¡¢!=)£¬²¢·Ç˵ÓÃ>,>=,=,between..and ʱ»áÌáʾSQLÓï·¨´íÎ󣬶øÊǾ³£ÊDz鲻³öÒ»Ìõ¼Ç¼À´£¬»¹»á³öÏÖËƺõÊÇĪÃûÆäÃîµÄ½á¹ûÀ´£¬ÆäʵÄúÖ»ÒªÀí½âºÃÁËÕâ¸ö rownum αÁеÄÒâÒå¾Í²»Ó¦¸Ã¸Ðµ½¾ªÆæ£ ......