/     !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ contents[[Ljava/lang/Object;()VCodeLineNumberTable getContents()[[Ljava/lang/Object; SourceFile SdoaMsg.java  [Ljava/lang/Object;java/lang/Object0003 &Connect ...0004 &Disconnect0002&View0130&Clear Display0016 Zoom &Out0015Zoom &In0039Zoom &To0524Reasonable &Size0525 &Extent ...0040 &Rectangle0041 &Geometry ..0527Draw Without &Warning0528Show Position of &Cursor0529 Show Ti&ps0515&Layer0001&Add Layer ...0118Add &Layer ...0530&Edit Layer ...0531 Draw All Geometries in &Viewport0018Draw All Geometries in Viewport0532Draw Geometries in &Layer ...0533&Remove Layer ...0534Remo&ve All Layers0535Remove Quer&y ...0536Remove All Que&ries0033&Query0516&Rectangle ...0517 &Circle ...0518 &Polygon ...0540 Poin&t ...0519 &Geometry ...0005Inde&x0537Show Area-of-&Interest Tiles0538Show &Fixed-Size Tiles0539Show &Variable-Size Tiles0522&Analyze Index ...0520&Create Index ...0521&Modify Index ...0523 &Drop Index0032Zoom0006 Add Layer0007KShow all geometries with the following relationship to the selected region:00080009Show Area-of-Interest Tiles0010Show Fixed-Size Tiles0011Show Variable-Size Tiles0012Hide Area-of-Interest Tiles0013Hide Fixed-Size Tiles0014Hide Variable-Size Tiles0017Zoom to Rectangle0019Query Rectangle0020Draw All Geometries0021Zoom to Reasonable Size0022Stop0023Oracle Spatial Index Advisor0128Spatial Index Advisor0024OK0025Cancel0026 Select Area Of Interest Geometry0027NShow all geometries with the following relationship to the specified geometry:0028Show Relationship Based On0029 Primary Filter Only (SDO_FILTER)0030 Spatial Interaction (SDO_RELATE)0031&Spatial Distance (SDO_WITHIN_DISTANCE)0115Nearest Neighbor (SDO_NN)0034 Attribute:0035Value:0036 Select Layer:0037Select Geometry in Layer0038Viewport0042 Select Layer0043 oracle.com0044iSelect the layer (table and column) that you would like to analyze. You can add subsequent layers later.0045Color:0046 ANYINTERACT0056CONTAINS0047 COVEREDBY0048COVERS0049DISJOINT0050EQUAL0051INSIDE0129ON0052OUTSIDE0053OVERLAPBDYDISJOINT0054OVERLAPBDYINTERSECT0055TOUCH0057Change Database Connection ...0058 a database0059&About Oracle Spatial Index Advisor ...0060 Using Help0061Search for Help on ...0062Contents0063Alias:0064 Fixed Tiles0065Variable Tiles0066Area of Interest Tiles0067Legend0068Current Layer:0069Draw on Zoom or Pan0070Properties ...0071Layer Information0072General0073Layer Description0074Service:0075Schema:0076Table:0077Column:0078Display Information0079Display in viewport0080Queries0081Query Description0082Close0083dSelect the layer or layers to remove. The Advisor will remove the layer and its associated queries.0084;Select the layer whose query or queries you want to remove.0085&Select the query or queries to remove.0086*The Advisor can draw all of the geometries that are in the layer. However, if the layer is large and the data is very dense, then this operation may take a very long time. To just get an idea where some of the data resides, you may instead choose to draw only some of the geometries in the layer.0087Draw0088"All of the geometries in the layer0089#Some of the geometries in the layer0090Geometries starting at row:0091Number of geometries to draw:0117Select the layer containing the geometry that you wish to zoom to. Note that the selected layer will not become the new "Current Layer".0119@Select the attributes for the geometry that you wish to zoom to.0126Layer: 0092ASelect the geometry which should become the focus of the display.0093The layer has an extent defined as part of its metadata. The Advisor can compute the dimensions of a bounding rectangle that encloses all the geometries in the layer. For a large layer, it may take several minutes to compute this rectangle.0094The metadata extent0095The computed bounding rectangle0096Specify the coordinate around which the Advisor should center the display. The Advisor will show a reasonable size area around this point. 0097 coordinate:0098,0099$Select the geometry to query against0100Zoom To0101&Analyze0102Recommendation0103A hybrid index contains both fixed-sized and variables-sized tiles. The tiling level (sdo_level) is used to compute the fixed-sized tiles. The number of tiles per geometry (sdo_numtiles) is used to compute the variable-sized tiles. In order to get optimal performance from the index, at least 50% of the variable-sized tiles should be different from the fixed-sized files. When you click the Analyze button, the Advisor will compute the percentage of tiles that are different. This computation may take several minutes for a large layer.0104Apply0105"The layer contains only point data0106 Distance:0107Use primary filter only01080109 Version 9.0.00110!Copyright (c) 1998, 2004, Oracle.0111All Rights Reserved0112Within Distance of:0113Units:0114Primary Filter Only0116Number of Nearest Neighbors:0124Query0125Geometry0122Graphical Selection0123Free SQL0120 Table Column0121Datatype0127 WHERE clause:0500Layer0501 Tessellation0526Coordinate ...0541 Remove Layer0542Zoom to Geometry0543 Query Circle0544 Query Polygon0545Query Geometry0546 Edit Layer0547 Remove Query0548Draw Geometries in the Layer0549Zoom to Extent0550Zoom to Coordinate0551 Analyze Index0552 Query Point1000:Do you really want to remove all objects from the display?1001Do you really want to exit?1002The Advisor can only work on layers that have the same extents. Do you want to remove all the layers that you are currently working on and replace them with the selected layer?1003ZThis operation will erase the query results. Do you want to continue with this operation?1004ZThis operation will erase all query results. Do you want to continue with this operation?1005pThis operation will erase the current layer and the query results. Do you want to continue with this operation?1006ZThis operation will erase the current layer. Do you want to continue with this operation?1007SThis operation will erase all layers. Do you want to continue with this operation?1008pThis operation will erase all layers other than the current layer. Do you want to continue with this operation?1009This operation will erase all layers other than the current layer and the query results. Do you want to continue with this operation?1010iThis operation will erase all layers and the query results. Do you want to continue with this operation?1011This operation will erase the query results and the fixed and/or variable sized tiles. Do you want to continue with this operation?1012This operation will erase the current layer, the query results and the fixed and/or variable sized tiles. Do you want to continue with this operation?1013nThis operation will erase the fixed and/or variable sized tiles. Do you want to continue with this operation?1014This operation will erase the current layer and the fixed and/or variable sized tiles. Do you want to continue with this operation?1015This operation will erase all layers, the query results and the fixed and/or variable sized tiles. Do you want to continue with this operation?1016}This operation will erase all layers and the fixed and/or variable sized tiles. Do you want to continue with this operation?1017{Drawing the layer in the specified viewport may take a long time if the data is very dense. Are you sure you want to draw?1018QDrawing a non-indexed layer may take a long time. Are you sure you want to draw?1019The Advisor cannot work on indexed and non-index layers at the same time. Do you want to remove all the layers that you are currently working on and replace them with the selected layer?1020[Drawing all the geometries in a layer may take a long time. Are you sure you want to draw?1022iDrawing the specified rows may take a long time if the data is dense. Are you sure you want to continue?1021nQuerying the specified area may take a long time. Are you sure you want to continue with the query operation?1023UThis operation will drop the index {0}. Do you want to continue with this operation?2000vThe Spatial Index Advisor only supports Oracle Databases version 8.1.6 or newer that have the Spatial Option installed2001%This layer is already being displayed2002No database has been discovered. Please use the Enterprise Manager console to discover at least one database before starting the application2003OUnable to process geometries. The geometries must have at least two dimensions20042This alias is already being used by another object2005GThis alias is not valid. It is the same as the description of an index20063The selected rectangle must have a height and width2007(The selected circle must have a diameter2008&The selected polygon must have an area2009BThe edges of the selected polygon cannot intersect with each other20104There is no geometry matching the specified criteria20118You do not have sufficient privileges to create an index20128You do not have sufficient privileges to modify an index2013The selected layer and the current layer have different extents. Please use the table property sheet to specify the spatial reference ID for both layers.20145No spatial geometry data was found for this database.2500 {0} ({1}={2})2501 {0} {1}@{2}2502{0}2503{0}{1}2504{0}_Q2505 ({0},{1})2506!Perform a query against layer {0}2507Execution time: {0} seconds2508(Execution time: {0} seconds (Incomplete)25125The Current Layer {0} Contains Only Single Point Data2509{0}% of the variable tiles are the same as the fixed-sized tiles. The number of variable tiles is tuned for optimal performance.2510{0}% of the variable tiles are the same as the fixed-sized tiles. This is not optimal. You should decrease the tiling level (sdo_level) to reduce this percentage.2511{0}% of the variable tiles are the same as the fixed-sized tiles. This is not optimal. You should increase the number of tiles per geometry (sdo_numtiles) to reduce this percentage.3000{0} is now the current layer3002There is now no current layer3001Drew {0} geometries3003Drew 1 geometry3004Draw was interrupted3005Interrupting draw3500Click on the location that you want to zoom to. Click the stop button (on the toolbar) or press the escape key to cancel this operation.3501Position the mouse pointer at the end point for the rectangle, and press and hold down the left mouse button. Then drag the mouse to the opposite end point and release the button.3502Zoom in on an area that you are interested in. The simplest way to do this is to use the Zoom to Reasonable Size operation on the View menu. You can then examine the index in detail.3503The data displayed below represents a typical sized query for the tiling parameters you have chosen. You may want to try panning around or zooming to areas that may be more dense. If there is too much data displayed, increase the tiling level (SDO_LEVEL). If there is not enough data displayed, decrease the tiling level. To help you decide how much to increase or decrease the tiling level, use the Show Fixed-size Tiles or Show Area-Of-Interest Tiles operation on the Index menu. If there is an appropriate amount of data displayed, try zooming in and out to see if the data is tuned appropriately and query performance is acceptable.3504ZFixed sized tiles are used to approximate the geometries. The tiles displayed below help you understand how many geometries are associated with each tile. If you think too many geometries are associated with a fixed tile, you can make the tiles smaller by reindexing with a smaller tile size (i.e., add 1 to the current tiling level). If you think not enough geometries are associated with a fixed tile, you can make the tiles larger by reindexing with a larger tile size (i.e., subtract 1 from the current tiling level). Increasing or decreasing SDO_LEVEL by 1 will modify tiles by a factor of 4.3505;The percentage of fixed tiles that equal variable tiles should not exceed 50 for the entire layer. The display below may or may not represent the entire layer. To get the exact percentage, you can run the Analyze Index operation on the Index menu. If the percentage is too high, you need to decrease the tiling level, or increase the number of tiles per geometry (SDO_NUMTILES). The number of tiles must be greater than or equal to 4 and not larger than 8. Decreasing the tiling level (SDO_LEVEL) by 1 will increase the size of the fixed sized tiles by a factor of 4.3506Look at the variable and fixed tiles together to make sure that you have the proper ratio of fixed to variable tiles. Aside from visualizing the tiles together, you can execute the Analyze Index operation (on the Index menu) to find out the exact ratio.3509The current area is now a good size to display. Click the Draw All Geometries in Viewport button to see the geometries in the viewport.3510Continue to zoom in the display until you get to a small area. The simplest way to do this is to use the Zoom to Reasonable Size operation on the View menu. You can then draw the geometries and examine the index in detail.3513The viewport now contains the full extent of the layer. Drawing an entire layer may be a time consuming operation. Zoom into the area that contains some geometries that you are interested in. The simplest way to do this is to use the Zoom to Reasonable Size operation on the View menu. If you do not know where the geometries are, use the Draw Geometries in Layer operation on the Layer menu, specifying that it draw some of the geometries.3515The viewport now contains a reasonable number of geometries. Use the Draw All Geometries in Viewport operation on the Layer menu to see the geometries.3514The viewport now contains too many geometries to draw in a reasonable amount of time. Zoom into the area that contains some geometries that you are interested in. The simplest way to do this is to use the Zoom to Reasonable Size operation on the View menu.3516zYou have added a non-indexed layer. You can zoom in and out, zoom to rectangle, and draw all the geometries in the layer.3517HClick the Add Layer button to select the layer that you want to analyze.3518xThe current layer is not indexed. You can zoom in and out, zoom to rectangle, and draw all the geometries in the layer.3519iIf this was a typical query and the performance was not acceptable, consider increasing the tiling level.3520Executing the specified query and displaying the results. Click the stop button (on the toolbar) or the escape key to cancel this operation.3521Executing a query to get all the geometries in the current viewport and displaying the results. Click the stop button (on the toolbar) or the escape key to cancel this operation.3522Getting all the geometries in the layer and drawing them. Click the stop button (on the toolbar) or the escape key to cancel this operation.3523Executing a query to get all the tiles in the current viewport and displaying the results. Click the stop button (on the toolbar) or the escape key to cancel this operation.3524Position the mouse pointer at the center of the circle, and push and hold the left mouse button. Then drag the mouse to any point on the desired circumference and release the button.3525Position the mouse pointer where you would like the polygon to start and click the left mouse button. Then click on each remaining vertex except the last, and double-click on the last vertex to complete the polygon.3526Executing a query to the geometries in the specified rows and displaying the results. Click the stop button (on the toolbar) or press the escape key to cancel this operation.3527Click on the location that you want to query against. Click the stop button (on the toolbar) or press the escape key to cancel this operation.3528Position the mouse pointer at the end point for the rectangle that you want to query against, and press and hold down the left mouse button. Then drag the mouse to the opposite end point and release the button.oracle/sysman/resources/SdoaMsgjava/util/ListResourceBundle!oracle/sysman/resources/SdoaMsgID!*`HYYSYSSYYSYSSYY SY SSYY SY SSYY SYSSYYSYSSYYSYSSYYSYSSYYSYSSY YSYSSY YSYSSY YSYSSY YSYSSY YSY SSYY!SY"SSYY#SY$SSYY%SY&SSYY'SY(SSYY)SY*SSYY+SY,SSYY-SY.SSYY/SY0SSYY1SY2SSYY3SY4SSYY5SY6SSYY7SY8SSYY9SY:SSYY;SYSSYY?SY@SSYYASYBSSYYCSYDSSY YESYFSSY!YGSYHSSY"YISYJSSY#YKSYLSSY$YMSYNSSY%YOSYPSSY&YQSYRSSY'YSSYTSSY(YUSYVSSY)YWSYXSSY*YYSYVSSY+YZSY[SSY,Y\SY]SSY-Y^SY_SSY.Y`SYaSSY/YbSYcSSY0YdSYeSSY1YfSYgSSY2YhSYiSSY3YjSYkSSY4YlSYmSSY5YnSYoSSY6YpSYqSSY7YrSYsSSY8YtSYuSSY9YvSYwSSY:YxSYySSY;YzSY{SSY<Y|SY}SSY=Y~SYSSY>YSYSSY?YSYSSY@YSYSSYAYSYSSYBYSYSSYCYSYSSYDYSYSSYEYSYSSYFYSYSSYGYSYSSYHYSYSSYIYSYSSYJYSYSSYKYSYSSYLYSYSSYMYSYSSYNYSYSSYOYSYSSYPYSYSSYQYSYSSYRYSYSSYSYSYSSYTYSYSSYUYSYSSYVYSYSSYWYSYSSYXYSYSSYYYSYSSYZYSYSSY[YSYSSY\YSYSSY]YSYSSY^YSYSSY_YSYSSY`YSYSSYaYSYSSYbYSYSSYcYSYSSYdYSYSSYeYSYSSYfYSYSSYgYSYSSYhYSYSSYiYSYSSYjYSYSSYkYSYSSYlYSYSSYmYSYSSYnYSYSSYoYSYSSYpYSYSSYqYSYSSYrYSYSSYsYSYSSYtYSYSSYuYSYSSYvYSYSSYwYSYSSYxYSYSSYyYSYSSYzYSYSSY{YSYSSY|YSYSSY}YSYSSY~YSYSSYYSYSSYYSYSSYYSYSSYYSY SSYY SY SSYY SY SSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYsSSYYSYSSYYSY SSYY!SY"SSYY#SY$SSYY%SY&SSYY'SY(SSYY)SY*SSYY+SY,SSYY-SY.SSYY/SY0SSYY1SY2SSYY3SY4SSYY5SY6SSYY7SY8SSYY9SY:SSYY;SYSSYY?SY@SSYYASYBSSYYCSYDSSYYESYFSSYYGSYHSSYYISYJSSYYKSYLSSYYMSYNSSYYOSYPSSYYQSYRSSYYSSYTSSYYUSYVSSYYWSYXSSYYYSYZSSYY[SY\SSYY]SY^SSYY_SY`SSYYaSYbSSYYcSYdSSYYeSYfSSYYgSYhSSYYiSYjSSYYkSYlSSYYmSYnSSYYoSYpSSYYqSYrSSYYsSYtSSYYuSYvSSYYwSYxSSYYySYzSSYY{SY|SSYY}SY~SSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSSYYSYSS