블로그
-
[문법]MYSQL 총정리(ing)
ADM_ID from ADMIN; => ADMIN테이블에 속한 ADM_ID컬럼을 검색 ㄴ.select * from LOG; => LOG테이블에 속한 모든(*)컬럼을 검색 2.DELETE문 ㄱ.delete ADM_ID from ADMIN; =>ADMIN테이블 중에서 ADM_ID컬럼을 삭제 ㄴ.delete ADM_ID from ADMIN where
blog.naver.com · 2015.08.06
-
Workshop 1
DB 튜닝 - DB 메모리 튜닝 - SQL 튜닝 ● 오라클 db의 구조 1. databse + instance ( memory ) ● 오라클 database 내의 3가지 파일 1. 하기 위한 파일 (db의 구조정보 ) select name from v$controlfile; 3. redo log file -> db의 변경사항을 적어놓은 파일 -DML 문
blog.naver.com · 2014.07.18
-
Symantec SCS 250-316 덤프
NO.1 An administrator needs to restore a mailbox to an Exchange 2010 Database Availability Group. Which server must have an installed Agent for Windows in order to restore from a GRT enabled backup of
blog.naver.com · 2014.03.03
-
DATABASE CHARACTER SET 변경 하는 방법
-- NLS_CHARACTERSET 확인 SELECT * FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET' OR ALTER DATABASE CHARACTER SET I.......
blog.naver.com · 2011.06.14
-
Considering Data Stores
Our programs take in data from somewhere, do something to it, and then send the data somewhere else: a file system, a user, a database, perhaps as an email or some other message.
blog.naver.com · 2010.12.27
-
Percona XtraBackup
percona-xtrabackup:start Percona XtraBackup is an open-source hot backup utility for MySQL that doesn't lock your database It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.0 and 5.1 servers, and it has many
blog.naver.com · 2010.11.08
-
NoCAP
must admit that i really enjoyed those discussions as it felt that we finally started to break away from That in itself sparks lots of interesting and innovative ideas that can revolutionize the entire database
blog.naver.com · 2010.10.21
-
VERY SLOW CONNECTIONS, SVRMGRL/SQLPLUS HANGS, CORE DUMPS
===== You are encountering one or more of the following symptoms: - Very slow connections to the database SQL*Net, such as TNS-12164 - Bus errors and/or core dumps from SQL*.......
blog.naver.com · 2009.03.19
-
저장형 함수 테스트
아래 게시물에서 말씀드렸던것처럼 저장형함수 테스트한 내용을 올려드립니다.테스트 환경은 'Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 v_return_val NUMBER := 0;BEGIN SELECT DECODE(p_val, 1, p_val * 1.5, 2, p_val * 2) INTO v_return_val FROM
blog.naver.com · 2008.06.23
-
Maintaining Redo Log files
v$database ;SVRMGR> SELECT archiver FROM v$instance ;2. V$LOG : gruop별 정보SVRMGR> SELECT group#, sequence#, bytes, members, status2 FROM v$log ;4.
blog.naver.com · 2008.04.08
