[spmarket 2]Spotify Reveals The Top Wedding Songs Globally [/spmarket]

Originally posted on Spotify Blog:

[spmarket 2]In many parts of the world, it’s Wedding Season! So if you’re still thinking about that perfect song for your first moments’ as a married couple, Spotify can help! Today, Spotify revealed that multi-award winning singer-songwriter John Legend’s ballad All of Me is the top choice for tying the knot around the globe. Mellow-rocker Jason Mraz is the world’s favorite artist for matrimonial music, with two of his tracks featuring in the global top 20 list.

Spotify analyzed over 400,000 wedding themed playlists worldwide, also identifying Bruno Mars’ Marry You, Ed Sheeran’s Thinking Out Loud and even Robin Thicke’s Blurred Lines as among the most popular wedding music.

Analysis of ‘First Dance’ playlists revealed that British crooner Ed Sheeran is the most popular artist globally for the all-important first dance, with his tracks Tenerife Sea and Thinking Out Loud featuring in the top 5, Jason Mraz, Etta James…

View original 142 more words

House of Cards – Season 3

pazyp:

House of cards day.

Originally posted on The Big Picture:

hoc_key_013_h.jpg

I know this is a movie blog, but I thought I’d mix things up a bit by reviewing a TV show in this post instead. That show just happens to be ‘House of Cards’.

As many of you will know, Season 3 of the political drama screened on Netflix last Friday, and me and my better half decided to take a day out of work and binge-watch the whole thing! Seeing in the new season in style, we stacked the fridge with beer and dished up a few southern-fused recipes in honour of the show’s villainous protagonist, Frank Underwood.

image2image1

A lot of my friends and blog regulars are also big fans of the show, so I’ve promised not to reveal any spoilers in this post. Instead, I will offer a general synopsis of what one can expect from the show’s recurring character, and some new ones to look out for!

View original 1,480 more words

Weekly script #3 unix_usr.sql

I use this one all the time. You have a high usage unix PID that is an Oracle Process. The script will take your defined pid and lookup the relating SQL and database user details to help you figure out the root cause.


set serveroutput on size 50000
set echo off feed off veri off
accept 1 prompt 'Enter Unix process id: '

DECLARE
v_sid number;
s sys.v_$session%ROWTYPE;
p sys.v_$process%ROWTYPE;
BEGIN
begin
select sid into v_sid
from sys.v_$process p, sys.v_$session s
where p.addr = s.paddr
and (p.spid = &&1
or s.process = '&&1');
exception
when no_data_found then
dbms_output.put_line('Unable to find process id &&1!!!');
return;
when others then
dbms_output.put_line(sqlerrm);
return;
end;

select * into s from sys.v_$session where sid = v_sid;
select * into p from sys.v_$process where addr = s.paddr;

dbms_output.put_line('=====================================================================');
dbms_output.put_line('SID/Serial : '|| s.sid||','||s.serial#);
dbms_output.put_line('Foreground : '|| 'PID: '||s.process||' - '||s.program);
dbms_output.put_line('Shadow : '|| 'PID: '||p.spid||' - '||p.program);
dbms_output.put_line('Terminal : '|| s.terminal || '/ ' || p.terminal);
dbms_output.put_line('OS User : '|| s.osuser||' on '||s.machine);
dbms_output.put_line('Ora User : '|| s.username);
dbms_output.put_line('Status Flags: '|| s.status||' '||s.server||' '||s.type);
dbms_output.put_line('Tran Active : '|| nvl(s.taddr, 'NONE'));
dbms_output.put_line('Login Time : '|| to_char(s.logon_time, 'Dy HH24:MI:SS'));
dbms_output.put_line('Last Call : '|| to_char(sysdate-(s.last_call_et/60/60/24), 'Dy HH24:MI:SS') || ' - ' || to_char(s.last_call_et/60, '990.0') || ' min');
dbms_output.put_line('Lock/ Latch : '|| nvl(s.lockwait, 'NONE')||'/ '||nvl(p.latchwait, 'NONE'));
dbms_output.put_line('Latch Spin : '|| nvl(p.latchspin, 'NONE'));

dbms_output.put_line('Current SQL statement:');
for c1 in ( select * from sys.v_$sqltext
where HASH_VALUE = s.sql_hash_value order by piece) loop
dbms_output.put_line(chr(9)||c1.sql_text);
end loop;

dbms_output.put_line('Previous SQL statement:');
for c1 in ( select * from sys.v_$sqltext
where HASH_VALUE = s.prev_hash_value order by piece) loop
dbms_output.put_line(chr(9)||c1.sql_text);
end loop;

dbms_output.put_line('Session Waits:');
for c1 in ( select * from sys.v_$session_wait where sid = s.sid) loop
dbms_output.put_line(chr(9)||c1.state||': '||c1.event);
end loop;

-- dbms_output.put_line('Connect Info:');
-- for c1 in ( select * from sys.v_$session_connect_info where sid = s.sid) loop
-- dbms_output.put_line(chr(9)||': '||c1.network_service_banner);
-- end loop;

dbms_output.put_line('Locks:');
for c1 in ( select /*+ ordered */
decode(l.type,
-- Long locks
'TM', 'DML/DATA ENQ', 'TX', 'TRANSAC ENQ',
'UL', 'PLS USR LOCK',
-- Short locks
'BL', 'BUF HASH TBL', 'CF', 'CONTROL FILE',
'CI', 'CROSS INST F', 'DF', 'DATA FILE ',
'CU', 'CURSOR BIND ',
'DL', 'DIRECT LOAD ', 'DM', 'MOUNT/STRTUP',
'DR', 'RECO LOCK ', 'DX', 'DISTRIB TRAN',
'FS', 'FILE SET ', 'IN', 'INSTANCE NUM',
'FI', 'SGA OPN FILE',
'IR', 'INSTCE RECVR', 'IS', 'GET STATE ',
'IV', 'LIBCACHE INV', 'KK', 'LOG SW KICK ',
'LS', 'LOG SWITCH ',
'MM', 'MOUNT DEF ', 'MR', 'MEDIA RECVRY',
'PF', 'PWFILE ENQ ', 'PR', 'PROCESS STRT',
'RT', 'REDO THREAD ', 'SC', 'SCN ENQ ',
'RW', 'ROW WAIT ',
'SM', 'SMON LOCK ', 'SN', 'SEQNO INSTCE',
'SQ', 'SEQNO ENQ ', 'ST', 'SPACE TRANSC',
'SV', 'SEQNO VALUE ', 'TA', 'GENERIC ENQ ',
'TD', 'DLL ENQ ', 'TE', 'EXTEND SEG ',
'TS', 'TEMP SEGMENT', 'TT', 'TEMP TABLE ',
'UN', 'USER NAME ', 'WL', 'WRITE REDO ',
'TYPE='||l.type) type,
decode(l.lmode, 0, 'NONE', 1, 'NULL', 2, 'RS', 3, 'RX',
4, 'S', 5, 'RSX', 6, 'X',
to_char(l.lmode) ) lmode,
decode(l.request, 0, 'NONE', 1, 'NULL', 2, 'RS', 3, 'RX',
4, 'S', 5, 'RSX', 6, 'X',
to_char(l.request) ) lrequest,
decode(l.type, 'MR', o.name,
'TD', o.name,
'TM', o.name,
'RW', 'FILE#='||substr(l.id1,1,3)||
' BLOCK#='||substr(l.id1,4,5)||' ROW='||l.id2,
'TX', 'RS+SLOT#'||l.id1||' WRP#'||l.id2,
'WL', 'REDO LOG FILE#='||l.id1,
'RT', 'THREAD='||l.id1,
'TS', decode(l.id2, 0, 'ENQUEUE', 'NEW BLOCK ALLOCATION'),
'ID1='||l.id1||' ID2='||l.id2) objname
from sys.v_$lock l, sys.obj$ o
where sid = s.sid
and l.id1 = o.obj#(+) ) loop
dbms_output.put_line(chr(9)||c1.type||' H: '||c1.lmode||' R: '||c1.lrequest||' - '||c1.objname);
end loop;

dbms_output.put_line('=====================================================================');

END;
/

undef 1

Featured Image -- 580

Here’s Where You Should Eat During The 2015 Glasgow Film Festival

Originally posted on James vs. Burger:

glasgow-film-festival-2015-logo

The Glasgow Film Festival is upon us once again! The annual event is one of our favourite things to do in Glasgow and most of the films during the festival are shown either at the Glasgow Film Theatre or Cineworld. That’s good news if you like your food as much as you like your movies! Why? Well, there happens to be loads of great burger joints and other places to eat nearby! Here are the best places to go eat that you’ll find close to the film festival venues and a couple a bit further away. You’ll just have to hit those on the way to the cinema! We’ve added extra info for those of you who may be travelling to Glasgow for the festival and included something for (hopefully) everyone. Enjoy the films!

The ‘Not Dog’ from Bar Bloc

The 'Not Dog' The ‘Not Dog’

My favourite item on the menu at Bloc. This…

View original 853 more words

Oracle Business Analytics Update

pazyp:

Big Larry!

Originally posted on Oracle BI By Bakboord:

Last week I visited the Oracle Business Analytics Partner Update at Oracle NL in Utrecht, the Netherlands. The NL (Pre-) Sales gave us an update of the Oracle Analytics Roadmap. There is a lot of movement in the world of Oracle Analytics. I have written about the publications during Oracle Open World 2014. When we look back at 2014; “Year in Review – Oracle Business Analytics in 2014“, we can see that there are a few subjects key; Big Data, Cloud.

Oracle Business Analytics Strategy

The Oracle Business Analytics Strategy can be captured in one picture.

Oracle Business Analytics Strategy - 2014

The Oracle Business Analytics Strategy consists of Six Design Goals.

Oracle Business Analytics Strategy - Six Design Goals

1. Solutions – “To see more Patterns”

  • OBIEE
    • 12 C
    • R Integration
    • Interactive Dashboards
    • Voice & Word Recognition (BIAsk)
    • Data Mashups
  • Endeca Information Discovery

2. Mobile – “A Secure and Simple Experience”

Oracle has two options for a Mobile Experience.

  • Oracle BI…

View original 211 more words

Weekly script #2 pid_from_sid.sql

A fairly easy script today that isn’t really hard to work out for yourself but I find it useful to have this script kicking around for when you find high resource using Oracle server process and you want to identify the offending SQL.


set pages 1000;
set lines 200;
col username for a10;

select b.status,a.inst_id,a.PID "Ora PID",a.SPID "Server PID",
a.LATCHWAIT,b.Program, b.Username,b.Osuser,b.machine,
b.terminal,a.terminal,b.Process "Client Process"
from gv$process a,gv$session b where a.addr=b.paddr and b.sid=&SID
/

See you next week!

Le Paz
 

 

Featured Image -- 530

Stephen & Grace

pazyp:

Stephen and Grace’s wedding which I was at on Friday.

Originally posted on RADIOMOTHS:

Stephen and Grace got married last Friday.

Here’s a selection of photos I managed to take. Alcohol + Manual focus don’t particularly go hand in hand…

View original