bitmapped indexes
Need a advice here .. Table A Col1 - PK Col2 - Low cardinality column ( say 2 or 3 distinct values) Col3- Low cardinality column col4- Log Cardinality column which of the following options is appropriate for the queries like this( Ours is a high OLTP APPLICATION) select * from A where col2='a' and col3='1' and col4 = 'b' ; a) Separate bitmap indexes on each of the columns(col1, col2, col3) b) Composite bitmap index on the columns col1,col2,col3. c) Composite b*tree index on the columns col1,col2,col3. ** I remember reading that bitmap is not suitable for high transactional applications..because of the locks on the blocks..but what is the another alternative .. Thanks, Siva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Trace ( Perl script help needed)
Hello Gurus, I was trying to pull distinct sql's and their total execute count from a bunch of 250 trace output files(output from tkprof trace files). How can I achive this. What i need the cumulative sum of execute count from different files for each sql's. As u all know sql can extend more than one line so ! I know this can be handled using perl script. file1.prf .. select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 select * from tablename2 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 file2.prf select * from tablename1 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 select * from tablename3 where col1=:1 and col2=:2 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse5 0.00 0.00 0 0 0 0 Execute 5 0.02 0.02 0600 0 0 Fetch5 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total 15 0.02 0.02 0600 0 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Statspack report !! Resending Can someone help Please
All, Can some there PLEASE clarify this question.. what is the corelation between user calls in the statspack report to number of sql's executed during the timeframe.. This is what i am doing please correct me !! We are trying to capture the total number of sql's calls during two time events (say t1, t2), what i was doing to take the snapshot report and copy of the v$sqlarea at t1 t2. 1) the sum of total number of executions from two V$sqlarea tables at t1 and t2 should be the total sql's excecuted. right ?? 2) what way the figure at step1 is releated to the user calls in the statspack report for difference of t1 and t2. *** Is there any other method do u suggest to capture number of sql's application is throwing during a timeframe. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Statspack report !!
All, Can some there PLEASE clarify this question.. what is the corelation between user calls in the statspack report to number of sql's executed during the timeframe.. This is what i am doing please correct me !! We are trying to capture the total number of sql's calls during two time events (say t1, t2), what i was doing to take the snapshot report and copy of the v$sqlarea at t1 t2. 1) the sum of total number of executions from two V$sqlarea tables at t1 and t2 should be the total sql's excecuted. right ?? 2) what way the figure at step1 is releated to the user calls in the statspack report for difference of t1 and t2. *** Is there any other method do u suggest to capture number of sql's application is throwing during a timeframe. Thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
High Parse Calls(-- high latch free events)
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Renaming Oracle_HOME of Oracle 816 on Solaris 2.7
Gurus, Could someone out there help me with following questions, Oracle: 8.1.6 ( Patch 8162 applied to it) OS: Solaris 2.7 1) Can we ( How can ?) rename ORACLE_HOME of Oracle 8.1.6 on solaris, with out re-installing :-) ( Currently my oracle_home is located at /opt//8162 wanted to rename to /opt/.../816) 2) How can we get the COMPLETE list of installed products on 816, without running the slow sluggish Installer from my client. Just by looking into a file or running a command from unix side.. I know short(summary) list of products are recorded in $ORACLE_HOME/install/unix.rgs, but wanted to know complete list of products. !! ( even querying product_component_version is also of not much use in my case, need COMPLETE list) 'inspdver' is not available for Oracle 8i and above (correct me?) Thanks in advance, Siva -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valiveru, Siva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
