Differences between sys and system users
1) The most important difference is that the importance of stored data is different.
Base tables and views of all oracle data dictionaries in sys are stored in sys users. These base tables and views are crucial for oracle operation and are maintained by the database, no user can change it manually. Sys users have the role or permissions such as dba, sysdba, and sysoper, and are the users with the highest oracle
The vast majority of databases run on Linux and UNIX platforms, and as the X86 platform's computing power nears or exceeds minicomputer, and in the tide of the IoE, more and more database environments run on Linux platforms.The Linux system is large and complex, summarized as a DBA, some basic management, network management, advanced applications, performance diagnostics, pipeline complex applications, hardware-related sensing commands need to master,
Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find the RMAN catalog if a particular archive log has been backed-up?3. How can I tell how much it's left in a given file system and how much
SYS and SYSTEM user differences
1 The most important difference, the importance of storing data is different
SYS the base tables and views of all Oracle's data dictionaries are stored in the SYS user, which is critical to the operation of Oracle and is maintained by the database itself and cannot be manually changed by any user. The SYS user has roles or permissions such as Dba,sysdba,sysoper and is the highest user of Oracle permissions.
The system
Oracle Pen questions Oracle DBA face questions and answers (foreign companies)Oracle Database Pen Test DBAOracle Interview Pen test for international large companiesOracle Database DBA Interview Questions1. How many memory layers are in the shared pool?2. How did you find the RMAN catalog if a particular archive log has been backed-up?3. How can I tell how much it's left in a given file system and how much
Today we have a guest Steve travels in the UKWell, I know a simple answer is that the DBA is a database administrator, but what role does it play? If you had to describe it to a non-technical person, what would you say? The DBA plays many different roles and functions. I have seen or used some roles or features: Install SQL Server, manage server performance including disk space usage, backup management, acc
Label:Becoming a qualified DBA is not enough to understand how to encoding some SQL statements and simple database management, so a qualified DBA needs to understand every aspect of it, and can have the ability to debug performance, hardware, and software problems. This article will cover a few things that a DBA needs to understand, and the individual feels that
Tags: Web services Internet Database Linux How to become a MySQL DBAThe success of the Internet's rapid development has benefited from the support of MySQL database. MySQL itself is developing faster, with significant performance improvements, and allows traditional businesses to use MySQL to provide services. It seems that the MySQL DBA's Gap is very large. So welcome to the MySQL DBA team.A classmate referred to MySQL
JetBrains Company's recommended books, detailed information please refer to http://www.jetbrains.com/idea/community/recommends.html, the industry commented has been good, recently spent a little time to read some, quite some sentiment. Here is the book information:
Martin Fowler: "Patterns of Enterprise Application Architecture" "Enterprise Application Architecture Model"
Martin Fowler: "refactoring:improving The design of Existing code" refactori
Android is a Linux based free and open source operating system that is primarily used in mobile devices such as smartphones and tablets, led and developed by Google and the Open Cell Alliance, and, in language, Android applications are based on the Java language, But it's all something we have to work on ourselves to learn.
Whether you are Android rookie or Android God, you must be able to find a book suitable for their own reading, grab a look at it!
Gorky once said "book is the Ladder of hum
http://www.vaikan.com/what-is-the-single-most-influential-book-every-programmer-should-read/
Overseas well-known website StackOverflow has a problem survey: Which book is the most influential to programmers, every programmer should read the book. , the survey has lasted two years, so far attracted 153,432 people to visit, the reader has recommended 478 books (still increasing), one of the most popular book "Code Complete" was the top 1306 times. I
March 7, Dangdang announced the latest issue of earnings, data show when the fourth quarter of the total revenue of 1.6 billion yuan, 31% year-on-year, at the same time, Dangdang continued to net losses, the loss degree of about 120 million yuan, but slightly narrowed. On the whole, Dangdang's performance in the fourth quarter of 2012 was pretty good from the data. But these figures are not amenable to scrutiny, because from 2012 the overall development of the electric business industry, everyon
the functional features of the scholarly gathering of the computer edition :
1. Integrated Cloud Library platform. Cloud Library: Set download, search, reading, management, sharing and many other functions as one of the service platform.
2. Self-paced display, each chapter read how much at a glance (also can be cleared by one click). And with a powerful bookmark management function, save multiple bookmarks, record more exciting.
3. Multi-theme style, read more good mood, and set the theme o
Generally, you can log on to the ISQLPLUS website http: // ip: Port/isqlplus. after entering the website, you can directly log on to the Database User Logon page and use the common users in the database to log on. The DBA user logs on to the isqlpus website http: // ip: Port/isqlplus/DBA. after entering the website, a login box is displayed, you must first enter the iSQL * Plus
Database version 11.2.0.4
The experiment idea is:--The trace information of the database open, can refer to: http://blog.csdn.net/q947817003/article/details/17025489
File#1 block#1==>root dba==>struct Ktetb
That is, start with the system's data file header: File#1 block#1 to locate the root DBA, and then within the block of the root DBA, find the location of t
, memory, and external storage is quite
Complex, these factors must be considered. In addition, pl/sql packages, stored procedures, temporary table empty
, the table structure itself, all of these will become increasingly complex as they are used to ensure that the database
Structural optimization, no garbage, is definitely more complicated than regular vacuum running from cron.
Oracle DBA (DB adminstrator, database administrator) is a computer profe
After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA -- Linux general technology-Linux technology and application information. For more information, see the following. After ORACLE is installed in LINUX, you cannot log on to iSQL * Plus as a DBA. Why?
To log on to isqlplus as a DBA, you must configure the Solaris User first. To use the xm
I finally completed all the OCP DBA courses. Tired! In general, Oracle certification is worth the test. I have a ccnp and MCSE certificate, but after passing the DBA examination, I feel that I have not only deepened my understanding of modern databases, but also enriched the knowledge structure of computer science. In my opinion, Oracle databases even have some operating system functions.
There are quite a
how to find out which users have DBA authority
We sometimes need to find out which users in the database server have DBA authority for security and Rights management.You can usually use the following simple methods to get the answer:
Select the current database, execute SQL:
Select the current database, execute SQL:
SELECT * from Dba_role_privs where granted_role= '
tuning rules that every Oracle DBA should follow
Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most effective ways to do this is through Oracle tuning. It has a large number of tuning parameters and techniques to improve the performance of your Oracle databas
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.