Less01_DBA1

w4000 ANSI Lumens, 85% uniformity, and 500:1 contrast ratio.wWeighs less than 8 lbs! Compact, low-profile design!w3panel LCD imaging delivers a rich, color saturated picture.wXGA resolution. WXGA, UXGA~VGA and MAC compatible.wQuiet operation: fan noise as low as 29 dBA in Eco mode.wSmart data compression/expansion, and video scaling.wConvenient mid-range 1.2:1 manual zoom and focus lens.wTwo VGA computer inputs, plus one VGA computer monitor output.wPreset image offset. Vertical digital keystone correction.wAccepts Composite, S, and Component Video in all major standards.wDisplays both 4:3 and 16:9 formats. Supports most HDTV resolutions.wConverts Interlace to Progressive scan. 3-2 (and 2-2) Pulldown support.wVariable Power Management option. Optional local or remote keylock.wCustom warm-up screen image option. Factory defaults reset.wWireless remote control. 16X digital zoom. Auto input search.w Green chalkboard projection mode. 3 Year* Projector Warranty!Projectors...and more!XGA "Brilliant" Series 2345Get the rich color imaging of 3-panel LCD technology in a compact, lightweight projector.More than bright...it’s Brilliant!LC-XB414000 ANSI LumensOutstanding Features 1.High brightness and contrast, with up to 3000 hours est. lamp life.2.Two VGA inputs plus one VGA monitor output.3.Project straight up or down: projector supports pitch through 360°.4.Integrated lens cover can’t be misplaced.5.UXGA & WXGA compatible. Interlace to Progressive conversion.6.Turn ON and Show! (Countdown can be optionally skipped.)7.Turn OFF and Go! (A/C cord can be removed immediately after OFF).Specifications subject to change without notice. ©2007 EIKI International, Inc. Printed in the USA. 09/01/07SPECIFICATIONS: LC-XB41Eiki International, Inc .30251 Esperanza, Rancho Santa Margarita, CA 92688-2130 Tel:800-242-3454;Fax:800-457-3454,E-mail:************In Canada, 310 First St.- Unit 2, P.O. Box 156, Midland, ON L4R 4K8 Phone:800-563-3454,Fax:800-567-4069E-mail:*************** Talk to your EIKI Dealer... the "pro"in projectors.Projectors...and more!2345LC-XB41 LC-XB414000 ANSI LumensINCLUDED ACCESSORIES:Quick Start Guide. Owner’s Manual on CD-ROM. AC Power Cord.VGA-type Computer Input Cable (HD15~HD15). Wireless Remote Control & Batteries (AA x 2).OPTIONAL ACCESSORIES:Soft Carry Bag. Replacement Lamp. VGA-type Computer Input Cable (HD15~HD15). Component Video Input Cable (HD15~3-RCA). Scart Video Input Cable (HD15~Scart). MAC Adapter.MAC Monitor Cable. DB9~Mini DIN-8 cable for RS-232 control.Luggage-Style ("wheelie") Carrying Case with Wheels, Telescoping Handle, and Detachable Computer Compartment. ATA-Style Shipping Case with Wheels and Telescoping Handle. Ceiling Mount. Ceiling Post and Plate. 33’ (10 M) Extension Cable for Serial Cable. EZ-250 Local Control. NPC-1 Network Control.Brightness ..................................................up to 4000 ANSI Lumens Illumination Uniformity .........................................................85%Size of Color Palette ....................................................16.7 Million Contrast Ratio .................................................500:1 (Full ON/OFF)Projection Lamp ....................................................275 Watt NSHA Estimated Lamp Life .........................................up to 3000 Hours of Use Imaging System ............................0.8” PolySilicon active matrix TFT Panels x 3Screen Pixels .......................................1024 x 768 in stripe configuration Total Pixels ...........................................2,359,296 ((1024 x 768) x 3)Lens Type ..................................................Manual Zoom and Focus Lens Specs .........................Speed: f:1.7~2.1; FL: 1.05~1.26 in. (26.7~32 mm)Lens Ratios ..........................Zoom Max:Min: 1.2:1; Throw:Width: 1.62~1.97:1Image Diagonal ............................................33~300 in. (84~762 cm)Image Width ............................................... 2.2~20 ft. (0.67~6.1 m)Throw Distance (tele~wide)................................... 4.3~32.8 ft. (1.3~10 m)Front Elevation ..........................................................Up to 8.9°Maximum Pitch .............................anywhere up to 360°off the horizontal axis Anti Keystone ...............................Preset Image Offset, Ratio (Top:Bottom) 9:1Vertical Keystone Correction ..............................Digital: up to 40°up or down Scanning Frequency ......................Auto: H Sync. 15-100kHz; V Sync. 50-100Hz Dot Clock ................................................................140 MHz Image Orientation .........................................Normal, Reversed, Inverted Local Control/Power Management .........................Full Function/Auto Shutdown Remote Projector Control ......................................Wireless (Infra Red) x 1Service Port (for RS-232 control)...................................Mini DIN 8 Pin x 1Computer Native Resolution .......................................1024 x 768 (XGA)Computer: Compatibility ...............................UXGA, SXGA+, SXGA, WXGA,XGA, SVGA, VGA & MAC Computer: Formats ..................................1600 x 1200 through 640 x 480Computer: Higher Resolutions ...................Displayed panned or Smart Compressed Computer: Lower Resolutions ......................Displayed normal or Smart Expanded Video Compatibility .........................NTSC/PAL/SECAM/NTSC 4.43/PAL-M&N Video HD Compatibility ..........................480i/p, 575i/p, 720p, 1035i, 1080i Formats Supported ................................Normal 4:3 and Wide Screen 16:9Video: Image Sizing ........................................Video Scaling Technology Image Signal Inputs Computer 1...........................................................HD15 x 1Computer 2/Component Video (w/optional adapter):.......................HD15 x 1Video – Composite:......................................................RCA x 1S-Video:....................................................S-Video x 1Audio Signal Inputs Computer 1 & 2/Component (Stereo):................................MiniStereo x 1Composite/S-Video (Stereo)...............................................RCA x 2Outputs Computer Monitor:......................................................HD15 x 1Audio (Stereo) - Variable Line:........................................MiniStereo x 1Sound – Amplifier (Mono):...............................................1Watt RMS Sound – Speaker:................................................ 1.1 in. (2.8cm) x 1Fan Noise ........................................................as low as 29 dBA Cabinet Size (HxWxD)...................3.07 x 13.15 x 9.17 in. (78 x 334 x 233 mm)Weight .............................................................7.3 lb (3.3 kg)Packaged Size (HxWxD)..................8.4 x 16.5 x 14.4 in ( 214 x 420 x 365 mm)Packaged Weight ...................................................11.9 lb (5.4 kg)Power Requirements .........................................100-240V AC, 50/60Hz Power Consumption ................................................up to 385 Watts Heat .....................................................up to 1314 BTU (331 KC)Power Cord ............................................10’ (3 M) Type 3, Detachable Safety Compliance .....................................................UL, cUL, IEC Security Facilities ............................................Kensington ®Security Slot Operating Temperature ...........................................41~95°F (5~35°C)User Maintenance ......................................Clean Air Filter, Replace Lamp Warranty: (to the original end-use customer)Projector:....................3Years/6000 Hour Use*(Parts/Labor to Correct Defects)Lamp:.....................................90 Days (Failed Lamp Replaced Pro-Rata)*whichever occurs first Lamp ContainsMercury.Do notput in trash.Dispose-of-as HazardousWaste, according to thelaws in your jurisdiction.3.07"13.15”9.13”。

MYSQL之表分区----按⽇期分区MYSQL之表分区----按⽇期分区于 2015-07-16 14:23:38 发布40948收藏 16错误的按⽇期分区例⼦最直观的⽅法，就是直接⽤年⽉⽇这种⽇期格式来进⾏常规的分区：PLAIN TEXTCODE:1.mysql> create table rms (d date)2.-> partition by range (d)3.-> (partition p0 values less than ('1995-01-01'),4.-> partition p1 VALUES LESS THAN ('2010-01-01'));上⾯的例⼦中，就是直接⽤"Y-m-d"的格式来对⼀个table进⾏分区，可惜想当然往往不能奏效，会得到⼀个错误信息: ERROR 1064 (42000): VALUES value must be of same type as partition function near '),partition p1 VALUES LESS THAN ('2010-01-01'))' at line 3上述分区⽅式没有成功，⽽且明显的不经济，⽼练的DBA会⽤整型数值来进⾏分区：PLAIN TEXTCODE:1.mysql> CREATE TABLE part_date12.-> ( c1 int default NULL,3.-> c2 varchar(30) default NULL,4.-> c3 date default NULL) engine=myisam5.-> partition by range (cast(date_format(c3,'%Y%m%d') as signed))6.-> (PARTITION p0 VALUES LESS THAN (19950101),7.-> PARTITION p1 VALUES LESS THAN (19960101) ,8.-> PARTITION p2 VALUES LESS THAN (19970101) ,9.-> PARTITION p3 VALUES LESS THAN (19980101) ,10.-> PARTITION p4 VALUES LESS THAN (19990101) ,11.-> PARTITION p5 VALUES LESS THAN (20000101) ,12.-> PARTITION p6 VALUES LESS THAN (20010101) ,13.-> PARTITION p7 VALUES LESS THAN (20020101) ,14.-> PARTITION p8 VALUES LESS THAN (20030101) ,15.-> PARTITION p9 VALUES LESS THAN (20040101) ,16.-> PARTITION p10 VALUES LESS THAN (20100101),-> PARTITION p11 VALUES LESS THAN MAXVALUE );Query OK, 0 rows affected (0.01 sec)搞定？接着往下分析PLAIN TEXTCODE:1.mysql> explain partitions2.-> select count(*) from part_date1 where3.-> c3> '1995-01-01' and c3 <'1995-12-31'\G4.*************************** 1. row ***************************5.id: 16.select_type: SIMPLE7.table: part_date18.partitions: p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p119.type: ALL10.possible_keys: NULL11.key: NULL12.key_len: NULL13.ref: NULL14.rows: 810000015.Extra: Using where16.1 row in set (0.00 sec)万恶的mysql居然对上⾯的sql使⽤全表扫描，⽽不是按照我们的⽇期分区分块查询。

SECTION 23 05 29HANGERS AND SUPPORTS FOR HVAC PIPING AND EQUIPMENT******************************************Throughout this document you will find these ‘specifier notes’ or links to specific electronic resources to better serve your needs. If you have any questions or comments, please contact your local Eaton B-Line Division sales representative, email ***************** or call (618) 654-2184.******************************************PART 1GENERAL1.1SUMMARYA.The work covered under this section consists of the furnishing of all necessary labor, supervision,materials, equipment, and services to completely execute the pipe hanger and supports asdescribed in this specification.1.2REFERENCESA.American Society of Mechanical Engineers:1.ASME B31.1 - Power Piping.2.ASME B31.5 - Refrigeration Piping.3.ASME B31.9 - Building Services Piping.B.ASTM International:1.ASTM B633 - Specification for Electrodeposited Coatings of Zinc on Iron and Steel2.ASTM A123 - Specification for Zinc (Hot-Galvanized) Coatings on Products Fabricatedfrom Rolled, Pressed, and Forged Steel Shapes, Plates, Bars, and Strip3.ASTM A653 – Specification for Steel Sheet, Zinc-Coated by the Hot-Dip Process4.ASTM A1011 - Specification for Steel, Sheet and Strip, Hot-Rolled, Carbon, Structural,High-Strength Low-Alloy and High-Strength Low-Alloy with Improved Formability(Formerly ASTM A570)C.Manufacturers Standardization Society of the Valve and Fittings Industry:1.MSS SP 58 - Pipe Hangers and Supports - Materials, Design and Manufacturer.2.MSS SP 69 - Pipe Hangers and Supports - Selection and Application.3.MSS SP 89 - Pipe Hangers and Supports - Fabrication and Installation Practices.D.NFPA1.NFPA 13 – Standard for the Installation of Sprinkler Systems1.3DEFINITIONSA.Firestopping (Through-Penetration Protection System): Sealing or stuffing material or assemblyplaced in spaces between and penetrations through building materials to arrest movement of fire,smoke, heat, and hot gases through fire rated construction.1.4SUBMITTALSA.Submit product data on all hanger and support devices, including shields and attachmentmethods. Product data to include, but not limited to materials, finishes, approvals, load ratings,and dimensional information.1.5QUALITY ASSURANCEA. Hangers and supports used in fire protection piping systems shall be listed and labeled byUnderwriters Laboratories.B. Steel pipe hangers and supports shall have the manufacturer’s name, part number, andapplicable size stamped in the part itself for identification.C. Hangers and supports shall be designed and manufactured in conformance with MSSSP 58.D. Supports for sprinkler piping shall be in conformance with NFPA 13.1.6QUALIFICATIONS******************************************Include the following paragraph if a list of manufacturers is not included or when substitutions are allowed to define applicable requirements. [] denotes a variable or choice******************************************A.Manufacturer: Company specializing in manufacturing Products specified in this section withminimum [_____] years of documented experience, and with service facilities within [_____]miles of Project.1.7PRE-INSTALLATION MEETINGSA.Section 01 30 00 - Administrative Requirements: Pre-installation meeting.B.Convene a minimum of [_____] week(s) prior to commencing work of this section.1.8DELIVERY, STORAGE, AND HANDLINGA.Section 01 60 00 - Product Requirements: Requirements for transporting, handling, storing, andprotecting products.B.Accept materials on site in original factory packaging, labeled with manufacturer's identification.C.Protect from weather and construction traffic, dirt, water, chemical, and damage, by storing inoriginal packaging.PART 2PRODUCTS2.1ACCEPTABLE MANUFACTURERSA.Subject to compliance with these specifications, wire basket cable tray systems to be installedshall be as manufactured by the following:1.Eaton’s B-Line Division. 509 West Monroe Street, Highland, IL, 62249, USA. Phone:(618)654-2184 or email *****************2.Engineer approved equivalent2.2PIPE HANGERS AND SUPPORTSA.Hangers1.Uninsulated pipes 2 inch and smaller:a.Adjustable steel swivel ring (band type) hanger, B-Line series B3170.b.Adjustable steel swivel J-hanger, B-Line series B3690.c.Malleable iron ring hanger, B-Line series B3198R or hinged ring hanger, B3198H.d.Malleable iron split-ring hanger with eye socket, B-Line series B3173 with B3222.e.Adjustable steel clevis hanger, B-Line series B3104 or B3100.2.Uninsulated pipes 2-1/2 inch and larger:a.Adjustable steel clevis hanger, B-Line series B3100.b.Pipe roll with sockets, B-Line series B3114.c.Adjustable steel yoke pipe roll, B-Line series B3110.3.Insulated pipe- Hot or steam piping:a. 2 inch and smaller pipes: use adjustable steel clevis with galvanized sheet metal shield.B-Line series B3100 with B3151 series.b.2-1/2 inch and larger pipes:1)Adjustable steel yoke pipe roll with pipe covering protection saddle. B-Line seriesB3110 with B3160-B3165 series.2)Pipe roll with sockets with pipe covering protection saddle, B-Line series B3114with B3160-B3165 series.4.Insulated pipe – Cold or chilled water piping:a. 5 inch and smaller pipes: use adjustable steel clevis with galvanized sheet metal shield.B-Line series B3100 with B3151 solutions.b. 6 inch and larger pipes:1)Pipe roll with sockets with pipe covering protection saddle, B-Line series B3114with B3160-B3165 series.2)Steel yoke pipe roll with pipe covering protection saddle. B-Line series B3110with B3160-B3165 solutions.B.Pipe Clamps1.When flexibility in the hanger assembly is required due to horizontal movement, use pipeclamps with weldless eye nuts, B-Line series B3140 or B3142 with B3200. For insulatedlines use double bolted pipe clamps, B-Line series B3144 or B3146 with B3200.C.Multiple or Trapeze Hanger1.Trapeze hangers shall be constructed from 12-gauge roll formed ASTM A1011 SS Grade 33structural steel channel, 1-5/8 inch by 1-5/8 inch minimum, B-Line series B22 strut orstronger as required.2.Mount pipes to trapeze with 2-piece pipe straps sized for outside diameter of pipe, B-Lineseries B2000 solutions.3.For pipes subjected to axial movement:a.Strut mounted roller support, B-Line series B3126. Use pipe protection shield orsaddles on insulated lines.b.Strut mounted pipe guide, B-Line series B2417.D.Wall Supports1.Pipes 4 inch and smaller:a.Carbon steel hook, B-Line series B3191.b.Carbon steel J-hanger, B-Line series B3690.2.Pipes larger than 4 inches:a.Welded strut bracket and pipe straps, B-Line series B3064 and B2000 solutions.b.Welded steel brackets, B-Line series B3066 or B3067, with roller chair or adjustablesteelyoke pipe roll. B-Line series B3120 or B3110. Use pipe protection shield or saddles oninsulated lines.E.Floor Supports1.Hot piping under 6 inches and all cold piping:a.Carbon steel adjustable pipe saddle and nipple attached to steel base stand sized for pipeelevation. B-Line series B3093 and B3088T or B3090 and B3088. Pipe saddle shall bescrewed or welded to appropriate base stand.2.Hot piping 6 inch and larger:a. [Adjustable] Roller stand with base plate, B-Line series B3117SL [or B3118SL]b.Adjustable roller support and steel support sized for elevation, B-Line series B3124F.Vertical Supports1.Steel riser clamp sized to fit outside diameter of pipe, B-Line series B3373.G.Copper Tubing Supports1.Hangers shall be sized to fit copper tubing outside diameters.a.Adjustable steel swivel ring (band type) hanger, B-Line series B3170CT.b.Malleable iron ring hanger, B-Line series B3198RCT or hinged ring hangerB3198HCT.c.Malleable iron split-ring hanger with eye socket, B-Line series B3173CT withB3222.d.Adjustable steel clevis hanger, B-Line series B3104CT.2.For supporting vertical runs use epoxy painted or plastic-coated riser clamps,B-Line series B3373CT or B3373CTC.3.For supporting copper tube to strut use epoxy painted pipe straps sized for copper tubing, B-Line series B2000 solutions, or plastic inserted vibration isolation clamps, B-Line seriesBVT products.H.Plastic Pipe Supports1.V-Bottom clevis hanger with galvanized 18-gauge continuous support channel, B-Line seriesB3106 and B3106V, to form a continuous support system for plastic pipe or flexible tubing.I.Supplementary Structural Supports1.Design and fabricate supports using structural quality steel bolted framing materials asmanufactured by Cooper B-Line, Inc. (DBA Eaton). Channels shall be roll formed, 12-gauge ASTM A1011 SS Grade 33 steel, 1-5/8 inch by 1-5/8 inch or greater as required byloading conditions. Submit designs for pipe tunnels, pipe galleries, etc., to engineer forapproval. Use clamps and fittings designed for use with the2.3UPPER ATTACHMENTSA.Beam Clamps1.Beam clamps shall be used where piping is to be suspended from building steel. Clamp typeshall be selected on the basis of load to be supported, and load configuration.2.C-Clamps shall have locknuts and cup point set screws, B-Line series B351L, or B3036L.Top flange c-clamps shall be used when attaching a hanger rod to the top flange of structuralshapes, B-Line series B3034 or B3033. Refer to manufacturer’s recommendation forsetscrew torque. Retaining straps shall be used to maintain the clamps position on the beamwhere required.3.Center loaded beam clamps shall be used where specified. Steel clamps shall be B-Lineseries B3050, or B3055. Malleable iron or forged steel beam clamps with cross bolt shall beB-Line series B3054 or B3291-B3297 solutions as required to fit beams.B.Concrete Inserts1.Cast in place spot concrete inserts shall be used where applicable; either steel or malleableiron body, B-Line series B2500 or B3014. Spot inserts shall allow for lateral adjustment andhave means for attachment to forms. Select inserts to suit threaded hanger rod sizes, B-Lineseries N2500 or B3014N solutions.2.Continuous concrete inserts shall be used where applicable. Channels shall be 12 gauge,ASTM A1011 SS Grade 33 structural quality carbon steel, complete with styrofoam insertsand end caps with nail holes for attachment to forms. The continuous concrete insert shallhave a load rating of 2,000 lbs/ft. in concrete, B-Line series B22I, 32I, or 52I. Selectchannel nuts suitable for strut and rod sizes.2.4VIBRATION ISOLATION AND SUPPORTSA.For refrigeration, air conditioning, hydraulic, pneumatic, and other vibrating system applications,use a clamp that has a vibration dampening insert and a nylon inserted locknut. For copper andsteel tubing use B-Line series BVT series Vibra-Clamp™, for pipe sizes use BVP series.B.For larger tubing or piping subjected to vibration, use neoprene or spring hangers as required.C.For base mounted equipment use vibration pads, molded neoprene mounts, or spring mounts asrequired.D.Vibration isolation products as manufactured by Cooper B-Line, Inc. (DBA Eaton)Vibratrol systems.2.5ACCESSORIESA.Hanger Rods shall be threaded both ends, or continuous threaded rods of circular cross section.Use adjusting locknuts at upper attachments and hangers. No wire, chain, or perforated straps areallowed.B.Shields shall be 180-degree galvanized sheet metal, 12 inch minimum length, 18-gauge minimumthickness, designed to match outside diameter of the insulated pipe, B-Line series B3151.C.Pipe protection saddles shall be formed from carbon steel, 1/8-inch minimum thickness, sized forinsulation thickness. Saddles for pipe sizes greater than 12 inches shall have a center support rib.2.6FINISHESA.Indoor Finishes1.Hangers and clamps for support of bare copper piping shall be coated with copper coloredepoxy paint, B-Line series Dura-Copper™. Additional PVC coating of the epoxy paintedhanger shall be used where necessary.2.Hangers for other than bare copper pipe shall be zinc plated in accordance with ASTM B633OR shall have an electro-deposited green epoxy finish, B-Line series Dura Green™.3.Strut channels shall be pre-galvanized in accordance with ASTM A653 SS Grade 33 G90OR have an electro-deposited green epoxy finish, B-Line series Dura Green.B.Outdoor and Corrosive Area Finishes1.Hangers and strut located outdoors shall be hot dip galvanized after fabrication inaccordance with ASTM A123. All hanger hardware shall be hot dip galvanized or stainlesssteel. Zinc plated hardware is not acceptable for outdoor or corrosive use.2.Hangers and strut located in corrosive areas shall be type 304 [316] stainless steel withstainless steel hardware.PART 3EXECUTION3.1PIPE HANGERS AND SUPPORTSA.Pipe shall be adequately supported by pipe hanger and supports specified in PART 2PRODUCTS. Hangers for insulated pipes shall be sized to accommodate insulation thickness.B.Horizontal steel piping shall be supported in accordance with MSS SP-69 Tables 3 and 4,excerpts of which follow below:NOMINAL PIPE SIZE ROD DIAMETER MAXIMUM SPACING(INCHES) (INCHES) (FEET)1/2 to 1-1/4 3/8 71-1/2 3/8 92 3/8 102-1/2 1/2 113 1/2 123-1/2 1/2 134 5/8 145 5/8 166 3/4 178 3/4 1910 7/8 2212 7/8 2314 1 2516 1 27C.Horizontal copper tubing shall be supported in accordance with MSS SP-69 Tables 3 and 4,excerpts of which follow below:NOMINAL PIPE SIZE ROD DIAMETER MAXIMUM SPACING(INCHES) (INCHES) (FEET)1/2 to 3/4 3/8 51 3/8 61-1/4 3/8 71-1/2 3/8 82 3/8 82-1/2 1/2 93 1/2 103-1/2 1/2 114 1/2 125 1/2 136 5/8 148 3/4 16D.Provide means of preventing dissimilar metal contact such as plastic-coated hangers, coppercolored epoxy paint, or non-adhesive isolation tape- B-Line series Iso-pipe. Galvanized feltisolators sized for copper tubing may also be used, B-Line series B3195CT.E.Support horizontal cast iron pipe adjacent to each hub, with 5 feet maximum spacingbetween hangers.F.Install hangers to provide a minimum of 1/2 inch space between finished covering andadjacent work.G.Place a hanger within 12 inches of each horizontal elbow.H.Support vertical piping independently of connected horizontal piping. Support verticalpipes at every [other] floor. Wherever possible, locate riser clamps directly below pipecouplings or shear lugs.I.Where several pipes can be installed in parallel and at the same elevation, provide trapeze hangersas specified in section 2.02 C. Trapeze hangers shall be spaced according to the smallest pipesize or install intermediate supports according to schedule in section 3.01B.J.Do not support piping from other pipes, ductwork or other equipment that is notbuilding structure.3.2CONCRETE INSERTSA.Provide inserts for placement in formwork before concrete is poured.B.Provide inserts for suspending hangers from reinforced concrete slabs and sides of reinforcedconcrete beams.C.Where concrete slabs form finished ceilings, provide inserts to be flush with slab surface.D.Provide hooked rod to concrete reinforcement section for inserts carrying pipe over 4 inches.END OF SECTION。

Valtek MaxFlo 4 Eccentric Rotary Plug Control ValveMaxFlo 4 Eccentric Rotary Plug Control Valve2The Flowserve Valtek MaxFlo 4 control valve is a high performance eccentric rotary plug valve designed for the process industry. It features a large capacity, standard hardened trim and superior shaft blow-out protection. This valve is available in sizes 1 through 12 inches, ASME Class 150, 300 and 600 as well as DIN PN 10, PN16, PN 25, PN40 and PN63.An optional ISA 75.08.01 or DIN EN 558 series 1 long-pattern body makes this valve an easy drop-in replacement for a globe control valve.The MaxFlo 4 is suitable for most applications; its control valve features include:• Highest Rated Cv • Precise Control • Reliable Shut-off• Most Current Safety Standards • Fugitive Emissions Elimination •Integral Noise Reduction PlatesHighest Rated CvThe unique design of the MaxFlo 4 shaft and plug provide as much as 70% more Cvcompared to the competition. This allows customers to get more flow when neededand sometimes allows for a smaller, more economical valve to be used.Precise ControlThe MaxFlo 4 polygon connection between the shaft and plug is a proven superiormethod for making demanding mechanical connections that are stronger, more preciseand have a substantially longer service life. This reduces backlash and the high strengthof the polygon connections makes them capable of withstanding greater shock loadsunder extreme torque reversal conditions.Reliable Shut-offThe MaxFlo 4 double-offset eccentric plug rotates into the seat at an angle that eliminatessliding over the seat surface. This design reduces seat wear, and thereby decreases main-tenance requirements and costs. At the same time, a tight ANSI Class VI shutoff is easilyobtainable using the soft seat design.Safety StandardThe shaft is designed to meet the safety requirements of industry standard ASME B16.34to ensure that the shaft is retained even if the actuator is removed when the valve is stillpressurized. This is standard on every MaxFlo 4 to provide our customers with confidenceand safety.3Separate bonnet ensures positive anti-blowout, accommodates multiple packing options, and offers flexibility in material selection for demandingapplications.Heavy-duty rigid metal seat,with hardfaced or soft-seat options, provides tighter shutoff, and easier maintenance. Available in full area and several reductions in every size to suit your process needs.Blow out proof shaft required by ASME B16.34 2004 Sec 6.5 ensures safety. Standard on every MaxFlo 4.An economical flangeless configuration of the MaxFlo 4 is also available. The standard flanged body is the same length. To replace existing globe valves we offer the flanged body with the same face to face length as a globe valve (Per ISA 75.08.01).4Open Flow Path gives as much as 70%more C v than competitive valves that have the shaft obstructing the flow. In many cases it is possible to use a smaller, more economical MaxFlo 4.Flanged end post allows for easy maintenance.Hard stainless steel plug requires no breakout torque and increases valve life as the plug lifts off the seat immediately when it begins rotating.Precision NC machined plug and shaft significantly reduces maintenance costs byallowing replacement of only the necessary parts.Polygon shaft/plug connection for precise robust control.Shimless seat offers simplified assembly and easy maintenance.5Eliminate Fugitive EmissionsSpecial Flowserve packing sets, such as SureGuard XT live loaded packing, are available to control fugitive emissions. Packing options include: PTFE V-Ring, Braided PTFE, Graphite, Sureguard XT, Garlock SVS, LATTYflon 3265 LM and LATTYgraf 6995 NG (meeting requirements for TA-Luft, ISO 15848-1 class B and A, and EPA standards).Integral Noise-Reduction Plate OptionDesigned to reduce noise levels by 5 to 10 dBA, our integral plate fits into the valve body. It can be easily maintained using the same tools required for the seat retainer. It is perfectly suitable with all gases in the shaft-downstream direction, and the plate does not change the length of the valve.Integrated Control Valve SolutionOperated by a diaphragm, piston, or rack-and-pinion actuator coupled with a Logix digital positioner, the MaxFlo 4 maintains high positioning accuracy, repeatability, controlled high speed and reliable response. With the advanced diagnostic solutions that can be seamlessly integrated into a host control and/or plant asset management system, along with state-of-the-art features and performance, the MaxFlo 4 is the most economical Eccentric Rotary Plug valve in the market.NR Diaphragm Rotary ActuatorThe Flowserve NR diaphragm rotary actuator is a rugged single-acting actuator designed to provide high performance, long life and reliability. The diaphragm actuator is very sensitive to small changes in air supply, which allows it toprecisely move the valve plug without over shoot.6Logix 3000MD+ Digital PositionerEasiest calibration and configuration of any positioner available. Single, push-button calibration and DIP switch configuration allow you to fully commission the positioner in a matter of minutes. Using ValveSight Software DTM brings the availability of 24/7 diagnostics.For more information see document number LGENIM0059 and LGENIM3404 at .Logix 500MD+ Series Digital PositionerTo minimize your total cost of ownership and maximize productivity, Flowserve developed the Logix MD+ digital positioner. The Logix MD+ digital positioner allows for fast, simple commis-sioning, extremely accurate and reliable control, and diagnostic features that provide powerfuland easy ways to determine when maintenance is required.ValveSight™ Diagnostic Software – Prevention deliveredValveSight is a diagnostic solution for control valves that can be seamlessly integrated into a host control and/or plant asset management system. The power of ValveSight is the intel-ligent diagnostic engine -- which detects an emerging condition in the valve, actuator, posi-tioner, and control signal -- that may indicate a performance, safety, or environmental problem. ValveSight advises which corrective actions totake to prevent a failure.VR Spring Cylinder Rotary ActuatorThe Flowserve VR spring cylinder rotary actuator combines high torque and pneu-matic stiffness with excellent throttling capabilities. These characteristics are designed into a lightweight, rugged and compact assembly, making the Flowserve spring cylinder rotary actuator an excel-lent choice for quarter-turn applications.SuperNova Rack & Pinion Rotary ActuatorThe Flowserve SuperNova rack & pinion rotary actuator is designed forreliability, versatility and safety. Rugged, yet compact construction combined with technical solutions make this product extremely reliable in the severest of operating conditionsLogix 420 Digital PositionerThe Logix 420 is the latest addition to the digital positioner family from Flowserve. When mounted to the MaxFlo 4 eccentric rotary plugcontrol valve, Logix 420 provides the user with a cost competitive solutionfor the general service, explosion proof market. For more information see document numberLGENIM0106 at www .Unparalleled Service: Day or Night, WorldwideFlowserve Quick Response Centers (QRCs) are equipped with thousands of parts, including OEM andFlowserve custom-built products. Each has the manpower andequipment to expedite time-sensitiverepairs of any size.7To find your local Flowserve representative:For more information about Flowserve Corporation, visit or callUSA 1 800 225 6989 or International +1 972 910 0774FCD VLENBR0064-01-AQ Printed in USA. November 2015. © 2015 Flowserve Corporation United States Flowserve1350 N. Mt. Springs Parkway Springville, UT 84663USAPhone: +1 801 489 8611Fax: +1 801 489 3719AustriaFlowserve Control Valves GmbH Kasernengasse 69500 Villach AustriaPhone: +43 (0)4242 41181 0Fax: +43 (0)4242 41181 50FranceFlowserve France S.A.S.BP 60 63307 Thiers Cedex FrancePhone: 33 4738 04266Fax: 33 4738 01424IndiaFlowserve India Controls Pvt. Ltd Plot # 4, 1A, E.P .I.P , Whitefield Bangalore Kamataka India 560 066Phone: +91 80 284 10 289Fax: +91 80 284 10 286SingaporeFlowserve Pte. Ltd.12 Tuas Avenue 20Republic of Singapore 638824SingaporePhone: +65 6879 8900Fax: +65 6862 4940Saudi ArabiaFlowserve Abahsain Flow Control Co., Ltd.Makkah Road, Phase 4Plot 10 & 12, 2nd Industrial City Damman, Kingdom of Saudi ArabiaPhone: +966 3 857 3150 ext. 243Fax: +966 3 857 4243ChinaFlowserve Fluid Motion and Control (Suzhou) Co., Ltd.No. 35, Baiyu RoadSuzhou Industrial Park, Suzhou Jiangsu Province, P .R. 215021ChinaPhone: 86 512 6288 8790Fax: 86 512 6288 8736。

第46卷第5期2601年5月分析测试学报FENXI CESHI XUEBA0(Jomat of EWmmxOl Analysis -Vol. 46 No. 5750-756doi : 17. 3969/j. issn. 1704 -4957. 2221. 05・ 014气相色谱-质谱法检测益智药材中16种多环芳绘孙细珍、* *,杜佳炜1,钱全全1,吴平谷4收稿日期：2626 -69 -08；修回日期：2627 -16 -27*通讯作者：孙细珍，高级工程师,研究方向：食品安全与风味研究，E-mail ： 347756486@qq. om 网络出版时间：2601年4月4日(1.中药保健食品质量与安全湖北省重点实验室,湖北黄石435100； 7.浙江省疾病预防控制中心,浙江 杭州310051)摘 要：建立了气相色谱-质谱联用技术同时测定益智药材中4种多环芳桂(PAHs)的分析方法。

最佳萃取条件为：取样品7.0 a ,加入同位素内标后用无水乙醇、水混合溶解,以10mL 正己烷提恥 提取液先过FW-mU 柱固相萃取，经氢氧化钾-乙醇溶液皂化,多环芳桂分子印迹柱固相萃取后,以5 mL 二氯甲烷-正己烷4 ：(，体积比)进行洗脱；采用DB-EUPAH 毛细管色谱柱进行分离,内标标准曲线法定量测定。

在此条 件下，4种多环芳桂的线性范围为4 0~200.4 R g/LI U M 0. 267 5)；检岀限(S/TV = 3)为0. 8 ~ 1. 4 R y/ky ；在不同浓度(4 3、4 R y/ky )基质加标条件下，苯并[O d(BcFL)的加标回收率为65. 4%-77. 8% ,日内相对 标准偏差(RSD , u=6)为6. 0% - 7. 4% ,日间RSD(u=6)为& 5% ;其他4种多环芳桂的加标回收率为86. 8%-117% ,日内 RSD(u=6)为 0.10%~6.1%,日间 RSD(u=6)为).2%~7.5%。

N-Channel MOSFETs: OptiMOS™ (20V…250V) Product TypeProduct TypeBSN045NE2LSBSN011NE2LSBSN011NE2LSIBSN012N03LSBSN012N03LSIBSN048N03LSBSB012NE2LXBSB014N04LX3 GBSB015N04NX3 GBSB017N03LX3 GBSB012N03LX3 GBSB028N06NN3 GBSB044N08NN3 GBSB056N10NN3 GBSB013NE2LXIBSB008NE2LXBSB280N15NZ3 G BSB165N15NZ3 G BSB012NE2LXI BSF024N03LT3 G BSF050N03LQ3 G BSF030NE2LQ BSF134N10NJ3 G BSF110N06NT3 G BSF450NE7NH3 G BSF035NE2LQ IPB015N04L G IPB027N10N3 G IPB035N08N3 G IPB015N04N G IPB019N06L3 G IPB083N10N3 G IPB042N10N3 G IPB054N06N3 GIPB037N06N3 G IPB097N08N3 G IPB055N03L G IPB054N08N3 G IPB042N03L G IPB022N04L G IPB065N03L G IPB072N15N3 G IPB025N08N3 G IPB080N03L G IPB081N06L3 G IPB147N03L G IPB096N03L G IPB136N08N3 GIPB090N06N3 G IPB029N06N3 G IPB049NE7N3 G IPB031NE7N3 G IPB020NE7N3 G IPB123N10N3 G IPB038N12N3 G IPB144N12N3 G IPB320N20N3 G IPB107N20N3 G IPB200N25N3 G IPB600N25N3 G BUZ32 H3045A BUZ31 H3045A IPB108N15N3 G BUZ30A H3045AIPB107N20NA IPB057N06N IPB026N06N IPB230N06L3 G IPB067N08N3 G IPB034N03L G IPB009N03L G IPB011N04L G IPB011N04N G IPB016N06L3 G IPB017N06N3 G IPB019N08N3 G IPB020N04N G IPB025N10N3 G IPB030N08N3 GIPB036N12N3 G IPB065N15N3 G IPB010N06NIPB014N06NSPD07N20 GIPD031N06L3 G IPD034N06N3 G IPD035N06L3 G IPD036N04L GIPD038N06N3 G IPD048N06L3 G IPD053N08N3 G SPD50N03S2L-06 G SPD30N03S2L-07 G IPD068N10N3 G SPD50N03S2-07 GIPD082N10N3 G IPD088N06N3 G IPD096N08N3 G SPD30N03S2L-10 G IPD127N06L GIPD135N08N3 G IPD160N04L GIPD170N04N GIPD200N15N3 G SPD30N03S2L-20 G IPD220N06L3 G IPD25CN10N GIPD250N06N3 G IPD33CN10N GIPD350N06L GIPD640N06L G IPD78CN10N G IPD800N06N G IPD122N10N3 G IPD180N10N3 G IPD110N12N3 G IPD031N03L G IPD040N03L G IPD050N03L G IPD060N03L G IPD075N03L G IPD090N03L G IPD320N20N3 G IPD600N25N3 G IPD530N15N3 G IPD105N03L G IPD135N03L GIPD025N06N IPD053N06N IPI023NE7N3 G IPI034NE7N3 G IPI052NE7N3 G IPI126N10N3 G IPI180N10N3 G IPI041N12N3 G IPI076N12N3 G IPI147N12N3 G IPI045N10N3 G IPI086N10N3 G IPI030N10N3 G IPI04CN10N G IPI072N10N3 G IPI26CN10N G IPI35CN10N GIPI075N15N3 G IPI200N15N3 G IPI024N06N3 G IPI032N06N3 G IPI040N06N3 G IPI037N08N3 G IPI320N20N3 G IPI110N20N3 G IPI200N25N3 G IPI600N25N3 G IPI111N15N3 G IPI530N15N3 G IPI020N06NIPI029N06N BUZ31 H3046 IPI084N06L3 GIPU135N08N3 G IPS110N12N3 G IPS060N03L G IPS075N03L G IPS031N03L G IPS040N03L G IPS090N03L G IPS105N03L G IPS135N03L G IPS050N03L G BSZ0908ND BSZ0907ND BSC0921NDI BSC0923NDI BSC0924NDI BSC0925ND BSC0910NDI BSC0911NDBSZ035N03LS G BSZ035N03MS G BSZ040N04LS G BSZ042N04NS G BSZ050N03LS G BSZ050N03MS G BSZ058N03LS G BSZ058N03MS G BSZ067N06LS3 G BSZ076N06NS3 G BSZ088N03MS G BSZ088N03LS G BSZ097N04LS G BSZ100N06LS3 G BSZ100N03MS GBSZ105N04NS G BSZ110N06NS3 G BSZ123N08NS3 G BSZ130N03MS G BSZ130N03LS G BSZ165N04NS G BSZ340N08NS3 G BSZ440N10NS3 G BSZ160N10NS3 G BSZ900N15NS3 G BSZ520N15NS3 G BSZ0909NSBSZ240N12NS3 G BSZ12DN20NS3 G BSZ16DN25NS3 GBSZ42DN25NS3 G BSZ900N20NS3 G BSZ060NE2LS BSZ065N03LS BSZ036NE2LS BSZ018NE2LS BSZ0901NSBSZ0901NSIBSZ0902NSBSZ0904NSIBSZ0902NSIBSZ018NE2LSI BSZ042N06NS BSZ023N04LS BSZ150N10LS3 G BSO615N GBSO033N03MS GBSO083N03MS G BSO110N03MS G BSO330N02K G BSO150N03MD G BSO220N03MD G BSC010NE2LS BSC050NE2LS BSC046N02KS G BSC019N02KS G BSC014N03LS G BSC016N03LS G BSC014N03MS G BSC016N04LS G BSC016N03MS G BSC017N04NS G BSC018N04LS GBSC020N03MS G BSC020N03LS G BSC025N03MS G BSC027N04LS G BSC025N03LS G BSC028N06LS3 G BSC030N03MS G BSC030N04NS G BSC030N03LS G BSC031N06NS3 G BSC034N03LS G BSC035N04LS G BSC042N03MS G BSC042N03LS GBSC050N03MS G BSC050N04LS G BSC050N03LS G BSC054N04NS G BSC057N03MS G BSC057N03LS G BSC057N08NS3 G BSC059N04LS G BSC060N10NS3 G BSC067N06LS3 G BSC076N06NS3 G BSC079N10NS GBSC080N03LS G BSC082N10LS G BSC090N03MS G BSC090N03LS G BSC093N04LS G BSC100N03MS G BSC100N10NSF G BSC100N06LS3 G BSC105N10LSF G BSC110N06NS3 G BSC118N10NS G BSC120N03MS G BSC120N03LS GBSC123N10LS G BSC152N10NSF G BSC190N15NS3 G BSC159N10LSF G BSC196N10NS G BSC205N10LS G BSC252N10NSF G BSC265N10LSF G BSC340N08NS3 G BSC042NE7NS3 G BSC160N10NS3 G BSC440N10NS3 G BSC077N12NS3 G BSC190N12NS3 G BSC520N15NS3 GBSC600N25NS3 G BSC026N02KS G BSC070N10NS3 G BSC109N10NS3 G BSC0909NSBSC360N15NS3 G BSC0908NSBSC240N12NS3 G BSC900N20NS3 G BSC12DN20NS3 G BSC16DN25NS3 G BSC22DN20NS3 G BSC018NE2LS BSC024NE2LS BSC011N03LS BSC052N03LSBSC0902NSBSC032NE2LS BSC0901NSIBSC0904NSIBSC010NE2LSI BSC0902NSIBSC014NE2LSI BSC018NE2LSI BSC011N03LSI BSC0906NSBSC009NE2LS BSC036NE7NS3 G BSC046N10NS3 G BSC028N06NS BSC010N04LSI BSC014N04LS BSC014N04LSIBSC039N06NS BSC014N06NS BSC010N04LS BSC500N20NS3 G BSC022N04LS BSC072N03LD G BSC150N03LD G BSC750N10ND G IPP023NE7N3 G IPP034NE7N3 G IPP052NE7N3 G BUZ31L HBUZ73 HBUZ73A HBUZ73AL HBUZ73L HIPP180N10N3 G IPP041N12N3 G IPP048N12N3 G IPP076N12N3 G IPP114N12N3 G IPP147N12N3 G IPP030N10N3 G IPP045N10N3 G IPP04CN10N G IPP05CN10N G IPP072N10N3 G IPP086N10N3 G IPP12CN10L G IPP16CN10N G IPP075N15N3 G IPP200N15N3 G IPP034N03L GIPP055N03L G IPP065N03L G IPP080N03L G IPP096N03L G IPP114N03L G IPP015N04N G IPP023N04N G IPP039N04L G IPP041N04N G IPP024N06N3 G IPP032N06N3 G IPP037N06L3 G IPP040N06N3 G IPP052N06L3 G IPP057N06N3 G IPP084N06L3 G IPP093N06N3 GIPP028N08N3 G IPP037N08N3 G IPP057N08N3 G IPP070N08N3 G IPP100N08N3 G IPP139N08N3 G IPP320N20N3 G IPP110N20N3 G IPP200N25N3 G IPP600N25N3 G BUZ31 HBUZ32 HIPP111N15N3 G BUZ30A HIPP065N04N G IPP530N15N3 GIPP048N04N G IPP110N20NA IPP147N03L G IPP029N06N IPP020N06N IPP040N06N IPP060N06N IPA028N08N3 G IPA037N08N3 G IPA057N08N3 G IPA100N08N3 G IPA045N10N3 G IPA086N10N3 G IPA126N10N3 G IPA180N10N3 G IPA030N10N3 GIPA105N15N3 G IPA032N06N3 G IPA057N06N3 G IPA093N06N3 G IPT004N03L IPT007N06N IPT020N10N3 IPT059N15N3Datasheet Group Product Status /dgdl/BSN045NE2LS_rev1.0.pdf?fBlade 3x3 (USON-6)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7ca959855780/dgdl/BSN011NE2LS_rev1.3.pdf?fBlade 3x3 (USON-6)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7cbfeef05815Blade 3x3 (USON-6)in production /dgdl/BSN011NE2LSI_rev1.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7ccf22ee58e4Blade 3x3 (USON-6)in production /dgdl/BSN012N03LS_rev1.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7cde510c594c/dgdl/BSN012N03LSI_rev1.3.pdf?Blade 3x3 (USON-6)in production folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7cea5f8559f4Blade 3x3 (USON-6)in production /dgdl/BSN048N03LS_rev1.0.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433d68e984013d7cf6d2e25a60/dgdl/BSB012NE2LX_Rev+2.3.pdfCanPAK™ M-size in production?folderId=db3a304326dfb1300126fb3bec803f1a&fileId=db3a304326dfb1300126fb6a32613f3dCanPAK™ M-size in production /dgdl/BSB014N04LX3+G_Rev+2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a02c6c737a9bCanPAK™ M-size in production /dgdl/BSB015N04NX3+G_Rev+2.4.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a03bbfcd7aacCanPAK™ M-size in production /dgdl/BSB017N03LX3+G_Rev+2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a04b132c7abb/dgdl/BSB012N03LX3+G_Rev_+2CanPAK™ M-size in production.1_pdf.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a0112ce07a8b/dgdl/BSB028N06NN3_G_rev2.0.CanPAK™ M-size in production pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30432e25b009012e29fda4e23838/dgdl/BSB044N08NN3_G_rev2.0.CanPAK™ M-size in production pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30435819ae2e012e385cde7b70d4CanPAK™ M-size in production /dgdl/BSB056N10NN3+G_Rev+2.5.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30442e152e91012e390b9a631459/dgdl/BSB013NE2LXI_Rev+2.3.pdCanPAK™ M-size in production f?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432e398416012e47a158802577/dgdl/BSB008NE2LX_Rev+1.3.pdfCanPAK™ M-size in production?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432e564707012e5745ca7d000eCanPAK™ M-size in production /dgdl/BSB280N15NZ3+G+Rev+2.5_.pdf?folderId=db3a304326623792012669f6bee2224b&fileId=db3a30432e779412012e7b0b544c3852CanPAK™ M-size in production /dgdl/BSB165N15NZ3+G+Rev+2.2.pdf?folderId=db3a304326623792012669f6bee2224b&fileId=db3a30432e779412012e7b04a1353843/dgdl/BSB012NE2LXI_rev1+1.pdfCanPAK™ M-size coming soon?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433f764301013f805e3eb247c1CanPAK™ S-size in production /dgdl/BSF024N03LT3+G_Rev+2.1_pdf.pdf?folderId=db3a30431ddc9372011ebafa04517f8b&fileId=db3a30432239cccd012282adaadf7bc8CanPAK™ S-size in production /dgdl/BSF050N03LQ3+G_Rev+2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a0f584407b1cCanPAK™ S-size in production /dgdl/BSF030NE2LQ_Rev+2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432e398416012e47a8f0792588/dgdl/BSF134N10NJ3+G_Rev+2.5CanPAK™ S-size in production.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432e779412012e7afa4a6c3834CanPAK™ S-size in production /dgdl/BSF110N06NT3_G_rev2.0.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a3043382e837301387b92fdc80c37CanPAK™ S-size in production /dgdl/BSF450NE7NH3G_rev2.0.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433a047ba0013a687e2ae403daCanPAK™ S-size coming soon /dgdl/BSF035NE2LQ_rev1+1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433f764301013f7fe8a925463cD2PAK (TO-263)in production /dgdl/IPB015N04L_rev1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431936bc4b0119382488c359d3D2PAK (TO-263)in production /dgdl/IPB027N10N3+G_Rev2.4.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1ed9348e15efD2PAK (TO-263)in production /dgdl/IPP037N08N3_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431add1d95011ae8426111565bD2PAK (TO-263)in production /dgdl/IPB015N04N_rev2.2.pdf?folderId=db3a3043156fd5730115c7d50620107c&fileId=db3a30431689f4420116c474de8f0845/dgdl/IPB019N06L3_Rev2.2.pdf?fD2PAK (TO-263)in production olderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2600a49e467b/dgdl/IPP086N10N3+G_Rev2.5.pdD2PAK (TO-263)in productionf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1ac5c8fa1358/dgdl/IPP045N10N3+G_Rev2.5.pdD2PAK (TO-263)in productionf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1e8b0cc31586D2PAK (TO-263)not for new design /dgdl/IPP_B057N06N3_Rev2.2.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2b439f1d4d93/dgdl/IPP037N06L3_Rev2.7.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b4561341f7d38D2PAK (TO-263)in production /dgdl/IPP040N06N3_Rev1.03.pdf?folderId=db3a3043163797a6011637c252b10018&fileId=db3a304317a7483601182c2d4f447647D2PAK (TO-263)in production /dgdl/IPP_I_B100N08N3_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ddc9372011e071f53b82619D2PAK (TO-263)in production /dgdl/IPP055N03L_rev2.0.pdf?folderId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d01148d01ee1c0e91/dgdl/IPP057N08N3_Rev1.2.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304317a748360117cf0cf5951d06/dgdl/IPP042N03L_rev2.0.pdf?foldD2PAK (TO-263)in production erId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d01148d012d010e8eD2PAK (TO-263)discontinued /dgdl/IPB022N04L_rev2.0.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431936bc4b01193836c99c5a08D2PAK (TO-263)in production /dgdl/IPP065N03L_rev2.0.pdf?folderId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d011492371ebc0fe2/dgdl/IPP075N15N3+G_Rev2.06.pD2PAK (TO-263)in production df?folderId=db3a304313b8b5a60113cee7c66a02d6&fileId=db3a304319c6f18c0119cd76cc527ab6/dgdl/IPB025N08N3_Rev1.2.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304317a748360117d35658bc066bD2PAK (TO-263)in production /dgdl/IPP080N03L_rev2.0.pdf?folderId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d01148d028c300e94D2PAK (TO-263)in production /dgdl/IPP_B084N06L3_Rev2.23.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b4592273f7db2/dgdl/IPP147N03L_rev2.0.pdf?foldD2PAK (TO-263)in production erId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d01148d08f1f30e9aD2PAK (TO-263)in production /dgdl/IPP096N03L_rev2.0.pdf?folderId=db3a30431441fb5d01148c401f250e27&fileId=db3a30431441fb5d01148d0849910e97/dgdl/IPP139N08N3_Rev2.5.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431add1d95011ae8a77e3656c2?folderId=db3a304313b8b5a60113cee7c66a02d6&fileId=db3a304319c6f18c0119cd1cc23279beD2PAK (TO-263)in production /dgdl/IPP_B093N06N3_Rev1.2.pdf?folderId=db3a3043163797a6011637c252b10018&fileId=db3a304317a7483601182c3043a67656D2PAK (TO-263)in production /dgdl/IPP032N06N3_Rev2.2.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2a84ff084cc8/dgdl/IPB049NE7N3_Rev2.2.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a517a48e0bb9D2PAK (TO-263)in production /dgdl/IPB031NE7N3_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121a52a87680bc8/dgdl/IPB020NE7N3_Rev2.2.pdf?fD2PAK (TO-263)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d590121e31c838554d3D2PAK (TO-263)in production /dgdl/IPP126N10N3+G_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd012260508e027f74D2PAK (TO-263)in production /dgdl/IPP_I_B041N12N3_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a75b86467ca4D2PAK (TO-263)in production /dgdl/IPP_I_B147N12N3+G_Rev2.6.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a79a30f57d01D2PAK (TO-263)in production /dgdl/IPP_B_I_320N20N3+G+Rev2.3.pdf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f170124967064ba184aD2PAK (TO-263)in production /dgdl/IPP_I_110N20N3+G_IPB107N20N3+G+Rev2.3.pdf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f170124968e7d1f18e7/dgdl/IPP_B_I_200N25N3+G+RevD2PAK (TO-263)in production2.4.pdf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f17012496b87e9f1971/dgdl/IPP_B_600N25N3+G+Rev2.D2PAK (TO-263)in production3.pdf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f17012496c9548d199cD2PAK (TO-263)not for new design /dgdl/BUZ32+H3045A+rev+2.2.pdf?folderId=db3a304325305e6d012596c6ca7b290a&fileId=db3a304325305e6d01259718c8d8291eD2PAK (TO-263)not for new design /dgdl/BUZ31+H3045+A+Rev+2.1.pdf?folderId=db3a304325305e6d012596c6ca7b290a&fileId=db3a304325305e6d0125971c90292922D2PAK (TO-263)in production /dgdl/IPP_I111N15N3+G_IPB108N15N3+G_Rev2.1.pdf?folderId=db3a304325305e6d01254a567c041b4e&fileId=db3a304325305e6d01254a5795541b4fD2PAK (TO-263)in production /dgdl/Buz30a+H3045A+Rev+2.2.pdf?folderId=db3a304325305e6d012596c6ca7b290a&fileId=db3a304325305e6d012596cd45e4290folderId=db3a304326623792012669f6bee2224b&fileId=db3a30432662379201266a1f6dd2227c/dgdl/IPP110N20NA_IPB107N20NA+Rev2.1.pdf?folderId=db3a304325305e6d012596c6ca7b290a&fileId=db3a3043300464130130307ce52a20a3D2PAK (TO-263)in production/dgdl/IPB057N06N_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433727a44301372c2ed50b49b3D2PAK (TO-263)in production/dgdl/IPB026N06N_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a3043372d5cc8013754c7b2a74f7cD2PAK (TO-263)in production/dgdl/IPP_B230N06L3_Rev2.2_.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2aab4a564d14D2PAK (TO-263)discontinued/dgdl/IPP070N08N3_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431add1d95011ae849e8f1566bD2PAK (TO-263)in production/dgdl/IPP034N03L_rev2.0.pdf?folderId=db3a304313b8b5a60113cee8ed2a02db&fileId=db3a304313b8b5a60113d3c9730503e7D2PAK (TO-263)in production/dgdl/IPB009N03L_rev1.3.pdf?fold erId=db3a3043156fd5730115c7d50620107c&fileId=db3a3 0431689f4420116d426b6770ca3D2PAK 7pin (TO-2637pin)in production/dgdl/IPB011N04L_rev1.3.pdf?fold erId=db3a3043156fd5730115c7d50620107c&fileId=db3a3 0431689f4420116c451f4e20825D2PAK 7pin (TO-2637pin)in production/dgdl/IPB011N04N_rev1+4.pdf?fol derId=db3a3043163797a6011643468e7505a4&fileId=db3 a3043163797a601164373e07005f8D2PAK 7pin (TO-2637pin)in production/dgdl/IPB016N06L3_Rev2.3.pdf?f olderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3 a30431ddc9372011e261543e54693D2PAK 7pin (TO-2637pin)in production/dgdl/IPB017N06N3_Rev2.2.pdf?f olderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3 a30431ddc9372011e264a7ab746ea D2PAK 7pin (TO-2637pin)in production/dgdl/IPB019N08N3_Rev2.3.pdf?f olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db 3a30431add1d95011ae87fdf90569f D2PAK 7pin (TO-2637pin)in production/dgdl/IPB020N04N_rev1.3.pdf?fol derId=db3a304313b8b5a60113cee8763b02d7&fileId=db3 a30431936bc4b0119382c70a859ed D2PAK 7pin (TO-2637pin)in production/dgdl/IPB025N10N3+G_Rev2.03.p df?folderId=db3a304313b8b5a60113cee8763b02d7&fileId =db3a30431ce5fb52011d1ab1d9d51349D2PAK 7pin (TO-2637pin)in production/dgdl/IPB030N08N3_Rev2.3.pdf?f olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db 3a30431add1d95011ae88a47a856b1D2PAK 7pin (TO-2637pin)in productiondf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1ed1fd3915e07pin)/dgdl/IPB036N12N3+G_Rev2.2.pd f?folderId=db3a304313b8b5a60113cee8763b02d7&fileId= db3a304323b87bc20123c7030ed51f56D2PAK 7pin (TO-2637pin)in production/dgdl/IPB065N15N3+G_Rev2.1.pd f?folderId=db3a304326623792012669f6bee2224b&fileId= db3a30432662379201266a0379d1225c D2PAK 7pin (TO-2637pin)in production/dgdl/IPB010N06N_Rev2.1.pdf?fol derId=db3a304313b8b5a60113cee8763b02d7&fileId=db3 a3043353fdc1601355341f17a485f D2PAK 7pin (TO-2637pin)in production/dgdl/IPB014N06N_Rev2.2.pdf?fol derId=db3a304313b8b5a60113cee8763b02d7&fileId=db3 a3043353fdc160135534e951e4873D2PAK 7pin (TO-2637pin)in production/dgdl/spd07n20_Rev+2.5.pdf?folderId=db3a30431a5c32f2011a809773886508&fileId=db3a30431f848401011fc73c3e60796aDPAK (TO-252)in production/dgdl/IPD031N06L3_Rev2.0.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2a9f6a9d4d02DPAK (TO-252)in production/dgdl/IPD034N06N3_Rev2.0.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2a97343b4cf3DPAK (TO-252)in production/dgdl/IPD035N06L3_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b4558ed7f7d14DPAK (TO-252)in production/dgdl/IPD036N04L_rev1.0.pdf?folderId=db3a3043163797a6011643468e7505a4&fileId=db3a3043163797a6011643476a6505a5DPAK (TO-252)in production/dgdl/IPD038N06N3_Rev1.02.pdf?folderId=db3a3043132679fb0113346bdc4505a3&fileId=db3a304317a7483601181bf8dae11675DPAK (TO-252)in production/dgdl/IPD048N06L3_Rev2.0.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2b4f496e4db0DPAK (TO-252)in production/dgdl/IPD053N08N3_Rev1.0.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304317a748360117cf072cf31ce8DPAK (TO-252)in production/dgdl/SPD50N03S2L-06+rev+1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b9718a1a20e3cDPAK (TO-252)in production/dgdl/SPD30N03S2L-07+rev+1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b92c6dcba0f89DPAK (TO-252)in production/dgdl/IPD068N10N3+G_Rev2.1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1eb7aeb615d1DPAK (TO-252)in production/dgdl/SPD50N03S2-07+rev+1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b97117df80e2aDPAK (TO-252)in productionolderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2b5528634dc0DPAK (TO-252)in production /dgdl/IPP086N10N3+G_Rev2.5.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1ac5c8fa1358DPAK (TO-252)in production /dgdl/IPD088N06N3_Rev2.0.pdf?folderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e2b2351db4d5c/dgdl/IPD096N08N3_Rev2+1.pdf?DPAK (TO-252)in production folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1f35150315feDPAK (TO-252)in production /dgdl/SPD30N03S2L-10+rev+1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b96e752ea0e08/dgdl/IPD127N06LG%2BRev1.2.pDPAK (TO-252)not for new design df?folderId=db3a30431a5c32f2011a809773886508&fileId=db3a30431f848401011fc786d4077a24DPAK (TO-252)in production /dgdl/IPD135N08N3_Rev2.1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431add1d95011ae8b1143256d4/dgdl/IPD160N04L_rev1.0.pdf?folDPAK (TO-252)not for new design derId=db3a3043163797a6011643468e7505a4&fileId=db3a3043163797a60116436401cf05cfDPAK (TO-252)not for new design /dgdl/IPD170N04N_rev1.0.pdf?folderId=db3a3043163797a6011643468e7505a4&fileId=db3a3043163797a601164367820f05dd/dgdl/IPD200N15N3_Rev2.05.pdfDPAK (TO-252)in production?folderId=db3a304313b8b5a60113cee7c66a02d6&fileId=db3a304319c6f18c0119cd1cc23279beDPAK (TO-252)in production /dgdl/SPD30N03S2L-20+rev+1.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431b3e89eb011b96f227b90e19/dgdl/IPD220N06L3_Rev2.0.pdf?fDPAK (TO-252)not for new design olderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e266fb35e471aDPAK (TO-252)in production /dgdl/IPP26CN10N_Rev1.08.pdf?folderId=db3a304412b407950112b408e8c90004&fileId=db3a304412b407950112b42b420244aa/dgdl/IPD250N06N3_Rev2.0.pdf?fDPAK (TO-252)not for new design olderId=db3a30431441fb5d01148ca9f1be0e77&fileId=db3a30431ddc9372011e268ceca1474fDPAK (TO-252)in production /dgdl/IPP35CN10N_Rev1.09.pdf?folderId=db3a304412b407950112b408e8c90004&fileId=db3a304412b407950112b42b457b44b1DPAK (TO-252)in production /dgdl/IPD350N06L+G++Rev1.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431be39b97011c320778777982?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431be39b97011c31db9a4f795cDPAK (TO-252)in production /dgdl/IPD640N06L%2BG%2BRev1.4.pdf?folderId=db3a30431ddc9372011ebafa04517f8b&fileId=db3a30431f848401011fcafb4ac00440DPAK (TO-252)in production /dgdl/IPP80CN10N_Rev1.09.pdf?folderId=db3a304412b407950112b408e8c90004&fileId=db3a304412b407950112b42c2aaf468dDPAK (TO-252)not for new design /dgdl/IPD800N06N%2BG%2BRev1.3.pdf?folderId=db3a30431ddc9372011ebafa04517f8b&fileId=db3a30431f848401011fcaff7887044fDPAK (TO-252)in production /dgdl/IPD122N10N3+G_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122604a0b2e7f65DPAK (TO-252)in production /dgdl/IPD180N10N3+G_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd01226070a4bb7fb9DPAK (TO-252)in production /dgdl/IPD_S110N12N3+G_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a7a49e2b7d1dDPAK (TO-252)in production /dgdl/IPD031N03L_rev2+1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239e2ed62a6fffDPAK (TO-252)in production /dgdl/IPD040N03LG_rev1%5B1%5D.02.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239e343d7c700fDPAK (TO-252)in production /dgdl/IPD050N03LG_rev1%5B1%5D.02.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239e47dbfe701f/dgdl/IPD060N03LG_rev2.0.pdf?fDPAK (TO-252)in production olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239e4d33a3702f/dgdl/IPD075N03LG_rev1%5B1%DPAK (TO-252)in production5D.1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239e56990c7047/dgdl/IPD090N03LG_rev2.0_.pdf?DPAK (TO-252)in production folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e01239eac54cb707bDPAK (TO-252)in production /dgdl/IPD320N20N3+G+Rev2.3.pdf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f1701249669796017f3/dgdl/IPD600N25N3+G+Rev2.3.pDPAK (TO-252)in productiondf?folderId=db3a3043163797a6011637d4bae7003b&fileId=db3a3043243b5f17012496b03c67195bDPAK (TO-252)in production /dgdl/IPD530N15N3_Rev2.5.pdf?folderId=db3a304326623792012669f6bee2224b&fileId=db3a30432662379201266a1f6dd2227c/dgdl/IPD105N03LG_rev2.1.pdf?fDPAK (TO-252)in production olderId=db3a304313b8b5a60113cee8ed2a02db&fileId=db3a3043271faefd0127b84794a33348/dgdl/IPD135N03LG_rev2.1.pdf?fDPAK (TO-252)in production olderId=db3a304313b8b5a60113cee8ed2a02db&fileId=db3a304327b897500127b8b9540f0003DPAK (TO-252)not for new design /dgdl/IPP12CN10N_Rev1.07.pdf?folderId=db3a304412b407950112b408e8c90004&fileId=db3a304412b407950112b42c236e467cDPAK (TO-252)in production /dgdl/IPD025N06N_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304336415dec0136531648062c76/dgdl/IPD053N06N_Rev2.2.pdf?foDPAK (TO-252)in production lderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30433727a44301372c22c4c3499fI2PAK (TO-262)in production /dgdl/IPP_I023NE7N3_Rev2+11.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d5901210a9da8c22702I2PAK (TO-262)in production /dgdl/IPP_I034NE7N3_Rev2+01.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d5901210ab6d74b2720I2PAK (TO-262)in production /dgdl/IPP_I052NE7N3_Rev2+01.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304320d39d5901210ac80a8c273d/dgdl/IPP126N10N3+G_Rev2.3.pdI2PAK (TO-262)in productionf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd012260508e027f74I2PAK (TO-262)in production /dgdl/IPP180N10N3+G+Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd01226066faa07f9dI2PAK (TO-262)in production /dgdl/IPP_I_B041N12N3_Rev2.2.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a75b86467ca4I2PAK (TO-262)in production /dgdl/IPP_I076N12N3+G_Rev2.3.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a77a83ab7cd4I2PAK (TO-262)in production /dgdl/IPP_I_B147N12N3+G_Rev2.6.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432239cccd0122a79a30f57d01I2PAK (TO-262)in production /dgdl/IPP045N10N3+G_Rev2.5.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1e8b0cc31586I2PAK (TO-262)in production /dgdl/IPP086N10N3+G_Rev2.5.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30431ce5fb52011d1ac5c8fa1358I2PAK (TO-262)in production /dgdl/IPP030N10N3+G_Rev2%5B1%5D.1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e0123939fdbcf03c9/dgdl/IPP04CN10N_Rev1.4.pdf?foI2PAK (TO-262)not for new design lderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e012393a80d1d03d8/dgdl/IPP072N10N3+G_Rev2%5BI2PAK (TO-262)in production1%5D.1.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e012393bed2d20405/dgdl/IPP26CN10N_Rev1.08.pdf?fI2PAK (TO-262)discontinued olderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a30432313ff5e012393d285660441I2PAK (TO-262)discontinued /dgdl/IPP35CN10N_Rev1.09.pdf?folderId=db3a304313b8b5a60113cee8763b02d7&fileId=db3a304317a748360117cf1876cc1d1a。

Chapter1Overview of Oracle9i Database Performance TuningTuning goalsminimizing response timeincreasing throughputincreasing load capabilitiesdecreasing recovery timeTuning steps during development1design2application3memory4input/output(I/O)5contention6opersting systemChapter2Diagnostic and Tuning Toolsv$sysstat(statistic#,name,class,value)v$sgastat(pool,name,bytes)v$event_name(event number,name,parameter1,parameter2,parameter3)v$system_event(event,total_waits,total_timeouts,time_waited,average_wait)SQL>select name,class,value from v$sysstat;SQL>select*from v$sgastat;Displaying session-related statisticsv$statname(statistic#,name,class)v$sesstat(sid,statistic#,value)v$session(sid,serial#,username,osuser)v$session_event(sid,event,total_waits,total_timeouts,time_waited,average_wait,max_wait)v$event_name(event#,name,parameter1,parameter2,parameter3)v$session_wait(sid,seq#,event,ps/2/3,p1/2/3text,p1/2/3raw,wait time,seconds_in_wait,state)SQL>select sid,username,type,server from v$session;SQL>select username,name,value from v$statname n,v$session s,v$sesstat t where s.sid=t.sid and n.statistic#=t.statistic#and s.type='user' and ername is not null and ='session pga memory'and t.value>30000;SQL>select sid,event from v$session_wait where wait_time=0;SQL>select name,parameter1,parameter2,parameter3from v$event_name;SQL>select sid,event,total_Waits,average_wait from v$session_event where sid=10;SQL>select sid,seq#,event,wait_time,state from v$session_wait;wait_time{>0(the session's last wait time);=0(the session is currently waiting)=-1(the value was less than1/100of a second)=-2(the system cannot provide timing information)}SQL>select event,total_waits,total_timeouts,time_Waited,average_wait from v$system_event order by time_waited desc; Troubleshooting and tuning viewsInstance/Databasev$databasev$instancev$optionv$parameterv$backupv$px_process_sysstat:parallel query system statisticsv$process:information about currently active processv$waitstat:connection statisticsv$system_event:total waits for particular eventsDiskv$datafilev$filestat:data file read/write statisticsv$logv$log_historyv$dbfilev$tempfilev$tempstat:information about file read/write statistics for temporary tablespace data filesv$segment_statistics:offers statistics on I/O segmentConnectionv$lockv$rollnamev$rollstat:statistics for all online rollback segmentsv$waitstat:block contention statistics(the timed_statistics parameter should be set to true)v$latch:statistics for each types of latchMemoryv$buffer_pool_statistics:buffer pools allocation on the instancev$db_object_cache:database objects cached in the library cachev$librarycache:library cache performance and activity statisticsv$rowcache:data dictionary hits and misses activityv$sysstat:basic instance statisticsv$sgastatUser/Sessionv$lock:locks currently held by the server and outstanding requests for a lock or latchv$open_cursor:cursors currently opened and parsed by each sessionv$processv$transactionv$px_sesstat:information about the session executing SQL statements in parallelv$px_sessionv$sesstat:user session statisticsv$session_event:information on waits for an event by a sessionv$sort_usage:seze of temporary segment and sessions creating them;identification of process doing disk sortsv$session_waitv$sessionv$session_object_cachetestSQL>show parameter timed_statisticsSQL>altere system set timed_statistics=true;SQL>alter session set SQL_TRACE=true;SQL>select count(*)from dba_tables;SQL>alter session set SQL_TRACE=false;$cd$HOME/admin/udump$ls-l$sqlplus hr/hr$sqlplus sys/oracle as sysdbaSQL>select username,sid,serial#from v$session where username='hr';SQL>begindbms_system.set_sql_trace_in_session(&SID,&SERIALNUM,true);end;/SQL>select*from employees;SQL>begindbms_system.set_sql_trace_in_session(&SID,&SERIALNUM,false);end;/$cd$HOME/admin/udump$ls-lSQL>connect sys/oracle as sysdbaSQL>create tablespace tools datafile'$HOME/oradata/u05/tools.dbf'size100M extent management dictionary;SQL>select tablespace_name,sum(types)from dba_free_space where tablespace_name='tools'group by tablespace_name; SQL>@$HOME/student/labs/spcreate.sqlSQL>@$HOME/student/labs/snap.sqlSQL>@$HOME/student/labs/spauto.sqlSQL>select job,next_date,next_sec,last_sec from user_jobs;SQL>select sanp_id,to_char(startup_time,'dd Mon"at"HH24:mi:ss')instart_fm,to_char(snap_time,'dd Mon YYYY HH24:mi') snapdat,snap_level"level"from stats$snapshot order by snap_id;SQL>@$HOME/student/labs/spreport.sql$vi sp_x_y.1stwhere x is the starting snapshot,and y is the ending snapshot(this is true if the default report filename was used)SQL>connect sys/oracle as sysdbaSQL>select event,total_waits,time_waited from v$system_event;SQL>select sid,event,p1text,wait_time,state from v$session_wait;SQL>connect perfstat/perfstatSQL>select job,log_user from user_jobs;SQL>execute dbms_job.remove($job);SQL>alter session set sql_trace=true;SQL>select sid,serial#,username from v$session;SQL>execute dbms_system.set_sql_trace_insession(16.167.true);statspack install先阅读/u010g/oracle/rdbms/admin/spdoc.txt这文档SQL>create tablespace perfstat datafile'/u01/oradata/pitts/perfstat_01.dbf'size512M;SQL>@?/rdbms/admin/spcreate.sqlSQL>execute statspack.snap;SQL>execute statspack.snap;SQL>@?/rdbms/admin/spreport********************************************************************************德哥statspack讲解SQL>drop user perfstat cascade;SQL>drop tablespace perfstat including contents and datafiles;SQL>create tablespace perfstat datafile'/oradata/clonedb/perfsata01.dbf'size500M autoextend on;SQL>@?/rdbms/admin/spcreate.sql如过运行出错SQL>@?/rdbms/admin/spdrop.sql然后在安装SQL>@?/rdbms/admin/spcreate.sql查看相关文档cat spcusr.listSQL>connect perfstat/perfstatSQL>execute statspack.snap;SQL>select*from stats$statspack_parameter;SQL>select*from stats$snapshot;然后在执行一次SQL>execute statspack.snap;vi spauto.sqlvariable jobno number;variable instno number;beginselect instance_number into:instno from v$instance;dbms_job.submit(:jobno,'statspack.snap;',trunc(sysdate+1/24,'HH'),'trunc(SYSDATE+1/24,''HH'')',TRUE,:instno);commit;end;/SQL>execute dbms_job.interval(62,'sysdate+1/(24*60)');SQL>select*from user_jobs;report1、instance reportspreport.sqlsprepins.sql(multi-instance)2、sql reportsprepsql.sqlsprsqins.sql(multi-instance)vi$HOME/rdbms/admin/sprepcon.sqldefine num_days='';SQL>@?/rdbms/admin/spreport.sql(生成报告)SQL>@?/rdbms/admin/sprepins.sqlSQL>@?/rdbms/admin/sprepsql.sqlConfigure1database parameters2snapshot parameters3instance report parameters4sql report parametersSQL>desc stats$statspack_parameter;SQL>select SNAP_LEVEL from stats$statspack_parameter;SQL>execute statspack.snap<i_snap_level=>7>;SQL>execute statspack.snap<i_snap_level=>7,i_modify_parameter=>'true'>;使用包更改SQL>execute statspack.modify_statspack_parameter<i_snap_level=>6>;SQL>select SNAP_LEVEL from stats$statspack_parameter;停止脚步执行SQL>execute dbms_job.remove(62);SQL>select*from user_jobs;maintenanceMake_baseline&clear_baselinePurge snapshot except baselineTruncate all tables with perfstat schemaDrop perfstat schema;SQL>define i_begin_snap=1SQL>define i_end_snap=16SQL>execute statspacl.make_baseline(i_begin_snap=>1,i_end_snap=>16);SQL>execute statspack.purge(i_begin_snap=>1,i_end_snap=>73);SQL>execute statspace.clear_baseline(i_begin_snap=>1,i_end_snap=>16,i_snap_range=>false);SQL>execute statspack.purge(i_begin_snap=>1,i_end_snap=>16);SQL>select snap_id from stats$snapshot;********************************************************************************Chapter3Database Configuration and I/O IssuesUsing the v$filestat viewSQL>select phyrds,phywrts, from v$datafile d,v$filestat f where d.file#=f.file#order by ;I/O statisticsSQL>select d.tablespace_name tablespace,d.file_name,f.phyrds,f.phywrts from v$filestat f,dba_data_files d where f.file#=d.file_id; Table Scan statisticsSQL>select name,value from v$sysstat where name like'table scan%';Determine the progress of long operations usingSQL>select sid,serial#,opname,to_char(start_time,'HH24:MI:SS')as"start",(sofar/totalwork)*100as percent_complete from v$session_longops;Use set_session_longops to populate v$session_longopsdbms_application_info.set_session_longops(rindex,slno,"Operation X",obj,0,sofar,totalwork,"table","tables");Monitoring full table scan operationsdeclarerindex binary_integer;slno binary_integer;totalwork number;sofar number;obj binary_integer;beginrindex:=dbms_application_info.set_session_longops_nohint;sofar:=0;totalwork:=10;while sofar<10loop--update obj based on sofar and perform task on object targetsofar:=sofar+1;dbms_application_info.set_session_longops(rindex,slno,"Operation X",obj,0,sofar,totalwork,"table","tables");end loop;end;DB_FILE_MULTINLOCK_READ_COUNT:是指oracle一次IO读出的最大块数，同时也受操作系统限制如：oracle一次IO读64K，但是，操作系统只能读32K，这样就受到限制。

达梦分区表的使用在大型的企业应用或企业级的数据库应用中，要处理的数据量通常达到TB 级，对于这样的大型表执行全表扫描或者DML操作时，效率是非常低的。

为了提高数据库在大数据量读写操作和查询时的效率，达梦数据库提供了对表和索引进行分区的技术，把表和索引等数据库对象中的数据分割成小的单位，分别存放在一个个单独的段中，用户对表的访问转化为对较小段的访问，以改善大型应用系统的性能。

达梦数据库分区表主要包括范围分区、哈希分区和列表分区三种方式，企业可以使用合适的分区方法，如日期（范围）、区域（列表），对大量数据进行分区。

由于达梦数据库划分的分区是相互独立且可以存储于不同的存储介质上的，完全可满足企业高可用性、均衡IO、降低维护成本、提高查询性能的要求。

今天我们主要讨论水平分区。

我们今天的测试环境操作系统: 中标麒麟6 64位数据库版本：达梦8.1一、创建分区表1.创建范围分区表create table r_t1 (pid int primary key ,id int)partition by range (pid)(partition p1 values less than (101),partition p2 values less than (201));将1-200的值录入到t_r1中。

beginfor i in 1..200 loopinsert into r_t1 values (i,i+1);end loop;end;查看表r_t1的类型，显示为分区表select table_name,PARTITIONED from dba_tables wheretable_name='R_T1';查看分区表的分区，显示为二个分区p1和p2select table_name,partition_name from dba_tab_partitions where table_name='R_T1';查询分区表中的记录数SQL> select count(*) from r_t1 partition (p1);这样一个范围分区就建立好了。

DBA数据库管理员JAVA程序员架构师必看一、技术问题部分(数据库部分)1、表空间的管理方式有哪几种？数据字典管理方式本地文件管理方式2、谈谈你对索引的理解？索引是若干数据行的关键字的列表，查询数据时，通过索引中的关键字可以快速定位到要访问的记录所在的数据块，从而大大减少读取数据块的I/O次数，因此可以显著提高性能。

3、说说索引的组成?索引列、rowid4、分区表用过么？谈谈分区表的应用？分区表在对表的DML的并行处理上有极大得优势，而且可以一部分设为只读，用在销售记录，医院处方等地方！！5、你对分区表的理解?怎样截断分区表一个分区的记录?一个分区表有一个或多个分区，每个分区通过使用范围分区、散列分区、或组合分区分区的行分区表中的每一个分区为一个段，可各自位于不同的表空间中对于同时能够使用几个进程进行查询或操作的大型表分区非常有用alter table table_name truncate partition partition_name;6、物理文件有哪几种?控制文件包含了什么信息?1）数据文件 2）控制文件 3）日志文件包含维护和验证有选举权据库完整性的必要信息、例如，控制文件用于识别数据文件和重做日志文件，一个有选举权据库至少需要一个控制文件7、表空间用完了如何增加?三种种扩展方式：1 增加数据文件alter tablespace name add datafile ‘路径’ size 4M;2 扩展数据文件大小alter database datafile ‘路径’ resize 4M;3 把数据文件设为自动增长alter database datafile ‘路径’ autoextend on next 1M max size 20M;8、SGA包含几部分?Shared pool(共享池)，DataBase Buffer Cache(数据缓冲区)Redo Log Buffer(重做日志缓冲区), Large Pool,大池，JAVA池。

达梦数据库分区达梦数据库分区分区是指将表、索引等数据库对象划分为较⼩的可管理⽚段的技术，⼀个表被分区后，对表的查询操作可以局限于某个分区进⾏，⽽不是整个表，这样可以⼤⼤提⾼查询速度，在分区表中，⼦表跟主表具有相同的逻辑结构，主表本⾝不存储数据，所有数据只存储在⼦表中，从⽽实现不同分区的完全独⽴性，可满⾜企业⾼可⽤性、均衡IO、降低维护成本、提⾼查询性能的要求。

分区主要包括范围分区、哈希分区、列表分区和复合分区。

按时间分区是现实⽣产中最主要的分区⽅式，本⽂主要讲解这种分区⽅式。

创建范围分区表create table PART(tdate datetime,city varchar(50),income number(10,2))PARTITION BY RANGE(tdate)( PARTITION p2016 VALUES LESS THAN ('2017-01-01'),PARTITION p2017 VALUES LESS THAN ('2018-01-01'),PARTITION p2018 VALUES LESS THAN ('2019-01-01'),PARTITION p2019 VALUES LESS THAN ('2020-01-01'),PARTITION p_other VALUES LESS THAN (MAXVALUE));创建存储过程proc_partCREATE OR REPLACE PROCEDURE proc_part ASDECLAREStartDate DATE:=DATE '2000-01-01';beginfor i in 1..11000 loopINSERT INTO PART (PART.TDATE,PART.CITY,PART.income)SELECTStartDate+i,CITY.CITY_NAME,convert(number(10,2),1000000*RAND())from "DMHR"."CITY";end loop;commit;end;调⽤proc_partcall PROC_PART;查看表分区数据查看分区select partition_name from dba_tab_partitions where table_name='PART';交换分区1新建交换表，表结构和分区表字段相同create table PART2 as select * from PART where 1=2;2 交换分区ALTER TABLE PART EXCHANGE PARTITION p_other WITH TABLE PART2; 可以看到p_other分区数据已经到新建交换表中了删除分区alter table PART drop partition p_other增加分区alter table PART add partition p2020 values less than('2021-01-01');合并分区alter table PART merge partitions p2016,p2017 into partition p20116_17;拆分分区alter table PART split partition p20116_17 at ('2017-01-01') into (partition p2016,partition p2017);定时⾃动新增表分区创建分区表create table PART(tdate datetime,city varchar(50),income number(10,2))PARTITION BY RANGE(tdate)( PARTITION p_2016 VALUES LESS THAN ('2017-01-01'),PARTITION p_2017 VALUES LESS THAN ('2018-01-01'),PARTITION p_2018 VALUES LESS THAN ('2019-01-01'),PARTITION p_2019 VALUES LESS THAN ('2020-01-01'),PARTITION p_2020_01 VALUES LESS THAN ('2020-02-01'),PARTITION p_2020_02 VALUES LESS THAN ('2020-03-01'),PARTITION p_2020_03 VALUES LESS THAN ('2020-04-01'),PARTITION p_2020_04 VALUES LESS THAN ('2020-05-01'),PARTITION p_2020_05 VALUES LESS THAN ('2020-06-01'),PARTITION p_2999 VALUES LESS THAN (MAXVALUE));查看表分区信息select partition_name from dba_tab_partitions where table_name='PART' order by 1 desc按⽉份增加分区存储过程create or replace procedure addpartition(tname varchar(50)) isdeclarehighvalue varchar(50);partition_name varchar(50);month_name varchar(2);year_name varchar(4);sSql varchar(2000);dSql varchar(2000);aSql varchar(2000);beginselect substr(max(high_value),10,10) into highvalue from dba_tab_partitions where table_name=sTable_name andtable_owner='SYSDBA' and HIGH_VALUE like 'DATETIME%';year_name = datepart(year,highvalue);if datepart(month,highvalue)<10 thenmonth_name = '0' || datepart(month,highvalue);elsemonth_name = datepart(month,highvalue);end if;partition_name = 'p_' || year_name ||'_'|| month_name;highvalue=dateadd(MM,1,highvalue);year_name = datepart(year,highvalue);month_name=datepart(month,highvalue);dSql := 'alter table '|| sTable_name || ' drop partition p_2999';sSql := 'alter table '|| sTable_name || ' add partition ' || partition_name || ' values less than(DATETIME''' || year_name || '-' || month_name || '-01 00:00:00'')';aSql := 'alter table '|| sTable_name || ' add partition p_2999 values less than (MAXVALUE)';execute immediate dSql;execute immediate sSql;execute immediate aSql;end;设置job，定时调⽤调⽤该存储过程（过程略）call addpartition('PART');查看结果select partition_name from dba_tab_partitions where table_name='PART' order by 1 desc。

Bootsect.s(1-9)!! SYS_SIZE is the number of clicks (16 bytes) to be loaded.! 0x3000 is 0x30000 bytes = 196kB, more than enough for current! versions of linux ! SYS_SIZE 是要加载的节数（16 字节为1 节）。

0x3000 共为1 2 3 4 5 60x7c000x00000x900000x100000xA0000system 模块代码执行位置线路0x90200! 0x30000 字节=192 kB（上面Linus 估算错了），对于当前的版本空间已足够了。

!SYSSIZE = 0x3000 ! 指编译连接后system 模块的大小。

参见列表1.2 中第92 的说明。

! 这里给出了一个最大默认值。

!! bootsect.s (C) 1991 Linus Torvalds!! bootsect.s is loaded at 0x7c00 by the bios-startup routines, and moves! iself out of the way to address 0x90000, and jumps there.!! It then loads 'setup' directly after itself (0x90200), and the system! at 0x10000, using BIOS interrupts.!! NOTE! currently system is at most 8*65536 bytes long. This should be no! problem, even in the future. I want to keep it simple. This 512 kB! kernel size should be enough, especially as this doesn't contain the! buffer cache as in minix!! The loader has been made as simple as possible, and continuos! read errors will result in a unbreakable loop. Reboot by hand. It! loads pretty fast by getting whole sectors at a time whenever possible.!! 以下是前面这些文字的翻译：! bootsect.s (C) 1991 Linus Torvalds 版权所有!! bootsect.s 被bios-启动子程序加载至0x7c00 (31k)处，并将自己! 移到了地址0x90000 (576k)处，并跳转至那里。

考纲词汇3‎500检测‎（2）一、词性变化，并说出其汉‎语意思。

1. analy‎se (v.) (n.)2. appea‎r (v.) (n.)(反义词)3. amaze‎ (v.) (a.)(a.)4. amuse‎(v.) (n.)5. decla‎re (v.) (近义词)6. ancie‎n t (a.) (反义词)7. apply‎(v.) (n.)(n.)8. appoi‎n t (v.) (n.)9. appro‎p riat‎e (a.) (同义词)(反义词) 10. appro‎v e (v.) (n.)二、短语翻译1. by air _____‎_____‎_____‎_____‎____2. Leave‎me alone‎. _____‎_____‎____3. one anoth‎e r4. the apple‎of sb’s eye__‎_____‎_____‎_5. 发出警报_____‎_____‎_____‎_____‎_6. 英雄所见略‎同。

_____‎_____‎_____‎_7. appea‎l to (3) _____‎_____‎_____‎____8. apply‎to (2)_____‎_____‎_____‎_____‎三、根据句意、首字母、或中文提示‎填词，要求意思通‎顺，语法搭配正‎确。

1.Sever‎al peopl‎ e were burie‎ d a durin‎g that earth‎quake‎.2.There‎are 26 lette‎rs in the Engli‎s h a .rge‎ a of money‎are neede‎d to cure the disea‎se.4.Eatin‎g candi‎e s/sweet‎s befor‎e dinne‎r will spoil‎ your a .5.Let’s a a day to have dinne‎r toget‎h er.6.The band’s lates‎t(专辑唱片) is selli‎n g very well.7.(附录) to a book are worth‎consu‎l ting‎.8.They don’t live in the same neigh‎b ourh‎o od. Their‎ house‎s are 2 miles‎(相距).9.Chris‎t mas is an festi‎v al to celeb‎r ate the birth‎of Jesus‎Chris‎t.10.I am amaze‎ d to find that she is not a profe‎ssion‎al (演员)butan .四、改错1.All but one was here just now.2.Altho‎ugh he is consi‎dered‎ a great‎write‎r, howev‎er his works‎are notwidel‎y read.3.I think‎he’s just going‎to deal with this probl‎em the other‎day.4.The singe‎r’s perfo‎rmanc‎ e was so excel‎lent that the audie‎nce all rose to appla‎ud for her.5.Aircr‎afts inclu‎de airpl‎anes, jets, helic‎opter‎s, space‎ships‎, ballo‎ons andso on.五、句子改写1.She insis‎ted on his apolo‎gy.She insis‎ted that to her.2.I have no idea how to use this word.I don’t the of this word.3.As a grown‎-up, you shoul‎d answe‎r for your behav‎ior.As an , you shoul‎ d for your behav‎ior.4.He was angry‎at her words‎.He was by she .5.We are worki‎ng overt‎ime in order‎to finis‎h the task befor‎ e the deadl‎ine.By worki‎ng overt‎ime we to finis‎h the task time.六、单项选择1.—Could‎I ask you a rathe‎r perso‎nal quest‎ion?—Sure, .A. pardo‎n meB. go ahead‎C. good ideaD. forge‎t it2.It is easy to do the repai‎r. you need is a hamme‎r and some nails‎.A. Anyth‎ingB. Somet‎hingC. AllD. Both3.—Have you been to New Zeala‎nd?—No, I’d like to, .A. tooB. thoug‎hC. yetD. eithe‎r4.The manag‎er belie‎ves price‎s will not rise by more than four perce‎nt.A. any other‎B. the other‎C. anoth‎erD. other‎5.—Excus‎e me, could‎you tell me the way to the Briti‎s h Museu‎m?—Sorry‎, I'm a stran‎g er here.—.A. Thank‎s, anywa‎yB. It doesn‎'t matte‎rC. Never‎mindD. No probl‎e m.6.Many Chine‎s e unive‎r siti‎e s provi‎d ed schol‎a rshi‎p s for stude‎n ts in need of finan‎c ial .A. assis‎t antB. helps‎C. aidD. crisi‎s7.I will never‎know what was on his mind at the time, nor will_‎_____‎__.A. anyon‎eB. anyon‎e elseC. no oneD. every‎o ne else8.Jim sold most of his thing‎s. He has hardl‎y _____‎__ left in the house‎.A. anyth‎i ngB. every‎t hing‎C. nothi‎n gD. somet‎h i ng9.At the meeti‎ng they discu‎ssed three‎diffe‎rent to the study‎ofmathe‎matic‎s.A. means‎B. waysC. metho‎dsD. appro‎aches‎st night‎I had a terri‎ble cold and ached‎all .A. the wayB. overC. at onceD. right‎11.—We’d like you to start‎work tomor‎row if possi‎ble.—I’m sorry‎, but I can’t possi‎bly start‎until‎Monda‎y. ?A. Do you agree‎with meB. Is that a good ideaC. Do you think‎I’m right‎D. Will that be all right‎12.Energ‎y drink‎s are not allow‎ed in Austr‎alia but are broug‎ht in fromNew Zeala‎nd.A. makin‎gB. to makeC. to be madeD. being‎made13.We are all going‎to the games‎. Why don’t you come ?A. upB. acros‎sC. toD. along‎14.As there‎is less and less coal and oil, scien‎t ists‎are explo‎r ing new ways of makin‎g use ofenerg‎y, such as sunli‎g ht, wind and water‎for power‎and fuel.A. prima‎r yB. alter‎n ativ‎eC. insta‎n tD. uniqu‎e15.the polic‎e thoug‎h t he was the most likel‎y one, since‎they had no exact‎proof‎about‎it, they could‎not arres‎t him.A. Altho‎u ghB. As long asC. If onlyD. As soon as16.Four Chine‎s e model‎s were _____‎_ the 14 peopl‎e award‎e d prize‎s on Frida‎y at the World‎Super‎m odel‎Compe‎t itio‎n.A. among‎B. betwe‎e nC. along‎D. besid‎e17.She set out soon after‎dark home an hour later‎.A. arriv‎ingB. to arriv‎ eC. havin‎g arriv‎edD. and arriv‎ed18.One more week, we will accom‎plish‎the task.A. orB. so thatC. andD. if19.She is to leave‎as soon as possi‎ble.A. hurri‎edB. anxio‎usC. worri‎edD. nervo‎us20.—When shall‎we meet again‎?—Make it day you like; it’s all the same to me.A. oneB. anyC. anoth‎erD. some21.I reall‎y appre‎ciate‎to relax‎with you on this nice islan‎ d.A. to have had timeB. havin‎g timeC. to have timeD. to havin‎g time22.The envir‎onmen‎talis‎ts said wild goats‎’on the vast grass‎land was agood indic‎ation‎of the bette‎r envir‎onmen‎t.A. escap‎ eB. absen‎ceC. atten‎dance‎D. appea‎rance‎23.I don’t of smoki‎ng in the offic‎ e.A. allow‎B. agree‎C. appro‎veD. subsc‎ribe24.He is such a man who is findi‎n g fault‎ wi th other‎ peopl‎e.A. somet‎i m esB. often‎C. alway‎sD. never‎25.The total‎expen‎ses to $ 1,000.A. amoun‎tB. devot‎ eC. apply‎D. appea‎l七、语段翻译My (套房)is locat‎ed in an (古老的)(巷子), at the entra‎nce of which‎stand‎s an (拱形门). From the (角度) of an(业余的)(建筑师)with(抱负), I (欣赏) its(建筑风格). I (呼吁) the resid‎ents to prese‎rve the (古物) our (祖先) left to us. And I (申请) the gover‎nment‎for its resto‎ratio‎n (也). Great‎minds‎think‎(相似地). Final‎ly, my (申请) won the(批准) of the gover‎nment‎and I was (任命) as head (负责) the resto‎ratio‎n progr‎am. We were provi‎ded (足够的)funds‎( (大约) $20,000) to take (合适的)(方法) to resto‎ring the (古物). When the work is (完成), I think‎the (外表) of our(小巷) will look(有活力的) and peopl‎ e will (为……鼓掌) me.八、写出下列单‎词的词性和‎汉语意思。

oracle 按时间创建分区表首先明确分区表和表分区的区别：表分区是一种思想，分区表示一种技术实现。

当表的大小过G 的时候可以考虑进行表分区，提高查询效率，均衡IO 。

oracle 分区表是oracle 数据库提供的一种表分区的实现形式。

表进行分区后，逻辑上仍然是一张表，原来的查询SQL 同样生效，同时可以采用使用分区查询来优化SQL 查询效率，不至于每次都扫描整个表一、分区表基本操作1、按时间分区表创建：1 2 3 4 5 6 7 8 9 10 11 create table t_test (pk_id number(30) not null,add_date_time DATE,constraintPK_T_TEST primary key (pk_id))PARTITION BY RANGE (add_date_time)(PARTITIONt_test_2013_less VALUES LESS THAN (TO_DATE('2013-01-01 00:00:00','yyyy-mm-ddhh24:mi:ss')) TABLESPACE TS_MISPS,PARTITIONt_test_2013 VALUES LESS THAN (TO_DATE('2014-01-01 00:00:00','yyyy-mm-ddhh24:mi:ss')) TABLESPACE TS_MISPS,PARTITION t_test_2014VALUES LESS THAN (TO_DATE('2015-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'))TABLESPACE TS_MISPS)其中add_date_time 为分区字段，每一年一个分区。

插入100W 数据1 2 3 4 5 6 7 declarei int := 1;yearVARCHAR2(20);beginloopyear := CASEmod(i, 3)WHEN 0 THEN8 9 10 11 12 13 14 15 16 17 18 '2012-01-14 12:00:00'WHEN 1 THEN'2013-01-14 12:00:00'ELSE'2014-01-14 12:00:00'END;insert into t_test values(i, to_date(year, 'yyyy-mm-dd hh24:mi:ss'));exit when i= 1000000;i := i + 1;end loop;end;查看分区表的分区的详细信息1 Select table_name,partition_name,high_value fromdba_tab_partitions where table_name='T_TEST';2、分区表修改2.1增加一个分区分两种情况：1.没有maxvalue 分区。

oracle扩展表空间的常用方法监控表空间的使用是DBA的日常工作之一，Oracle扩展表空间很简单，一般有扩展某个数据文件大小或增加新的数据文件两种办法。

举例说明如下。

首先我们要获取某个表空间的数据文件信息：select file_name,file_id,tablespace_name,bytes/1024/1024 fromdba_data_filesorder by file_name根据file_id扩展某个数据文件大小：alter database datafile 12 resize 13312m;要注意的是，如果使用裸设备，一般要先查看LV是否足够，否则以上扩展命令可能出错，查看方式如下：查看VG信息：ERPDB1@/home/oracle>lsvgrootvgoraclevg查看VG的LV：ERPDB1@/home/oracle>lsvg -l oraclevgoraclevg:LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINTdb_oravote raw 1 1 1 closed/syncd N/Adb_oraocr raw 1 1 1 closed/syncd N/Adb_system raw 3 3 1 open/syncd N/Adb_sysaux raw 5 5 1 open/syncd N/Adb_undotbs1 raw 3 3 1 open/syncd N/Adb_undotbs2 raw 3 3 1 open/syncd N/Adb_temp raw 46 46 1 closed/syncd N/Adb_erp_ht2 raw 56 56 1 open/syncd N/Adb_erp2 raw 72 72 1 open/syncd N/A查看VG的详细信息：ERPDB1@/home/oracle>lsvg oraclevgVOLUME GROUP: oraclevg VGIDENTIFIER: 00c65fbf00004c000000011697e0f5f9VG STATE: active PP SIZE: 256 megabyte(s)VG PERMISSION: read/write TOTAL PPs: 2328 (595968 megabytes)MAX LVs: 512 FREE PPs: 1146 (293376 megabytes)LVs: 57 USED PPs: 1182 (302592 megabytes)OPEN LVs: 39 QUORUM: 5 TOTAL PVs: 8 VG DESCRIPTORS: 8STALE PVs: 0 STALE PPs: 0 ACTIVE PVs: 8 AUTO ON: no Concurrent: Enhanced-Capable Auto-Concurrent: DisabledVG Mode: ConcurrentNode ID: 1 Active Nodes:MAX PPs per VG: 130048MAX PPs per PV: 1016 MAX PVs: 128LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: noHOT SPARE: no BBPOLICY: relocatable这里可见还有1146个可用的pp ，根据pp size能计算出VG的容量。

全局（Global）与本地（Local）索引的区别⼀、定义说明oracle数据库中，存在多种对象，最常见的表和索引，索引的⽬的是为了加快查询；oracle建议⼀个表>2g时，就建议进⾏分区，分区表的好处此处省略，分区表有维护操作，但是某些维护操作对整个表的索引维护造成巨⼤开销，因此本地索引就是解决分区表管理的问题。

⾮分区索引创建⽅式，create index index_name on table_name(column_name);查询索引状态从dba_indexes->status列查询全局分区索引创建，create index index_name on table_name(column_name) global partition by range(column_name) (partition p1 values less than (11104) tablespace system,partition p2 values less than (11100) tablespace users,partition p3 values less than (maxvalue) tablespace sysaux.) or partition by hash (id) partitions 8 online等;查询索引状态dba_ind_partitions->STATUS列查询查询分区索引类型，是全局or本地 DBA_PART_INDEXES ->LOCALITY本地分区索引创建，create index index_name on table_name(column_name) local;查询索引状态dba_ind_partitions->STATUS列查询⼆、create/selet 说明1) ⾮分区索引SQL> create index ind_1 on range_part_tab(deal_date);Index created.SQL> select index_name,PARTITION_NAME,HIGH_VALUE,STATUS,TABLESPACE_NAME from dba_ind_partitions where index_owner='SYS' and index_name='IND_1'; no rows selectedSQL> select index_name,STATUS,GLOBAL_STATS,TABLESPACE_NAME from dba_indexes where owner='SYS' and index_name='IND_1';INDEX_NAME STATUS GLO TABLESPACE_NAME------------------------------ -------- --- ------------------------------IND_1 VALID YES SYSTEMSTATUS表⽰⼀个⾮分区索引是否VALID或UNUSABLEGLOBAL_STATUS对于分区索引，指⽰是通过分析整个索引（YES）来收集统计信息，还是根据基础索引分区和⼦分区（NO）的统计信息进⾏估计2）全局分区索引create index ind_3 on range_part_tab(area_code) global partition by range(area_code) (partition p1 values less than (11104) tablespace system,partition p2 values less than (11100) tablespace users,partition p3 values less than (maxvalue) tablespace sysaux)*ERROR at line 1:ORA-14037: partition bound of partition "P1" is too high12:39:59 SYS@ceshi>select area_code,count(*) from range_part_tab group by area_code;AREA_CODE COUNT(*)---------- ----------599 11104594 11074596 11021593 11113595 10927592 11214598 11235591 11169597 111439 rows selected. 全局范围分区索引，第⼀个分区不能⽐所有的值都⼤SYS@ceshi>create index ind_3 on range_part_tab(area_code) global partition by range(area_code) (partition p1 values less than (592) tablespace system,partition p2 values less than (11100) tablespace users,partition p3 values less than (maxvalue) tablespace sysaux); Index created.select index_name,PARTITION_NAME,HIGH_VALUE,STATUS,TABLESPACE_NAME from dba_ind_partitions where index_owner='SYS' and index_name='IND_3'INDEX_NAME PARTITION_ HIGH_VALUE STATUS TABLESPACE_NAME---------- ---------- ------------------------------ -------- ------------------------------IND_3 P1 592 USABLE SYSTEMIND_3 P2 11100 USABLE USERSIND_3 P3 MAXVALUE USABLE SYSAUXPARTITION_NAME 索引的分区名称HIGH_VALUE 索引分区的范围条件STATUS 分区索引的状态SYS@ceshi>selectindex_name,table_name,PARTITIONING_TYPE,SUBPARTITIONING_TYPE,PARTITION_COUNT,LOCALITY,DEF_TABLESPACE_NAME from DBA_PART_INDEXES where index_name='IND_3';INDEX_NAME TABLE_NAME PARTITION SUBPARTIT PARTITION_COUNT LOCALI DEF_TABLESPACE_NAME---------- ------------------------------ --------- --------- --------------- ------ ------------------------------IND_3 RANGE_PART_TAB RANGE NONE 3 GLOBAL SYSTEMhash全局分区索引，使⽤场景较多，例如索引块争⽤，且表为⾮分区表时SYS@ceshi>create table a1 as select * from range_part_tab;SYS@ceshi>create index ind_4 on a1(id) global partition by hash (id) partitions 8 online;Index created.SYS@ceshi>alter index ind_4 parallel 1;Index altered.select index_name,PARTITION_NAME,HIGH_VALUE,STATUS,TABLESPACE_NAME from dba_ind_partitions where index_owner='SYS' and index_name='IND_4'INDEX_NAME PARTITION_NAME HIGH_VALUE STATUS TABLESPACE_NAME------------------------------ ------------------------------ ---------- -------- ------------------------------IND_4 SYS_P61 USABLE SYSTEMIND_4 SYS_P62 USABLE SYSTEMIND_4 SYS_P63 USABLE SYSTEMIND_4 SYS_P64 USABLE SYSTEMIND_4 SYS_P65 USABLE SYSTEMIND_4 SYS_P66 USABLE SYSTEMIND_4 SYS_P67 USABLE SYSTEMIND_4 SYS_P68 USABLE SYSTEM8 rows selected.SYS@ceshi>selectindex_name,table_name,PARTITIONING_TYPE,SUBPARTITIONING_TYPE,PARTITION_COUNT,LOCALITY,DEF_TABLESPACE_NAME from DBA_PART_INDEXES where index_name='IND_4';INDEX_NAME TABLE_NAME PARTITION SUBPARTIT PARTITION_COUNT LOCALI DEF_TABLESPACE_NAME------------------------------ ------------------------------ --------- --------- --------------- ------ ------------------------------IND_4 A1 HASH NONE 8 GLOBAL SYSTEM3）本地分区索引SQL> create index ind_2 on range_part_tab(id) local;Index created.select index_name,PARTITION_NAME,HIGH_VALUE,STATUS,TABLESPACE_NAME from dba_ind_partitions where index_owner='SYS' and index_name='IND_2'INDEX_NAME PARTITION_ HIGH_VALUE STATUS TABLESPACE_NAME------------------ -----------------------------------------------------------------------------------------------------------------------IND_2 P1 TO_DATE(' 2017-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P10 TO_DATE(' 2017-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P11 TO_DATE(' 2017-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P12 TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P2 TO_DATE(' 2017-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P3 TO_DATE(' 2017-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P4 TO_DATE(' 2017-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P5 TO_DATE(' 2017-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P6 TO_DATE(' 2017-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P7 TO_DATE(' 2017-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P8 TO_DATE(' 2017-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P9 TO_DATE(' 2017-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') USABLE SYSTEMIND_2 P_MAX MAXVALUE USABLE SYSTEM13 rows selected.SYS@ceshi>selectindex_name,table_name,PARTITIONING_TYPE,SUBPARTITIONING_TYPE,PARTITION_COUNT,LOCALITY,DEF_TABLESPACE_NAME from DBA_PART_INDEXES where index_name='IND_2';INDEX_NAME TABLE_NAME PARTITION SUBPARTIT PARTITION_COUNT LOCALI DEF_TABLESPACE_NAME---------- ------------------------------ --------- --------- --------------- ------ ------------------------------IND_2 RANGE_PART_TAB RANGE NONE 13 LOCAL三、索引的重建⾮分区索引：SQL> alter index ind_1 rebuild;全局分区索引：SQL> alter table range_part_tab move partition p1;Table altered.SQL> select TABLE_NAME,PARTITION_NAME,TABLESPACE_NAME from dba_tab_partitionswhere TABLE_OWNER='SYS' and TABLE_NAME='RANGE_PART_TAB';TABLE_NAME PARTITION_ TABLESPACE_NAME------------------------------ ---------- ------------------------------RANGE_PART_TAB P1 SYSTEMRANGE_PART_TAB P10 SYSTEMRANGE_PART_TAB P11 SYSTEMSQL> select index_name,PARTITION_NAME,HIGH_VALUE,STATUS,TABLESPACE_NAMEfrom dba_ind_partitions where index_owner='SYS' and index_name='IND_3';INDEX_NAME PARTITION_ HIGH_VALUE STATUS TABLESPACE_NAME---------- ---------- -------------------- -------- ------------------------------IND_3 P1 592 USABLE SYSTEMIND_3 P2 11100 USABLE USERSIND_3 P3 MAXVALUE USABLE SYSAUXSQL> alter index ind_3 rebuild partition p1;Index altered.全局分区索引，单个分区的move并不会导致全局分区索引的失效本地分区索引select index_name,PARTITION_NAME,STATUS,TABLESPACE_NAMEfrom dba_ind_partitions where index_owner='SYS' and index_name='IND_2'; INDEX_NAME PARTITION_ STATUS TABLESPACE_NAME ---------- ---------- -------- ------------------------------IND_2 P1 USABLE SYSTEMIND_2 P10 USABLE SYSTEMIND_2 P11 USABLE SYSTEMIND_2 P12 USABLE SYSTEMSQL> alter table range_part_tab move partition p1;Table alteredSQL> alter index ind_2 rebuild partition p1;Index altered.。