/explore
|
You are here 
|
tanelpoder.com | ||
| | | | |
antognini.ch
[AI summary] A collection of technical blog posts discussing Oracle Database performance tuning, troubleshooting, query optimizer features, and script updates for various database versions. |
|
| | | | | ||
| | | | |
hackaday.io
I've posted the scripts used to generate the anti-aliased text used in the User Interface. The first is a Photoshop script,CreateFontData.jsx. This makes a set of PNG files, one for each character. The second isConvertText.py, a Python script that takes the output of CreateFontData and generates C code for display the characters on the Epson LCD used in the project. Note these scripts have some hard-coded pathnames in them (to the development folder) but this is pretty easy to find and modify. |
|
| | | | | ||
| | | | |
blog.tanelpoder.com
In recent past I've blogged few scripts which use specially crafted ordered nested loop for sampling contents of V$ and X$ views fast, with plain SQL. If you haven't read them yet, here are the links: WaitProf LatchProf LatchProfX I wrote the above scripts having special purposes in mind (e.g. profile session waits or latching activity). Now I introduce a simple but powerful sqlplus script for ad-hoc sampling of any V$ view. It's called.... (drumroll) .... sample.sql :) When you look into it, the script ... |
|
| | | | | ||
| | | | |
iusoltsev.wordpress.com
465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT... |
|
| | | |||
