create - MemoSoup

Oracle: recreate database links

SELECT ’create ‘ ||DECODE(U.NAME,’PUBLIC’,'public ‘) ||’database link ‘||CHR(10) ||DECODE(U.NAME,’PUBLIC’,NULL, U.NAME||’.') || L.NAME||CHR(10) ||’connect to ‘ || L.USERID || ‘ identified by ”’ ||L.PASSWORD||”’ using ”’ || L.host || ”” ||CHR(10)||’;’ TEXT FROM sys.LINK$ L, sys.USER$ U WHERE L.OWNER# = U.USER# ;

JavaScript: build table dynamically

Creation and using of Sybase DBCCDB database

Planning:

sp_plan_dbccdb ‘{dbname}’

Creation:

create database dbccdb on … log on … isql -U sa -i $SYBASE/$SYBASE_ASE/scripts/installdbccdb

DBCCDB Configuration:

sp_configure "number of worker processes", {value_from_sp_plan} — create named cache for dbccdb sp_cacheconfig "dbccdb_cache", "{cache_size}M" — Size is at least 40 * 16K * (number of working processes) sp_poolconfig "dbccdb_cache", "{pool_size}M", "16K"

Working space configuration:

[...]

MemoSoup

Oracle: recreate database links

JavaScript: build table dynamically

Creation and using of Sybase DBCCDB database

Meta

Tags