oracle dba fundamentals

Oracle Learning (18) [DBA]: Distributed DatabaseWhat is a distributed database? L data is physically stored on multiple nodes of the network, logically being a whole.The independence of distributed databases l the independence of distributed data means that users do not have to worry about how data is divided and stored, but only what data they need.Oracle distributed RDBMS local operations remote operation

(nomount); 2. Mount the database (Mount); 3. Open the database (open) 1. Start and instance In nomount, Oracle starts an instance and reads the specified initial parameter values in the spfile or pfile parameter file. Allocate the SGA shared memory area and create background processes. You can use the restrict and force options to enable instances. In restrict mode, only DBA is allowed to do the follow

What should I know first as an Oracle DBA in a completely new environment?Here, we will not talk about those major aspects, such as understanding the overall situation of the entire IT environment. If you already know this, you need to face these living databases. here we have summarized some general ideas to face a database first, so as to quickly understand the environment overview you are facing. This i

dynamic adjustment of the SGA area; SQL>show SGA; network connection--Session processes;Sql> SelectUsername,paddr fromV$sessionwhereUsername is not NULL; USERNAME paddr------------------------------ ----------------SYS 00000000f04dae60sys 00000000f04dae60c# #SCOTT 00000000f04dbea0SelectAddr fromV$processwhereBackground is NULL andAddr='00000000f04dae60';Select * fromV$processwhereBackground is NULL andAddr='00000000f04dae60';SetAutotrace onStat;SelectUsername,paddr fromV$sessionwhereUsernam

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

Oracle Database Migration-FundamentalsAs a developer, database knowledge must be in our hands. But now the company's database is dedicated DBA maintenance, usually give us an environment address, and then we write Crud SQL. And the company's product requirements can cross the data source, so usually not too concerned about the operation of a particular database platform. As a result, your DB knowledge is se

As an Oracle DBA, a number of problems with character sets are frequently dealt with at work. But when you really want to write something about it, you suddenly don't have a clue. After a half-day, or decided to use the two character set as an example of the point of entry, it is a clue, perhaps in the course of the experiment, the problem will emerge one after another. Now, let's cut to the chase. The da

Oracle DBA Database Senior Engineer Training Upper (project implementation + Backup Recovery + foundation depth)Purchase Address:Http://edu.51cto.com/pack/view/id-739.html 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 employ

Rights Super User: Sys,system Permissions: SYSDBA,DBA 4. Oracle NET Configuration Configuration file: Listner.ora Tnsnames.ora Configure Image command: NETCA Start/close/view commands: Lsnrctl start/stop/status Connect to the database via Oracle client Configuration Tnsname.ora Vi. Database Backup 1. Backup is important 2, General database failure type: SQL sta

; Wrl_type wrl_parameter STATUS---------------------------------------------------File D:\ App\oracle\admin\orcl\wallet OPEN # Create encrypted tablespace sql> create tablespace encrypt_tbs 2 datafile ' D:\app\oracle\oradat A\ORCL\SECUREFILE.DBF ' reuse 3 encryption using ' AES192 ' 4 default storage (encrypt); The tablespace has been created. # View tablespace encryption sql> Select T.name,e.encryption

tablespaces the SCOTT user uses select T.table_name, T.tablespace_namefrom dba_all_tables twhere t.owner = ' SCOTT '; 14. View Current user-owned permissions select T.privilege from Session_privs t; Sql> Select T.privilege from Session_privs t; PRIVILEGE----------------------------------------CREATE sessionunlimited tablespacecreate tablecreate Clustercreate viewcreate sequencecreate procedurecreate triggercreate typecreate OPERATORCREATE indextype 11 rows have been selected. 14. View role (

Oracle- related Fundamentals relational database and non-relational database Relational database is a database based on the relational model, and the relational model is a two-dimensional table to represent and store the data;non-relational database (NoSQL) is a key-value pair that stores data in a way that Key-value . RedisDatabase and instance A database is a heap of files, a physical concept; a bunch of

Tags: Oracle DBA stress testThis article is original article, reprint please indicate source: http://blog.csdn.net/msdnchina/article/details/42376661Before a business system stress test, an Oracle DBA is required to do the work ahead of time:1. If the Oracle database softwar

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 following SQL statement lists the sessions established by the current database: Select Sid,serial#,username,program,machine,status From V$session; which The ID number of the SID conversation (session); The serial number of the serial# session, together with the SID, to uniquely i

This is a sophomore writing in the QQ space in an article, I remember that the problem took me the whole day to fix it, so experienced quite deep, so at that time deliberately recorded the process of the settlement, and today suddenly have the interest to find out a few college writing in the spaces in the article and share with you, In case something like that happened to me, it would take a lot of time, and the following is the full contents of the record:Today login with the user Scott landed

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

tablespace group: sql> Create temporary tablespace tmp_ts 2 tempfile ' D:\app\oracle\oradata\orcl\temp03.dbf ' Size 5m 3 tablespace group group1; The tablespace has been created. # Add temporary tablespace to the temporary tablespace group: sql> alter tablespace TMP_TBS tablespace group group1; Table space has changed. # Remove a temporary tablespace from a temporary table space group sql> alter tablespace TMP_TBS tablespace Group '; Tabl

Tags: training institutions RAC training database ACL android Oracle database ora AgencyNow that I've been testing, I've learned about Android before, I've been through some databases, I didn't know much about it, and I'm not sure how to get Oracle DBA to do a preliminary plan here:1. Search for the process of obtaining an Or