Laimis Oracle blog | Oracle database issues diary

Laimis Oracle blog | Oracle database issues diary:

"v$event_histogram

- Sent using Google Toolbar"

"set linesize 160
set pagesize 100

column 'Seconds' format 99999990.99
column 'Gets/Exec' format 99999990.99
column 'Reads/Exec' format 99999990.99
column 'Rows/Exec' format 99999990.99
column 'version_count' format 99999999

Prompt Top 10 by CPU:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
hash_value, cpu_time/(1000000) 'Seconds'
FROM V$SQLAREA
WHERE cpu_time > 10000
ORDER BY 3 DESC)
WHERE rownum <= 10 ;

Prompt Top 10 by Buffer Gets:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
buffer_gets, executions, buffer_gets/executions 'Gets/Exec',
hash_value,address
FROM V$SQLAREA
WHERE buffer_gets > 10000
AND executions != 0
ORDER BY buffer_gets DESC)
WHERE rownum <= 10;

Prompt Top 10 by Physical Reads:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
disk_reads, executions, disk_reads/executions 'Reads/Exec',
hash_value,address
FROM V$SQLAREA
WHERE disk_reads > 1000
AND executions != 0
ORDER BY disk_reads DESC)
WHERE rownum <= 10;

Prompt Top 10 by Executions:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
executions, rows_processed, rows_processed/executions 'Rows/Exec',
hash_value,address
FROM V$SQLAREA
WHERE executions > 100
ORDER BY executions DESC)
WHERE rownum <= 10;

Prompt Top 10 by Parse Calls:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
parse_calls, executions, hash_value,address
FROM V$SQLAREA
WHERE parse_calls > 1000
ORDER BY parse_calls DESC)
WHERE rownum <= 10;

Prompt Top 10 by Sharable Memory:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
sharable_mem, executions, hash_value,address
FROM V$SQLAREA
WHERE sharable_mem > 1048576
ORDER BY sharable_mem DESC)
WHERE rownum <= 10;

Prompt Top 10 by Version Count:

SELECT * FROM
(SELECT substr(sql_text,1,80) sql,
version_count, executions, hash_value,address
FROM V$SQLAREA
WHERE version_count > 20
ORDER BY version_count DESC)
WHERE rownum <= 10;


- Sent using Google Toolbar"

turn off screen monitor

^!m::
{
Sleep 500
SendMessage 0x112, 0xF170, 2,, Program Manager
}

HP17 aHK

F10::Volume_Up
F9::Volume_Down

;send space for vlc player. for 5 in numpad wher numpad is off
NumpadClear::
{
If WinActive("ahk_class QWidget")
{
Send {Space}
return
}
}

/*
SC15D::
{
Send {PgUp}
return
}
return
*/

SC15D & RIGHT::Send #{RIGHT}
SC15D & LEFT::Send #{LEFT}

!x::Send {Up 10}
!,::Send {Up 10}
!.::Send {Up 10}

turn off monitor --RadilaMenu

Sleep 500
SendMessage 0x112, 0xF170, 2,, Program Manager

taskbar - autohide script

run Rundll32.exe C:\WINDOWS\SYSTEM32\SHELL32.DLL`,Options_RunDLL 1
title := "Taskbar and Start Menu Properties"
WinWaitActive %title%,,5
if ErrorLevel
TrayTip,, failed (probably) try again

;ControlGetText,text,Button2
ControlGet, text, Checked,, Button2

;msgbox %text%

ControlSend, Button2,{Space} , %title%
Sleep,500
ControlClick, OK, %title%
Sleep,100
WinClose %title%

Quick Launch - Taskbar and start menu properties

Quick Launch - AutoIt Forums: "This is my way of achieving this


Run('Rundll32.exe SHELL32.DLL,Options_RunDLL 1')
WinWait('Taskbar and Start Menu Properties')
ControlCommand('Taskbar and Start Menu Properties','','Button5','Check')
Sleep(2000)
ControlClick('Taskbar and Start Menu Properties','','Button13')
ControlClick('Taskbar and Start Menu Properties','','Button11')


- Sent using Google Toolbar"

Folder Menu Function

Folder Menu Function: "- Sent using Google Toolbar"

What code should I use to show/make custom context menu?

What code should I use to show/make custom context menu?: "menu, menuname, add, Item &1, Item_1
menu, menuname, add, Item &2, Item_2
menu, menuname, add, Item &3, Item_3

menu, menuname2, add, Item &4, Item_4
menu, menuname2, add, Item &5, Item_5
menu, menuname2, add, Item &6, Item_6

Menu, context, add, &Menu Name, :menuname
Menu, context, add,
Menu, context, add, &Menu Name 2, :menuname2

MButton::Menu, context, Show

Item_1:
Item_2:
Item_3:
Item_4:
Item_5:
Item_6:
MsgBox %A_ThisMenu% %A_ThisMenuItem%
Return

- Sent using Google Toolbar"