Today's Singapore RACSIG meeting went well. Ravi brought up a "problem" case in RAC Architecture which we discussed for some time. Next was a review of GoldenGate. Here, too, there were many questions and many answers !
Not very good news for skilled people in India? TOI: IT firms to suffer as angry America wants its jobs back
I have extracted this from an AWR report :
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
277.8 1 277.85 97.6 14.9 59.4 8madvr3cvp929
select count(*), sum(sale_qty), sum(discount_rate) from very_large_fact_table
CPU CPU per Elapsed
PACKT Publishing had invited me to review the new 11g RAC book "Oracle 11g R1/R2 Real Application Clusters Essentials". This book, published in May 2011, is an update on the earlier book "Oracle 11g R1/R2 Real Application Clusters Handbook" published in June 2010.
SQL> drop table COUNT_ROWS_TBL ;
SQL> create table COUNT_ROWS_TBL (Column_1 number, Column_2 number, Column_3 varchar2(100)) ;
SQL> insert into COUNT_ROWS_TBL
As a followup to my previous post "Running a COUNT(column) versus COUNT(*)", here's a demo of :
d. COUNT(*) done via an Index
SQL> -- Create a test table with 3 columns
SQL> -- The first column happens to have a NULL value for every 10th row
SQL> -- Column_2 contains numbers, all greater than 0
SQL> -- so a query for "WHERE Column_2 > 0" retrieves ALL the rows
Here's an example of a data quality issue that SQL , PLSQL, Oracle Text etc cannot resolve for you :
See my comments in the thread.
I have just completed a Webinar at BrainSurface Virtathon.
I have uploaded a copy of the presentation 'Oracle Database "Performance" - A Diagnostics Approach' at my "Oracle Diagnostics Presentations" site.
As I demonstrated in my previous blog post "ENABLE ROW MOVEMENT" the ALTER TABLE ... ENABLE ROW MOVEMENT is not just for supporting the ALTER TABLE ... SHRINK SPACE.
Furthermore, unlike ALTER TABLE ... SHRINK SPACE which requires that the Table be created in a Tablespace with Segment Space Management AUTO ("ASSM"), ENABLE ROW MOVEMENT can be done for a table in a Segment Space Management MANUAL ("MSSM") Tablespace as well.
SQL> create tablespace MSSM