Flush the buffer cache in [tag]Oracle[/tag]. This invalidates also the read cache, so the query performance results provides from the physical reads time. alter system flush buffer_cache; This command is not available prior to 10g. It flushes the buffer cache in the SGA.9i had an undocumented command to flush the buffer cache: alter session set [...]
Posts in ‘2007’
kill a Windows process from the command line with taskkill
[tag]taskkill[/tag] usage To kill a process by name: taskkill /IM notepad.exe To kill a single instance of a process, specify its process id (PID). For example, if the desired process has a PID of 827, use the following command to kill it: taskkill /PID 853
ClearCase – Find view private files
In a VOB dir, cleartool> ls -recurse -view_only Technorati Tags: ClearCase
How to check the timezone on a unix machine
cat /etc/TIMEZONE
Dump database schema to a file
export all oracle database to a dump file: $ORACLE_HOME/bin/exp / GRANTS=y ROWS=y FILE=”exp.dmp exp_1.dmp” FILESIZE=1GB LOG=export.log OWNER=”()”
Implement pagination with SQL Server 2005
With the new row_number() feature of the MS SQL Server 2005, now it’s very easy to implement pagination: get data rows page by page to avoid the retrieve too much data at same time. The new feature it’s very similar to the Oracle ROWUM. The prepare statement could be like the follow: SELECT * FROM [...]
Error: no `server’ JVM at … jvm.dll
- remove the -server parameter from your command line, or – download de Java JDK. The JVM server configuration DLL are not included in the JRE. Technorati Tags: java, jvm
Retrieving identity column values from MS SQL Server by JDBC
Retrieving identity column values in JDBC applications: You define an identity column in a CREATE TABLE by specifying the IDENTITY clause when you define a column. This feature is defined in the JDBC, and implmented in the MS Sql Server 2005, not in the older version. For Oracle database this is not implemented, but the [...]