Link to home
Start Free TrialLog in
Avatar of bhanu823
bhanu823Flag for Afghanistan

asked on

Questions about XML type databases

Hello all,

There is a  database which is of type xml ..i mean all the tables are xml tye and it contaings huge blob data.  The application team are running a process and it is running for more than one day.. so  have to increase the performance of that.. hiow can i check the stats on that table and how can i update the stats.  when i query like the regular tables to check the stats...it is not showing anything

like this.so please advise how to handle xml type tables/databases

select last_analyzed from dba_tables where table_name ='PS_IN_DEMAND_ADDR';
sql>no rows selected
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>sql>no rows selected

This means you don't have a table called 'PS_IN_DEMAND_ADDR'.  At best you get a null value for last_analyzed.

>>so please advise how to handle xml type tables/databases

The answer to this depends on how the XML is being used/accessed.

For example, "The application team are running a process and it is running for more than one day",  What is this doing?
Avatar of bhanu823

ASKER

whn i look up the toad the table is there. the tables are  there but dont know hot to update the stats or to check
>>whn i look up the toad the table is there.

Then DBA_TABLES should see it.

>>but dont know hot to update the stats or to check

Checking is with last_analyzed column of dba_tables.  There are other important columns in there as well but this will tell you when it was done.

As for updating them, check the online docs for DBMS_STATS.

Until we know more about what the app is doing, I cannot suggest what stats you might need to collect.

What makes you think it is a stats issue?
>>The application team are running a process and it is running for more than one day.. so  have to increase the performance of that<<
Do you have xmlindexes on your tables?
>>Do you have xmlindexes on your tables?

I'm thinking that until we know what the process is doing with the XML, xmlindexes may not be any benefit.
ASKER CERTIFIED SOLUTION
Avatar of awking00
awking00
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial