Australia photo & PC memo

SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’. Journey to SQL Authority with Pinal Dave

C:\Users\Pinal>sqlcmd -S LocalHost -d master -A
1> DROP TRIGGER Tr_ServerLogon ON ALL SERVER
2> GO

The Old New Thing : Hidden gotcha: The command processor

HKEY_LOCAL_MACHINE\Software\Microsoft\Command Processor\AutoRun

Penetration Testing: Re: How to: Check SSL version Numbers remotely

openssl ciphers -v 'ALL:eNull'

Step-By-Step Configuration of NAT with iptables | HowtoForge - Linux Howtos and Tutorials

Log memory usage using declare and ticks in PHP | DaveDevelopment

# function log_memory() {  

#     $_SESSION['memory'][] = array(  

#         'time'   => microtime(true),  

#         'memory' => memory_get_usage(),  

#     ); // or insert your logging code here  

# }  

#   

# declare(ticks = 50); // log every 50 ticks (low level instructions)  

# register_tick_function('log_memory');  

# $var = 'a';  

#   

# for($i=0;$i<100;$i++) {  

#     $var .= 'a';  

# }  

#   

# var_dump($_SESSION['memory']); 

Scheduler Reference

SELECT JOB_NAME, STATUS, ERROR#
FROM DBA_SCHEDULER_JOB_RUN_DETAILS WHERE JOB_NAME = 'MY_JOB1';

sysdigg: How to list all users in Oracle database

select * from all_users;

＠IT：Windows TIPS -- Knowledge：netstatの統計情報を活用する

netstat -s

The Linux and Unix Menagerie: Finding The Number Of Open File Descriptors Per Process On Linux And Unix

ls -al /proc/[process id]/fd


What do I need to know about File Descriptors for best system stability?

cat /proc/sys/fs/file-nr

データベース統計情報 - オラクル・Oracleをマスターするための基本と仕組み

SET SERVEROUTPUT ON SIZE 1000000

DECLARE

	vMsg	VARCHAR(250);

	vList	DBMS_STATS.OBJECTTAB;

BEGIN

	DBMS_STATS.GATHER_DATABASE_STATS(

		 OPTIONS => 'LIST EMPTY'

		,OBJLIST => vList

	);

        FOR i IN 1..vList.COUNT LOOP

		vMsg := vList(i).OWNNAME;

		vMsg := vMsg || ',' || vList(i).OBJTYPE;

		vMsg := vMsg || ',' || vList(i).OBJNAME;

		vMsg := vMsg || ',' || vList(i).PARTNAME;

		vMsg := vMsg || ',' || vList(i).SUBPARTNAME;

		-- vMsg := vMsg || ',' || vList(i).CONFIDENCE;

		-- (パッケージ定義に未使用項目とある)

		DBMS_OUTPUT.PUT_LINE(vMsg);

	END LOOP;

END;

/