Chapter 5: 사용자를 파악하기 위한 데이터 추출
Feb 21 · 14 min read · 11강. 사용자 전체의 특징과 경향 찾기 사용자 속성과 행동 패턴을 분석하여 서비스 개선에 활용하는 방법 1. 사용자의 액션 수 집계하기 액션과 관련된 지표 집계 UU (Unique Users): 중복 없이 집계된 사용자 수 사용률 (usage_rate): 특정 액션 UU / 전체 UU 1인당 액션 수: 액션 수 / 액션 UU WITH stats AS ( SELECT COUNT(DISTINCT session) AS total_uu ...
Join discussionChapter 4: 매출을 파악하기 위한 데이터 추출
Feb 21 · 9 min read · 9강. 시계열 기반으로 데이터 집계하기 시계열 데이터를 다양한 관점에서 집계하여 매출 추이를 분석하는 방법 1. 날짜별 매출 집계하기 매출 집계의 기본: 날짜별 매출과 평균 구매액 집계 SELECT dt, COUNT(*) AS purchase_count, SUM(purchase_amount) AS total_amount, AVG(purchase_amount) AS avg_amount FROM purchase_log...
Join discussion🧯 PostgreSQL Production Incident: Understanding a Disk I/O Meltdown After a Holiday Backlog
Feb 16 · 6 min read · This article documents a real-world PostgreSQL production incident.All business names, schemas, queries, IPs, and identifiers have been anonymized for confidentiality. 📌 System Overview OS: Ubuntu Server 24.04 LTS Database: PostgreSQL 16.x CPU:...
Join discussionDiagnóstico de Crescimento Anormal do Log da tempdb no SQL Server
Dec 9, 2025 · 4 min read · Você já se deparou com este cenário? Arquivo de log da TempDB crescendo sem parar. Arquivos de dados da TempDB praticamente do mesmo tamanho. Foi exatamente isso que aconteceu em um ambiente de produção:uma estação de trabalho travou no meio de u...
DMatheus commented
my DBA Journey
Dec 4, 2025 · 1 min read · Starting My Oracle DBA Journey: A Place to Learn, Grow, and Document the Path For years, tech blogs have been shaped by people who’ve spent decades in IT—experts sharing deep knowledge and seasoned insights. I’ve learned a lot from them, and I’m grat...
Join discussion
Caso de Estudio Aurora: Cómo las R8g (Graviton4) casi nos engañan y por qué las R6gd fueron la respuesta correcta.
Nov 12, 2025 · 6 min read · Como DBAs e ingenieros de la nube, siempre nos entusiasma la última tecnología. Cuando AWS anunció las nuevas instancias R8g impulsadas por los procesadores Graviton4, la tentación fue inmediata. Vimos los benchmarks que prometían un rendimiento de C...
Join discussion
ORA-12541: TNS: No Listener — The One That Wastes Your Morning
Nov 3, 2025 · 1 min read · You start your day, coffee in hand, and Oracle throws this: ORA-12541: TNS: no listener Classic. Database’s fine, client’s screaming. Let’s reproduce it and fix it properly. Reproducing It lsnrctl stop sqlplus system@ORCL Boom. Same error. No ma...
Join discussionUnlock Your Global Career with the Best DBA Programs in USA
Sep 20, 2025 · 5 min read · In today’s competitive global market, advancing your career requires not only experience but also specialized knowledge and strategic thinking. Professionals seeking to reach the next level often explore the best DBA programs in USA, which provide a ...
Join discussion
Why an Online DBA in Business Administration Could Be Your Next Big Career Move
Sep 11, 2025 · 1 min read · AACSB reported that senior roles including VP of Global Operations, Director of Global Strategy, Senior Management Consultant, VP- Mergers & Acquisitions are ypically held by DBA graduates. This further makes it more relevant to pursue the best Docto...
Join discussion