Simplifying oracle Concepts

Friday, 22 July 2016

Command to list larger files in Unix

du -sh * |sort -n -r |head -10

- July 22, 2016

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Command to list larger files in Unix

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Add Data file

************************************************** Database status Tablespace Usage ASM Disk Group Usage(RAC) Backup Filesystem Usage Alert...

SYS.USER$ table in Oracle

last password change time, last locked, last expired, creation time, failed logon. Oracle internal table SYS.USER$ has got many interestin...
Common ORA errors in ORACLE from ORA-00900 to ORA-01499

ORA-00900 invalid SQL statement Cause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural O...
Oracle Golden Gate GGSCI command

GGSCI commands executed at the ggsci line utility, are used to setup, manage, monitor and troubleshoot the different components of the Gol...

Search This Blog

Home

ORACLE DBA

NITIN SINGH

View my complete profile

Blog Archive

▼ 2016 (87)
- ► February (1)
- ► June (64)
- ▼ July (19)
- ► August (1)
- ► September (1)
- ► October (1)

► 2017 (21)
- ► February (3)
- ► May (2)
- ► August (1)
- ► September (3)
- ► October (6)
- ► November (6)

► 2018 (5)
- ► February (1)
- ► May (1)
- ► August (3)

► 2020 (7)
- ► February (3)
- ► July (2)
- ► October (2)

► 2022 (2)
- ► May (1)
- ► November (1)

Total Pageviews

Report Abuse

Labels

11gR2 Clusterware Startup Sequence (RAC)
ASM Commands 11 G
ASM disk group re-balancing manually
Automatic Storage Management (ASM)
Background Processes in oracle
Backup and Restore Basic questions in ORACLE 11G
Backup of Privs as Pre Refresh script
Block Change Tracking file
Block Corruption and how to identify corrupted blocks
CellCLI in Exadata
Checking the load on the database
Command to list larger files in Unix
command to remove AUDIT
Common ORA errors in ORACLE from ORA-00000 to ORA-00899
Common ORA errors in ORACLE from ORA-00900 to ORA-01499
control_file_record_keep_time
Converting a RAC database to single instance database
Create a user and grant connect and execute
Data Guard switchover checklist
Data Protection in Oracle
Difference between Session and Process
Estimate Tablespace Growth
EXADATA - Who Manages the Exadata Machine
Export and Import using unix pipes and compression
Find a role
Find the number of archivelogs generated each hour of the day
Get create user DDL with grants
Golden Gate Interview Question Part -1
Golden Gate Interview questions and answers Part -2
Grants delete on current schemas tables to the specified user/role in oracle 11g
Grants select on current schemas tables
How can we stop scheduled job
How many Scan listener
How to check memory in solaris
How to Check the Locked Object details
How to create backup of control file
How to create BITMAP index in Oracle 11G
How to Monitor RMAN Backup through SQL Query
How to start the service on DR if it does not Auto start After reboot the server
How To take export a job
How to take the Backup of a package in Oracle
How to unregister the database from catalog
Identify database idle sessions
Identify database SID based on OS Process ID
Identify OS process ID based on database SID
Identifying Oracle Tables with Migrated/Chained Rows
Killing an Oracle job at the OS level
List all recent DDL modifications
List Objects being accessed by a particular SID
Lists all locked objects.
Lists all objects being accessed in the schema
Locked Sessions and Locked Objects
Loss of Undo tablespace datafile and Process to restore and recover
Managing an ASM Disk Group
Monitor Data Guard Log Shipping
Monitor long running operations using v$session_longops
Monitor the Flashback area space usage
ocrc heck commands in Oracle RAC
OEM Agent Deinstall
ONLINE RMAN Backup ON STANDBY
ORA-00604 Undo Block Corruption
ORA-16649: possible failover to another database prevents this database from being opened
Oracle - Long running SQL
Oracle 12C new features
Oracle Golden Gate GGSCI command
Oracle Home and GRID backup command
Oracle RAC interview question Part -2
OraInventory in Oracle
Point in time recovery using RMAN (until a log sequence number)
Post Refresh privs execution after refreshing the environment
privileges and roles
Query to find PID & SPID of LGWR
Query to find which user is consuming more UNDO tablespace
Query to identify which schema's are taking more space
RAC crs Commands
RAC interview Questions Part -1
Rebalancing act ASM_POWER_LIMIT
Rebuild of standby using incremental backup of primary
Rebuild Standby database in Oracle
Reclaimable space of a table in oracle database
Recovery of Missing Non -System Datafile
Recreate online redo logs and standby logs
Redo Log in oracle 11g
RMAN - Clone an Oracle database using a cold backup (same server)
RMAN point-in time recovery
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
Script to extract Generic ASM metadata
Script to find out the Top SQL statement in your database
Script to generate ASM Full Path Alias Directory
Script to generate ASM Files & ASM Alias
Script to kill the ACTIVE/INACTIVE session in RAC
script to kill the session in Oracle RAC
Script to moving objects from one tablespace to another tablespace
Scripts related to TEMP TABLESPACE
Scripts to resize standby redolog files
Skipping Tablespaces in RMAN cloning
snapshot controlfile and RMAN-08512
SQL query to find Inactive Session
Standby database Commands
Start instance in a RAC database
Tablespace resize - (To reduce the size)
TFA Collector in Oracle RAC
To check the status of EM dbconsole.
To Find ideal sga size.
To find out tablelocks.
TOP 10 SQL STATEMENTS WITH LARGE NO. OF DISK READS
Types of Mount Modes in oracle
Unix - The vi Editor Tutorial
Viewing Memory Use for Each User Session
views & sequences to the specified user/role.in 11g
What IS Exadata?

Watermark theme. Powered by Blogger.