中华娘！！！参上！！！！(●°u°●) 」也是自己第一次尝试这样子的妆造去上台，一直很担心头发上的夹子会掉下去[并不简单]一直让10s帮我看看有没有掉这样子！少了一张合照！！！可恶！ε-(´∀｀; )但是有大合照嘿嘿～我爱大家(⁎⁍̴̛ᴗ⁍̴̛⁎)牵牵小手拉勾勾(＞人＜;)
#starlink偶像计划##NULL空值变数[超话]#
#starlink偶像计划##NULL空值变数[超话]#
Ruined Fooocus
.Style Selection + One Button Preset
.Instant OBP
{
"Prompt": "cyberpunk game style cyberpunk, concept art, cyborg Girl, background is night city, neon-lit, designed by Howard Schatz, portraiture, dance photography, underwater, experimental, dynamic compositions, technology, neon hue, shadowrun, neon, dystopian, futuristic, digital, vibrant, detailed, high contrast, reminiscent of cyberpunk genre video games, ",
"Negative": "painting, abstract, camera, anime, cartoon, sketch, 3d, render, illustration, character sheet, low contrast, (monochromatic:1.3), (natural:1.3), (rustic:1.3), (primitive:1.3), (organic:1.3), (simplistic:1.3), moody, washed out, (photograph:1.3), realism, (photorealism:1.3), modern, ordinary, mundane, minimalism, plain, simple, full body shot, dark, still life, static, still, slow, boring, standing still, calm, peaceful, historical, natural, rustic, low detailed, , natural, colorful, deformed, sketch, low contrast, watercolor, , ",
"steps": 30,
"cfg": 8,
"width": 1152,
"height": 896,
"seed": 2821498775,
"sampler_name": "dpmpp_2m_sde_gpu",
"scheduler": "karras",
"base_model_name": "sd_xl_base_1.0_0.9vae.safetensors",
"base_model_hash": "be9edd61",
"loras": ",,,,",
"start_step": 0,
"denoise": null,
"software": "RuinedFooocus"
}
.Style Selection + One Button Preset
.Instant OBP
{
"Prompt": "cyberpunk game style cyberpunk, concept art, cyborg Girl, background is night city, neon-lit, designed by Howard Schatz, portraiture, dance photography, underwater, experimental, dynamic compositions, technology, neon hue, shadowrun, neon, dystopian, futuristic, digital, vibrant, detailed, high contrast, reminiscent of cyberpunk genre video games, ",
"Negative": "painting, abstract, camera, anime, cartoon, sketch, 3d, render, illustration, character sheet, low contrast, (monochromatic:1.3), (natural:1.3), (rustic:1.3), (primitive:1.3), (organic:1.3), (simplistic:1.3), moody, washed out, (photograph:1.3), realism, (photorealism:1.3), modern, ordinary, mundane, minimalism, plain, simple, full body shot, dark, still life, static, still, slow, boring, standing still, calm, peaceful, historical, natural, rustic, low detailed, , natural, colorful, deformed, sketch, low contrast, watercolor, , ",
"steps": 30,
"cfg": 8,
"width": 1152,
"height": 896,
"seed": 2821498775,
"sampler_name": "dpmpp_2m_sde_gpu",
"scheduler": "karras",
"base_model_name": "sd_xl_base_1.0_0.9vae.safetensors",
"base_model_hash": "be9edd61",
"loras": "
"start_step": 0,
"denoise": null,
"software": "RuinedFooocus"
}
#SQL每天一分钟（2）#
1.kill某个等待事件对应的spid
select 'kill -9 ' || a.spid
from v$process a, v$session b
where a.addr = b.paddr
and a.background is null
and b.type = 'USER'
and b.event like '%' || '&eventname' || '%'
and b.status = 'ACTIVE';
select machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;' kill_session,
status
from v$session
where type='USER'
and event like '%event_name%'
and status = 'ACTIVE'
2.kill某个sql_id对应的spid
select 'kill -9 ' || a.spid
from v$process a, v$session b
where a.addr = b.paddr
and a.background is null
and b.type = 'USER'
and b.sql_id = '&sql_id'
and b.status = 'ACTIVE'
select machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;',
status
from v$session
where sql_id = '&sql_id'
and type='USER'
and status='ACTIVE'
3.被kill会话的类型
select b.osuser,b.machine,b.program,b.sql_id,b.PREV_SQL_ID,a.spid,to_char(LAST_CALL_ET) as seconds,b.BLOCKING_SESSION,b.BLOCKING_INSTANCE
from v$process a, v$session b
where a.addr = b.paddr
and a.inst_id=b.inst_id
and a.background is null
and b.type = 'USER'
and b.event='&event_name'
and b.status = 'ACTIVE'
4.blocking会话类型和kill blocking会话
SELECT
blocking_instance,
blocking_session,
BLOCKING_SESSION_STATUS,
FINAL_BLOCKING_INSTANCE,
FINAL_BLOCKING_SESSION,
COUNT(*)
FROM
v$session
WHERE
upper(event) LIKE '%&cursor%'
GROUP BY
blocking_instance,
blocking_session,
BLOCKING_SESSION_STATUS,
FINAL_BLOCKING_INSTANCE,
FINAL_BLOCKING_SESSION
order by blocking_instance,count(*)
select
inst_id,
machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;' kill_session,
status
from gv$session a
where a.type='USER' and (a.inst_id,a.sid) in
(
select
BLOCKING_INSTANCE,
BLOCKING_SESSION
from v$session
where upper(event) like '%&cursor%'
)
order by inst_id
5.kill掉所有的Oracle数据库中远程连接进程
ps -ef|grep -v grep|grep LOCAL=NO|awk '{print $2}'|xargs kill -9
1.kill某个等待事件对应的spid
select 'kill -9 ' || a.spid
from v$process a, v$session b
where a.addr = b.paddr
and a.background is null
and b.type = 'USER'
and b.event like '%' || '&eventname' || '%'
and b.status = 'ACTIVE';
select machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;' kill_session,
status
from v$session
where type='USER'
and event like '%event_name%'
and status = 'ACTIVE'
2.kill某个sql_id对应的spid
select 'kill -9 ' || a.spid
from v$process a, v$session b
where a.addr = b.paddr
and a.background is null
and b.type = 'USER'
and b.sql_id = '&sql_id'
and b.status = 'ACTIVE'
select machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;',
status
from v$session
where sql_id = '&sql_id'
and type='USER'
and status='ACTIVE'
3.被kill会话的类型
select b.osuser,b.machine,b.program,b.sql_id,b.PREV_SQL_ID,a.spid,to_char(LAST_CALL_ET) as seconds,b.BLOCKING_SESSION,b.BLOCKING_INSTANCE
from v$process a, v$session b
where a.addr = b.paddr
and a.inst_id=b.inst_id
and a.background is null
and b.type = 'USER'
and b.event='&event_name'
and b.status = 'ACTIVE'
4.blocking会话类型和kill blocking会话
SELECT
blocking_instance,
blocking_session,
BLOCKING_SESSION_STATUS,
FINAL_BLOCKING_INSTANCE,
FINAL_BLOCKING_SESSION,
COUNT(*)
FROM
v$session
WHERE
upper(event) LIKE '%&cursor%'
GROUP BY
blocking_instance,
blocking_session,
BLOCKING_SESSION_STATUS,
FINAL_BLOCKING_INSTANCE,
FINAL_BLOCKING_SESSION
order by blocking_instance,count(*)
select
inst_id,
machine,
'alter system kill session ' || ''''||sid|| ',' || serial# ||''''|| 'immediate;' kill_session,
status
from gv$session a
where a.type='USER' and (a.inst_id,a.sid) in
(
select
BLOCKING_INSTANCE,
BLOCKING_SESSION
from v$session
where upper(event) like '%&cursor%'
)
order by inst_id
5.kill掉所有的Oracle数据库中远程连接进程
ps -ef|grep -v grep|grep LOCAL=NO|awk '{print $2}'|xargs kill -9
✋热门推荐