---
title: "Discussion on \"How direct-path inserts and one extra row per loop bloated 18 MB into 8 GB\" | Hashnode"
description: "Discussion on \"How direct-path inserts and one extra row per loop bloated 18 MB into 8 GB\". I was investigating the code that looked something like this:\ntruncate table t1;\nfor i in 1..300 loop\n   insert /*+ append */ into t1\n      select 1 from dual connect by level <= p_connect_by_level;"
url: "https://hashnode.com/posts/how-direct-path-inserts-and-one-extra-row-per-loop-bloated-18-mb-into-8-gb/6a4a1e03029ce5ae887f504d"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How direct-path inserts and one extra row per loop bloated 18 MB into 8 GB](https://blog.srecnik.info/how-direct-path-inserts-and-one-extra-row-per-loop-bloated-18-mb-into-8-gb?utm_source=hashnode&utm_medium=feed)

I was investigating the code that looked something like this: truncate table t1; for i in 1..300 loop insert /\*+ append \*/ into t1 select 1 from dual connect by level <= p\_connect\_by\_level;

Jul 5 · 10 min read · blog.srecnik.info  
Read the article

-   [#oracle-database](https://hashnode.com/tag/oracle-database)

## Written by

[Urh Srecnik](https://hashnode.com/@usrecnik)

@usrecnik

  
[View profile](https://hashnode.com/@usrecnik)

Oracle DBA

DBA Team Lead and Oracle ACE Pro. Building database tools and helping teams manage Oracle infrastructure.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
