database + it database edgedb postgres My experience with EdgeDB · divan's blog wono | discuss | tweet + database type (Oracle PostgreSQL변환) 자료형 변환Oracle에서 작성한 Create Table문을 수정없이 PostgreSQL에서 사용할 수 없는 경우가 있습니다. Oracle의 자료형 중에 일부 VARCHAR2 , NUMBER, BLOB 등은 PostgreS wono | comment (2) | tweet + postgresql database PostgreSQL 13.3 문서 wono | discuss | tweet + database oracle Oracle Database - (Fragmented) (Unused|Free) space (Reclaim|Shrink|resize) | Oracle Database | Datacadamia - Data and CoUsed and free space. A data file contains ordered extents (by block Id). One segments is made up of one of several extents (not ordered, contiguous). Over time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space is referred to as fragmented free spaceextentable segmensegmentablespacext… wono | discuss | tweet + database oracle How to Calculate Used and Allocated Storage in Oracle Autonomous Database – Database HeartbeatIntroduction Oracle Autonomous Database is a fully managed service. Simply specify the CPU count and the amount of storage needed and you are ready to go. Scaling up and down CPU and storage is an … wono | comment (1) | tweet + database oracle storage used Oracle Autonomous Database - Over-counting storage used? - Stack OverflowI was trying out the oracle's autonomous DB. Wanted to understand what is the fuss about oracle APEX services - which enables one to directly build apps on a db. The DB comes with a bunch of system wono | discuss | tweet + database oracle temp shrink How Oracle Resize Temp Tablespace - Ed Chen LogicAlter Database Tempfile Resize Upsizing Upsizing a tempfile is easy, just make sure you set a larger size than the original but no more than the maximum size of a data file. For example: SQL> alter database tempfile '+DATA/ORCLCDB/ORCLPDB/temp01.dbf' resize 24g; Database altered. Downsizing As for downsizing a tempfile, it needs to be careful. Downsizing… Read More »How Oracle Resize Temp Tablespace wono | comment (2) | tweet + database oracle Autonomous Database's increased storage usage? : oraclecloudI have added an ATP database but I noticed the storage used in the overview tab increase significantly over time. There is barely any data in the … wono | discuss | tweet + database oracle ORACLE 테이블스페이스 - DB CAFE wono | discuss | tweet + database oracle 오라클 테이블별 사이즈 조회하기 :: 김과장의 AZ팩토리오라클 테이블별 사이즈 조회하기 1. 모든 유저별 테이블 단위 사이즈 조회하기(단위 MB) 아래 쿼리는 system 유저로 접속해서 수행하며 모든 테이블의 크기를 MB 단위로 표현해준다. select owner, segment_name,.. wono | comment (1) | tweet + database boolean 데이터베이스별 boolean 데이터 타입(PostgreSQL, MySQL, Oracle) :: 오렌지파솔라시도boolean 타입의 데이터를 저장할 때 항상 0과 1, 'Y'와 'N' 등의 값으로 대체해서 저장하곤 했다. 나는 주로 PostgreSQL을 사용하는데, 문득 boolean 데이터 타입은 진짜 없을까? 하고 찾아보게 되었다. PostgreSQ.. wono | discuss | tweet + oci database backup 28. OCI를 이용해서 데이터베이스 어플리케이션 아키텍쳐 구성하기 - 데이터베이스 (백업)2019/01/17 - [Cloud/Oracle Cloud Infrastructure] - 27. OCI를 이용해서 데이터베이스 어플리케이션 아키텍쳐 구성하기 - 데이터베이스 (DB 시스템연결2) 5단계. 데이터베이스 구성 서비스 게이트웨이를 통한 데.. wono | discuss | tweet + oci database restore Database Level 100 - Demo 2 - Restoring a database in OCI from the latest database backup.Demonstration of restoring a database in OCI from the latest database backup.Learn More: https://www.oracle.com/cloud/iaas/training/Register for a free live ... wono | discuss | tweet
+ database type (Oracle PostgreSQL변환) 자료형 변환Oracle에서 작성한 Create Table문을 수정없이 PostgreSQL에서 사용할 수 없는 경우가 있습니다. Oracle의 자료형 중에 일부 VARCHAR2 , NUMBER, BLOB 등은 PostgreS wono | comment (2) | tweet
+ database oracle Oracle Database - (Fragmented) (Unused|Free) space (Reclaim|Shrink|resize) | Oracle Database | Datacadamia - Data and CoUsed and free space. A data file contains ordered extents (by block Id). One segments is made up of one of several extents (not ordered, contiguous). Over time, updates and deletes on objects within a tablespace can create pockets of empty space that individually are not large enough to be reused for new data. This type of empty space is referred to as fragmented free spaceextentable segmensegmentablespacext… wono | discuss | tweet
+ database oracle How to Calculate Used and Allocated Storage in Oracle Autonomous Database – Database HeartbeatIntroduction Oracle Autonomous Database is a fully managed service. Simply specify the CPU count and the amount of storage needed and you are ready to go. Scaling up and down CPU and storage is an … wono | comment (1) | tweet
+ database oracle storage used Oracle Autonomous Database - Over-counting storage used? - Stack OverflowI was trying out the oracle's autonomous DB. Wanted to understand what is the fuss about oracle APEX services - which enables one to directly build apps on a db. The DB comes with a bunch of system wono | discuss | tweet
+ database oracle temp shrink How Oracle Resize Temp Tablespace - Ed Chen LogicAlter Database Tempfile Resize Upsizing Upsizing a tempfile is easy, just make sure you set a larger size than the original but no more than the maximum size of a data file. For example: SQL> alter database tempfile '+DATA/ORCLCDB/ORCLPDB/temp01.dbf' resize 24g; Database altered. Downsizing As for downsizing a tempfile, it needs to be careful. Downsizing… Read More »How Oracle Resize Temp Tablespace wono | comment (2) | tweet
+ database oracle Autonomous Database's increased storage usage? : oraclecloudI have added an ATP database but I noticed the storage used in the overview tab increase significantly over time. There is barely any data in the … wono | discuss | tweet
+ database oracle 오라클 테이블별 사이즈 조회하기 :: 김과장의 AZ팩토리오라클 테이블별 사이즈 조회하기 1. 모든 유저별 테이블 단위 사이즈 조회하기(단위 MB) 아래 쿼리는 system 유저로 접속해서 수행하며 모든 테이블의 크기를 MB 단위로 표현해준다. select owner, segment_name,.. wono | comment (1) | tweet
+ database boolean 데이터베이스별 boolean 데이터 타입(PostgreSQL, MySQL, Oracle) :: 오렌지파솔라시도boolean 타입의 데이터를 저장할 때 항상 0과 1, 'Y'와 'N' 등의 값으로 대체해서 저장하곤 했다. 나는 주로 PostgreSQL을 사용하는데, 문득 boolean 데이터 타입은 진짜 없을까? 하고 찾아보게 되었다. PostgreSQ.. wono | discuss | tweet
+ oci database backup 28. OCI를 이용해서 데이터베이스 어플리케이션 아키텍쳐 구성하기 - 데이터베이스 (백업)2019/01/17 - [Cloud/Oracle Cloud Infrastructure] - 27. OCI를 이용해서 데이터베이스 어플리케이션 아키텍쳐 구성하기 - 데이터베이스 (DB 시스템연결2) 5단계. 데이터베이스 구성 서비스 게이트웨이를 통한 데.. wono | discuss | tweet
+ oci database restore Database Level 100 - Demo 2 - Restoring a database in OCI from the latest database backup.Demonstration of restoring a database in OCI from the latest database backup.Learn More: https://www.oracle.com/cloud/iaas/training/Register for a free live ... wono | discuss | tweet