Thu Nov 21 23:50:40 2024 EVENTS FREE SOFTWARE INSTITUTE POLITICS JOBS MEMBERS' CORNER MAILING LIST NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice. DATE 2014-11-01 LEARN 2024-11-21 | 2024-10-21 | 2024-09-21 | 2024-08-21 | 2024-07-21 | 2024-06-21 | 2024-05-21 | 2024-04-21 | 2024-03-21 | 2024-02-21 | 2024-01-21 | 2023-12-21 | 2023-11-21 | 2023-10-21 | 2023-09-21 | 2023-08-21 | 2023-07-21 | 2023-06-21 | 2023-05-21 | 2023-04-21 | 2023-03-21 | 2023-02-21 | 2023-01-21 | 2022-12-21 | 2022-11-21 | 2022-10-21 | 2022-09-21 | 2022-08-21 | 2022-07-21 | 2022-06-21 | 2022-05-21 | 2022-04-21 | 2022-03-21 | 2022-02-21 | 2022-01-21 | 2021-12-21 | 2021-11-21 | 2021-10-21 | 2021-09-21 | 2021-08-21 | 2021-07-21 | 2021-06-21 | 2021-05-21 | 2021-04-21 | 2021-03-21 | 2021-02-21 | 2021-01-21 | 2020-12-21 | 2020-11-21 | 2020-10-21 | 2020-09-21 | 2020-08-21 | 2020-07-21 | 2020-06-21 | 2020-05-21 | 2020-04-21 | 2020-03-21 | 2020-02-21 | 2020-01-21 | 2019-12-21 | 2019-11-21 | 2019-10-21 | 2019-09-21 | 2019-08-21 | 2019-07-21 | 2019-06-21 | 2019-05-21 | 2019-04-21 | 2019-03-21 | 2019-02-21 | 2019-01-21 | 2018-12-21 | 2018-11-21 | 2018-10-21 | 2018-09-21 | 2018-08-21 | 2018-07-21 | 2018-06-21 | 2018-05-21 | 2018-04-21 | 2018-03-21 | 2018-02-21 | 2018-01-21 | 2017-12-21 | 2017-11-21 | 2017-10-21 | 2017-09-21 | 2017-08-21 | 2017-07-21 | 2017-06-21 | 2017-05-21 | 2017-04-21 | 2017-03-21 | 2017-02-21 | 2017-01-21 | 2016-12-21 | 2016-11-21 | 2016-10-21 | 2016-09-21 | 2016-08-21 | 2016-07-21 | 2016-06-21 | 2016-05-21 | 2016-04-21 | 2016-03-21 | 2016-02-21 | 2016-01-21 | 2015-12-21 | 2015-11-21 | 2015-10-21 | 2015-09-21 | 2015-08-21 | 2015-07-21 | 2015-06-21 | 2015-05-21 | 2015-04-21 | 2015-03-21 | 2015-02-21 | 2015-01-21 | 2014-12-21 | 2014-11-21 | 2014-10-21 Key: Value: Key: Value: MESSAGE DATE 2014-11-24 FROM Ruben Safir SUBJECT Subject: [LIU Comp Sci] Oracle DBA short cuts From owner-learn-outgoing-at-mrbrklyn.com Mon Nov 24 13:48:17 2014 Return-Path: X-Original-To: archive-at-mrbrklyn.com Delivered-To: archive-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix) id 9E382161154; Mon, 24 Nov 2014 13:48:17 -0500 (EST) Delivered-To: learn-outgoing-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix, from userid 28) id 7FA7316115B; Mon, 24 Nov 2014 13:48:17 -0500 (EST) Delivered-To: learn-at-nylxs.com Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89]) by mrbrklyn.com (Postfix) with ESMTP id 757F3161154 for ; Mon, 24 Nov 2014 13:48:16 -0500 (EST) Received: from [10.0.0.42] (unknown [96.57.23.82]) by mailbackend.panix.com (Postfix) with ESMTP id 3FF3412E29 for ; Mon, 24 Nov 2014 13:48:16 -0500 (EST) Message-ID: <54737DB7.2080706-at-panix.com> Date: Mon, 24 Nov 2014 13:49:27 -0500 From: Ruben Safir User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.1.0 MIME-Version: 1.0 To: learn-at-nylxs.com Subject: [LIU Comp Sci] Oracle DBA short cuts Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Sender: owner-learn-at-mrbrklyn.com Precedence: bulk Reply-To: learn-at-mrbrklyn.com http://tuxiom.com/forum/index.php?topic=33.0 List all users/schema SET PAGESIZE 50 SELECT DISTINCT USERNAME FROM DBA_USERS; List ONLY your tables SET PAGESIZE 80 COL TABLE__NAME FORMAT a30; COL TABLE_TYPE FORMAT a30; SELECT * FROM CAT; List the Oracle Tablespaces and free space SELECT * from v$TABLESPACE; List the free space for all Oracle Tablespaces within a Database SELECT * from DBD_FREE_SPACE where TABLESPACE_NAME = 'IATOR'; List the space ALREADY USED for a specific Oracle Tablespace SELECT * from DBA_SEGMENTS where TABLESPACE_NAME = 'myTABLESPACE'; List extents for segments SELECT TABLESPACE_NAME, count(*), max(blocks), sum(blocks) from dba_free_space group by TABLESPACE_name; See all the tables you have access to: SET PAGESIZE 90 COLUMN "OBJECT NAME" format a26 COLUMN "OBJECT TYPE" format a20 SELECT object_name "OBJECT NAME", object_type "OBJECT TYPE" FROM user_objects WHERE object_type = 'TABLE'; See your TABLESPACE SELECT TABLESPACE_NAME from ALL_TABLES where TABLE_NAME = '' « Last Edit: November 05, 2009, 10:47:35 by Nitin » ? Logged 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Re: Welcome to learn 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] second post!! 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Webineir on pl/sql 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UEFI and Secure Boot 2014-11-24 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle DBA short cuts 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] =?UTF-8?B?UmU6IERhdGFiYXNlIE1hbmFnZW1lbnQgU3lzdGVtczogQ1MgNjQ5IEE=?= 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] More problems with modeling and normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalize because your professor said too 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Problems with Normalization 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Data Models Shouldn't Drive Object Models (And Vice Versa) 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database 2014-11-29 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Cache theory Architecture Class 2014-11-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Cache Model in C programming NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!