Download All Xiaobu Teacher's Videos

download.py

#!/usr/bin/python2

#下载小布老师的所有 Oracle 学习视频
#http://www.boobooke.com/bbs/thread-272667-1-1.html

import urllib2,urllib,re,sys,os,subprocess
from HTMLParser import HTMLParser

class MyHTMLParser(HTMLParser):
    def __init__(self):
        HTMLParser.__init__(self)
        #self.links = []
        self.dir = ""
        self.filename = ""
        self.url = ""
        self.preTag = ""
        self.index = 1
        
    def urlcallback(self, a,b,c):
        print a,

    def handle_starttag(self, tag, attrs):
        #print "Encountered a start tag:", tag
        if tag == "a":
            #pattern = re.compile("http://www.boobooke.com/v/bbk.*")
            self.preTag = tag
            if len(attrs) == 0:
                pass
            else:
                for (variable, value) in attrs:
                    if variable == "href":
                        self.url = value + "/video.swf"
                        #self.links.append(value)
                        print "Download " + self.url + " to FILE:",
        elif tag == "h1":
            self.preTag = "h1"
        else:
            self.preTag = "none"

    def handle_endtag(self, tag):
        #print "Encountered a end tag:", tag
        pass
    
    def handle_data(self, data):
        #print "Encountered some data:", data
        name = re.sub(r'[\/:*?"<>|]+', "_", data)
        if self.preTag == "a":
            self.filename = str(self.index) + ". " + name + ".swf"
            filepath = self.dir + "/" + self.filename
            print self.dir + "/" + self.filename
            if os.path.isfile(filepath):
                print "File exist, pass"
                self.index += 1
            else:
                print "Start downloading..."
                #urllib.urlretrieve(self.url, filepath, self.urlcallback)
                result = subprocess.call(["aria2c",self.url,"-o",filepath])
                if result == 0:
                    print "End download\n\n"
                else:
                    subprocess.call(["rm","-f",filepath,filepath + ".aria2"])
                    print "Download error\n\n"
                self.index += 1
        elif self.preTag == "h1":
            #check and mkdir
            self.dir = name
            self.index = 1
            if not os.path.exists(self.dir):
                print self.dir + " not exist, mkdir "+ self.dir
                os.mkdir(self.dir)
            else:
                print self.dir + " exist, pass"
            self.preTag = "none"

if __name__ == "__main__":
    fp = open('urls.txt')
    urls = fp.read()
    xiaobu = MyHTMLParser()
    xiaobu.feed(urls)
    xiaobu.close()

urls.txt

<h1>搭建学习环境</h1>
<a href="http://www.boobooke.com/v/bbkvmlinux1" target="_blank">使用虚拟机搭建Linux学习环境第1讲</a><br />
<a href="http://www.boobooke.com/v/bbkvmlinux2" target="_blank">使用虚拟机搭建Linux/Oracel学习环境第2讲</a><br />
<a href="http://www.boobooke.com/v/bbk1111" target="_blank">在CentOS 4.x上安装Oracle 9i 第1讲</a><br />
<a href="http://www.boobooke.com/v/bbk1668" target="_blank">在CentOS 4.x上安装Oracle 9i 第2讲</a><br />
<a href="http://www.boobooke.com/v/bbk1669" target="_blank">在CentOS 4.x上安装Oracle 9i 第3讲</a><br />
<a href="http://www.boobooke.com/v/bbk1704" target="_blank">在Solaris 10 x86平台上安装Oracle 10gR2 第1讲</a><br />
<a href="http://www.boobooke.com/v/bbk1705" target="_blank">在Solaris 10 x86平台上安装Oracle 10gR2 第2讲</a><br />
<a href="http://www.boobooke.com/v/bbk1706" target="_blank">在Solaris 10 x86平台上安装Oracle 10gR2 第3讲</a><br />
<a href="http://www.boobooke.com/v/bbk1707" target="_blank">在Solaris 10 x86平台上安装Oracle 10gR2 第4讲</a><br />
<a href="http://www.boobooke.com/v/bbk1040" target="_blank">Oracle 11g 在Linux平台上的安装视频教程第1讲</a><br />
<a href="http://www.boobooke.com/v/bbk1041" target="_blank">Oracle 11g 在Linux平台上的安装视频教程第2讲</a><br />
<a href="http://www.boobooke.com/v/bbk1042" target="_blank">Oracle 11g 在Linux平台上的安装视频教程第3讲</a><br />
<a href="http://www.boobooke.com/v/bbk5306" target="_blank">在Windows 7上VMWare Server 2.0安装CentOS 5.6 + Oracle 11g第1讲</a><br />
<a href="http://www.boobooke.com/v/bbk5335" target="_blank">在Windows 7上VMWare Server 2.0安装CentOS 5.6 + Oracle 11g第2讲</a><br />
<a href="http://www.boobooke.com/v/bbk5346" target="_blank">在Windows 7上VMWare Server 2.0安装CentOS 5.6 + Oracle 11g第3讲</a><br />
<a href="http://www.boobooke.com/v/bbk5353" target="_blank">在Windows 7上VMWare Server 2.0安装CentOS 5.6 + Oracle 11g第4讲</a><br />
<h1>Oracle 9i DBA Fundamentals I</h1>
<a href="http://www.boobooke.com/v/bbk1109" target="_blank">Chapter 01-Oracle Architectural </a><br />
<a href="http://www.boobooke.com/v/bbk1110" target="_blank">Chapter 01-Oracle Architectural </a><br />
<a href="http://www.boobooke.com/v/bbk1112" target="_blank">Chapter 01-Oracle Architectural </a><br />
<a href="http://www.boobooke.com/v/bbk1114" target="_blank">Chapter 01-Oracle Architectural </a><br />
<a href="http://www.boobooke.com/v/bbk1115" target="_blank">Chapter 02-Getting Started with the Oracle Server</a><br />
<a href="http://www.boobooke.com/v/bbk1148" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1149" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1150" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1151" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1152" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1153" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1154" target="_blank">Chapter 03-Managing an Oracle Instance</a><br />
<a href="http://www.boobooke.com/v/bbk1161" target="_blank">Chapter 04-Creating a Database</a><br />
<a href="http://www.boobooke.com/v/bbk1162" target="_blank">Chapter 04-Creating a Database</a><br />
<a href="http://www.boobooke.com/v/bbk1163" target="_blank">Chapter 04-Creating a Database</a><br />
<a href="http://www.boobooke.com/v/bbk1164" target="_blank">Chapter 04-Creating a Database</a><br />
<a href="http://www.boobooke.com/v/bbk1165" target="_blank">Chapter 04-Creating a Database</a><br />
<a href="http://www.boobooke.com/v/bbk1166" target="_blank">Chapter 05-Using Data Dictionary and Dynamic Performance</a><br />
<a href="http://www.boobooke.com/v/bbk1167" target="_blank">Chapter 05-Using Data Dictionary and Dynamic Performance</a><br />
<a href="http://www.boobooke.com/v/bbk1168" target="_blank">Chapter 06-Maintaining the Control File</a><br />
<a href="http://www.boobooke.com/v/bbk1169" target="_blank">Chapter 06-Maintaining the Control File</a><br />
<a href="http://www.boobooke.com/v/bbk1170" target="_blank">Chapter 07-Maintaining Online Redo Log Files</a><br />
<a href="http://www.boobooke.com/v/bbk1171" target="_blank">Chapter 07-Maintaining Online Redo Log Files</a><br />
<a href="http://www.boobooke.com/v/bbk1179" target="_blank">Chapter 07-Maintaining Online Redo Log Files</a><br />
<a href="http://www.boobooke.com/v/bbk1180" target="_blank">Chapter 07-Maintaining Online Redo Log Files</a><br />
<a href="http://www.boobooke.com/v/bbk1187" target="_blank">Chapter 08-Maintaining Tablespace and Data files</a><br />
<a href="http://www.boobooke.com/v/bbk1188" target="_blank">Chapter 08-Maintaining Tablespace and Data files</a><br />
<a href="http://www.boobooke.com/v/bbk1263" target="_blank">Chapter 08-Maintaining Tablespace and Data files</a><br />
<a href="http://www.boobooke.com/v/bbk1264" target="_blank">Chapter 08-Maintaining Tablespace and Data files</a><br />
<a href="http://www.boobooke.com/v/bbk1281" target="_blank">Chapter 08-Maintaining Tablespace and Data files</a><br />
<a href="http://www.boobooke.com/v/bbk1353" target="_blank">Chapter 09-Storage Structure and Relationships</a><br />
<a href="http://www.boobooke.com/v/bbk1354" target="_blank">Chapter 09-Storage Structure and Relationships</a><br />
<a href="http://www.boobooke.com/v/bbk1366" target="_blank">Chapter 09-Storage Structure and Relationships</a><br />
<a href="http://www.boobooke.com/v/bbk1367" target="_blank">Chapter 09-Storage Structure and Relationships</a><br />
<a href="http://www.boobooke.com/v/bbk1382" target="_blank">Chapter 09-Storage Structure and Relationships</a><br />
<a href="http://www.boobooke.com/v/bbk1384" target="_blank">Chapter 10-Managing Undo Data</a><br />
<a href="http://www.boobooke.com/v/bbk1385" target="_blank">Chapter 10-Managing Undo Data</a><br />
<a href="http://www.boobooke.com/v/bbk1404" target="_blank">Chapter 10-Managing Undo Data</a><br />
<a href="http://www.boobooke.com/v/bbk1405" target="_blank">Chapter 10-Managing Undo Data</a><br />
<a href="http://www.boobooke.com/v/bbk1406" target="_blank">Chapter 10-Managing Undo Data</a><br />
<a href="http://www.boobooke.com/v/bbk1663" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1664" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1665" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1666" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1667" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1675" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk1676" target="_blank">Chapter 11-Managing Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2347" target="_blank">Chapter 12-Managing Indexes</a><br />
<a href="http://www.boobooke.com/v/bbk2348" target="_blank">Chapter 12-Managing Indexes</a><br />
<a href="http://www.boobooke.com/v/bbk2360" target="_blank">Chapter 12-Managing Indexes</a><br />
<a href="http://www.boobooke.com/v/bbk2361" target="_blank">Chapter 12-Managing Indexes</a><br />
<a href="http://www.boobooke.com/v/bbk2363" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2364" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2369" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2380" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2381" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2382" target="_blank">Chapter 13-Maintaining Data Integrity</a><br />
<a href="http://www.boobooke.com/v/bbk2383" target="_blank">Chapter 14-Managing Password Security and Resikyrces</a><br />
<a href="http://www.boobooke.com/v/bbk2384" target="_blank">Chapter 15-Managing Users</a><br />
<a href="http://www.boobooke.com/v/bbk2385" target="_blank">Chapter 15-Managing Users</a><br />
<a href="http://www.boobooke.com/v/bbk2386" target="_blank">Chapter 16-Managing Privileges</a><br />
<a href="http://www.boobooke.com/v/bbk2387" target="_blank">Chapter 16-Managing Privileges</a><br />
<a href="http://www.boobooke.com/v/bbk2420" target="_blank">Chapter 16-Managing Privileges</a><br />
<a href="http://www.boobooke.com/v/bbk2421" target="_blank">Chapter 17-Managing Roles</a><br />
<a href="http://www.boobooke.com/v/bbk2425" target="_blank">Chapter 18-Auditing</a><br />
<a href="http://www.boobooke.com/v/bbk2426" target="_blank">Chapter 18-Auditing</a><br />
<a href="http://www.boobooke.com/v/bbk2500" target="_blank">Chapter 19-Loading Data into a Database</a><br />
<a href="http://www.boobooke.com/v/bbk2501" target="_blank">Chapter 19-Loading Data into a Database</a><br />
<a href="http://www.boobooke.com/v/bbk2502" target="_blank">Chapter 19-Loading Data into a Database</a><br />
<a href="http://www.boobooke.com/v/bbk2503" target="_blank">Chapter 19-Loading Data into a Database</a><br />
<a href="http://www.boobooke.com/v/bbk2520" target="_blank">Chapter 20-Using Globalization Support</a><br />
<a href="http://www.boobooke.com/v/bbk2521" target="_blank">Chapter 20-Using Globalization Support</a><br />
<a href="http://www.boobooke.com/v/bbk2522" target="_blank">Chapter 20-Using Globalization Support</a><br />
<a href="http://www.boobooke.com/v/bbk2523" target="_blank">Chapter 20-Using Globalization Support</a><br />
<a href="http://www.boobooke.com/v/bbk2527" target="_blank">Chapter 20-Using Globalization Support</a><br />
<a href="http://www.boobooke.com/v/bbk2528" target="_blank">Chapter 20-Using Globalization Support</a><br />
<h1>Oracle 9i DBA Fundamentals II</h1>
<a href="http://www.boobooke.com/v/bbk1172" target="_blank">Chapter 01-Networking Overivew</a><br />
<a href="http://www.boobooke.com/v/bbk1173" target="_blank">Chapter 01-Networking Overivew</a><br />
<a href="http://www.boobooke.com/v/bbk1174" target="_blank">Chapter 02-Oracle Net Architecture</a><br />
<a href="http://www.boobooke.com/v/bbk1175" target="_blank">Chapter 02-Oracle Net Architecture</a><br />
<a href="http://www.boobooke.com/v/bbk1178" target="_blank">Chapter 03-Basic Oracle Net Server Dide Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk1181" target="_blank">Chapter 03-Basic Oracle Net Server Dide Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk1182" target="_blank">Chapter 03-Basic Oracle Net Server Dide Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk1190" target="_blank">Chapter 04-Naming Method Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk1191" target="_blank">Chapter 04-Naming Method Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk1192" target="_blank">Chapter 05-Usage and Configuration of the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk1195" target="_blank">Chapter 05-Usage and Configuration of the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk1196" target="_blank">Chapter 05-Usage and Configuration of the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk1246" target="_blank">Chapter 05-Usage and Configuration of the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk1247" target="_blank">Chapter 05-Usage and Configuration of the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk1254" target="_blank">Chapter 06-Backup and Recovery Overview</a><br />
<a href="http://www.boobooke.com/v/bbk1255" target="_blank">Chapter 06-Backup and Recovery Overview</a><br />
<a href="http://www.boobooke.com/v/bbk1413" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1414" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1415" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1423" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1424" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1425" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1479" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1480" target="_blank">Chapter 07-Instance and Media Recovery Structures</a><br />
<a href="http://www.boobooke.com/v/bbk1481" target="_blank">Chapter 08-Configuring the Database Archiving Mode</a><br />
<a href="http://www.boobooke.com/v/bbk1482" target="_blank">Chapter 08-Configuring the Database Archiving Mode</a><br />
<a href="http://www.boobooke.com/v/bbk1483" target="_blank">Chapter 08-Configuring the Database Archiving Mode</a><br />
<a href="http://www.boobooke.com/v/bbk1486" target="_blank">Chapter 08-Configuring the Database Archiving Mode</a><br />
<a href="http://www.boobooke.com/v/bbk1487" target="_blank">Chapter 08-Configuring the Database Archiving Mode</a><br />
<a href="http://www.boobooke.com/v/bbk3461" target="_blank">Chapter 09-Oracle Recover Manager Overview and Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk3462" target="_blank">Chapter 09-Oracle Recover Manager Overview and Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk3463" target="_blank">Chapter 09-Oracle Recover Manager Overview and Configuration</a><br />
<a href="http://www.boobooke.com/v/bbk4018" target="_blank">Chapter 10-User-Managed Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4019" target="_blank">Chapter 10-User-Managed Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4020" target="_blank">Chapter 10-User-Managed Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4021" target="_blank">Chapter 10-User-Managed Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4022" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4023" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4024" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4025" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4026" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4027" target="_blank">Chapter 11-RMAN Backups</a><br />
<a href="http://www.boobooke.com/v/bbk4028" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4029" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4071" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4072" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4091" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4092" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4096" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4097" target="_blank">Chapter 12-User-Managed Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4098" target="_blank">Chapter 13-RMAN Complete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4313" target="_blank">Chapter 14-User-Managed Incomplete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4314" target="_blank">Chapter 14-User-Managed Incomplete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4320" target="_blank">Chapter 15-RMAN Incomplete Recovery</a><br />
<a href="http://www.boobooke.com/v/bbk4381" target="_blank">Chapter 16-RMAN Recovery Catalog Creation and Maintenance</a><br />
<a href="http://www.boobooke.com/v/bbk4382" target="_blank">Chapter 16-RMAN Recovery Catalog Creation and Maintenance</a><br />
<a href="http://www.boobooke.com/v/bbk4383" target="_blank">Chapter 16-RMAN Recovery Catalog Creation and Maintenance</a><br />
<a href="http://www.boobooke.com/v/bbk4419" target="_blank">Chapter 17-RMAN Maintenance</a><br />
<a href="http://www.boobooke.com/v/bbk4435" target="_blank">Chapter 17-RMAN Maintenance</a><br />
<a href="http://www.boobooke.com/v/bbk4444" target="_blank">Chapter 18-Export and Import Utilities</a><br />
<a href="http://www.boobooke.com/v/bbk4445" target="_blank">Chapter 18-Export and Import Utilities</a><br />
<a href="http://www.boobooke.com/v/bbk4446" target="_blank">Chapter 18-Export and Import Utilities</a><br />
<h1>Oracle 9i 性能调优系列培训</h1>
<a href="http://www.boobooke.com/v/bbk2100" target="_blank">Chapter 01-Overview of Oracle9i Database Performance Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk2101" target="_blank">Chapter 01-Overview of Oracle9i Database Performance Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk2102" target="_blank">Chapter 02-Diagnostic and Tuning Tools</a><br />
<a href="http://www.boobooke.com/v/bbk2103" target="_blank">Chapter 02-Diagnostic and Tuning Tools</a><br />
<a href="http://www.boobooke.com/v/bbk2120" target="_blank">Chapter 02-Diagnostic and Tuning Tools</a><br />
<a href="http://www.boobooke.com/v/bbk2121" target="_blank">Chapter 02-Diagnostic and Tuning Tools</a><br />
<a href="http://www.boobooke.com/v/bbk2122" target="_blank">Chapter 03-Database Configuration and IO Issues</a><br />
<a href="http://www.boobooke.com/v/bbk2125" target="_blank">Chapter 03-Database Configuration and IO Issues</a><br />
<a href="http://www.boobooke.com/v/bbk2126" target="_blank">Chapter 03-Database Configuration and IO Issues</a><br />
<a href="http://www.boobooke.com/v/bbk2152" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2153" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2154" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2156" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2157" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2158" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2173" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2174" target="_blank">Chapter 04-Tuning the Shared Pool</a><br />
<a href="http://www.boobooke.com/v/bbk2175" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2176" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2177" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2178" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2179" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2180" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2181" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2182" target="_blank">Chapter 05-Tuning the Buffer Cache</a><br />
<a href="http://www.boobooke.com/v/bbk2183" target="_blank">Chapter 06-Dynamic Instance Resizing</a><br />
<a href="http://www.boobooke.com/v/bbk2184" target="_blank">Chapter 07-Sizing Other SGA Structures</a><br />
<a href="http://www.boobooke.com/v/bbk2185" target="_blank">Chapter 07-Sizing Other SGA Structures</a><br />
<a href="http://www.boobooke.com/v/bbk2188" target="_blank">Chapter 08-Tuning the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk2189" target="_blank">Chapter 08-Tuning the Oracle Shared Server</a><br />
<a href="http://www.boobooke.com/v/bbk2190" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2191" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2192" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2193" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2194" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2195" target="_blank">Chapter 09-Optimizing Sort Operations</a><br />
<a href="http://www.boobooke.com/v/bbk2196" target="_blank">Chapter 10-Using Resource Manager</a><br />
<a href="http://www.boobooke.com/v/bbk2197" target="_blank">Chapter 10-Using Resource Manager</a><br />
<a href="http://www.boobooke.com/v/bbk2225" target="_blank">Chapter 10-Using Resource Manager</a><br />
<a href="http://www.boobooke.com/v/bbk2226" target="_blank">Chapter 10-Using Resource Manager</a><br />
<a href="http://www.boobooke.com/v/bbk2228" target="_blank">Chapter 10-Using Resource Manager</a><br />
<a href="http://www.boobooke.com/v/bbk2229" target="_blank">Chapter 11-SQL Statement Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk2300" target="_blank">Chapter 11-SQL Statement Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk2301" target="_blank">Chapter 11-SQL Statement Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk2340" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2341" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2342" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2343" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2344" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2345" target="_blank">Chapter 12-Managing Statistics</a><br />
<a href="http://www.boobooke.com/v/bbk2515" target="_blank">Chapter 13-Using Oracle Blocks Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2516" target="_blank">Chapter 13-Using Oracle Blocks Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2668" target="_blank">Chapter 13-Using Oracle Blocks Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2863" target="_blank">Chapter 13-Using Oracle Blocks Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2864" target="_blank">Chapter 14-Using Oracle Data Storage Structures Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2900" target="_blank">Chapter 14-Using Oracle Data Storage Structures Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2901" target="_blank">Chapter 14-Using Oracle Data Storage Structures Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk2902" target="_blank">Chapter 14-Using Oracle Data Storage Structures Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk3016" target="_blank">Chapter 14-Using Oracle Data Storage Structures Efficiently</a><br />
<a href="http://www.boobooke.com/v/bbk3019" target="_blank">Chapter 15-Application Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk3152" target="_blank">Chapter 15-Application Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk3153" target="_blank">Chapter 15-Application Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk3154" target="_blank">Chapter 15-Application Tuning</a><br />
<a href="http://www.boobooke.com/v/bbk3201" target="_blank">Chapter 16-Using Materialized Views</a><br />
<a href="http://www.boobooke.com/v/bbk3202" target="_blank">Chapter 16-Using Materialized Views</a><br />
<a href="http://www.boobooke.com/v/bbk3203" target="_blank">Chapter 16-Using Materialized Views</a><br />
<a href="http://www.boobooke.com/v/bbk3204" target="_blank">Chapter 17-Monitoring and Detecting Lock Conterntion</a><br />
<a href="http://www.boobooke.com/v/bbk3205" target="_blank">Chapter 17-Monitoring and Detecting Lock Conterntion</a><br />
<a href="http://www.boobooke.com/v/bbk3206" target="_blank">Chapter 17-Monitoring and Detecting Lock Conterntion</a><br />
<a href="http://www.boobooke.com/v/bbk3300" target="_blank">Chapter 18-Tuning the Operating System</a><br />
<a href="http://www.boobooke.com/v/bbk3301" target="_blank">Chapter 18-Tuning the Operating System</a><br />
<h1>Oracle 11g SQL 基础入门系列培训</h1>
<a href="http://www.boobooke.com/v/bbk2003" target="_blank">Oracle 11g SQL Fundamentals Training Introduction</a><br />
<a href="http://www.boobooke.com/v/bbk2004" target="_blank">Oracle 11g SQL Fundamentals Training Introduction</a><br />
<a href="http://www.boobooke.com/v/bbk2005" target="_blank">Chapter 01-Restricting Data Using the SQL SELECT Statement</a><br />
<a href="http://www.boobooke.com/v/bbk2006" target="_blank">Chapter 01-Restricting Data Using the SQL SELECT Statement</a><br />
<a href="http://www.boobooke.com/v/bbk2008" target="_blank">Chapter 02-Restricting and Sorting Data</a><br />
<a href="http://www.boobooke.com/v/bbk2009" target="_blank">Chapter 02-Restricting and Sorting Data</a><br />
<a href="http://www.boobooke.com/v/bbk2021" target="_blank">Chapter 02-Restricting and Sorting Data</a><br />
<a href="http://www.boobooke.com/v/bbk2022" target="_blank">Chapter 03-Using Single-Row Functions to Customize Output</a><br />
<a href="http://www.boobooke.com/v/bbk2023" target="_blank">Chapter 03-Using Single-Row Functions to Customize Output</a><br />
<a href="http://www.boobooke.com/v/bbk2024" target="_blank">Chapter 04-Using Conversion Functions and conditional Expressions</a><br />
<a href="http://www.boobooke.com/v/bbk2025" target="_blank">Chapter 04-Using Conversion Functions and conditional Expressions</a><br />
<a href="http://www.boobooke.com/v/bbk2026" target="_blank">Chapter 05-Reporting Aggregated Data Using the Group Functions</a><br />
<a href="http://www.boobooke.com/v/bbk2027" target="_blank">Chapter 05-Reporting Aggregated Data Using the Group Functions</a><br />
<a href="http://www.boobooke.com/v/bbk2028" target="_blank">Chapter 06-Displaying Data from Mutiple Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2029" target="_blank">Chapter 06-Displaying Data from Mutiple Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2030" target="_blank">Chapter 06-Displaying Data from Mutiple Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2036" target="_blank">Chapter 07-Using Subqueries to Solve Queries</a><br />
<a href="http://www.boobooke.com/v/bbk2037" target="_blank">Chapter 07-Using Subqueries to Solve Queries</a><br />
<a href="http://www.boobooke.com/v/bbk2049" target="_blank">Chapter 08-Using the Set Operators</a><br />
<a href="http://www.boobooke.com/v/bbk2050" target="_blank">Chapter 08-Using the Set Operators</a><br />
<a href="http://www.boobooke.com/v/bbk2051" target="_blank">Chapter 09-Manipulating Data</a><br />
<a href="http://www.boobooke.com/v/bbk2052" target="_blank">Chapter 09-Manipulating Data</a><br />
<a href="http://www.boobooke.com/v/bbk2055" target="_blank">Chapter 09-Manipulating Data</a><br />
<a href="http://www.boobooke.com/v/bbk2056" target="_blank">Chapter 10-Using DDL Statements to Create and Manage Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2057" target="_blank">Chapter 10-Using DDL Statements to Create and Manage Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2070" target="_blank">Chapter 10-Using DDL Statements to Create and Manage Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2077" target="_blank">Chapter 10-Using DDL Statements to Create and Manage Tables</a><br />
<a href="http://www.boobooke.com/v/bbk2078" target="_blank">Chapter 11-Creating Other Schema Objects</a><br />
<a href="http://www.boobooke.com/v/bbk2079" target="_blank">Chapter 11-Creating Other Schema Objects</a><br />
<a href="http://www.boobooke.com/v/bbk2080" target="_blank">Chapter 11-Creating Other Schema Objects</a><br />
<h1>Oracle 11g PL/SQL 系列培训视频</h1>
<a href="http://www.boobooke.com/v/bbk3480" target="_blank">Chapter 01-Introduction to PL/SQL</a><br />
<a href="http://www.boobooke.com/v/bbk3481" target="_blank">Chapter 02-Declaring PL/SQL Variables</a><br />
<a href="http://www.boobooke.com/v/bbk3482" target="_blank">Chapter 02-Declaring PL/SQL Variables</a><br />
<a href="http://www.boobooke.com/v/bbk4448" target="_blank">Chapter 02-Declaring PL/SQL Variables</a><br />
<a href="http://www.boobooke.com/v/bbk4978" target="_blank">Chapter 03-Writing Executable Statements</a><br />
<a href="http://www.boobooke.com/v/bbk4979" target="_blank">Chapter 03-Writing Executable Statements</a><br />
<a href="http://www.boobooke.com/v/bbk4980" target="_blank">Chapter 04-Interacting with Oracle Database Server</a><br />
<a href="http://www.boobooke.com/v/bbk4981" target="_blank">Chapter 04-Interacting with Oracle Database Server</a><br />
<a href="http://www.boobooke.com/v/bbk4982" target="_blank">Chapter 05-Writing Control Structures</a><br />
<a href="http://www.boobooke.com/v/bbk4984" target="_blank">Chapter 05-Writing Control Structures</a><br />
<a href="http://www.boobooke.com/v/bbk4998" target="_blank">Chapter 05-Writing Control Structures</a><br />
<a href="http://www.boobooke.com/v/bbk5128" target="_blank">Chapter 06-Working with Composite Data Types</a><br />
<a href="http://www.boobooke.com/v/bbk5129" target="_blank">Chapter 06-Working with Composite Data Types</a><br />
<a href="http://www.boobooke.com/v/bbk5141" target="_blank">Chapter 06-Working with Composite Data Types</a><br />
<a href="http://www.boobooke.com/v/bbk5153" target="_blank">Chapter 06-Working with Composite Data Types</a><br />
<a href="http://www.boobooke.com/v/bbk5160" target="_blank">Chapter 06-Working with Composite Data Types</a><br />
<a href="http://www.boobooke.com/v/bbk5300" target="_blank">Chapter 07-Using Explicit cursors</a><br />
<a href="http://www.boobooke.com/v/bbk5355" target="_blank">Chapter 08-Handling Exceptions</a><br />
<a href="http://www.boobooke.com/v/bbk5364" target="_blank">Chapter 08-Handling Exceptions</a><br />
<a href="http://www.boobooke.com/v/bbk5377" target="_blank">Chapter 08-Handling Exceptions</a><br />
<a href="http://www.boobooke.com/v/bbk5391" target="_blank">Chapter 08-Handling Exceptions</a><br />
<a href="http://www.boobooke.com/v/bbk5396" target="_blank">Chapter 09-Creating Procedures</a><br />
<a href="http://www.boobooke.com/v/bbk5200" target="_blank">Chapter 09-Creating Procedures</a><br />
<a href="http://www.boobooke.com/v/bbk5201" target="_blank">Chapter 09-Creating Procedures</a><br />
<a href="http://www.boobooke.com/v/bbk5202" target="_blank">Chapter 09-Creating Procedures</a><br />
<a href="http://www.boobooke.com/v/bbk5203" target="_blank">Chapter 10-Creating Functions</a><br />
<a href="http://www.boobooke.com/v/bbk5204" target="_blank">Chapter 10-Creating Functions</a><br />
<h1>Oracle GoldenGate 快速入门培训</h1>
<a href="http://www.boobooke.com/v/bbk4941" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 1</a><br />
<a href="http://www.boobooke.com/v/bbk4946" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 2</a><br />
<a href="http://www.boobooke.com/v/bbk4947" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 3</a><br />
<a href="http://www.boobooke.com/v/bbk4950" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 4</a><br />
<a href="http://www.boobooke.com/v/bbk4951" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 5</a><br />
<a href="http://www.boobooke.com/v/bbk4952" target="_blank">小布作品： Oracle GoldenGate快速入门培训 - 6</a><br />
<h1>Oracle 11g DATAGUARD</h1>
<a href="http://www.boobooke.com/v/bbk1087" target="_blank">小布作品：Oracle 11g DatGuard视频1 - DataGuard介绍(1)</a><br />
<a href="http://www.boobooke.com/v/bbk1088" target="_blank">小布作品：Oracle 11g DatGuard视频2 - DataGuard介绍(2)</a><br />
<a href="http://www.boobooke.com/v/bbk1090" target="_blank">小布作品：Oracle 11g DatGuard视频3 - DataGuard介绍(3)</a><br />
<h1>使用Perl管理Oracle 11g数据库培训</h1>
<a href="http://www.boobooke.com/v/bbk4929" target="_blank">使用Perl管理Oracle 11g数据库培训 01</a><br />
<a href="http://www.boobooke.com/v/bbk4962" target="_blank">使用Perl管理Oracle 11g数据库培训 02</a><br />
<a href="http://www.boobooke.com/v/bbk4963" target="_blank">使用Perl管理Oracle 11g数据库培训 03</a><br />
<h1>SQL PLUS 使用培训视频讲座</h1>
<a href="http://www.boobooke.com/v/bbk1389" target="_blank">SQL*Plus使用培训视频讲座 01</a><br />
<a href="http://www.boobooke.com/v/bbk1390" target="_blank">SQL*Plus使用培训视频讲座 02</a><br />
<a href="http://www.boobooke.com/v/bbk1391" target="_blank">SQL*Plus使用培训视频讲座 03</a><br />
<a href="http://www.boobooke.com/v/bbk1392" target="_blank">SQL*Plus使用培训视频讲座 04</a><br />
<a href="http://www.boobooke.com/v/bbk1397" target="_blank">SQL*Plus使用培训视频讲座 05</a><br />
<a href="http://www.boobooke.com/v/bbk1398" target="_blank">SQL*Plus使用培训视频讲座 06</a><br />
<a href="http://www.boobooke.com/v/bbk1400" target="_blank">SQL*Plus使用培训视频讲座 07</a><br />
<a href="http://www.boobooke.com/v/bbk1401" target="_blank">SQL*Plus使用培训视频讲座 08</a><br />
<h1>从客户端到SQL语句的跟踪</h1>
<a href="http://www.boobooke.com/v/bbk1420" target="_blank">小布作品：作品：从客户端到SQL语句的跟踪 1</a><br />
<a href="http://www.boobooke.com/v/bbk1421" target="_blank">小布作品：作品：从客户端到SQL语句的跟踪 2</a><br />
<a href="http://www.boobooke.com/v/bbk1422" target="_blank">小布作品：作品：从客户端到SQL语句的跟踪 3</a><br />