Archive for the ‘Uncategorized’ Category

My First Poll Block

13. November 2020 Leave a comment

Click on the poll block above to edit it directly in this post. Add a question, and multiple answers and even change the styling of the block using the sidebar controls. Add new poll blocks by searching for “poll” or type “/poll” in a new block.

Categories: Uncategorized

some sql scripting hints

4. November 2011 Leave a comment

generate dynamic filenames

to generate dynamic spool filenames use (name will be set at the select):

col spoolfile new_val spoolfile
select 'log_' ||to_char(sysdate, 'yymmdd_hh24miss' ) spoolfile from dual;

spool &spoolfile

to be continued 😉

Categories: Uncategorized

generate dumps – overview

13. September 2011 Leave a comment

Some nice – important dump options 🙂

and still under constuction

find sga ID

in Unix environments with mutiple instances running within the same os-use (e.g. oracle) you cannot see which memory segment is allocated to which instance.

sqlplus  / as sysdba
oradebug setmypid
oradebug ipc
oradebug tracefile_name

the column Shmid shows the dependend memory structures

Read more…