What is DB Buffer Cache Advisor?

What is DB Buffer Cache Advisor?
by

1 Answer

Answer :

The Buffer Cache Advisor provides advice on how to size the Database Buffer Cache to obtain optimal cache hit  ratios.
Member of Performance Advisors --> Memory Advisor pack.
by

Related questions

How would you go about increasing the buffer cache hit ratio?

Description : How would you go about increasing the buffer cache hit ratio?

Last Answer : Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

What is kept in the Database Buffer Cache?

Description : What is kept in the Database Buffer Cache?

Last Answer : The database buffer cache is the portion of the SGA that holds copies of data blocks read from datafiles. All user processes concurrently connected to the instance share access to the database buffer cache.

What is dictionary cache ?

Description : What is dictionary cache ?

Last Answer : Dictionary cache is information about the databse objects stored in a data dictionary table.

Translation Look-aside Buffer(TLB) is (A) a cache-memory in which item to be searched is compared one-by-one with the keys. (B) a cache-memory in which item to be searched is compared with all the keys simultaneously. (C) an associative memory in which item to be searched is compared one-by-one with the keys. (D) an associative memory in which item to be searched is compared with all the keys simultaneously.

Description : Translation Look-aside Buffer(TLB) is (A) a cache-memory in which item to be searched is compared one-by-one with the keys. (B) a cache-memory in which item to be searched is compared with ... keys. (D) an associative memory in which item to be searched is compared with all the keys simultaneously.

Last Answer : (D) an associative memory in which item to be searched is compared with all the keys simultaneously.

The virtual address generated by a CPU is 32 bits. The Translation Lookaside Buffer (TLB) can hold total 64 page table entries and a 4-way set associative (i.e. with 4- cache lines in the set). The page size is 4 KB. The minimum size of TLB tag is (A) 12 bits (B) 15 bits (C) 16 bits (D) 20 bits

Description : The virtual address generated by a CPU is 32 bits. The Translation Lookaside Buffer (TLB) can hold total 64 page table entries and a 4-way set associative (i.e. with 4- cache lines in the set). The page size is 4 KB. The minimum size of TLB tag is (A) 12 bits (B) 15 bits (C) 16 bits (D) 20 bits

Last Answer : (C) 16 bits Explanation: VirtualAddress = 32 bits PageSize = 4KB = 12 bits therefore : VPNTag = 20 bits, OffsetTag = 12 bits TLBEntryLength = VPNTag = 20 bits TotalTLBEntries = 64, 4-way implies ... therefore : TLBIndex = 4 bits TLBTag = TLBEntryLength - TLBIndex = 20 - 4 = 16 bits

What is the name of a memory buffer used to accommodate a speed differential ? (1) Cache (2) Stack Pointer (3) Accumulator (4) Disc

Description : What is the name of a memory buffer used to accommodate a speed differential ? (1) Cache (2) Stack Pointer (3) Accumulator (4) Disc

Last Answer : Cache

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

What is meant by redo log buffer ?

Description : What is meant by redo log buffer ?

Last Answer : Changes made to entries are written to the on-line redo log files. So that they can be used in roll forward operations during database recoveries. Before writing them into the redo log files ... buffers in SGA and LGWR will write into files frequently. LOG_BUFFER parameter will decide the size.

What is Buffer Manager?

Description : What is Buffer Manager?

Last Answer : It is a program module, which is responsible for fetching data from disk storage into main memory and deciding what data to be cache in memory.

Name the buffer in which all the commands that are typed in are stored

Description : Name the buffer in which all the commands that are typed in are stored

Last Answer : ‘Edit’ Buffer

I've lost some Rollback Segments, how can I get my DB back? (for DBA

Description : I've lost some Rollback Segments, how can I get my DB back? (for DBA

Last Answer : Re-start your database with the following INIT.ORA parameter if one of your rollback segments is corrupted. You can then drop the corrupted rollback segments and create it from scratch. ... Please contact Oracle Support before using it. _Corrupted_rollback_segments = (rbs01, rbs01, rbs03, rbs04)

I've lost my REDOLOG files, how can I get my DB back? (for DBA

Description : I've lost my REDOLOG files, how can I get my DB back? (for DBA

Last Answer : The following INIT.ORA parameter may be required if your current redo logs are corrupted or blown away. Caution is advised when enabling this parameter as you might end-up losing your entire database. Please contact Oracle Support before using it. _allow_resetlogs_corruption = true

When you start an Oracle DB which file is accessed first?

Description : When you start an Oracle DB which file is accessed first?

Last Answer : Oracle first opens and reads the initialization parameter file (init.ora) [oracle@hostname ~]$ls -la $ORACLE_HOME/dbs/initDB1_SID.ora -rw-r--r-- 1 oracle oinstall 1023 May 10 19:27 /u01/app/oracle/product/ ... 1 0 12:59 ? 00:00:05 ora_pmon_DB1_SID oracle 6779 1 0 12:59 ? 00:00:06 ora_smon_DB1_SID

Okay what is your take on Jared Kushner (Trump's Son-in-law) being named Senior Advisor to the President and Federal anti-nepotism rules?

Description : Okay what is your take on Jared Kushner (Trump's Son-in-law) being named Senior Advisor to the President and Federal anti-nepotism rules?

Last Answer : All hail our Highness, the kind Donald I of Trump dynasty.

What are the steps to becoming a career advisor ?

Description : What are the steps to becoming a career advisor ?

Last Answer : I don’t know, but that seems like the perfect job for you.

Who is the best type of advisor for help with my personal finance management?

Description : Who is the best type of advisor for help with my personal finance management?

Last Answer : If you were in the UK I would suggest that you speak to one of the large national IFA (Independent Financial Adviser) firms as they will have a range of practitioners to suit varying budgets ... on the USA's personal wealth management industry structure but I'm sure there would be some equivalent.

Which movie/book/tv show villain would be best employed as your personal security advisor?

Description : Which movie/book/tv show villain would be best employed as your personal security advisor?

Last Answer : Doc Holiday from Tombstone. I’m you huckleberry is right up my alley.

I need a great small business accountant and financial advisor in the Bay Area. Any recommendations?

Description : I need a great small business accountant and financial advisor in the Bay Area. Any recommendations?

Last Answer : You are asking for two entirely different skill sets….assuming you want both in the same person.

Is the job "Northwestern Mutual Financial Advisor" a scam?

Description : Is the job "Northwestern Mutual Financial Advisor" a scam?

Last Answer : I can't say what you should do. You'll have to decide that on your own. What I can say is in this economy it might not be your best bet. You'll have to pay more taxes because you'll be ... just feels off. Probably better to save that day off from work for a job with full benefits and full hire.

The Devil made me do it??? What basis does Sanfords "Spiritual Advisor" have in saying that he was "Gripped by Darkness"?

Description : The Devil made me do it??? What basis does Sanfords "Spiritual Advisor" have in saying that he was "Gripped by Darkness"?

Last Answer : Sanford's Spiritual Advisor, whatever that is, needs first to learn about mixed metaphors. The fog may walk on litle cats' feet, but I don't think darkness can grip. Here's an excellent explanation, ... com/2009/06/29/opinion/29kenney.html?th&emc=th Disclosure; Kenney is a writer..often a funny one.

What's the difference between "adviser" and "advisor"?

Description : What's the difference between "adviser" and "advisor"?

Last Answer : answer:Since the root verb ("advise") ends in the letter E, I believe the -er suffix is preferred to the -or suffix. An analogous case is the verb organize, which becomes organizer (and clearly ... recognize "advisor" as an acceptable spelling of the word, and its usage seems to be pretty common.

What's a good baby gift for a PhD Advisor?

Description : What's a good baby gift for a PhD Advisor?

Last Answer : Does she have a registry?

How and where can I find a good financial advisor and how much does it cost ?

Description : How and where can I find a good financial advisor and how much does it cost ?

Last Answer : answer:Regardless who you end with, make sure she/he charges for her/his services. If it's free it means they the make their money on commision so you'll be subject to the possibility of being offered ... one of the dozen of books on the subject (the Personal Finance for Dummies' is a good start).

Which was the first National Security Advisor of India who died recently? -General Knowledge

Description : Which was the first National Security Advisor of India who died recently? -General Knowledge

Last Answer : The answer is 'Gold'

Who is a legal advisor of the State Government as provided by the Constitution? -Do You Know?

Description : Who is a legal advisor of the State Government as provided by the Constitution? -Do You Know?

Last Answer : answer:

Which was the first National Security Advisor of India who died recently? -General Knowledge

Description : Which was the first National Security Advisor of India who died recently? -General Knowledge

Last Answer : answer:

Which bank acts as government advisor ?

Description : Which bank acts as government advisor ?

Last Answer : Central Bank Government Advisor.

What is a non fudiciary advisor?

Description : What is a non fudiciary advisor?

Last Answer : Need Answer

How was Thomas Jefferson's role as chief foreign affairs advisor different from John jay's?

Description : How was Thomas Jefferson's role as chief foreign affairs advisor different from John jay's?

Last Answer : rtyg

Why were the czarina's advisor concerned about her relationship with rasputin?

Description : Why were the czarina's advisor concerned about her relationship with rasputin?

Last Answer : What is the answer ?

Who was a trusted advisor to king george I?

Description : Who was a trusted advisor to king george I?

Last Answer : Need answer

How much of a commission does a financial advisor make?

Description : How much of a commission does a financial advisor make?

Last Answer : Financial advisor commission can be done two ways: per trade and/or by the amount they make you. For the latter, some advisors can charge up to 10% of your returns. There are advisors not paid by commission but rather a flat fee, though.

What kind of qualifications do H&R Block tax advisor experts have?

Description : What kind of qualifications do H&R Block tax advisor experts have?

Last Answer : H&R Block tax advisor experts have to graduate from a four year certifed university or college. In addition , most if not all of them have a either a master degree in fianace or a MBA.

What are some things to look for in an investment advisor?

Description : What are some things to look for in an investment advisor?

Last Answer : Some important questions to ask while looking for the best investment advisor for you would be: -How much experience they have? -Where did they attend school? -what services to they offer? -what are their rates? -have they ever been penalized for dishonest conduct.

How to Select the Best Financial Advisor ?

Description : How to Select the Best Financial Advisor ?

Last Answer : A good financial advisor will help you to invest and manage your money in an effort to meet your financial goals. It's wise to be careful when choosing a financial advisor because you will ... paid a commission on their investments as these planners may be less biased in their investment decisions.

Do I Need A Tax Advisor?

Description : Do I Need A Tax Advisor?

Last Answer : Doing your taxes on your own can be a very difficult and frustrating process. The forms are not clear to people who do not have a background in finances. They can be confusing and can leave you wondering ... way that it should be done. You might even learn so much by working with them that you are

Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Description : Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Description : Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University 88 C. Columbia University D. Karachi University

Description : Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University 88 C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Description : Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Description : Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Harvard University Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Description : Harvard University Advisor to the Prime Minister on Foreign Affairs, Sartaj Aziz holds a Masters degree in Development Economics from: A. Cambridge University B. Harvard University C. Columbia University D. Karachi University

Last Answer : ANSWER: B

Who is the chief advisor to the Governor? (1) Chief Justice of Indian Supreme Court (2) Chief Minister (3) Speaker of the Lok Sabha (4) President

Description : Who is the chief advisor to the Governor? (1) Chief Justice of Indian Supreme Court (2) Chief Minister (3) Speaker of the Lok Sabha (4) President

Last Answer : (2) Chief Minister Explanation: The Governor acts as the nominal head whereas the real power lies in the hand of the Chief Ministers of the states and the Chief Minister's Council of Ministers. ... powers must act according to the advice of the Council of Ministers headed by the Chief Minister.

Which one of the following has the right to address the Parliament? (1) Atorney General of India (2) Chief Election Commissioner of India (3) Chief Justice of India (4) National Security Advisor

Description : Which one of the following has the right to address the Parliament? (1) Atorney General of India (2) Chief Election Commissioner of India (3) Chief Justice of India (4) National Security Advisor

Last Answer : (1) Atorney General of India Explanation: Attorney general of India may speak in Parliament and can take part in proceedings without having right to vote.

Who of the following enjoys the rank of Cabinet Minister in Union Cabinet? (1) Judge of Supreme Court (2) Secretary to Government of India (3) Political Advisor to PM (4) Deputy Chairman of Planning Commission

Description : Who of the following enjoys the rank of Cabinet Minister in Union Cabinet? (1) Judge of Supreme Court (2) Secretary to Government of India (3) Political Advisor to PM (4) Deputy Chairman of Planning Commission

Last Answer : (4) Deputy Chairman of Planning Commission Explanation: With the prime minister as the exofficio Chairman, the Planning Commission has a nominated Deputy chairman, who is given the rank of a full Cabinet. Minister. Mr. Mont& Singh Ahluwalla is presently the Deputy Chairman of the Commission.

Draft of Indian Constitution was prepared by— (1) Sir B. N. Rao, "Advisor to the Constituent Assembly (2) Sir A lladi Krislinaswamy Iyer Chairman Constitution Draft Committee (3) Dr. B.R. Ambedkar, Union Law Minister (4) Jawahar Lal Nehru, Prime Minister

Description : Draft of Indian Constitution was prepared by— (1) Sir B. N. Rao, "Advisor to the Constituent Assembly (2) Sir A lladi Krislinaswamy Iyer Chairman Constitution Draft Committee (3) Dr. B.R. Ambedkar, Union Law Minister (4) Jawahar Lal Nehru, Prime Minister

Last Answer : (1) Sir B. N. Rao, "Advisor to the Constituent Assembly

Who was the Constitutional Advisor to the Constituent Assembly of India? (1) Dr. Rajendra Prasad (2) Dr. B. R. Ambedkar (3) Sir B.N. Rao (4) Shri K.M. Munshi

Description : Who was the Constitutional Advisor to the Constituent Assembly of India? (1) Dr. Rajendra Prasad (2) Dr. B. R. Ambedkar (3) Sir B.N. Rao (4) Shri K.M. Munshi

Last Answer : (3) Sir B.N. Rao Explanation : Benegal Narsing Rau was an Indian bureaucrat, jurist, diplomat and statesman known for his key role in drafting the Constitution of India. He was also ... their duties with thoroughness and intelligence by supplying them with the material on which they could work.'

Who was the constitutional advisor to constituent assembly of India

Description : Who was the constitutional advisor to constituent assembly of India

Last Answer : Sir B.N. Rau

Who is a legal advisor of the State Government as provided by the Constitution?

Description : Who is a legal advisor of the State Government as provided by the Constitution?

Last Answer : Advocate General

Who is a legal advisor of the State Government as provided by the Constitution?

Description : Who is a legal advisor of the State Government as provided by the Constitution?

Last Answer : Advocate General