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# = [...]

JavaScript: build table dynamically

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);
}

new_table.appendChild(new_tbody);
new_table.setAttribute("border", "2");

the_body.appendChild(new_table);

return new_table ;

}
</script>
<body>
Example:
<script type="text/javascript">
buildTable(4,3)
</script>
</body>

There is also interesting article on oreillynet.com, discussing performance improvement for [...]

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:

sp_dbcc_createws dbccdb, "default", scan_{dbname}, scan, ‘{size_from_sp_plan}’
sp_dbcc_createws dbccdb, "default", text_{dbname}, text, ‘{size_from_sp_plan}’

sp_dbcc_updateconfig [...]

MemoSoup

Meta

Oracle: recreate database links

JavaScript: build table dynamically

Creation and using of Sybase DBCCDB database