oracle certification path

I will not say what happened, direct focus: Computer-> Properties-> advanced system Settings-> advanced-> environment variables 1 in the "system variable" edit path, select all of them to copy the path all out into the text document; 2 Create a new system variable named Path1, cut all the variables in the path into Path1 and then save; 3) and change the total

First, the principle of startup and shutdown of Oracle1. Oracle Boot Step AnalysisSql> Startup-This is the command to start the databaseORACLE instance started. --first stage, launch instance, Nomount stateTotal System Global area 608174080 bytesFixed Size 1268920 bytesVariable Size 230687560 bytesDatabase buffers 373293056 bytesRedo buffers 2924544 bytesDatabase mounted. --second stage, load database, Mount stateDatabase opened. --The third stage, op

Reason for writing: 1. Oracle instance is created on 91. 2. In order to solve the problem of importing SDE user error without creating the SDE service pilot data, the sequence of data is introduced after the first SDE service is created. 3, because 91 of the ArcGIS version on the machine is 9.3, in order to ensure the release of the version of the site can be used normally, so, on other machines for 91 to create SDE table space and users. (Set up a s

Reference: http://wwyz998.blog.163.com/blog/static/321867852011117111832334/Oracle Mobile data Files1. Connect to a database[Email protected]]$./sqlplus/nologSql> Conn/as SYSDBA2. View the data file locationSql> select file_name from Sys.dba_data_files;Orsql> select name from V$datafile;file_name------------------------------------------------------------------------/oradata/pmptgdb/users01.dbf/oradata/pmptgdb/undotbs01.dbf/oradata/pmptgdb/sysaux01.db

of the flash recovery zone.Db_recovery_file_dest_size: Specifies the available space size of the flash recovery zone.Db_flashback_retention_target: specifies the time when the database can be rolled back. The unit is minute. The default value is 1440 minutes, that is, one day. Of course, the rollback time is also determined by the size of the flash recovery zone, because the flash log required for rollback is saved. Therefore, this parameter must be modified with db_recovery_file_dest_size. 2.

Before Oracle 10 Gb, the warning log is located in the bdump folder, but 11 GB has changed the log and introduced ADR (a directory that stores the diagnostic logs and tracking files of the database ), it corresponds to the initialization parameter DIAGNOSTIC_DEST. If the $ ORACLE_BASE environment variable is set, DIAGNOSTIC_DEST is equal to $ ORACLE_BASE. If $ ORACLE_BASE is not set, it is equal to $ ORACLE_HOME/log. You can use the following stateme

Label:Installing Oracle today has the following issues:Then on-line BaiduThe reason for the analysis is as follows: Environment variable path length is too long.Step: (Win7) Right-click My Computer--Properties--Advanced system settings--environment variables--the path in the system variable, double-clicking. BackupThen only the%systemroot%\system32;%systemroot%;%

Tags: bsp www acl how much graduation video Inspire blog YourselfJust graduated this year, from graduation to now work formally work four months (internship months will not forget). There are many difficulties encountered in the work, there are many things learned, but the feeling learned is not enough, after all, Java water is very deep ah.Now, not every day in the work can learn new things, but the problem will not be reduced, so decided to learn something after work every day. Right hand has

A cainiao's oracle path -------- II (continued) case 16 which employees do not receive 400,500,100 yuan in bonuses and are not empty. [SQL] select ename, bonus from emp_xxx where bonus not in () or bonus is null; // when not in is used for comparison, the set cannot contain null values, if it contains //, no rows selected // displays the last two characters of each employee. [SQL] select substr (ename, 2, 2

Oracle learning path (6) two practical examples1. Simple data insertion example -- Created on 2015/6/15 by LYH declare v_fnumber varchar2(10):='qwe'; v_fname varchar2(10):='lyh'; v_fage int:=10; v_fsalary int:=101.00;begin INSERT INTO t_employee(fnumber,fname,fage,fsalary) VALUES(v_fnumber,v_fname,v_fage,v_fsalary); COMMIT;end; 2. Simple data deletion example-- Created on 2015/6/15 by LYH declar

How to Learn: Oracle SQL learning path (4): Analyzing function statistics (2) Preface I have written several blog posts about analysis functions. However, I have always been not satisfied with what I wrote, and I cannot tell where the problem is. The biggest problem is that I am not satisfied, but completely confused, and where I am not satisfied, what should I say clearly? Or the content is too thin. MAX a

Change the Oracle archive path and archive mode in oracle10g and 11g versions, the Oracle default log archive path is the Flashback recovery area ($ORACLE _base/flash_recovery_area). For this path,

1. First set the Full_name (full path) of one-level menuupdate S_DEPARTMENT t set t.full_name = ‘XX集团‘ where fid=‘-1‘;2, set the level two menu Full_nameupdate ( select a.dep_name,a.full_name,b.dep_name dd,b.full_name cc from (select * from S_DEPARTMENT where dep_level = ‘2‘) a , -- 获取二级菜单 (select * from S_DEPARTMENT where dep_level = ‘1‘) b -- 获取一级菜单 where a.fid = b.id)set full_name = cc||‘/‘||dep

Tags: Oracle RAC Archive1. Modify the archive Path parameterSqlplus/as SYSDBASql> alter system set log_archive_dest_1= ' Location=+asmarch ' scope=spfile sid= ' * ';2. Close the database and all nodes are closedSrvctl Stop database-d racdb3. Boot a node database to mount State 5 and modify the database's archive mode and start the databaseSrvctl start instance-d racdb-i racdb2-o Mountsql> ALTER DATABASE Arc

Label:Performance tuning is a task that every DBA can encounter in his careerBig to the World 500 strong core system, small to the township enterprises of the invoicing, almost will have to tune the timeFaced with a variety of systems, a wide range of needs, the means of tuning is also colorfulLocating the problem, analyzing the problem, solving the problem, is indispensable, and the method is diverse, and the effect is different.determining baselines is the first major task in the communication

Ext.://http://blog.chinaunix.net/uid-23177306-id-2531235.htmlFirst, direct path read1. Wait events associated with direct read. When Oracle reads data blocks directly into the PGA (Process Global Zone) of the session, it bypasses the SGA (System global Zone). Data in the PGA is not shared with other sessions. That is, this part of the data read is used on its own, not in the shared SGA.2, when the sort oper

Starting with Oracle 11GR2, GI integrated Asm,ocr/votedisk is also housed in ASM disk groups (11GR2 previously needed to be stored in bare devices), and ASM has a much greater capability than 10g.Let's first introduce a problem: in 11gr2, Ocr/votedisk is stored in ASM Disk group, which means that the GI can start with the ability to start the ASM instance smoothly and can mount the corresponding disk group, while the ASM SPFile is placed in the ASM di

Label:Modify the Bdump log storage path, need to restart the database, 10G version has this parameter, 11G canceled this parameterObjective: The Oracle database sometimes produces a large number of log documents due to abnormal conditions, and the disk space of the storage path is improperly set, such as being placed in a small capacity, which can easily cause a

Environment variable: "Path"-this test checks whether the length of the environment variable ' path ' does not exceed the Recommended length.Expected value: 1023Actual value: 1245Prvf-3929:adding the Oracle binary location to the PATH environment variable would exceed the OS length limit of ["1023" ] for the variable-A

Tags: Resolving the beginning of the image. com log workaround ACL properties OracleI'm not going to tell you what happened. Direct Focus:Environment variables, advanced system settings, properties, computer1) In the "System variables" edit path, select all to copy the paths in the text document;2) Create a new system variable named Path1, cut all the variables in path into Path1 and save;3) And remove the