-
编辑 删除
Oracle Linux xargs Command
xargs
-
编辑 删除
ORA-00001 : Unique Constraint Violated caused by DATE VS Timestamp(6)
Date Timestamp(6) ORA-00001
-
编辑 删除
Oracle Reporting 4 - Time Series Calculations
Time series Reporting LAG data densification Pivot Decode
-
编辑 删除
Oracle Reporting 3 - Aggregation Level
Grouping_id Group_ID Oracle SQL
-
编辑 删除
Oracle Reporting 2 - Subtotals and Grand Total
Oracle subtotal grand total
-
编辑 删除
Oracle Reporting 1 - Ratio_to_Report Function
Ratio_to_report Percentage Performance
-
编辑 删除
ORA-00845: MEMORY_TARGET not supported on this system
Oracle Linux Database ORA_00845 Memory
-
编辑 删除
Oracle nologging
Nologging direct-path insert redo
-
编辑 删除
Linux sed Tips
--Removing the last comma from each line.sed 's/,$//' xxx.file
-
编辑 删除
Oracle Database Compression 2 - Advanced/OLTP Compression
Advanced OLTP Compression
-
编辑 删除
Oracle Database Compression 3 - Hybrid Columnar Compression
Hybrid Columnar CompressionHybrid Columnar Compression is a feature of the Enterprise Edition of Oracle Database 11g that is dependent on the underlying storage system. Only Exadata storage, ZFS storage, and Pillar Axiom 600 storage support Hybrid Columnar Compression.With Hybrid Columnar Compres...
-
编辑 删除
Oracle Database Compression 1 - Basic Compression
Basic Compression value repetition
-
编辑 删除
Oracle Timezone
Oracle Timezone systimestamp current_timestamp timestamp with local timezone timestamp with time zone
-
编辑 删除
Linux Ctrl Z
Ctrl +Z brings a process into background. For instance, while you're editing a file using vi, hitting Ctrl+z brings user back to command line, and makes vi run as a background process.Use jobs command to list all background process.Use fg % to bring the process back.
-
编辑 删除
SELinux tips
Closing SELinuxset enforce 0
-
编辑 删除
Oracle Lock Information Queries
--Find out what objects are locked.select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machinefrom v$locked_object a , v$session b,&n...
-
编辑 删除
Setting up Samba3.6.9 on Oracle Linux 6
Samba Oracle Linux Windows
-
编辑 删除
GoldenGate Tips
Download the OGG for Oracle 11g 64 bit for Windows 64bit.ggs_Windows_x64_ora11g_64bit.zip
-
编辑 删除
Getting Approximate Row Count of a Huge File
This blog is originated from stackoverflow.comStep 1: head -n filename > newfile // get the first n lines into newfile，e.g. n =5Step 2: Get the huge file size, AStep 3: Get the newfile size,BStep 4: (A/B)*n is approximately equal to the exact line count.Set n to ...
-
编辑 删除
Export with Spool and Parallel Utl_File
Parallel Utl_File spool
