ÓÃperl²éѯoracleÊý¾Ý¿âÖдæÔÚµÄlock
ÔÎĵØÖ·oracle lock
1ÓÃPerl TKÄ£¿é ²éѯDBÖеÄLOCK
use DBI;
use Tkx;
use DBD::Oracle qw(:ora_session_modes);
$mw = Tkx::widget->new(”.”);
$mw->g_wm_title(”Oracle Lock”);
$content = $mw->new_ttk__frame(-padding => “5 5 12 0″);
$content->g_grid(-column => 0, -row => 0, -sticky => “nwes”);
$mw->g_grid_columnconfigure(0, -weight => 1);
$mw->g_grid_rowconfigure(0, -weight => 1);
$e1= $content->new_tk__entry( -width => 27, -textvariable => \$uname);
$e1->g_grid(-column => 2, -row => 0,-sticky => “nwes”);
$lbl = $content->new_ttk__label(-text => “username:”);
$lbl->g_grid(-column => 1, -row => 0,-sticky => “nwes”);
$e2= $content->new_tk__entry( -width => 27, -textvariable => \$passwd);
$e2->g_grid(-column => 2, -row => 1,-sticky => “nwes”);
$lb2 = $content->new_ttk__label(-text => “password:”);
$lb2->g_grid(-column => 1, -row => 1,-sticky => “nwes”);
$e3= $content->new_tk__entry( -width => 27, -textvariable => \$dsn1);
$e3->g_grid(-column => 2, -row => 3,-sticky => “nwes”);
$lb3 = $content->new_ttk__label(-text => “dsn:”);
$lb3->g_grid(-column => 1, -row => 3,-sticky => “nwes”);
$ba1 = $content->new_tk__button(-text => “sure”, -command => sub {sure();});;
$ba1->g_grid(-column =>2, -row => 4,-sticky => “nwes”);;
$ba1->g_bind(”<1>”, sub {sure();});
# $ba1->g_bind(”", sub {sure();});
($lb = $content->new_tk__listbox(-height =>
15,-width=>100))->g_grid(-column => 1, -row => 5, -sticky
=> “nwes”);
($s = $content->new_ttk__scrollbar(-command => [$lb, "yview"],
-orient => “vertical”))->g_grid(-column =&
Ïà¹ØÎĵµ£º
Ò»¡¢½¨Á¢Á´½Ó·þÎñÆ÷
ÓÐÈËϲ»¶µ÷ÓÃϵͳ¹ý³ÌÀ´½¨Á¢£¬µ«ÎÒ¸öÈ˶Ôϵͳ¹ý³ÌûÓÐÌØ±ðµÄѧϰ £¬ËùÒÔÓõÄÊǽçÃæÉèÖ㬵±È»ÓÐÐËȤҲ¿ÉÒÔÑо¿Ò»Ïµģ¬ÒòΪ¿ÉÒÔ°ÑSQLÖ´Ðе¼³öÀ´¡£
USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N'TEST2', @srvproduct=N'ORCL', @provider=N ......
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
sql> alter system set job_queue_processes=n;£¨n>0£©
job_queue_processes×î´óֵΪ1000
²é¿´¸ÃÖµ show parameter processes
²é¿´job queue ºǫ́½ø³Ì
sql>select name,description from v$bgprocess;
¶þ£¬dbms_job package Ó÷¨½é ......
crsctl stop crs
killall init.crsd
cd /etc/init.d
rm -rf init.crs init.crsd init.cssd init.evmd
rm -rf /tmp/.oracle/
rm -rf /var/tmp/
rm -rf /var/tmp/.oracle/
cd /etc
rm -rf oraInst.loc oracle/ oratab
rm -rf $ORACLE_BASE
dd if=/dev/zero of=/dev/raw/raw_voting_disks bs=1024k
dd if=/dev/zero ......
<!--
@Name£º·ÖÀàͳ¼ÆÃ÷ϸ
@Time£º2010.01.05
@author JZP
--->
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page language="java" import="wfc.service.database.DB"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.Resul ......
OracleÓ¦ÓÃϵͳµÄÓÅ»¯Ëĸö·½Ãæ
1.¡¡¡¡¡¡ Ó¦ÓóÌÐòSQLÓï¾äÓÅ»¯;
2.¡¡¡¡¡¡ ORACLEÊý¾Ý¿â²ÎÊýµ÷Õû;
3.¡¡¡¡¡¡ ²Ù×÷ϵͳ²ÎÊýµ÷Õû;
4.¡¡¡¡¡¡ ÍøÂçÐÔÄܵ÷Õû.
oracleÓ¦ÓÃϵͳµÄÐÔÄÜÖ¸±ê
1.¡¡¡¡¡¡ Êý¾Ý¿âÍÌÍÂÁ¿;
2.¡¡¡¡¡¡ Êý¾Ý¿âÓû§ÏìӦʱ¼ä.
ORACLEÊý¾Ý¿âÐÔÄÜÓÅ»¯µÄ¼¸¸ö²¿·Ö
Êý¾Ý¿âÐÔÄÜÓÅ»¯°üÀ¨Èçϼ¸¸ö²¿·Ö£º
1¡¢1¡¢µ÷Õ ......