What Oracle DBA should do on a daily, weekly, and monthly basis (I) Check alert on a daily basis. log ② check the environment ● check whether the database instance is working properly ▼ ps-ef | grep ora _ explain select status from v $ instance ● whether the listener is working properly ▼ lsnrctl status ● whether the tablespace is faulty ▼ select tablespace_name, status from dba_tablespace; ● control file,
space at the university and share them with you to prevent me from happening in the past, it takes a lot of time. The following are all recorded at that time:
Today, I logged on to Oracle with SCOTT. When I edited the table, I found that I didn't have the corresponding permissions. So I wanted to log on to sys and grant the DBA role SCOTT as a DBA, however, I co
Before the business system stress test, Oracle dba must complete the work in advance. oracledba
This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/42376661
Before the business system stress test, the Oracle dba must complete the following work in
; Conn Test/test as Sysoper;
is connected.
Sql> Show User
USER is "public"
Sql> Conn Test/test as Sysdba
is connected.
Sql> Show User
USER is "SYS"
Sql>
3, the difference between DBA and SYSDBA
DBA, Sysdba What's the difference between the two system roles, before I explain this, I need to talk about the Oracle service creation process
• Create an inst
. Oracle returns a warning message and starts database recovery
1
Q. 5: Bob tried to shutdown normal, Oracle said it was unavailable, and when he tried to starup, oracle said that it was already started. what is the best mode that bob can use to force a shutdown on the server
1. NORMAL2. ABORT3. IMMEDIATE4. NONE
2
Q. 6: Tom issued a command to startup the da
Oracle DBA Common Queries–1. Querying the system for all objectsSelect owner, object_name, Object_type, created, Last_ddl_time, timestamp, statusFrom Dba_objectsWhere Owner=upper (' Scott ')–2. View all system tablesSelect owner, TABLE_NAME, tablespace_name from Dba_tables–3. View all users ' tablesSelect owner, TABLE_NAME, tablespace_name from All_tables–4. View the current User tableSelect table_name, tab
XPROCESSES) + 5
By default, this parameter is automatically calculated and takes effect when PROCESSES is modified.
2. Operating System Dependent Parameters
The valid values or value ranges of some parameters depend on or are limited by the operating system, such as the db_cache_size parameter, which sets the memory size used by Oracle. The maximum value of this parameter is limited by the physical memory. This type of parameter is generally not cal
Oracle dba Pen TestOne: SQL tuning class
1: Enumerate several table connection ways2: How to view SQL execution plan without the help of Third-party tools3: How to use the difference between CBO,CBO and rule4: How to locate the SQL that is important (consumes a lot of resources)5: How to track the SQL of a sessionWhat is the most concerned about 6:sql adjustment7: Talk about your knowledge of indexes (struc
oracle| Script
In a longer period of interaction with Oracle, each DBA, especially some heroes have a variety of scripting tools to complete a variety of purposes, so very convenient and quick to complete the day-to-day work, the following part of my commonly used to show you, this article mainly focused on database management, these scripts have been rigorously
previous: oracle DBA Study Notes-control files
RedoLog Files
Redo log files record the changes made to the database (or changes to transactions) in the form of redo records, including the execution of DMLOrDDLStatement modification to the database,It also includesDBAModify the database structure,Redo log files also need to be reused.
Log File writing principles:1.Write order must strictly fol
A lot of the time, do Oracle DBA us, when the application administrator to inform us that the application is now slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, sometimes we can not start, Because we believe that the various life rates of the database are recommendations for meeting Oracle do
The DBA will periodically check the connection to the database to see if the number of sessions established with the database is normal, and if too many connections are established, the resources of the database are consumed. At the same time, some "hang dead" connections may require manual cleanup by the DBA.
The first thing to say is that the system tables pro
depends on whether you want to be a DBA or a developer? The certificate is sure to be taken, just like having a driver's license to drive a car. Second, there are teachers to get you started. Entering the industry will be quick, otherwise it is difficult to enter the industry role. If you have a friend who knows best, if not, it is also a good choice to attend the training. Choose a company with real training technology is the best, of course, our cen
This article mainly introducesOracle 10g isqlplusUseDBA accountNext, we will introduce them one by one.
1. vi. bash_profile
Add Environment Variables
exportJAVA_HOME=$ORACLE_HOME/jdk
Save and exit.
source.bash_profile
2. Switch to the correct directory
cd$ORACLE_HOME/oc4j/j2ee/isqlplus/application-deployments/isqlplus
3. Run the JAZN shell.
$JAVA_HOME/bin/java-Djava.security.properties=$ORACLE_HOME/sqlplus/admin/iplus/provider
-jar$ORACLE_HOME/oc4j/j2ee/hom
Major work of the database administrator (DBA)
Start and close a database1) Start the database$ SvrmgrlSvrmgr> connect internal (instance startup)Svrmgr> startup
2) shut down the database$ SvrmgrlSvrmgr> connect internalSvrmgr> shutdown [immediate/abort]Immediate: the database is closed only after the session accessing the database is completely terminated and the resources are released in sequence.Abort: the session is terminated immediately and the
Oracle DBA Database Senior Engineer Training Package (series more than 60 sets + seven phases + thousands of cases)DescribeOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employment, high-paying employment. The course content is based on
. For example, grant role to user, or grant insert on table to user;.Standard SQL statements given in MOS:To create a role:Create role To assign a role permission:Grant To reclaim permissions from a role:Revoke Assign a role to a role or user:Grant 2. Second, connect and resource are the built-in roles of the two systems, and the DBA is tied to the relationship.For some posts, permissions can be divided into two categories:System permissions: The syst
, such as Grant role to user, or grant insert on the table to user;.Standard SQL statements given in MOS:To create a role:Create role To assign a role permission:Grant To reclaim permissions from a role:Revoke To assign a role to another role or user:Grant 2. Second, connect and resource are the built-in roles of the two systems, and the DBA is tied to the relationship.Referring to some of the posts, permissions can be divided into two categories:Syst
Tags: evel group span user false standard value RAC BSPQuery scripts that Oracle DBA must master:1: Querying the size of Oracle standard data blocks by V$parameter data fields1 ----Query the size of the Oracle standard data block by v$parameter the data dictionary.
2[Email protected]> startup3ORACLE instance started.4
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.