http://docs.oracle.com/cd/E11882_01/license.112/e10594.pdf
There are two scripts to use to get an idea of what options are being used in the database, available at
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1317265.1
But even this one is still not
officially official, it still has disclaimer saying:
“Kindly note the
report generated is to be used for informational purposes only and this does not represent your license entitlement
or requirement. for known issues with this check MOS DOC ID
1309070.1”
It says for 11.2 only, but as dba_feature_usage_statistics has been available since 10g, so you still can use this script to get a basic idea.
If you have no access to Oracle Support, basically, you need to create this table to match name column of dba_feature_usage_statistics to an option.
| OPTIONS | NAME |
|---|---|
| Active Data Guard | Active Data Guard - Real-Time Query on Physical Standby |
| Advanced Compression | HeapCompression |
| Advanced Compression | Backup BZIP2 Compression |
| Advanced Compression | Backup DEFAULT Compression |
| Advanced Compression | Backup HIGH Compression |
| Advanced Compression | Backup LOW Compression |
| Advanced Compression | Backup MEDIUM Compression |
| Advanced Compression | Backup ZLIB, Compression |
| Advanced Compression | SecureFile Compression (user) |
| Advanced Compression | SecureFile Deduplication (user) |
| Advanced Compression | Data Guard |
| Advanced Compression | Oracle Utility Datapump (Export) |
| Advanced Compression | Oracle Utility Datapump (Import) |
| Advanced Security | ASO native encryption and checksumming |
| Advanced Security | Transparent Data Encryption |
| Advanced Security | Encrypted Tablespaces |
| Advanced Security | Backup Encryption |
| Advanced Security | SecureFile Encryption (user) |
| Change Management Pack (GC) | Change Management Pack (GC) |
| Data Masking Pack | Data Masking Pack (GC) |
| Data Mining | Data Mining |
| Diagnostic Pack | Diagnostic Pack |
| Diagnostic Pack | ADDM |
| Diagnostic Pack | AWR Baseline |
| Diagnostic Pack | AWR Baseline Template |
| Diagnostic Pack | AWR Report |
| Diagnostic Pack | Baseline Adaptive Thresholds |
| Diagnostic Pack | Baseline Static Computations |
| Tuning Pack | Tuning Pack |
| Tuning Pack | Real-Time SQL Monitoring |
| Tuning Pack | SQL Tuning Advisor |
| Tuning Pack | SQL Access Advisor |
| Tuning Pack | SQL Profile |
| Tuning Pack | Automatic SQL Tuning Advisor |
| Database Vault | Oracle Database Vault |
| WebLogic Server Management Pack Enterprise Edition | EM AS Provisioning and Patch Automation (GC) |
| Configuration Management Pack for Oracle Database | EM Config Management Pack (GC) |
| Provisioning and Patch Automation Pack for Database | EM Database Provisioning and Patch Automation (GC) |
| Provisioning and Patch Automation Pack | EM Standalone Provisioning and Patch Automation Pack (GC) |
| Exadata | Exadata |
| Label Security | Label Security |
| OLAP | OLAP - Analytic Workspaces |
| Partitioning | Partitioning (user) |
| Real Application Clusters | Real Application Clusters (RAC) |
| Real Application Testing | Database Replay: Workload Capture |
| Real Application Testing | Database Replay: Workload Replay |
| Real Application Testing | SQL Performance Analyzer |
| Spatial | Spatial (Not used because this does not differential usage of spatial over locator, which is free) |
| Total Recall | Flashback Data Archive |
The script doesn't work for 10 ... Some names are different, for instance awr usage is logged as "Automatic Workload Repository", which is not found by the script
ReplyDeleteYes, that table is for 11g so there will be difference in names for 10g. You could create this table and using outer join to find out which ones are not mapped to an option then adjust the table content accordingly. Unfortunately I don't have 10g environment any more so I couldn't do it.
DeleteThis comment has been removed by the author.
DeleteINTERNATIONAL CONCEPT OF WORK FROM HOME
ReplyDeleteWork from home theory is fast gaining popularity because of the freedom and flexibility that comes with it. Since one is not bound by fixed working hours, they can schedule their work at the time when they feel most productive and convenient to them. Women & Men benefit a lot from this concept of work since they can balance their home and work perfectly. People mostly find that in this situation, their productivity is higher and stress levels lower. Those who like isolation and a tranquil work environment also tend to prefer this way of working. Today, with the kind of communication networks available, millions of people worldwide are considering this option.
Women & Men who want to be independent but cannot afford to leave their responsibilities at home aside will benefit a lot from this concept of work. It makes it easier to maintain a healthy balance between home and work. The family doesn't get neglected and you can get your work done too. You can thus effectively juggle home responsibilities with your career. Working from home is definitely a viable option but it also needs a lot of hard work and discipline. You have to make a time schedule for yourself and stick to it. There will be a time frame of course for any job you take up and you have to fulfill that project within that time frame.
There are many things that can be done working from home. A few of them is listed below that will give you a general idea about the benefits of this concept.
Baby-sitting
This is the most common and highly preferred job that Women & Men like doing. Since in today's competitive world both the parents have to work they need a secure place to leave behind their children who will take care of them and parents can also relax without being worried all the time. In this job you don't require any degree or qualifications. You only have to know how to take care of children. Parents are happy to pay handsome salary and you can also earn a lot without putting too much of an effort.
Nursery
For those who have a garden or an open space at your disposal and are also interested in gardening can go for this method of earning money. If given proper time and efforts nursery business can flourish very well and you will earn handsomely. But just as all jobs establishing it will be a bit difficult but the end results are outstanding.
Freelance
Freelance can be in different wings. Either you can be a freelance reporter or a freelance photographer. You can also do designing or be in the advertising field doing project on your own. Being independent and working independently will depend on your field of work and the availability of its worth in the market. If you like doing jewellery designing you can do that at home totally independently. You can also work on freelancing as a marketing executive working from home. Wanna know more, email us on workfromhome.otr214423@gmail.com and we will send you information on how you can actually work as a marketing freelancer.
Internet related work
This is a very vast field and here sky is the limit. All you need is a computer and Internet facility. Whatever field you are into work at home is perfect match in the software field. You can match your time according to your convenience and complete whatever projects you get. To learn more about how to work from home, contact us today on workfromhome.otr214423@gmail.comand our team will get you started on some excellent work from home projects.
Diet food
Since now a days Women & Men are more conscious of the food that they eat hence they prefer to have homemade low cal food and if you can start supplying low cal food to various offices then it will be a very good source of income and not too much of efforts. You can hire a few ladies who will help you out and this can be a good business.
Thus think over this concept and go ahead.
Hello, does anyone know why these 3 components are listed under Advanced Compression?
ReplyDeleteAdvanced Compression Data Guard
Advanced Compression Oracle Utility Datapump (Export)
Advanced Compression Oracle Utility Datapump (Import)
Surely you can use Data Guard or Datapump with just a standard Enterprise license, without using compression?
Are you in need of quick an urgent loan with relatively low interest rate as low as 3%? We offer business loan, personal loan, home loan, auto loan,student loan, debt consolidation loan e.t.c. no matter your credit score. We are guaranteed in giving out financial services to our numerous clients all over world. With our flexible lending packages, loans can be processed and transferred to the borrower within the shortest time possible, contact our specialist for advice and finance planning. If you need a quick loan contact us via Email: creditloanpvt@gmail.com
ReplyDeleteYour Name:...............
Your Country:...............
Your Occupation:...............
Loan Amount Needed:...............
Loan Duration...............
Monthly Income:...............
Your Telephone Number:.....................
Business Plan/Use Of Your Loan:...............
Contact Us At : creditloanpvt@gmail.com
Phone number :+44-75967-81743 (WhatsApp Only)
Hi, are you sure that "Automatic SQL Tuning Advisor" needs Tuning Pack, please?
ReplyDeleteWe offer certified and verifiable bank instruments via Swift Transmission from a genuine provider capable of taking up time bound transactions.
ReplyDeleteBANK INSTRUMENT PARTICULARS
Instruments :Fully Cash Backed, Fresh Cut Bank Guarantee(Standard ICC format)
Age :One (1) years and One (1) day
Rate :Leasing: 3+2, Purchase: 32+2
Currency :USD/Euro
Bank :Top A Rated banks
Amount :As Advised by Beneficiary
Intermediary Fees : Two Percent (2%) of Face Value payable by Beneficiary
Tranches : As per agreed tranches schedule
Delivery : Swift MT799/MT760
Payment : Swift MT103 (Wire Transfer)
Contact Name: Michael paker
Email:bramblesfinanceplc@gmail.com
Skype ID:bramblesfinanceplc
BUPA FINANCE PLC is a group of company with funding experts and mandate to a finance and investment Company who is a premier provider of trade finance and project finance instruments as well as discountable bank instruments.
ReplyDeleteOur bank instrument can be help you fund you projects in Trading, funding project(s) such as Aviation, Agriculture, Petroleum, Telecommunication, construction of Dams, Bridges, Real Estate and all kind of projects.Having years of professional, invaluable experience in the banking and finance industry, and having access to dozens of different prominent trusted and reliable providers, our Financial Services consultants will crawl through hundreds of products to find one that perfectly matches your needs.
Purchase Instrument of BG/SBLC : 32%+2% Min Face Value cut =5M- 10B EUR/USD
Lease Instrument of BG/SBLC : 4%+2% Min Face Value cut = 5M- 10B EUR/USD
DESCRIPTION OF INSTRUMENTS:
1. Instrument: Bank Guarantee (BG / SBLC) (Appendix A)
2. Total Face Value: Eur 5M MIN and Eur 10B MAX (Ten Billion USD).
3. Issuing Bank: HSBC Bank London, Barclays, Credit Suisse and Deutsche Bank Frankfurt.
4. Age: One Year, One Month
5. Leasing Price: 6% of Face Value plus 2% commission fees to brokers.
6. Delivery: Bank to Bank swift.
7. Payment: MT-103 or MT760
8. Hard Copy: Bonded Courier within 7 banking days.
Name :Howard Anthony
Email:bupafinance9@gmail.com
Skype ID:92f864467edaf0b8
We are able to finance your signatory
ReplyDeleteprojects and help you enhance your
business plan. Furthermore, our
financial instrument can be used for
the purchase of goods from any
manufacturer irrespective of their
location. It can also serve as
collateral with any bank in the world
to secure loans for your project or to
activate credit line to finance your
business plan. We have {BG}, Standby
Letter of Credit {SBLC}, Medium Term
Notes {MTN}, Confirmable Bank Draft
{CBD} as well as other financial
instruments issued from AAA Rated bank
such as HSBC Bank Hong Kong, HSBC Bank
London, Deutsche Bank AG Frankfurt,
Barclays Bank , Standard Chartered Bank
and others on lease at the lowest
available rates depending on the face
value of the instrument needed.
Email : nat.mandate18@gmail.com
Skype : nat.mandate18@gmail.com
Regards
Nat
PREMIUM SBLC WITHOUT UPFRONT FEES
ReplyDeleteWe are ready and able and willing to deliver bank instruments in the form of BG/SBLC to your nominated bank coordinates.
Kindly review the procedures and inform on your readiness to proceed.
TRANSACTION DESCRIPTION:
1. Instrument: Bank Guarantee (BG) Standby Letter of Credit (SBLC)
2. Total Face Value: Client to inform us
3. Issuing Bank: HSBC Bank/Barclays Bank UK.
4. Age: One Year One Day
5. Leasing Fee: 4+1 Selling Fee: 32+1
6. Delivery: Bank to Bank Swift MT799 and/or MT760
7. Payment: MT103
8. Hard Copy: By Bank Bonded Courier within 5 banking days after delivery of Swift.]
Email:mishraexclusivefinance@gmail.com
Mishraf Nandan
Skype ID:mishraexclusivefinance@gmail.com
We are able to finance your signatory
ReplyDeleteprojects and help you enhance your
business plan. Furthermore, our
financial instrument can be used for
the purchase of goods from any
manufacturer irrespective of their
location. It can also serve as
collateral with any bank in the world
to secure loans for your project or to
activate credit line to finance your
business plan. We have {BG}, Standby
Letter of Credit {SBLC}, Medium Term
Notes {MTN}, Confirmable Bank Draft
{CBD} as well as other financial
instruments issued from AAA Rated bank
such as HSBC Bank Hong Kong, HSBC Bank
London, Deutsche Bank AG Frankfurt,
Barclays Bank , Standard Chartered Bank
and others on lease at the lowest
available rates depending on the face
value of the instrument needed.
Email : nat.mandate18@gmail.com
Skype : nat.mandate18@gmail.com
Regards
Nat
ReplyDeleteSIGNET UK FINANCE PLC is a British based financial consulting company with years of experience in the international and local finance market. Be it lease bank guarantee, Stand by letter of credit or any type of refinancing, talk to our team at SIGNET UK FINANCE PLC and certainly we will set your business on the right path with our sound and quality financial advice and services. Our bank instrument can be help you fund you projects in Trading, funding project(s) such as Aviation, Agriculture, Petroleum, Telecommunication, construction of Dams, Bridges, Real Estate and all kind of projects.Having years of professional, invaluable experience in the banking and finance industry, and having access to dozens of different prominent trusted and reliable providers, our Financial Services consultants will crawl through hundreds of products to find one that perfectly matches your needs.
Purchase Instrument of BG/SBLC : 38%+2% Min Face Value cut =5M- 10B EUR/USD
Lease Instrument of BG/SBLC : 6%+2% Min Face Value cut = 5M- 10B EUR/USD
Contact Name: Alex James
Email:signetukfinanceplc@gmail.com
SKYPE:signetukfinanceplc@hotmail.com
Whatsapp #:+971 55 178 0389
We are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
ReplyDeleteWe are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
we always deliver on time and precision as Set forth in the agreement. You are at liberty to engage our leased facilities into trade programs, project financing, Credit line enhancement, Corporate Loans (Business Start-up Loans or Business Expansion Loans), Equipment Procurement Loans (Industrial Equipment, Air crafts, Ships, etc.) as well as other financial instruments issued from AAA Rated bank such as HSBC Bank Hong Kong, HSBC Bank London, Deutsche Bank AG Frankfurt, Barclays Bank , Standard Chartered Bank and others on lease at the lowest available rates depending on the face value of the instrument needed, Our Terms and Conditions are reasonable.
DESCRIPTION OF INSTRUMENTS:
1. Instrument: Bank Guarantee (BG)/SBLC (Appendix A)
2. Total Face Value: 10M MIN to 50B MAX USD or Euro
3. Issuing Bank: HSBC, Deutsche Bank Frankfurt, UBS or any Top 25 .
4. Age: One Year, One Day
5. Leasing Price: 4 1%
6. Sale Price: 32 2%
7. Delivery by SWIFT .
8. Payment: MT103-23
9. Hard Copy: Bonded Courier within 7 banking days
We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct.
Name:May Gary
Email:algecoglobalfinanceplc@gmail.com
Skype::algecoglobalfinanceplc
or let us know via WhatsApp:+1(218)2417690
We are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
ReplyDeleteWe are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
we always deliver on time and precision as Set forth in the agreement. You are at liberty to engage our leased facilities into trade programs, project financing, Credit line enhancement, Corporate Loans (Business Start-up Loans or Business Expansion Loans), Equipment Procurement Loans (Industrial Equipment, Air crafts, Ships, etc.) as well as other financial instruments issued from AAA Rated bank such as HSBC Bank Hong Kong, HSBC Bank London, Deutsche Bank AG Frankfurt, Barclays Bank , Standard Chartered Bank and others on lease at the lowest available rates depending on the face value of the instrument needed, Our Terms and Conditions are reasonable.
DESCRIPTION OF INSTRUMENTS:
1. Instrument: Bank Guarantee (BG)/SBLC (Appendix A)
2. Total Face Value: 10M MIN to 50B MAX USD or Euro
3. Issuing Bank: HSBC, Deutsche Bank Frankfurt, UBS or any Top 25 .
4. Age: One Year, One Day
5. Leasing Price: 4 1%
6. Sale Price: 32 2%
7. Delivery by SWIFT .
8. Payment: MT103-23
9. Hard Copy: Bonded Courier within 7 banking days
We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct.
Name:May Gary
Email:algecoglobalfinanceplc@gmail.com
Skype::algecoglobalfinanceplc
or let us know via WhatsApp:+1(218)2417690
TESTIMONY ON HOW I GOT MY LOAN FROM A FINANCE COMPANY LAST WEEK Email for immediate response: drbenjaminfinance@gmail.com
ReplyDelete{Dr.Benjamin Scarlet Owen} can also help you with a legit loan offer. He Has also helped some other colleagues of mine. If you need a genuine loan without cost/stress he his the right loan lender to wipe away your financial problems and crisis today. BENJAMIN LOAN FINANCE holds all of the information about how to obtain money quickly and painlessly via WhatsApp +19292227023 Email drbenjaminfinance@gmail.com
My name is Mohammed Ahsan I'm a financial Consultant of a reputable firm Operating out of the United Kingdom
ReplyDeletewe provide Discrete Financial, Services for High Net Worth CEO's/Executives of Corporation & Senior Government Officials globally.
What we do is Legal & within the ambit of the law but following the Leakage of the Infamous United Kingdom
Papers & subsequent threat by the International Consortium of Investigative Journalists (ICIJ)
International Criminal Court (ICC)
Below is what my Sender can offer.
1, MT103 gpi automatic
2, MT103 wire transfer
3, MT103 TT
4, MT103/202 manual download
5, SBLC lease and Purchase
All bank instrument will be done via bank officer to bank officer, Receiver has to provide bank officer details
on DOA all brokers are welcome and guarantee of there payment after successful deal
kindly send me a message via email and WhatsApp.
Email: mohammedahsan877@gmail.com
WhatsApp- +19893413179
We offer certified and verifiable bank instruments via Swift Transmission from a genuine provider capable
ReplyDeleteof taking up time bound transactions. We work with Top AA Rated bank and can close deal within five days.
Our BG/SBLC Financing can help you get your project funded, loan financing by providing you with yearly. RWA ready to close leasing with any interested client in few banking days
renewable leased bank instruments. We work directly with issuing bank lease providers, this Instrument can be monetized on your behalf for 100% funding.
email : inquiry.trustedfinanceplc@gmail.com
Whatsapp : +17329300338
GENUINE BANK GUARANTEE(BG) LETTER OF CREDIT(LC) BUSINESS LOAN AND STANDBY LETTER OF CREDIT (SBLC)
ReplyDeleteAT THE BEST RATES AVAILABLE
We offer certified and verifiable bank instruments via Swift Transmission from a genuine provider capable of taking up time bound transactions.
FOR LEASING OF BG/SBLC
MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M-10B
LEASING FEE = 4%+2%
FOR PURCHASE OF FRESH CUT BG/SBLC
PRICE = 32%+2%
MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M-10B
MONETIZATION LTV 80%
Our BG/SBLC Financing can help you get your project funded, loan financing by providing you with yearly. we ready to close leasing with any interested client in few banking days
Email : financialexpert86@gmail.com
Do you need a quick long or short term Loan with a relatively low interest rate as low as 3%? We offer business Loan, personal Loan, home Loan, auto Loan, student Loan, debt consolidation Loan etc.. no matter your credit score.
ReplyDeletePersonal Loans (Secure and Unsecured)
Business Loans (Secure and Unsecured)
Consolidation Loan and many more.
Contact US for more information about Loan offer and we will solve your
financial problem. contact us via email: muthooth.finance@gmail.com
Phone number: +917428831341 (Call/What's app)
We are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
ReplyDeleteWe are major/Direct providers of Fresh Cut BG, SBLC, POF, MTN, Bonds and CDs and this financial instruments are specifically for lease and sale.We are one of the leading Financial instrument providers with offices all over Europe.
we always deliver on time and precision as Set forth in the agreement. You are at liberty to engage our leased facilities into trade programs, project financing, Credit line enhancement, Corporate Loans (Business Start-up Loans or Business Expansion Loans), Equipment Procurement Loans (Industrial Equipment, Air crafts, Ships, etc.) as well as other financial instruments issued from AAA Rated bank such as HSBC Bank Hong Kong, HSBC Bank London, Deutsche Bank AG Frankfurt, Barclays Bank , Standard Chartered Bank and others on lease at the lowest available rates depending on the face value of the instrument needed, Our Terms and Conditions are reasonable.
DESCRIPTION OF INSTRUMENTS:
1. Instrument: Bank Guarantee (BG)/SBLC (Appendix A)
2. Total Face Value: 10M MIN to 50B MAX USD or Euro
3. Issuing Bank: HSBC, Deutsche Bank Frankfurt, UBS or any Top 25 .
4. Age: One Year, One Day
5. Leasing Price: 4 1%
6. Sale Price: 32 2%
7. Delivery by SWIFT .
8. Payment: MT103-23
9. Hard Copy: Bonded Courier within 7 banking days
We are ready to close leasing with any interested client in few banking days, if interested do not hesitate to contact me direct.
Name:May Gary
Email:algecoglobalfinanceplc@gmail.com
Skype::algecoglobalfinanceplc
or let us know via WhatsApp:+1(218)2417690
Hello,
ReplyDeleteWe Offer Swift MT760 BG/SBLC, FC MTN, Letter of Credit { LC }, MT103Etc.
N/B: Provider's Bank move first.
Let me know if you have any need for the above offers.
Thanks
Name: Jerry Osborne
Email: osbornej715@gmail.com
Skype: osbornejerry123@outlook.com
FINANCIAL AGENT LIMITED provides a full financial planning service to both the commercial and domestic markets. At IQ FINANCE PLC we believe that financial planning is about two things: creating wealth and protecting wealth. These two objectives are at the heart of everything we do. And, as a member of FINANCIAL AGENT LIMITED Services, we give you a small-company service but with a large-company set up – the best of both worlds.
ReplyDeleteYou are at liberty to engage our leased facilities into trade programs as well as in signature project(s) such as Aviation, Agriculture, Petroleum, Telecommunication, construction of Dams, Bridges and any other turnkey project(s) etc. Our terms and Conditions are reasonable.
Leasing Price : 6%+2%
Buying Price: 38%+2%
Contact us for more details on our terms and procedure of transaction.
NAME :Jason Edward
EMAIL :financialagentltd@gmail.com
SKYPE :financialagentltd@gmail.com
We offer certified and verifiable financial bank instruments via Swift Transmission from a genuine provider capable
ReplyDeleteof taking up time bound transactions.
FOR LEASING OF FRESH CUT BG/SBLC
MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M
LEASING PRICE = 4%+2%
FOR PURCHASE OF FRESH CUT BG/SBLC
MINIMUM FACE VALUE OF BG/SBLC = EUR/USD 1M
PURCHASE PRICE = 32%+2%
Our BG/SBLC Financing can help you get your project funded,
loan financing by providing you with yearly.
RWA ready to close leasing with any interested client in few banking days
I will be glad to share with you our working procedures.
Name : Christopher Liam
Email : trustedfinancemandate@gmail.com
Skype : trustedfinancemandate@gmail.com
WhatsApp: +13475948294
We are certified & verified Financial Instrument providers of Lease & purchase instruments. We Lease BG/SBLC @ 4+2% and purchase @ 32+2%.
ReplyDeleteKindly contact us for our procedures and be sure that we would surely achieve success
For further inquiry contact: BERRIDGE, Ian
Email: bizfinleasingltd@gmail.com
QUICK EASY EMERGENCY URGENT LOANS LOAN OFFER EVERYONE APPLY NOW +918929509036 financialserviceoffer876@gmail.com Dr. James Eric
ReplyDelete