Monday Jun 22, 2015

SQL Developer,SQLcl: INFO+コマンド

INFOおよびINFO+コマンドはDESCRIBEコマンドの拡張のような感じで使えます。
以下のエントリーでは表統計を取ってない状態で実行しました。

Excel分析ツール"t検定"をOracleで実行 (INOUE Katsumi @ Tokyo)

SQL DeveloperおよびSQLclというツールのINFOコマンドの出力です

以下は別テーブルですが統計を取った後です。最大値、最小値、一意の値の数、インメモリーおよびインデックスの情報も出力されます。

SQL>  info+ lineorder
TABLE: LINEORDER
         LAST ANALYZED:2014-12-04 15:02:32.0
         ROWS         :47989007
         SAMPLE SIZE  :47989007
         INMEMORY     :ENABLED
         COMMENTS     : 

Columns
NAME               DATA TYPE       NULL  DEFAULT    LOW_VALUE   HIGH_VALUE   NUM_DISTINCT   HISTOGRAM

 LO_ORDERKEY       NUMBER          Yes                  1           48000000     11834368       NONE
 LO_LINENUMBER     NUMBER          Yes                  1           7            7              NONE
 LO_CUSTKEY        NUMBER          Yes                  1           239999       160416         NONE
 LO_PARTKEY        NUMBER          Yes                  1           600000       600704         NONE
 LO_SUPPKEY        NUMBER          Yes                  1           16000        16000          NONE
 LO_ORDERDATE      NUMBER          Yes                  19920101    19980802     2406           NONE
 LO_ORDERPRIORITY  CHAR(15 BYTE)   Yes                                           5              FREQUENCY
 LO_SHIPPRIORITY   CHAR(1 BYTE)    Yes                                           1              NONE
 LO_QUANTITY       NUMBER          Yes                  1           50           50             FREQUENCY
 LO_EXTENDEDPRICE  NUMBER          Yes                  90098       10494950     1046528        NONE
 LO_ORDTOTALPRICE  NUMBER          Yes                  83168       56963813     10000384       NONE
 LO_DISCOUNT       NUMBER          Yes                  0           10           11             FREQUENCY
 LO_REVENUE        NUMBER          Yes                  81269       10489850     5833216        NONE
 LO_SUPPLYCOST     NUMBER          Yes                  54058       125939       14535          NONE
 LO_TAX            NUMBER          Yes                  0           8            9              NONE
 LO_COMMITDATE     NUMBER          Yes                  19920131    19981031     2466           NONE
 LO_SHIPMODE       CHAR(10 BYTE)   Yes                                           7              FREQUENCY  

Indexes
INDEX_NAME   UNIQUENESS  STATUS  FUNCIDX_STATUS  COLUMNS      COLUMN_EXPRESSION  
SSB.STEP3_3  NONUNIQUE   VALID                   LO_ORDERKEY

PL/SQLパッケージに対しても使えます。

Tuesday Jun 16, 2015

Java FX usage tracing on SQL Developer

I hope it is well known by now that part of SQL Developer is implemented in JavaFX

» Oracle SQL Developer version 4.1 is Now Available

it requires Java FX

I tried tracing SQL Developer for JavaFX and got the result below.
I hope this gives some ideas what JavaFX is.

$ JAVA_TOOL_OPTIONS="-Dprism.forceGPU=true -Dprism.verbose=true" /c/c/sqldeveloper.41/sqldeveloper.exe
Prism pipeline init order: d3d sw
Using native-based Pisces rasterizer
Using dirty region optimizations
Not using texture mask for primitives
Not forcing power of 2 sizes for textures
Using hardware CLAMP_TO_ZERO mode
Opting in for HiDPI pixel scaling
Prism pipeline name = com.sun.prism.d3d.D3DPipeline
Loading D3D native library ... succeeded.
D3DPipelineManager: Created D3D9Ex device
Direct3D initialization succeeded
(X) Got class = class com.sun.prism.d3d.D3DPipeline
Initialized prism pipeline: com.sun.prism.d3d.D3DPipeline
Maximum supported texture size: 8192
Maximum texture size clamped to 4096
OS Information:
        Windows 7 build 7601
D3D Driver Information:
        Intel(R) HD Graphics Family
        \\.\DISPLAY1
        Driver igdumdim64.dll, version 10.18.10.3574
        Pixel Shader version 3.0
        Device : ven_8086, dev_0A16, subsys_05CB1028
        Max Multisamples supported: 4
 vsync: true vpipe: true
Loading Prism common native library ... succeeded.
PPSRenderer: scenario.effect - createShader: LinearConvolve_8
PPSRenderer: scenario.effect - createShader: Blend_SRC_IN
About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Categories
Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today