Fun Metalink Search

If you're bored (or just curious) and have a Metalink account, try searching for LGWR...you'll be surprised and impressed with what comes back. I know I was. There's a ton of information out there and some of it you might just find useful.

Installing OCFS on RHEL4

So I realized that I wanted to use OCFS as my filesystem of choice for this install, but when I went to install the rpms available from here I kept getting script errors. The rpms were designed for RHEL2.1 and/or RHEL3 so they would not install completely. I could 'rpm -qa |grep 'ocfs' ' and all the packages I installed would be there, but I could not get 'ocfstool' to start. So I went hunting for a file to hack. I found '/proc/sys/kernel/ostype & /proc/sys/kernel/osrelease', but these are not writeable files (even by root). So I tried using 'sysctl', but I still could not update these parameters. I'm still trying to find a way to get around this.

Until the OCFS rpm is updated for RHEL4, installing it is an exercise in futility. You will need to install OCFS and OCFS Tools from source. This is also not an easy process. So I have now spent most of my morning hacking all kinds of files trying to get OCFSv1 or v2 installed on RHEL4 and it just will not co-operate. I'm throwing in the towel on this one and waiting for a code refresh of OCFS to work with RHEL4.

A: Recently executed sql statement and user

well, i did a quick google search because my brain just would not pull the answer out of the recesses...here's the first hit my search came back with: this came from Ask Tom
this is the link to the forum discussion "How can I track the execution of PL/SQL and SQL?", version 8.1.6

---------------- showsql.sql --------------------------
column status format a10
set feedback off
set serveroutput on

select username, sid, serial#, process, status
from v$session
where username is not null
/

column username format a20
column sql_text format a55 word_wrapped

set serveroutput on size 1000000
declare
    x number;
begin
    for x in
    ( select username||'('||sid||','||serial#||
                ') ospid = ' ||  process ||
                ' program = ' || program username,
             to_char(LOGON_TIME,' Day HH24:MI') logon_time,
             to_char(sysdate,' Day HH24:MI') current_time,
             sql_address, LAST_CALL_ET
        from v$session
       where status = 'ACTIVE'
         and rawtohex(sql_address) <> '00'
         and username is not null order by last_call_et )
    loop
        for y in ( select max(decode(piece,0,sql_text,null)) ||
                          max(decode(piece,1,sql_text,null)) ||
                          max(decode(piece,2,sql_text,null)) ||
                          max(decode(piece,3,sql_text,null))
                               sql_text
                     from v$sqltext_with_newlines
                    where address = x.sql_address
                      and piece < 4)
        loop
            if ( y.sql_text not like '%listener.get_cmd%' and
                 y.sql_text not like '%RAWTOHEX(SQL_ADDRESS)%')
            then
                dbms_output.put_line( '--------------------' );
                dbms_output.put_line( x.username );
                dbms_output.put_line( x.logon_time || ' ' ||
                                      x.current_time||
                                      ' last et = ' ||
                                      x.LAST_CALL_ET);
                dbms_output.put_line(
                          substr( y.sql_text, 1, 250 ) );
            end if;
        end loop;
    end loop;
end;
/

column username format a15 word_wrapped
column module format a15 word_wrapped
column action format a15 word_wrapped
column client_info format a30 word_wrapped

select username||'('||sid||','||serial#||')' username,
       module,
       action,
       client_info
from v$session
where module||action||client_info is not null;

there were plenty of comments and follow-ups on this discussion...i recommend reading the entire thread...you will find tons of valuable information

Q: Recently executed SQL statement and user

So I'm reading through my emails and I come across this question:

how do i determine the last executed sql statement and user

It's late and I know the answer to this...but I just can't seem to recall it. I'll post the answer a.s.a.p.

Oracle Statspack

I am always looking for more information about Oracle's statspack and have come across some very good links (some I have read, some I have not)....

Advanced Tuning with Statspack	This article lists and describes the top 10 most common wait events and some possible resolutions. One thing to keep in mind when reading this article is that these are the "most common wait events" and you should look at look at the exhibited behaviors of the system as well as these events.
How To Integrate Statspack with EM 10G	This is a good Metalink article on how to integrate your statspack data into the EM in 10g. If you don't have a Metalink account, you need one.
Gathering a StatsPack snapshot	This note is intended to provide information about the steps required to take a StatsPack snapshot of current database performance levels and how to capture different granularities of performance information at both the instance and session levels. This note also discusses how to automate the process of capturing a StatsPack snapshot. These snapshots can be used as a starting or ending point for generating a performance summary.
FAQ- Statspack Complete Reference	This FAQ is mostly for Oracle releases prior to 10g. It contains lots useful links to more Metalink related articles.

Oracle 9i RAC Training Class

The class...

Last Monday 24-JAN-2005 through Wednesday 26-JAN-2005 I attende an Oracle 9i RAC class in Dallas presented by Rick Pulliam. Rick is an outstanding instructor! I highly recommend taking a class from him if you're planning on taking an Oracle training class. He's very approachable and knowledgable.

This was my first class since starting at Oracle last September. My main areas of interest in Oracle is the performance tuning, high availablity, and architecture. Rick covered all areas and then some. Some of the links under my Oracle bookmark folder came from this class. I have just started posting my favorite Oracle links here so check back and see what I've found.

Rick recommended Optimizing Oracle Performance by Cary Milsap. Which I promptly went out and purchased it. It was the best $35 bucks I've spent in a long time. I've only just started reading it and find it easy to follow. Cary states in the preface that he always wanted to know why a fix worked and would lose sleep trying to figure it out. I am not as obsessive compulsive as Cary, but I am definitely on the "why did it work" side of the line.