[Oracle]学习相关网址记录

1、关于sharepool的分析：

http://oracle.chinaitlab.com/optimize/727954.html 这个网站更好！

http://tech.ddvip.com/2007-09/118949904834079_2.html

2、对于各视图的分析

http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html#db_object_cache

3、关于Buffercache的分析

http://space.itpub.net/9842/viewspace-399670

4、英文的网站分析Bigfile，整体上这个网站内容丰富

http://www.dba-oracle.com/t_bigfile_tablespace_tips.htm

5、spotlight软件相关破解东东

http://cr2384.chat.ru/quest.html

If the product is not present in the list:

Variant A (the best):
Buy the product.
Variant B:
if you have trial key, you can get Product ID here.
then return back and fill "Product ID" field.
Variant C:
go to well-known every-loved www.astalavista.com and try every search engine one by one.
Variant D (works not for all products):
select "Master-key" from "Product" list
keep in mind, "Master-key" is suitable not for all products!
Variant E:
You can try product once more (start trial period again):
close product application
delete (or better move to backup folder) file C:\WINDOWS\SYSTEM\qsXX*.qs (where XX is product id, * - product version or something else or nothing)
delete (better export to backup dir before delete) registry value \HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Multimedia\WindowPositionsXX/*
delete (or better move to backup folder) file C:\Program Files\Quest\ProductName\QSAuthorizeXX*.key
launch product application and reregister it with trial key.

 

6、官网的视图链接：

9i：

http://download.oracle.com/docs/cd/B10501_01/server.920/a96536/ch399.htm#1117308

10g：

11g：

http://download.oracle.com/docs/cd/E11882_01/server.112/e17110/dynviews_3016.htm#REFRN30223

7、语句查询网站：

http://www.shutdownabort.com/dbaqueries/Administration_Job_Scheduler.php