web analytics

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

<script type="text/javascript"> function buildTable(n_rows,n_columns) { var the_body = document.getElementsByTagName("body")[0]; <code>var new_table = document.createElement("table"); var new_tbody = document.createElement("tbody"); var new_row, new_col, new_text ; for(row=1;row<=n_rows;row++) { new_row = document.createElement("tr"); new_row.className = "tr"+row ; for(col=1;col<=n_columns;col++) { new_col = document.createElement("td"); new_col.className = "td"+col ; new_text = document.createTextNode("text:" + row + ":" + col ); new_col.appendChild(new_text); new_row.appendChild(new_col); } new_tbody.appendChild(new_row); } […]

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:

[…]