- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- index move - now queries are really slow
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 06:35 AM
тАО11-29-2006 06:35 AM
ALTER INDEX indexNameIDX REBUILD TABLESPACE MISC_IDX
Now my queries are really slow.
Oracle 8.1.7
on HP 11.00
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 06:46 AM
тАО11-29-2006 06:46 AM
Re: index move - now queries are really slow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 07:26 AM
тАО11-29-2006 07:26 AM
Re: index move - now queries are really slow
And as stated before performance metrics need to be collected in order to make that judgement. Ideally you should have metrics before and after the data/index separation so that you can compare them.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 08:18 AM
тАО11-29-2006 08:18 AM
Re: index move - now queries are really slow
Your back end OS and database are both out of support.
Short term recommendations:
1) Have the disk array checked for bottlenecks.
2) http://www.hpux.ws/system.perf.sh check your systems for bottlenecks.
3) Run oracle stats back.
4) Patch the system as current as possible with an emphasis on i/o.
5) Act on what you find in steps 1-3.
Long term:
Replace the system with 11i v1 and a version of Oracle thats under support.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 09:07 AM
тАО11-29-2006 09:07 AM
Re: index move - now queries are really slow
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 09:15 AM
тАО11-29-2006 09:15 AM
Re: index move - now queries are really slow
But, I can not figure out where it is pulling the index from...
It does not tell me the tablespace?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 10:33 AM
тАО11-29-2006 10:33 AM
Re: index move - now queries are really slow
Besides checking hardware, you must check it your database is in choose mode.
If the DB is in choose mode, try analyzing all indexes and tables of your database to see it it's missing.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 11:27 AM
тАО11-29-2006 11:27 AM
Re: index move - now queries are really slow
They are all local /permanent tablespaces
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 02:54 PM
тАО11-29-2006 02:54 PM
Re: index move - now queries are really slow
what about the execution plan?
did you notice any changes?
make sure the index is usable.
select * from user_indexes where index_name="indexNameIDX";
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-29-2006 02:56 PM
тАО11-29-2006 02:56 PM
Re: index move - now queries are really slow
i would also try to refresh the statistics.
exec dbms_stats.gather_table_stats( user, '
kind regards
yogeeraj