 Performance Issue on a specific Table only [message #320612] |
Thu, 15 May 2008 11:57  |
DBAsal
Messages: 5
Registered: May 2008
Location: T,Dot
|
Junior Member |
|
|
Hello All,
Maybe this was asked before but I am in a bind here. 
I have an issue with a select statement, it is taking way to long to fetch. I have run a full analyze on the schema, and a full analyze ont he table, and a full analyze on the indexes. It is still slow to select from it. it has roughly 225K records, some of which hold CLOB XML Values.
Now all the tables in this schema are running VERY FAST!
I am only experiencing this problem with this one table.
Now I have also checked the locks on this table, it isnt locked.
There are no active sessions on the databse except for mine.
I really could use a hand or 2, or 3 if you can offer.
Best Regards,
|
|
|
|
|
|
| Re: Performance Issue on a specific Table only [message #320616 is a reply to message #320613] |
Thu, 15 May 2008 12:13  |
DBAsal
Messages: 5
Registered: May 2008
Location: T,Dot
|
Junior Member |
|
|
Explain Plan below.
I forgot to mention that Select * from is taking a long time.
I have a mirror database very similar and doesnt take time at all.
THE SLOW DATABASE
SELECT STATEMENT, GOAL = ALL_ROWS 4250 224894 62745426
TABLE ACCESS FULL SDEDBA REF_ITEM 4250 224894 62745426
THE FAST DATABASE
SELECT STATEMENT, GOAL = ALL_ROWS 911 225886 26654548
TABLE ACCESS FULL SDEDBA REF_ITEM 911 225886 26654548
I will start to look into some of those FAQ in the link above.
Please Advise,
Regards,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Performance Issue on a specific Table only [message #320840 is a reply to message #320643] |
Fri, 16 May 2008 07:31 |
DBAsal
Messages: 5
Registered: May 2008
Location: T,Dot
|
Junior Member |
|
|
Hello,
No, both databases have had pretty much the same things done to them. the fast environment actually has had more things deleted and inserted. I would say after my initial load of the data, maybe 1-2% have been changed or deleted in the environment that is going slow.
I have tried so many things up till now, and I have a little bit more to share, in this table I have 2 columns which hold XML values in a BLOB. I copied this table to a different schema and it still ran slow, but when I dropped the 2 columns with the XML values the table selected very very fast. I am keeping in mind that the other Environment is going fast and it also contains pretty much the same values, also with 2 columns that hold XML values. so there is something going on with the 2 XML columns(BLOB).
Anyone ever have this issue before?
Regards,
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
