• Lgwr, log switches, and checkpointsLgwr, log switches, and checkpoints

    Redo Log Buffer and the Background Process LGWR The Oracle Server sequentially records all changes made to the database in the redo log buffer. The redo log buffer is used in a circular manner. The redo entries are written to one of the online redo log groups called the current online redo log group by the LGWR process under the following situation...

    pdf40 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2332 | Lượt tải: 0

  • Trace files and the alert fileTrace files and the alert file

    The following parameters control the location and size of the trace files: BACKGROUND_DUMP_DEST defines the location of the background trace file and ALERT file. USER_DUMP_DEST defines where trace files will be created at the request of the users. MAX_DUMP_FILE_SIZE specified in O/S blocks, limits the size of user trace files. Note ã The MAX_DUMP_F...

    pdf40 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2152 | Lượt tải: 0

  • Connecting to a DatabaseConnecting to a Database

    Apart from the database files, an Oracle server also uses other files. Some of these are: ã Parameter file: used to define the characteristics of an Oracle instance ã Password file: used to authenticate privileged database users ã Archived redo log files: offline copies of the redo log files that may be necessary to recover from media failures The ...

    pdf40 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2034 | Lượt tải: 0

  • Managing an Oracle InstanceManaging an Oracle Instance

    Objectives ã Setting up operating system and password file authentication ã Creating the parameter file ã Starting up an instance and opening the database ã Closing a database and shutting down the instance ã Getting and setting parameter values ã Managing sessions ã Monitoring ALERT and trace files

    pdf40 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2004 | Lượt tải: 0

  • Database AdministrationDatabase Administration

    Preface Profile xii Related Publications xiii Typographic Conventions xiv Curriculum Map Oracle8 Database Administrator Curriculum xviii Advanced DBA Curriculum xix Introduction Course Objectives I-3 Oracle8 Enterprise Edition I-4 Database Administrator Tasks I-5 Course Schedule I-6 Lesson 1: Oracle Architectural Components Objectives 1-3 Overview ...

    pdf40 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2226 | Lượt tải: 0

  • Web services with xsqlWeb services with xsql

    There is only one method left to document—the writeError. This is a simple utility method for writing out any errors. Since it is the last method, this code snippet also contains the closing brace for the class: void writeError(String mesg) { System.out.println(“An error occurred”); System.out.println(mesg); } } Now you can put this code to use. In...

    pdf60 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1863 | Lượt tải: 0

  • Building xsql web applicationsBuilding xsql web applications

    name, and price while the xsql:include-owa action is used to return the XML document using the get_product_xml procedure used earlier. <?xml version=”1.0”?> <prod-details connection=”momnpup” xmlns:xsql=”urnracle-xsql”> <xsql:include-xsql href=”cat-nav.xsql”/> <xsql:query rowset-element=”PRODUCT-SET” row-element=”DETAILS” produ...

    pdf60 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1846 | Lượt tải: 0

  • Parameter xml representationParameter xml representation

    In the previous examples, you saw how to reference parameters from your XSQL page. But what if you want the parameters to be part of the result? This is the job of two actions: <xsql:include-request-param> and <xsql:include-request-params>. This action outputs all of the parameters to the XML. Here is an example of <xsql:include -req...

    pdf60 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1804 | Lượt tải: 0

  • Oracle: XSQL Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web ContentOracle: XSQL Combining SQL, Oracle Text, XSLT, and Java to Publish Dynamic Web Content

    About the Author xix Chapter 1 Introducing Oracle XSQL 1 What XSQL Solves 2 The Problems of Web Application Development 2 XSQL as a Keystone Technology 5 XSQL and Other Oracle Technologies 11 Oracle Text 12 XMLSupport 12 Oracle JDeveloper 13 Introduction to XML 13 The Role of XML 13 Well-Formed versus Valid Documents 15 Document Structure 15 Proces...

    pdf60 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 1983 | Lượt tải: 0

  • Oracle sql internals handbookOracle sql internals handbook

    You can store SQL in the application itself (Java side) and access the database directly from the applet via a SQL statement. Or the programmer can make a request from the applet to the servlet, which then sends the SQL to the database. Another option within Java is to simply make a procedure or function call (Callable Statement in JDBC Driver) and...

    pdf20 trang | Chia sẻ: tlsuongmuoi | Ngày: 19/04/2013 | Lượt xem: 2132 | Lượt tải: 0