I know that portal users with create content privilege can create content in portal by uploading files from their local desktop.
Is there a size limitation that ESRI restricts ?? Also what is the physical location of these files that are being copied to the server?
There shouldn't be a size limitation. When an item is uploaded, such as a zipped shapefile, it will be stored in a folder at the following location: