Home
Search results “Check oracle database size”
how to find FULL DATABASE SIZE in  ORACLE
 
05:09
while we are taking FULL DATABASE BACKUPS , first we need to know the SIZE OF OUR DATABASE. so that if we know the size we can make that much of space available for the backup. so, this video explains how to find the FULL DATABASE SIZE.
Views: 3799 P-Square Technologies
How do I find the Overall Database size ?
 
13:58
Hi friend in my today scenario you learn how to find the total database size ? Oracle database Unbeatable,Unbreakable Platform.. #Databasesize
Views: 2876 Oracle World
Creating  Managing  Droping Oracle Database Tablespaces
 
12:10
Creating Managing Droping Oracle Database Tablespaces select tablespace_name,block_size,status,contents,logging from dba_tablespaces; create tablespace mytbs datafile 'd:\oradata\dbrdbms\mytbs01.dbf' size 10m; alter tablespace mytbs add datafile 'd:\oradata\dbrdbms\mytbs02.dbf' size 10m; alter tablespace mytbs drop datafile 'd:\oradata\dbrdbms\mytbs02.dbf'; desc v$datafile; desc ts#,name from v$datafile; select ts#,name from v$tablespace; select v$datafile.ts#,v$datafile.name,v$tablespace.name from v$datafile,v$tablespace where v$datafile.ts#=v$tablespace.ts# and v$tablespace.name='MYTBS'; alter database datafile 'd:\oradata\dbrdbms\mytbs01.dbf' resize 20m; ALTER DATABASE DEFAULT TABLESPACE mytbs; select ts#,name from v$tablespace; select ts#,name from v$datafile; select ts#,name from v$tablespace; drop tablespace mytbs; drop tablespace mytbs ialtncluding contents and datafiles; drop tablespace mytbs including contents and datafiles cascade; alter tablespace mytbs read only; alter tablespace mytbs read write; alter tablespace mytbs force logging; alter tablespace mytbs nologging; alter tablespace mytbs flashback on; alter tablespace mytbs flashback off; purge tablespace mytbs user myuser;
Views: 20878 Abbasi Asif
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks
 
02:08
How to Check Tablespace Size in SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Check Tablespace Size in SQL Developer How to Check Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in Oracle SQL Developer How to Monitor Tablespace Size in SQL Developer how to check tablespace in oracle sql developer how to check tablespace size in oracle 12c how to check particular tablespace size in oracle how to check tablespace size in gb in oracle how to check tablespace name in oracle how to check freespace in tablespace in oracle 11g how to check tablespace size in oracle 11g how to check freespace in oracle database How to Check Storage of Tablespace Size in SQL Developer How to Check Storage of Tablespace Size in Oracle SQL Developer how to check tablespace in oracle how to check tablespace size in oracle 12c what is tablespace in oracle how to check tablespace in oracle sql oracle list tablespaces in schema how to find tablespace used by a user in oracle how to check particular tablespace size in oracle oracle create tablespace
Views: 174 Oracle PL/SQL World
Table size ,Number of records,Disk usage in SQL Database,clear logs,cache
 
06:51
This clip will show you how to check each Table size, Number of records, Disk usage in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. http://daynamicsaxaptatutorials.blogspot.com This is axapta ERP blog for Technical and functional fields and includes Microsoft Dynamics Axapta tutorials and Dynamics Axapta Coverage. This blog also contains x++ code help for Ax developer and solution of technical and functional daily issues. This blog is specific for Microsoft dynamics programming. Enterprise portal, SharePoint services, business connectors and Enterprise Resource Planning applications and sql database.It will help to get Microsoft Business Solutions.
Views: 779 Santosh kumar Singh
How to Create, Alter, Resize, Drop Tablespace (Tablespace Management #1)
 
07:37
Hello Today I am showing you how to create tablespace. Alter tablespace datafile using fileid & filename and resize datafile. How to check Tablespace Size. How to check datafile Size in MB. How to drop Tablespace including contents and all Datafiles of these tablespace.
Views: 1178 Parag Mahalle
when checkpoint will occur in oracle database
 
14:13
How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 3429 Praveen Biyyapu
Calculate DB file Size
 
01:35
You get no description ! HEHE
Views: 294 Joseph Antoun
HOW TO INCREASE DECREASE MEMORY TARGET IN ORACLE 11G
 
04:55
How to increase/decrease memory_target in 11g ====================================================== oracle 10g --sga_target (parameter new in 10g) oracle 11g --memory_target (parameter new in 11g) How to check whether the parameter is static or dynamic? ========================================================= select name, value, issys_modifiable from v$parameter where name like '%&parameter%' ; if issys_modifiable=false --- parameter is static (database bounce required) if issys_modifiable=immediate --- parameter is dynamic (database bounce not required) (note: consider using spfile) sql commands ================ show parameter memory; alter system set memory_target=350m scope=spfile; alter system set memory_max_target=350m scope=spfile;
Views: 4714 Praveen Biyyapu
Database Size: How to Increase Sql Database Size
 
02:18
This video clearly explains how to increase SQL database size limit. All the important steps to increase SQL Server database size limit are provided.
Views: 4184 Technology Crowds
Performance Tuning of SGA using AMM in oracle 11gR2
 
16:02
Hello friends in my today scenario i briefly explain how to manage and tune automatically SGA AND PGA via Automatic memory management feature that is release in 11gR2. #PerformanceTuning #SGA #AMM
Views: 6700 Oracle World
Tablespaces in oracle database
 
08:27
This video will give you basic idea about tablespace issue. Plese find the following important query . Query to check tablespace usage ============================================== select a.TABLESPACE_NAME, a.BYTES bytes_used, b.BYTES bytes_free, b.largest, round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used from ( select TABLESPACE_NAME, sum(BYTES) BYTES from dba_data_files group by TABLESPACE_NAME ) a, ( select TABLESPACE_NAME, sum(BYTES) BYTES , max(BYTES) largest from dba_free_space group by TABLESPACE_NAME ) b where a.TABLESPACE_NAME=b.TABLESPACE_NAME order by ((a.BYTES-b.BYTES)/a.BYTES) desc; To check datafiles respective to tablespace_name. ======================================================== col tablespace_name format a30; col file_name format a40; SELECT TABLESPACE_NAME, FILE_NAME, BYTES/1024/1024 FROM DBA_DATA_FILES where TABLESPACE_NAME='&tablespace_name'; To check ASM disk group usage ======================================== select name, group_number, name, type, state, total_mb, free_mb from v$asm_diskgroup; Please comment , like, subscribe and reach me if you have any query. EmailId: [email protected] ================================================ Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 734 ANKUSH THAVALI
Oracle DBA Queries   Database status, uptime , SIZE OF DATABASE
 
02:50
oracle dba queries Startup time How large is the database Distribution of objects and data Which sachems are taking up all of the space Show the ten largest objects in the database
Views: 1568 Praveen Biyyapu
RECOVER LOST  DataFile in oracle database
 
15:33
Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 975 ANKUSH THAVALI
How to find the tablespaces in an Oracle Database - Database Tutorial 55 - Oracle DBA Tutorial
 
05:10
Video 55 How to find the tablespaces in an Oracle Database - Oracle DBA Tutorial This video explains about how to view the list of tablespaces that are there in an Oracle Database. To do that: select * from dba_tablespaces;
Views: 1450 Sam Dhanasekaran
What should be the Database block size? - DBPerf Video 15
 
07:44
In this video you will learn about the different block sizes and how it impacts an Oracle database performance. Note: You cannot change the block size after a database is created.... Stay subscribed for updates.... Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 1974 Ramkumar Swaminathan
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema
 
06:35
Toad for Oracle Schema browser how you will get the detail of database object ,log on schema,others schema,user
Views: 7144 Abinash Sahoo
Manage Oracle Tablespaces with Oracle Enterprise Manager 12C
 
03:37
Video tutorials on how Manage Oracle Tablespaces using Oracle Enterprise Manager 12C For more Database Administration articles and scripts go to www.aodba.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 6853 AO DBA
MySQL - check database and table size
 
01:02
Quick how to control database and table size: Tutorial is on MySQL Server version: 5.5.33 DB Size command: SELECT table_schema mysql, sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema; Table Size: Use "name of database"; SELECT TABLE_SCHEMA, TABLE_NAME,(INDEX_LENGTH+DATA_LENGTH)/(1024*1024) AS SIZE_MB, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA NOT IN ("mysql", "information_schema") ORDER BY SIZE_MB DESC LIMIT 10;
Views: 1896 Emil Belas
SQL Table Size: How to Get Database tables size in sql server
 
01:43
Here showing how we can get database all tables size in SQL Server. We can check our growing table size under this video demonstration so that we can optimise our database tables to speed up our application performance.
Views: 1295 Technology Crowds
How to check database and table size in Mariadb
 
03:25
This video explains about the commands that are used to check the sizes of database and tables in MariaDB. MariaDB is a community developed fork of MySQL. For more explanation on this video: https://www.linuxhelp.com/how-to-check-database-and-table-size-in-mariadb/
Views: 600 Linux Help
SQLPLUS: LineSize & PageSize
 
03:49
In this tutorial, you'll learn how to set linesize and pagesize . PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 16226 radhikaravikumar
TABLESPACE MANAGEMENT DATAFILE SIZE ENABLE DISABLE AUTOEXTEND ON
 
02:50
HOW TO ENABLE/DISABLE AUTOEXTEND ON FOR A DATAFILE ================================================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF' autoextend on; HOW TO FIND THE SIZE OF A DATAFILE ================================== SELECT SUBSTR (df.NAME, 1, 50) file_name, df.bytes / 1024 / 1024 allocated_mb, ((df.bytes / 1024 / 1024) - NVL (SUM (dfs.bytes) / 1024 / 1024, 0)) used_mb, NVL (SUM (dfs.bytes) / 1024 / 1024, 0) free_space_mb FROM v$datafile df, dba_free_space dfs WHERE df.file# = dfs.file_id(+) GROUP BY dfs.file_id, df.NAME, df.file#, df.bytes ORDER BY file_name; set lines 180 pages 200 col tablespace_name for a20 col file_name for a55 select tablespace_name,file_name,autoextensible from dba_data_files;
Views: 1137 Praveen Biyyapu
How to check the database size and usage for Control-M PostGreSQL.
 
02:19
How to check the database size and usage for Control-M PostGreSQL. https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000017352
How to work with large databases, linesize, pagesize in Oracle SQL
 
04:45
In this video i will show you how to configure window size and how to work with large databases in Oracle SQL
Oracle: How-to: Change the PAGESIZE and LINESIZE in SQL*Plus
 
02:09
The Best Site to Learn SQL Online
Views: 19004 TechnicalSkills
How do I increase SQL database size
 
02:01
How do I increase SQL database size - Find out more explanation for : 'How do I increase SQL database size' only from this channel. Information Source: google
Views: 15 theaiueo theaiueo
Table Shrinking in Oracle Database
 
14:15
1.Shrink the Table: Shrinking is started from 10g. In this method I’m using user u1 and table name sm1. Now I’m deleting some rows in sm1 COUNT ---------- 1048576 Table sm1 has 1048576 rows. [email protected]: delete from sm1 where deptno=10; 262144 rows deleted. I deleted above number of rows. Rows COUNT ---------- 786432 And I’m giving commit [email protected]: commit; Commit complete. So now we have 786432 rows in sm1 table. Now see the following command [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 After I deleted some rows in sm1 table still above result showing same values, so now our duty is shrink this table. This is done by following 2 ways, i By using COMPACT key word: In this method shrinking is done in two phases. In the first phase all fragmented space are just defragmented, but still the High Water Mark is persist with last used block only. That mean used free blocks are not de allocated and HWM is not updated here. Issue the following command before use shrink command. [email protected] alter table sm1 enable row movement; Table altered. There is particular use with above command, when we shrink the table all rows are moves to contiguous blocks, so here row movement should be done. By default the row movement is disabled for any table, so above command enabled the row movement. Then execute shrink command now. [email protected]: alter table sm1 shrink space compact; Table altered. Now see the space of table by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ------ ---------- ---------- U1 U1TS SM1 TABLE 29 mb 3712 44 So here seems nothing happened with above shrink command, but internally the fragmented space is defragmented. But the high water mark is not updated, used free blocks are also not de allocated. For de allocating the used blocks we have to execute below command. This is the second phase. [email protected]: alter table sm1 shrink space; Table altered. Now see the space by using below command. [email protected]: select OWNER,TABLESPACE_NAME,SEGMENT_NAME,SEGMENT_TYPE,BYTES/1024/1024||' mb'"space",BLOCKS,EXTENTS from dba_segments where tablespace_name like 'U%TS'; OWNER TABLESPACE_NAME SEGMENT_NAME SEGMENT_TYPE space BLOCKS EXTENTS ----- --------------- ------------- ------------- ---------- ---------- ---------- U1 U1TS SM1 TABLE 20.8125 mb 2664 36 So now the space of sm1 table is reduced. Note: Actually the alter table sm1 shrink space command will complete these two phases of the shrinking of table at a time. But here we done shrink process in two phases because when we use alter table sm1 shrink space command the table locked temporarily some time period, during this period users unable to access the table. So if we use alter table sm1 shrink space compact command the table is not locked but space is defragmented. When we not in business hours issue the second phase shrink command then users are won’t get any problem. ii Because of above method the table dependent objects are goes to invalid state, to overcome this problem we have to use below command. [email protected]: alter table sm1 shrink space cascade; Table altered. The above command also shrinks the space of all dependent objects. We also do this in two phases like above two phases. See the below command. [email protected]: alter table sm1 shrink space compact cascade; Table altered. And then [email protected]: alter table sm1 shrink space cascade; Table altered. Transporting tablespace to different platform by Using RMAN : https://www.youtube.com/watch?v=CN401PUKK4A Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51) : https://www.youtube.com/watch?v=zeO4goqR70Y Transport tablespace by using RMAN.: https://www.youtube.com/watch?v=YG6kWX7Par8
Views: 6640 BhagyaRaj Katta
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 145 OracleDBA
Full DB In-Memory Caching
 
03:50
This is the first of two demonstrations about In-Memory caching new features, introduced in Oracle Database 12.1.0.2. This one illustrates the Full Database In-memory Caching feature enabling an entire database to be cached in memory when the database size is smaller than the buffer cache size. Caching and running a database from memory leads to huge performance benefits. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Calculating DB size
 
00:20
Views: 103 Holly H
TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE
 
03:34
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 821 Praveen Biyyapu
Database Tutorial  69 - SGA System Global Area of an Oracle Database - Oracle DBA Tutorial
 
08:01
Database Tutorial 69 - SGA System Global Area of an Oracle Database - Oracle DBA Tutorial SGA - System Global Area
Views: 12184 Sam Dhanasekaran
Determine the size of all the tables in MySQL database
 
02:54
Do you use MySQL for your application. It is not very simple to identify how much space your database consumes on the file system and how much space each table takes. In this video learn how to determine the size of all the tables in your MySQL database.
Views: 99 sparxsys
Oracle Database XE Forgot Password
 
05:27
In this video, we’ll learn how to reset the password for an account in Oracle XE. Are you running Oracle database XE 11.2 and forgot your password? It can be for any Oracle XE version actually, but this is the latest one at the moment. Don’t worry, there are a few ways to recover this password. It also depends on if you know the password, and if you’re able to log in to the account still, as there is a time limit on these passwords. If you’ve forgotten it, then you won’t be able to log in as that account. But this video will help you reset the password so you can use the account again. For more information on Oracle SQL, check out DatabaseStar: https://www.databasestar.com/
Views: 1083 Database Star
Rename Tablespace ( Tablespace Management #3 )/* Step By Step /*
 
06:23
Hello Friends In this video I am showing you 1. How to check Tablespace, Datafile size and Datafile Location. 2. How to Rename Tablespace. 3. How to Offline Tablespace. 4. How to Online Tablespace. 5. How to Rename Datafile. 6. How to Check Tablespace. (How many tablespace Do you Have). 7. How to check Tablespace Status. It is Offline or online. 8. How to Rename Old Datafile name to New Datafile Name in controlfile.
Views: 128 Parag Mahalle
Oracle Database tutorial 64: How To Create Permanent tablespace (Big file and small file)
 
07:15
How to create big file and small file permanent tablepsace in oracle database by Manish sharma rebellionRider In this tutorial you will learn the process of big file and small file permanent tablespace creation with datafiles ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/permanent-tablespace-oracle-rebellionrider Script: https://copy.com/whfzfAeUtzy0JEoU Previous Tutorial ► Tablespace The Introduction : https://youtu.be/5i5RtUdxaHY ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 17470 Manish Sharma
Growth of Oracle Database
 
01:33
Growth of Oracle Database - I used this video in my presentation at Oracle Day in Baku State University.
Views: 312 Mahir M. Quluzade
Oracle Database  - Listener Process - DBArch Video 6
 
07:33
You will learn about the Oracle Listener, The purpose of Listener and what is the impact if its down... Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 14815 Ramkumar Swaminathan
Understanding Oracle Database Memory and what happens when a select statement is entered
 
14:46
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
Views: 2877 NewayITSolutions LLC
postgresql database size
 
00:31
PostgresPURE is the database product created by Splendid Data, that offers a direct, complete alternative to Oracle. The product is based on PostgreSQL, as published by the PostgreSQL Global Development Group
Views: 96 Postgre Sql
How to Export DDL Scripts in SQL Developer | Oracle SQL Developer Tips and Tricks
 
03:58
How to Export DDL Scripts Using Oracle SQL Developer | Oracle SQL Developer Tips and Tricks How to Export DDL Scripts in SQL Developer Oracle SQL Tutorial for Beginners Oracle Database Tutorial for Beginners Oracle SQL Developer Tips and Tricks Oracle Tutorial for Beginners Oracle Tutorial How to Export DDL Scripts Using Oracle SQL Developer How to Export DDL Scripts Using SQL Developer How to Export DDL Scripts from SQL Developer How to Export DDL Scripts in SQL Developer How to Export DDL Scripts in Oracle SQL Developer generate ddl from oracle sql developer how to generate ddl script in oracle sql developer export schema how to get ddl of a table in oracle how to get create table script in oracle how to export table data from oracle sql developer to excel How do I export DDL from SQL Developer How do I create a DDL script in SQL Developer How do you get DDL of a table in Oracle
Views: 145 Oracle PL/SQL World
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
 
08:36
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 172803 Manish Sharma
How to solve SQL Server Low Disk Space Issue in few minutes
 
07:24
Disk space issues are some of the most common issues that SQL Server DBAs have to face. The video shows how with SQL CheckUp the DBA can use the set up alerts, monitor disk space, drill down to the disk database files, see the files total and used space and find the quickest way to free the disk space under the time pressure. To understand why the disk space was used up so rapidly the DBA can jump to see the recent or historical performance counters for the drive, drill to the list of top IO consuming queries of the timeframes when the drive was experiencing the high activity. Also the DBA can see the charts of the drive and each drive database space usage trends.
Views: 18070 VgSQL
Quickfix: Tablespace full to resize tablespace
 
02:11
Quickfix is a demonstration on how to fix a spesific database issue. In this video we detect that a tablespace is full and go through the steps to resize the tablespace.
Views: 1610 dbWatch As
TSQL: Get Table Size and Column Count
 
03:21
GitHub script: https://github.com/tmmtsmith/SQLServer/blob/master/Admin%20Tools/tspace.sql
Views: 837 SQLInSix Minutes

Penny board and nickel comparison essay
Meta research mars
Nuclear arms race cold war essay question
Lokpal bill 2013 essay format
Adam aircraft case study analysis rubric