Platform/DB
-
잡 스케줄러Platform/DB 2015. 11. 16. 13:06
현재 Oracle에 설정된 유저 프로세스 개수(processes) 확인SQL> show parameter processes ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 10 ; --변경oracle parameter 의 JOB_QUEUE_PROCESSES가 0보다 커야 JOB 스케줄링이 동작한다 DBMS_JOB 패키지JOB QUEUEJOB QUEUE PROCESSJOB_QUEUE_PROCESSES 파라미터 c.f. 유닉스의 cron tab JOB의 확인은SELECT * FROM user_jobs; VARIABLE jobno NUMBER BEGIN DBMS_JOB.SUBMIT(:jobno, 'DBMS_DDL.ANALYZE_OBJECT(''TABLE'', ''HR'', ''EMPLOY..
-
LINQ(Languge INtegrated Query)Platform/DB 2013. 12. 9. 23:50
닷넷 프레임워크 3.5 private void Form1_Load(object sender, EventArgs e) { Con = new SqlConnection(); Con.ConnectionString = "Server=..;database=..;Integrated Security=true"; Adpt = new SqlDataAdapter("SELECT * FROM tblPeople", Con); tblPeople = new DataTable("tblPeople"); Adpt.Fill(tblPeople); var tp = tblPeople.AsEnumerable(); var Q = from p in tp orderby p.Field("Age") select p; foreach (var p in Q) ..
-
기타Platform/DB 2013. 6. 13. 01:59
Dynamic SQL # 문자열the standard database persistence framework JDBC # JavaADO.NET # .NET Object/relational mappingto simplify persistence of objects by eliminating SQL from the developer’s responsibility altogether. Instead, the SQL is generated. iBATISpersistence layer frameworkthe SQL is relatively independent of any particular language or platformdeals with relational databases of all kinds and..
-