Tags » Performance

Bandage

Video documentation by: Michał Hyjek

Performatic action realised in order to establish a temporary, individual and interpersonal relation with civilians of the city of Cracow. 60 more words

Performance

Dancing With The Elephant - Michael Jackson: Subverting Blackface Stereotypes

Willa: This week I’m so excited to be joined by Harriet Manning, the author of a fascinating new book, Michael Jackson and the Blackface Mask, which was published recently by Ashgate Press, and Lisha McDuff, a professional musician and musicologist who wrote her dissertation on Black or White, approaching it in part as an example of “whiteface minstrelsy – or a reverse blackface minstrel performance.” Lisha shared some of her ideas about Black or White in a fascinating post with us last year. 9 more words

Academia

Statistics to analyze the need of cursor sharing force mode

/*** 
  * query that returns statistics about cursor shareness
  * returns : cursor owner, total number of cursor per owner, 
  *           number of binded cursor per owner, 
  *           is the owner already using binded cursors,
  *           number of cursors created in the last 20 minutes 
 ***/ 
/** factoring view for applicative cursors **/ 
with s as (
  select parsing_schema_name, sql_id, child_number, first_load_time
  from v$sql
  where parsing_schema_name not in ('SYS','SYSTEM','SYSMAN','DBSNMP','ORACLE_OCM')
) 
/** results **/ 
select 
  a.*, nvl(b.n,0) nbr_binded_cursors,
  nvl(c.n, 'FALSE') already_use_cursor_sharing,
  nvl(d.m,0) nbr_last_min_cursors
/** total number of cursors per schema **/
from (
  select s.parsing_schema_name cur_owner, count(*) nbr_total_cursors
  from s 
  group by s.parsing_schema_name 
) a
/** number of binded cursors per schema **/ 
left join (
  select s.parsing_schema_name cur_owner, count(*) n
  from s where exists (
    select null from v$sql_bind_capture c 
    where s.sql_id=c.sql_id and c.sql_id=s.sql_id 
  )
  group by s.parsing_schema_name 
) b on a.cur_owner=b.cur_owner 
/** identify if cursor sharing is already used on the schema **/ 
left join (
  select s.parsing_schema_name cur_owner, decode(count(*), 0, 'FALSE', 'TRUE') n
  from s where exists (
    select null from v$sql_bind_capture c 
    where s.sql_id=c.sql_id and c.sql_id=s.sql_id 
    and name like ':SYS\_B\_%' escape '\'
  )
  group by s.parsing_schema_name 
) c on a.cur_owner=c.cur_owner 
/** number of cursors per schema created in the last 20 minutes **/
left join (
  select s.parsing_schema_name cur_owner, count(*) m
  from s 
  where to_date(first_load_time,'YYYY-MM-DD/HH24:MI:SS') > (sysdate - (1/72))
  group by s.parsing_schema_name 
) d on a.cur_owner=d.cur_owner ;
Performance

Use of a Free Ocean CO2 Enrichment (FOCE) system to evaluate the effects of ocean acidification on the foraging behavior of a deep-sea urchin

The influence of ocean acidification in deep-sea ecosystems is poorly understood, but is expected to be large owing to the presumed low tolerance of deep-sea taxa to environmental change. 227 more words

Science

Cabaret Chums, Old and New

I’ve seen some cabaret in my time, but not much. I probably couldn’t have defined it. Singing? Maybe a bit of dancing or some jokes thrown in? 425 more words

Tasmania

Final Weeks: So Many Photographs!

My last weeks at the Newberry processing the Ruth Page Papers mainly focused on organizing the multitude of photographs in the collection.  As I mentioned earlier Page was no slouch at self documentation both at work and at play.   440 more words

A Night in the Night Vale

A genial yet sonorous voice echoes over the radio in a quiet desert community as we all casually avert our gaze from the shadowy horrors lurking just beyond our peripheral vision. 718 more words

Science Fiction