bhanu823
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
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
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?
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?
>>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.
I'm thinking that until we know what the process is doing with the XML, xmlindexes may not be any benefit.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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?